Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
 

An Open Source Project- R-An Online Photographer Portal

Article:
Viewed:  1160 
Posted On:  3/7/2015 10:21:50 AM 
This is an open source project developed in ASP.NET c# using SQL Server 2008 R2.  

This is my open source project developed using (Visual Studio 2012) ASP.NET, C# & SQL Server 2008 R2.

Basically I developed this project with the name as R-An Online Photographer Portal.

Here any photographer can create his/her profile, can upload new photos, can view existing uploaded photos. Any user can view any photographer profile and their uploaded photos.

Below are the 2 tables I used in this project.

1. PhotograperRegistration

Table_PhotographerRegistration.png

Image 1.

Script of my table is:

CREATE TABLE [dbo].[PhotograperRegistration](
          [ID] [int] IDENTITY(1,1) NOT NULL,
          [Email] [varchar](500) NULL,
          [Password] [varchar](50) NULL,
          [First_Name] [varchar](50) NULL,
          [Last_Name] [varchar](50) NULL,
          [Gender] [varchar](50) NULL,
          [MyWebsite] [varchar](50) NULL,
          [Experience] [varchar](50) NULL,
          [Compensation] [varchar](50) NULL,
          [Genres] [varchar](500) NULL,
          [AboutMe] [text] NULL,
          [Country] [varchar](50) NULL,
          [ProfileImage] [varchar](50) NULL,         
          [Profile_CreatedDT] [datetime] 
NULL,
     CONSTRAINT [PK_PhotograperRegistration] PRIMARY KEY CLUSTERED
     (
          [ID] ASC
             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
           IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
    GO
    SET ANSI_PADDING OFF
    GO
 
    ALTER TABLE [dbo].[PhotograperRegistration] ADD  CONSTRAINT [DF_PhotograperRegistration_Profile_CreatedDT]  
     DEFAULT (getdate()) FOR [Profile_CreatedDT]
GO 

2. Photos

Table_Photo.png

Image 2.

Script Of My Table Is:

CREATE TABLE [dbo].[Photos](
          [Photo_ID] [int] IDENTITY(1,1) NOT NULL,
          [Photographer_ID] [int] NULL,
          [Title] [varchar](500) NULL,
          [Description] [varchar](500) NULL,
          [ImageName] [varchar](50) NULL,
          [Upload_Date] [datetime] NULL,
     CONSTRAINT [PK_Photos] PRIMARY KEY CLUSTERED
     (
           [Photo_ID] ASC
       )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, 
      ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    SET ANSI_PADDING OFF
    GO
    ALTER TABLE [dbo].[Photos] ADD  CONSTRAINT [DF_Photos_Upload_Date]  DEFAULT (getdate()) FOR [Upload_Date]
    GO

 

Now I am explaining the working of My Project. 

Below is my Default page. Here you can see all newly created Photographer profile and all new uploaded photos. From here you can view any photographer profile by clicking profile image. 

In recently uploaded photos you can view photo details by clicking on photo.

 

Default.png

 

Image 3.

 

Now click on Create profile link to create new profile.

Create Profile.png

 

Image 4.

 

After creating profile this will display on default page. Now click on any profile on default page like below.

 

Photographer Profile.png

 

Image 5.

 

Now click on any photo to view photo details.

 

Photo Details.png

 

Image 6.

 

Now if any existing photographer wants to login then click on Login button.

 

Login.png

 

Image 7.

 

After log in photographer will redirect to My Account Page.

 

My Account.png

 

Image 8.

 

From here Photographer can view his/her profile, see all uploaded photos & can upload new photo.

 

Uplaod Photo.png

Image 9.

 

Now see your uploaded photos.

 

My Account 2.png

 

Image 10.

 

Now see this photo as recently uplaoded photo on default page.

 

Default 2.png

 

Image 11.

 

I have saved my DB inside App_Data folder.

 

Data Base File.png

 

Image 12.

 

Once Again I am showing my DB as Data Base diagram.

 

DataBase Diagram.png

 

Image 13.

 

Enjoy My Project  J  Happy Coding!

  Comment:
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us