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

An Open Source Project- R-An Online Photographer Portal

Viewed:  3486 
Posted On:  07/03/2015 10:21:50 
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


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] 
     CONSTRAINT [PK_PhotograperRegistration] PRIMARY KEY CLUSTERED
          [ID] ASC
    ALTER TABLE [dbo].[PhotograperRegistration] ADD  CONSTRAINT [DF_PhotograperRegistration_Profile_CreatedDT]  
     DEFAULT (getdate()) FOR [Profile_CreatedDT]

2. Photos


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,
           [Photo_ID] ASC
    ) ON [PRIMARY]
    ALTER TABLE [dbo].[Photos] ADD  CONSTRAINT [DF_Photos_Upload_Date]  DEFAULT (getdate()) FOR [Upload_Date]


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.




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.




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!

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