An Open Source Project: R-An Online Photographer Portal
This is my open source project developed using Visual Studio 2012, C# and SQL Server 2008 R2.
Basically I developed this project with the name R-An Online Photographer Portal.
Here any photographer can create his/her profile, can upload new photos and can view existing uploaded photos. Any user can view any photographer profile and their uploaded photos.
The following are the 2 tables I used in this project.
PhotograperRegistration
The following is the script of my table:
- 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
Photos
The following is the script of my table:
- 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 how my project works.
The following is my Default page. Here you can see all the newly created Photographer profile and all new uploaded photos. From here you can view any photographer profile by clicking the profile image.
In the recently uploaded photos you can view the photo details by clicking on a photo.
Now click on the Create profile link to create a new profile.
After creating the profile this will be displayed on the default page. Now click on any profile in the default page as in the following.
Now click on any photo to view the photo details.
Now if any existing photographer wants to login then click on the Login button.
After logging in the photographer will be redirected to the My Account Page.
From here the Photographer can view his/her profile and see all the uploaded photos and can upload new photos.
Now see your uploaded photos.
Now see this photo is a recently uplaoded photo in the default page.
I have saved my DB inside the App_Data folder. From Here you can attach DB for this project.
Once again I am showing my DB as Database diagram. You can create these tables in you DB.
Enjoy my project. Happy Coding!