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] 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
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.
Image 3.
Now click on Create profile link to create new profile.
Image 4.
After creating profile this will display on default page. Now click on any profile on default page like below.
Image 5.
Now click on any photo to view photo details.
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.
Image 8.
From here Photographer can view his/her profile, see all uploaded photos & can upload new photo.
Image 9.
Now see your uploaded photos.
Image 10.
Now see this photo as recently uplaoded photo on default page.
Image 11.
I have saved my DB inside App_Data folder.
Image 12.
Once Again I am showing my DB as Data Base diagram.
Image 13.
Enjoy My Project J Happy Coding!