Pillai S College of Arts, Commerce & Science

MAHATMA EDUCATION SOCIETY’S

PILLAI’S COLLEGE OF ARTS, COMMERCE & SCIENCE

NEW PANVEL.

A PROJECT REPORT ON

WEB-BASED

ONLINE CLASSIFIEDS MANAGEMENT SYSTEM

SUBMITTED TO

UNIVERSITY OF MUMBAI

BY

Name

B.Sc. IN INFORMATION TECHNOLOGY

UNDER GUIDANCE OF

MR. PRAKASH BHISE

2014-2015

CERTIFICATE

INDEX

INTRODUCTION

ACKNOWLEDGEMENT

I, Name,of ‘PILLAI COLLEGE OF ARTS, SCIENCE & COMMERCE’ with an immense pleasure would like to present this project documentation on “ONLINE CLASSIFEDS MANAGEMENT SYSTEM”.

I would like to express gratitude and indebtedness to Mr.Prakash Bhise for his valuable advice and guidance without which this project would have not seen the light of the day.

I would also like to thank all the staff members of my college for their kind co-operation.

Finally, I would like to thank my parents for being supportive all the time. I am very much obliged to them. I am also thankful to all my friends for their moral support.

Yours faithfully,

ABHIJEET BHARAT SHINDE

(Final Year in Bachelor of Science in Information Technology)

ANALYSIS PHASE

REQUIREMENTS GATHERING

ABSTRACT

Everybody wants their special day to be perfect in every way. Whether it’s a surprise celebration, wedding reception, a corporate meeting or a launch of a new product or company, Special Event Planning and Decor can make it seamless, memorable and exceptional.

 Wedding planning

 Reception and party decor

 Engagement

 Birthday Parties

The project will help Clients to decorate and manage their event and the best cost required for particular decoration.

PROPOSED SYSTEM

The aim of this project is to make a user friendly application that can let a user to plan and decorate their event. He can select the event and according to the event the appropriate decoration can be made.

Choice of decoration can be made from the list of panel. Client will also find out the cost for particular decoration and virtual representation of that particular decoration.

ADVANTAGES OF PROPOSED SYSTEM

The proposed system will help to put all the operations online. Data will now be stored in digital format and will be able to keep data safe for ever by doing backups. The advantages of the proposed system are as follows:-

• Automatic payments methods to avoid time delay and negotiation.
• Data available for trend analysis to make effective cost decision.
• Direct mail, promotional banners and an informative event web site for easier access of events to clients.
• Personalization and targeted messaging to break an event.
• Effective campaign management by tracking the progress and bumps in the ongoing events.
• Pre populate attendee data into registration forms and provide a simple three click registration process proven to dramatically increase response rates.

• Give the clients or attendees the full support in deciding and planning their event.
• Data entry, stuffing envelopes, manual payment processing, creating reports manually, completing telephone registrations, telephone surveying and other tasks consume a tremendous amount of time and resources.
• Online systems can automate all of these tedious functions and enable one planner to execute more events, improve the quality of events, focus on higher-level responsibilities, make informed decisions and leave the office at a reasonable time every day.
• Event details can be provided in event confirmation letters, which are best sent via email.
• Much improved data analysis tool to Measure all aspects of event performance from attendance to revenue.

OPERATING ENVIRONMENT SPECIFICATIONS

HARDWARE REQUIREMENTS

• Input device : Windows XP/7/98.
• Output device : Standard color monitor, printer.
• RAM : 256 MB.

• Hard Disk : 120 GB.

SOFTWARE REQUIREMENTS

• Operating System: Windows XP/Vista/7.
• Back End Tool: SQL Server 2008.

• Front End Tool : Microsof Visual Studio 2010(ASP.NET).

SYSTEM STUDY

EXISTING SYSTEM

Planning of event has become the necessity of current time .In organizing the event, the decoration of that event is very important. Thus decoration is a vital part of planning an event. Decorating an event is a very tedious work which is faced by the event planners. So decorating the event using the web application provides the event planners ease in organizing the event.

This project will help the client to manage their event in order to setup and decorate the venue as in a efficient manner. The project can be extended to manage multiple events, keeping in mind the resource and time required for the same. The stored with the project can be used to analyze the market trends in terms of resource cost and man power involved.

.

LIMITATIONS OF EXISTING SYSTEM

1. This activity requires a precise definition of the problem in user terms in order to understand and come up with a solution to solve it efficiently.

2. A clear statement of the problem is crucial to the success of the web application.

3. A lot of human effort or labor us wasted in maintaining the records, and the records a always prone to human errors

4. Keeping recording for every event and respective service required for the client in the registers takes more time & is a tedious job.

5. To search for details of any particulars has to refer many registers.

6. Lacks reliability & no guarantee of sure end results.

7. The existing system doesn’t provide any tool to analyze the trends in the event management.

Areas for Improvement

Effective and economical invitations- The current system used traditional system for advertising their events and for invitations which costs more and less efficient.

• Communication with the client- The second secret key to successful events is to support your event marketing
• Efforts with targeted and personalized emails to invitees.
• Each group of invitees should receive specific messaging tailored to their interests.
• Response rates for a one size fits all invitation can be 50% less than invitations for specific groups of attendees such as VIP clients, prospects, different levels of association members etc. Furthermore, it is essential to send invitations that are personalized.
• Leverage the Event Website- Creating a compelling event web site is the fourth key to successful event marketing. It is critical for an event web site to allow attendees to register and pay for an event online (if fees apply for the event).
• There are various website oriented marketing initiatives that can be used to promote registration and attendance, such as early bird discounts, group rates, and promotion codes.
• Offering online event registration via the event web site is key because it allows planners to measure if they will have the right amount of space, food, seats, and materials at the event.
• Without a solid online registration solution and the capability to track these metrics, planners often overbook a venue or undersell the space they have bought.
• A quality event web site should present attendees with an event agenda and streamline the registration process for all parties.

FRONT- END TOOL

Microsoft Visual Studio 2010(ASP.NET):

Itis anintegrated development environment(IDE) fromMicrosoft. It is used to developcomputer programsforMicrosoft Windows, as well asweb sites,web applicationsandweb services. Visual Studio uses Microsoft software development platforms such asWindows API,Windows Forms,Windows Presentation Foundation,Windows StoreandMicrosoft Silverlight. It can produce bothnative codeandmanaged code.

Visual Studio includes acode editorsupportingIntelliSense(thecode completioncomponent) as well ascode refactoring. The integrateddebuggerworks both as a source-level debugger and a machine-level debugger. Other built-in tools include a forms designer for buildingGUIapplications,web designer,classdesigner, anddatabase schemadesigner. It accepts plug-ins that enhance the functionality at almost every level—including adding support forsource-controlsystems (likeSubversion) and adding new toolsets like editors and visual designers fordomain-specific languagesor toolsets for other aspects of thesoftware development lifecycle(like theTeam Foundation Serverclient: Team Explorer).

Visual Studio supports differentprogramming languagesand allows the code editor and debugger to support (to varying degrees) nearly any programming language, provided a language-specific service exists.

BACK- END TOOL

Microsoft SQL Server 2008:

Microsoft SQL Serveris arelational database management systemdeveloped byMicrosoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with manyconcurrent users.

DESIGN PHASE

CLASS DIAGRAM:

ACTIVITY DIAGRAM:

USE-CASE DIAGRAM

E-R DIAGRAM

SEQUENCE DIAGRAM

SYSTEM DESIGN

GANNT CHART:Gantt chartsare useful for planning and scheduling projects. They help you assess how long aprojectshould take, determine the resources needed, and plan the order in which you'll complete tasks. They are also helpful formanagingthe dependencies between tasks.

Proposed Plan

Actual Plan

IMPLEMENTATION PHASE

SNAPSHOTS AND CODING:

1.Home Page:

C# Coding

Registration Page

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

public partial class User1_2Registration : System.Web.UI.Page

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

int check(string sql)

{

cn.Open();

SqlCommand cmd = new SqlCommand(sql, cn);

SqlDataReader dr = cmd.ExecuteReader();

int ans = 0;

while (dr.Read())

{

ans++;

}

cn.Close();

return ans;

}

protected void Button9_Click(object sender, EventArgs e)

{

int temp = 0;

try

{

temp = check("select * from tblregistation where username='" + txtUsername.Text + "'");

if (temp > 0)

{

Label1.Text = "Username already Used";

}

else

{

cn.Open();

string check1;

if (chkAgree.Checked == true)

{

check1 = "Yes";

}

else

{

check1 = "No";

}

string sql = "insert into tblRegistation values('" + txtUsername.Text + "','" + txtPassword.Text + "','" + txtName.Text + "','" + ddlQuestion.SelectedValue + "','" + txtAnswer.Text + "','" + txtEmail.Text + "','" + ddlCountry.SelectedValue + "','" + ddlState.SelectedValue + "','" + txtMo.Text + "','" + txtPincode.Text + "','" + ddlGender.SelectedValue + "','" + check1 + "')";

SqlCommand cmd = new SqlCommand(sql, cn);

int ans = cmd.ExecuteNonQuery();

if (ans > 0)

{

Response.Redirect("~/user1/3Login.aspx");

}

cn.Close();

}

}

catch (Exception ex)

{

Label1.Text = "System Failuer Try Again";

}

}

}

Login Page

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

public partial class User1_3Login : System.Web.UI.Page

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button9_Click(object sender, EventArgs e)

{

try

{

cn.Open();

string sql = "select * from tblRegistation where username='"+TextBox1.Text +"' and password='"+TextBox4.Text +"'";

SqlCommand cmd = new SqlCommand(sql, cn);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Session["uname"] = TextBox1.Text;

Response.Redirect("~/User2/1UserHome.aspx");

}

else

{

Label1.Text = "Username Or Password is Invalid";

}

cn.Close();

}

catch

{

Label1.Text = "System Failuer";

}

}

}

Forgot Password

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

public partial class User1_4ForgotPassword : System.Web.UI.Page

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button9_Click(object sender, EventArgs e)

{

try

{

cn.Open();

string sql = "select * from tblregistation where username='" + txtUsername.Text + "' and seqque='" + ddlQuestion.SelectedValue + "' and answer='"+txtAnswer.Text +"' and email='"+txtEmail.Text +"'";

SqlCommand cmd = new SqlCommand(sql, cn);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Label1.Text="Your Current Password is:"+"<B<U>"+dr[1].ToString()+ "</B</U>";

}

else

{

Label1.Text = "Invalid Information";

}

cn.Close();

}

catch

{

Label1.Text = "System Failuer";

}

}

}

TESTING PHASE

Test result and test report

ANNEXURE

CONCLUSION

• More Detailed maintenance of classifieds.
• The number of categories at present are limited and in future, it’s possible to include more categories to the present list.
• The proposed system also provides an attractive (user-friendly) environment in which we can explore the event management efficiently in every respect than the traditional event managing system.
• Facility to link with other different event management websites.
• In future, the users will be allowed to have more access to system by having to create chat and polling applications.
• Less consumption of manpower and capital

• Time is saved due to faster access to each and every thing since all the tasks and activities are computerised.

• Less scope of human errors as errors can be easily rectified because of automization.

• The proposed system is beneficial to the users as well as the people who post the ads economically.

BIBLIOGRAPHY

UNDER GUIDENCE OF

Prof. PrakashBhise.

BOOKS:

Murach’s Visual Basic 2010.

Beginning with ASP.NET 2010.



WEBSITES:

1