Advertisements are very necessary in order to market or promote the product of the particular product. Advertisements can be done through the online mode through the radio, television, social networking sites so that it will gain nice promotion. Online advertisement management system is an application that deals with maintaining the advertisements given by the customers to the company. There will be many customers with different advertisements for a particular company. Maintenance of all the data using pen paper work is a tedious job. So to reduce the manual effort, the online advertisement management application will be of great help. This application will be very useful to the advertising agencies and the managers to manage advertisements and to view reports.

The user interface must be simple and easy to understand. This will be one of the useful projects that one can work on and implement in real time application. The schedule of the advertisement must be given so that it can be put on online. This application can be implemented on the internet for the real time use. Advertisements are very necessary in order to gain profit for any organization or the company. The features that can be included in online advertisement management application are as follows:

• Customer information: The details of the customers like name, address, contact must be stored in order to have the details of the advertisement with great ease.
• Advertisement details: The details related to the address can also be stored through this application.
• Provision of schedules: The details of the schedules that are provided to the customers can also be maintained through this application.
• Employee details: The employee details can also be maintained through this application before the administrator gets the customer details involved in advertisements.
• Reports: This application will help in generating reports based on the accounts that are there for advertisements.

Project title: Online Advertisement management System

Front End: ASP.NET (C# Language)

Back End: SQL Server

The C# language used to develop this ASP.NET project. The project source code is in the project folder and the database backup in the database folder. The database has 5 tables. The tables are created to store advertisements, budget details, advertisement channels, advertisement durations, user details and time slots. We have created 1N, 2N and 3N normalized tables.

Pages in this source code:

• Manager_Report.aspx
• Staff_report.aspx
• Forgot_Password.aspx
• Login_Page.aspx
• Logout_Page.aspx

Database backup files:

• ADMGT_AD_IDS_TB.sql
• ADMGT_BUDGET_TB.sql
• ADMGT_CHANNEL_TB.sql
• ADMGT_DURATION_TB.sql
• ADMGT_LOGIN_TB.sql
• ADMGT_TIME_SLOT_TB.sql

Kindly configure the database settings in the web.config .

<appSettings>
<add key="DSN" value="Server=.;DATABASE=Group_17;USER ID=sa;PWD=sa"/>
</appSettings>

Sample Login page source code: In the sample source code select query given to login the site. If user is login and password is valid then it logs in to the website.

		private void btnLogin_Click(object sender, System.EventArgs e)
		{
			SqlConnection con=new SqlConnection(ConfigurationSettings.AppSettings["DSN"]);
			
			con.Open();
			
			SqlCommand cmd=new SqlCommand("select ROLE from ADMGT_LOGIN_TB where PK_LOGIN_USER_NAME='"+					txtUser.Text+"' and	PASS_WORD='"+txtPass.Text+"'",con);

			string dr=Convert.ToString(cmd.ExecuteScalar());
			Session["ROLE"]=dr;
			Session["PK_LOGIN_USER_NAME"]=txtUser.Text;


			if(dr=="mgr")
			{
				
				Response.Redirect("Manager_Report.aspx");
			}
			else if(dr=="staff")
			{
				Response.Redirect("Staff_Report.aspx");
			}			
			else
			{
				
				lblInvalidUser.Text="Invalid User Name or Password";
				lblInvalidUser.Visible=true;
			}
		}

Download Project Source Code: Download this source code. This download link has source code folder, database backup and ppt presentation.

Note: This source code we download from internet and modified and fixed all the bugs. This is just student project and its not a real time live project. Kindly don’t submit this project for your college project. The company name and images in this project we used only for testing purpose. This project is only for reference purpose. If you have any queries regarding this project kindly post your queries in the comment box.