ONLINE COURSE MANAGEMENT SYSTEM PROJECT REPORT | ONLINE COURSE MANAGEMENT SYSTEM

Project Overview

Course Management systems have become more and more widely used in past 30 years. It was developed simultaneously at number of institutions. We will produce a working online course management system which will provide student validation functionality. To develop this online course system a combination of software, hardware, and coding knowledge will be required. A relational database will be used to store information about students and course content. A relational database was chosen as it provides an effective solution users for to access information. Server Pages will be used to create the actual online application that will communicate between the database and the user. The decision to use Server Pages in the online course system project was made because it is platform-independent and will provide an opportunity for the team to learn and apply a new programming validation technology

Objectives

Documentation, tracking, and reporting of training programs, classroom and e-learning programs content. Moreover it provides great assistance to the students who want to interact with faculty or other student from any place. Some features of online course management system are:-online course management system is a web portal for the administration

Ø Use self-service and self-guided services.

Ø Centralize and automate administration.

Ø Assemble and deliver learning content rapidly.

Ø Support portability and standards.

Personalize content and enable knowledge reuse.

1.2 Purpose, Scope

1.2.1 Purpose

Online course management systems became widely available in 1997 and its popularity has increased hugely ever since. The market conditions for these course management systems have been optimistic. The new technology has been positively reviewed and used by many colleges and universities across the country and some internationally. The future for course management systems is endless just as it is for many technologies of this nature. This is evident through its own development. Course management systems have gone from a place to post a syllabus and internet users.

1.2.2 Scope

A course management system is a web based application through which learning content is delivered and managed. A course management system is tied to on-line and off -line administration and performance management and includes functionality for course catalogs, launching courses, registering learners, and assignment. A CMS combines a front-end for the learners with a back-end for administrators and instructors. This course management system seamlessly displays, in a browsers interface, real time information drawn from a database. Has a front-end for administrators and instructors.

CHAPTER 2: SURVEY OF TECHNOLOGIES

ASP.NET 3.5 (C#):-

On November 19, 2007, Microsoft officially released the ASP.NET version 3.5 and Visual Studio 2008. Like with the progression from ASP.NET 2.0 to 3.0, the features in ASP.NET 3.5 are additive, meaning that the core assemblies installed from the .NET Framework version 2.0 are still used by the 3.0 and 3.5 versions.

Visual Studio 2008 is the recommended tool for developing ASP.NET applications. Unlike previous versions of Visual Studio, which were targeted to a specific framework version (i.e., Visual Studio .NET 2003 targeted ASP.NET 1.1 and Visual Studio 2005 targeted ASP.NET 2.0), Visual Studio 2008 is multi-targeted, meaning that you choose from a drop-down list whether to have Visual Studio 2008 build applications against the ASP.NET 2.0, 3.0, or 3.5 frameworks. Visual Studio 2008 also includes an improved Designer experience, JavaScript debugging and IntelliSense features, and the ability to view and even step into the core .NET Framework code during debugging.

ASP.NET web pages or webpage, known officially as Web Forms, are the main building block for application development. Web forms are contained in files with an ".aspx" extension; these files typically contain static markup, as well as markup defining server-side Web Controls and User Controls where the developers place all the required static and dynamic content for the web page.

NET Framework 3.5 New Features:-

1. Faster garbage collection

2. Smarter, faster Next Gen requiring smaller working set RAM

3. 64 bit client improvements

4. Thread Pool performance improvements

5. Security check caching during Next Gen

Microsoft SQL Server 2005:-

SQL server is a relational database management system (RDBMS) from Microsoft that’s designed for the enterprise environment. SQL Server runs on T-SQL (Transact-SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL including transaction control, exception and error handling, row processing and declared variables.

Codenamed Yukon in development, SQL Server 2005 was released in November 2005. The 2005 product is said to provide enhanced flexibility, scalability, reliability, and security to database application, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management. SQL Server 2005 also includes more administrative support. The original SQL Server code was developed by Sybase; in the late 1980s, Microsoft, Sybase and Ashton-Tate collaborated to produce the first version of the product, SQL Server 4.2 for OS/2. Subsequently, both Sybase and Microsoft offered SQL Server products. Sybase has since renamed their product adaptive server enterprise.

CHAPTER 3: REQUIREMENTS AND ANALYIS

Requirements and analysis is the main features of the software development. The following types of requirement and analysis are given below:

3.1 Problem Definition

· Problem Definition:-

There are various problems in the manual learning System because it is not easy system. useful for those people which are working and not have time for proper time for class room education. In this application we have to improve the problem of current learning This application is very useful for working person.

3.2 Requirements Specification

· Requirement Specification:-

In the proposed software the requirements of Online Course Management System the are given below:

· User can register herself/himself for any courses.

· Admin provide username and password to each student through their e-mail id.

· User can get detail of any courses available on the site.

· User can get online course material, notes,

· User can interact with their counselor.

· Collage faculty can also upload course materials.

3.3 Planning and Scheduling

· Planning and Scheduling:-

Ø Design of application.

Ø Design the prototype.

Ø Test the prototype with user acceptance.

Ø Use the finalized prototype as sample.

Ø Develop each module using water fall model.

Ø Integrate all the modules.

Ø Use black box testing of integrated modules.

Ø Fixing the bugs.

Ø Wrap up all the finalized modules.

Ø Deploy the application

3.3 Planning and Scheduling

Gantt chart:

A GANTT chart uses a calendar-oriented chart to represent the project schedule. Each activity is represented as a bar in the calendar, starting from the start date of the activity and ending at the ending date for that activity. The start and end of each activity becomes milestones for the project. The GANTT chart for this project is:

Task	21-25 mar	26-2 apr	3-18 apr	19-28 apr	1-7 may	8-12 may
Preparation and Planning
Develop Project Proposal
Analysis
Designing
Coding
Testing
Unit Testing
Alpha Testing
Beta Testing
Implementation

3.4 Software and Hardware Requirements

· Software and Hardware Requirement:-

(i) Hardware:

Processor : Minimum Intel Pentium IV or Above

(CPU Speed Pentium Type 1.2GHz)

RAM : 1GB Min Or Above

Free Hard Disk Space : 10 GB Free Space

Color Monitor : 17’’

(ii) Software:

Operating System : Windows XP, SP2

Front End : ASP.NET 3.5

Language : c#

Back End : SQL SERVER 2005

Any Internet Browser : a] Internet explorer

b] Mozilla fire fox

3.5 Preliminary Product Description

Present system is manual. The working of the organization May be described as:All details of Student, employees, Eligibility, Post etc are maintained in registers. All Payments & dues are also maintained in registers. All Bills are manually created, and send at desired place for further use. The daily-to-daily entries are also being manually.

Preliminary investigation took me to the Accounts room of Agency, where I came across the current working process. Although the process of maintaining data is not a recorded one as such there were no documents to be reviewed in order to determine efficacy of the current working process. So I had to emphasize on the observation I made while in the office. In order to complement my onsite observations I undertook a simple interview of office bearers. The results of which are broadly catalogued below.

In concurrence with onsite observation I conducted some interviews. To get a closer look at the present working culture and identify the problem domain I talked to some of office bearers. I presented them with the following set of questions.

Questionnaire:

Some general questions-

1.Who is behind the request for this work?

2.Who will use the software?

3.Why do you want this software?

4.Can you show me the environment in which the software will be used?

5.What is your requirement?

6.What will be the economic benefit of a successful solution?

Other question about software-

1.What do you feel is the biggest bottleneck in your work?

Ans. The slow working process of the work due to high number of calculations.

2. What effect does it have on your work?

Ans. Usually it delays our work. As such we have to prepare ourselves 3 to 4 days beforehand to say the least.

3. Are you always satisfied with your results?

Ans. No because it hardly leads to a conclusive result rather generating further queries. Also the bulk of work sometimes forces us to limit our capabilities and skip through some material and information since they may not be available.

The preliminary investigation gave me clear information about the ills plaguing the present system.

3.6 Conceptual Models

Entity Relationship Diagram

Gives

Programs

Enrolled in

Upload

Locate on

Approve registration of

Students

Has

Courses

Faculties

Online Course Management System

Entity Relation Ship Diagram (ERD)

Controls

Provide

CHAPTER 4: SYSTEM DESIGN

4.1 Basic Modules

In this project we have many modules who already used.

1. Registration module: in this module any student or faculty registers in any online university.

2. Login Module: in login module first any user logged himself. Then use any facility related to online course management.

3. Student verification: in this module student verified by admin. And register him to any course.

4. Cource upload: help of this module any student or user who already registered in any course can upload any query.

5. Cource Download: in this module any student can download any data of any subject.

6. Student forum: used of this module any user or faculty can discuss on any subject.

4.2 Data Design

4.2.1 Schema design

Table: Student

Attribute	Data Type(size)	Type	Contraints
Stu_id	Numeric (10)	Numeric	Primary Key
Stu_name	Varchar(40)	Varchar	Not Null
Fath_name	Varchar(30)	Varchar	Not Null
Mot_name	Varchar(30)	Varchar	Not Null
Stu_add	Varchar(50)	Varchar	Null
Stu_city	Varchar(30)	Varchar	Null
Stu_state	Varchar(20)	Varchar	Null
Stu_country	Varchar(20)	Varchar	Null
Stu_dob	Numeric(15)	Numeric	Not Null
Stu_username	Varchar(20)	Varchar	Not Null
Stu_password	Numeric(20)	Numeric	Not Null

Table: Registration

Attribute	Data Type(size)	Type	Contraints
Reg_no	Numeric(30)	Numeric	Primary Key
Reg_date	Numeric(30)	Numeric	Not Null
Roll. No.	Numeric(30)	Numeric	Not Null
Cour_code	Varchar(30)	Varchar	Not Null
App_stat_by_admin	Varchar(30)	Varchar	Not Null

Table: course

Attribute	Data Type(size)	Type	Contraints
Cour_code	Varchar(20)	Varchar	Primary Key
Cour_name	Varchar(40)	Varchar	Not Null
Cour_fee	Numeric(10)	Numeric	Null
Cour_duration	Numeric(10)	Numeric	Null

Table: subject

Attribute	Data Type(size)	Type	Contraints
Sub_code	Varchar(20)	Varchar	Primary Key
Sub_name	Varchar(20)	Varchar	Not Null
Description	Varchar(40)	Varchar	Not Null

Table : program

Attribute	Data Type(size)	Type	Contraints
Pro_code	Varchar(20)	Varchar	Primary Key
Pro_name	Varchar(20)	Varchar	Not Null
Description	Varchar(20)	Varchar	Not Null

Table: semester

Attribute	Data Type(size)	Type	Contraints
Sem_code	Varchar(10)	Varchar	Primary Key
Sem_slat	Varchar(10)	varchar	Not Null
Pro_code	Varchar(10)	Varchar	Not Null

Table:admin

Attribute	Data Type(size)	Type	Contraints
Admin_name	Varchar(20)	Varchar	Null
Admin_pass	Varchar(20)	Varchar	Not Null
Email_id	Varchar(20)	Varchar	Null

Table: announcement

Attribute	Data Type(size)	Type	Contraints
Ann_id	Varchar(20)	Varchar	Not Null
Ann_des	Varchar(20)	Varchar	Not Null
Date	Numeric(10)	Numeric	Not Null
Remark	Numeric(20)	Numeric	Not Null

Table: achievement

Attribute	Data Type(size)	Type	Contraints
Ach_id	Numeric(20)	numeric	Primary Key
Ach_des	Varchar(20)	Varchar	Not Null
Date	Numeric(10)	Numeric	Not Null
Remarks	Numeric(10)	Numeric	Not Null

Table : update file

Attribute	Data Type(size)	Type	Contraints
File_id	Numeric(10)	Numeric	Primary Key
File_name	Varchar(20)	Varchar	Not Null
Upload_by_date	Numeric(20)	Numeric	Not Null
Remark	Numeric(10)	Numeric	Not Null
Course_code	Numeric(10)	Numeric	Not Null

4.2.2 Data Integrity and Constraints

Validation Check:

There are lots of stages in the proposed software where validation checks will be used. The first check will be used during password verification. If the password entered by the user is correct then proceed and log him into the software else ask again for the password.

Validation checks during addition and modification of data:-

Duplicate entry: Duplicate records cannot be entered in the database because primary key is defined wherever required. For example:

rst.Open "select * from cust_info WHERE c_id='" & Trim(atext_cid) & "'", cn, adOpenDynamic, adLockOptimistic

With rst

If .RecordCount <> 0 Then

MsgBox ("DUPLICATE ID NOT ALLOWED")

atext_cid = ""

atext_cid.SetFocus

Else

Exit Sub

End If

End With

BLANK ENTRY: Blank entries cannot be entered in the database because fields are defined as NOT NULL in database. If any of the field is empty, the data does not get saved instead it keeps on asking for the values and saves the data when all the required fields are provided. For example:

If atext_cid.Text = "" Or aText_cname.Text = "" Or atext_add.Text = "" Or aText_str.Text = "" Or aText_city.Text = "" Or aText_state.Text = "" Or aText_pin.Text = "" Or aText_ph.Text = "" Or aText_cell.Text = "" Then

MsgBox " Blank Entrys Are Not Allowed.....!!!!", vbExclamation

atext_cid.SetFocus

Exit Sub

End If

NUMERIC CHECK: Character entry is not allowed in NUMERIC fields as numcheck is defined in programming.

Public Function NumChk(key As Integer)

Num = "0123456789."

If key > 26 Then

If InStr(Num, Chr(key)) = 0 Then

key = 0

End If

num_chk = key

End Function

ITEM MUST BE SELECTED: Item must be selected from the list before it is deleted or updated in the database. For example:

If a_flistday.ListIndex = -1 Then

MsgBox "Select an Item from the List!", vbInformation

Exit Sub

4.3 Procedural Design

4.3.2 Logic Diagrams

DFD

Students

Uploaded file

Student Info Update

Course

Management

System

Courses

Verification of user name and password

Course Details Verify

Registered user

Faculties

Manage

Faculty

Details

Create

Reports

Update

Database

Context Level DFD

Detail of student Registration

1.1

Reports

Database

Students

Incorrect information

Verification of Student and username and password generation 1.2

Online Course Management System 1.0

1.0

11.0

1.0

S_name,s_id,ph

Courses

C_name

Faculties

Uploaded File For different course

1.1

F_name,f_id,f_ph

First level DFD

Courses

Reports

Announcement & Achievements

Database

Generate

Students

U u update

Courses and Subject Selection

update

Online Course Management System

Student Registration

Verification by Admin by Sending a email

Generate User name and Passward

Faculties

info

Map Upload File in Related Courses

Students can take benefit of uploaded files

Upload file like audio, video and text tutorials

Second Level DFD

4.3.1 Data Structures

DATABASE FORM: REGISTER PAGE

DATABASE FORM: LOGIN PAGE

DATABASE FORM: TUTORIAL DETAILS PAGE

DATABASE FORM: PROGRAM PAGE

DATABASE FORM: SEM PAGE

DATABASE FORM: COURSE PAGE

DATABASE FORM: COUNTRY PAGE

DATABASE FORM: STATE PAGE

DATABASE FORM: CITY PAGE

DATABASE FORM: FACULTY REGISTER PAGE

DATABASE FORM: ANNOUNCES PAGE

DATABASE FORM: REPLY PAGE

DATABASE FORM: TOPIC PAGE

4.4 User Interface design

FORM NAME: HOME PAGE

FORM NAME: ABOUT COLLEGE PAGE

FORM NAME: ABOUT COURSE PAGE

FORM NAME:REGISTRATION PAGE

FORM NAME: USER CONFIRMATION PAGE

FORM NAME: ADMIN HOME PAGE

FORM NAME: VERIFY STUDENT PAGE

FORM NAME: REGISTER FACULTY PAGE

FORM NAME: FACULTY HOME PAGE

FORM NAME: FACULTY UPLOAD COURSE PAGE

FORM NAME: FORGET PASSWORD OF STUDENT PAGE

FORM NAME: STUDENT HOME PAGE

FORM NAME: STUDENT DOWNLOAD PAGE

FORM NAME: STUDENT FORUM PAGE

FORM NAME: VIEW PERSONNEL DETAILS OF STUDENT PAGE

FORM NAME: EDIT PERSONNEL DETAILS OF STUDENT PAGE

FORM NAME: CHANGE

PASSWORD OF STUDENT PAGE

FORM NAME: UPDATE ANNOUNCES PAGE

FORM NAME: VIEW ANNOUNCES PAGE

FORM NAME: CHANGE PASSWORD OF ADMIN PAGE

FORM NAME: VIEW STUDENT DETAILS PAGE

FORM NAME: CONTACT US PAGE

4.5 Security Issues

Security is the policy that protects any system or part of a system by unauthorized access that can cause the inconsistency or major loss to the system.

The primary reason the IT security industry exists is because IT products and services aren't naturally secure. If computers were already secure against viruses, there wouldn't be any need for antivirus products. If bad network traffic couldn't be used to attack computers, no one would bother buying a firewall. If there were no more buffer overflows, no one would have to buy products to protect against their effects. If the IT products we purchased were secure out of the box, we wouldn't have to spend billions every year making them secure.

Authentication is the act of establishing or confirming something (or someone) is authentic, that is, that claim made by or about the thing are true. This might involve confirming the identity of a person, the origins of an artifact, or assuring that a computer program is a trusted one.

In security engineering and computer security, authorization is the concept of allowing access to resources only to those permitted to use them. More formally, authorization is a process that protects computer resources by only allowing those resources to be used by resource consumers that have been granted authority to use them.

4.6 Test Cases Design

4.6.1 TEST CASE FOR REGISTRATION

Serial number

Test case

Expected result

Registration

Enter name, father name, family income, subject, year of passing, percentage, address line 1, address line2, city, pin, fee details, correspondence address, telephone number, mobile number, Email_id are written in textbox.

Rest of the details is to simply select through drop down list for appropriate Selection.

Name, father name, date of birth, nationality, sex, category, marital status, religion, minority, social status, Kashmir migrant, password, correspondence address1, state, city, pin, Email_id cannot be NULL.

Click on the Submit button.

Successful submit will into the values enter into database and send a confirmation result is send to his preferred Email_id.

4.6.2 TEST CASE FOR USER LOGIN

Serial number

Test case

Expected result

Enter Enrollment number in the text box Specified.

Enrollment number must be more the 8 integer number and it should not be character and it should not be contain any special character and no spaces in the short.

Enter the password in the text box Specify password must not be more the 10 character

Click on the log in button.

Successful login in to in to the system if the value is found in the Database.

4.6.3 TEST CASE FOR ADMINISTRATER LOGIN

Serial number

Test case

Expected result

Enter Enrollment number in the text box Specified.

Enrollment number must be more the 8 integer number and it should not be character and it should not be contain any special character and no spaces in the short.

Enter the password in the text box Specify password must not be more the 10 character

Click on the log in button.

Successful login in to in to the system if the value is found in the Database.

CHAPTER 5: IMPLEMENTATION AND TESTING

5.1 Implementation Approaches

Implementation includes all those activities that take place to convert from old system to new one. The new system may be completely new, replacing an existing manual or automated system or it may be major modification to an existing system. In either case, proper implementation becomes necessary so that a reliable system based on the requirements of the organization can be provided. Successful implementation may not guarantee improvement in the organization using the new system, but improper installation will prevent it.

There are three stages in an implementation process: -

Training Personnel

Application of Conversion procedure

Post implementation review

a) Training Personnel: Running of the system successfully depend on the user of the computer software. Training the users includes basic operability features such as rules and regulations for operating the software to optimum benefit. It is a feature where a line is drawn showing the similarities between the existing system, which the user is quite adapt with and the new system. The user is shown the benefits, which now he gets through a computerized process. He is made to understand the cohesion between the present system and the new system.

With a better understanding of the present system a user is more capable of understanding a system, which has strong linkages to the present one. This is what is emphasized during the training stage.

Successful culmination of training means that the user has a better understanding of the new system vis-à-vis the older one and the benefits the newer one offers over the older one. Since a user is already adapt to computer, understanding other basic features including maintenance of data security and integrity is not a difficult task.

The training is conducted on the site as the users of the proposed system are quite busy and cannot spare time for off-site training.

b) Application of Conversion procedure:

Parallel System: This is the safest method for converting the system from old to new one. Users continue to operate the old system in the usual manner but they start using the new system alongside. The method is safest one because it ensures that in case of any problems during the first real time operations of the new system, the organization can still fall back on the older one.

c) Post implementation review: After the system is implemented and conversion is complete the review plan is conducted to determine whether the system is meeting expectations and where improvements are needed. System is measured against pre-defined requirements. Thorough study is done to determine whether the new system requires re-designing or not. Information required for it, begins with the review plan, during which user views are kept into consideration.

Maintenance is an important part of the system development life cycle. It is actually the implementation of the post-implementation review plan. The average life of a system is 4 to 6 years. This period of use brings with it a need to continually maintain the system, which includes between other a regular performance tuning of the database. The maintenance part of a system life cycle is less required if sufficient time had been given during the analysis phase of the system.

Research show, that only 20 percent of all maintenance works is spent for Corrective Maintenance. The remaining 80 percent is spent adapting existing systems to changes in the external environment, and reengineering an application for future use, also called Adaptive Maintenance.

Since the working culture of Newspaper industry is very unlikely to change dramatically in a couple of years it is highly unlikely that Adaptive Maintenance will be required for the new software. Yet Corrective Maintenance is one major issue, but since time was spent in thoroughly analyzing the software, lesser effort will be required in performing this task.

As software is used, the user will recognize additional functions that will provide benefit. Considering human psyche performing Perfective maintenance will be highly required.

5.2 Coding Details and Code Efficiency

5.2.1 Coding Details

FORM NAME:- Home Page

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlDataAdapter objadap = new SqlDataAdapter();

DataTable dtb = new DataTable();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

string str = "select * from announces order by Date";

objadap = new SqlDataAdapter(str, con);

dtb = new DataTable();

objadap.Fill(dtb);

DataList1.DataSource = dtb;

DataList1.DataBind();

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

Response.Redirect("zeeregister.aspx");

}

protected void btnlogin_Click(object sender, EventArgs e)

{

string st = "Select username,password,type from login where username='" + txtusername.Text + "' and password='"+txtpassword.Text+"'";

objadap = new SqlDataAdapter(st, con);

dtb = new DataTable();

objadap.Fill(dtb);

if (dtb.Rows.Count ==1)

{

string type = dtb.Rows[0][2].ToString();

if (type == "student")

{

Session["uname"] = txtusername.Text;

Response.Redirect("studenthom.aspx");

}

else if (type == "faculty")

{

Session["uname"] = txtusername.Text;

Response.Redirect("fachome.aspx");

}

else

{

Session["uname"] = txtusername.Text;

Response.Redirect("adminhome.aspx");

}

else

{

invalid.Visible = true;

txtusername.Focus();

}

protected void txtusername_TextChanged(object sender, EventArgs e)

{

}

protected void LinkButton1_Click1(object sender, EventArgs e)

{

}

FORM NAME: Registration of Students

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlDataAdapter objadab = new SqlDataAdapter();

DataTable objdt = new DataTable();

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

int i;

for (i = 1; i <= 31; i++)

{

ddldate.Items.Add(i.ToString());

}

for (i = 1; i <= 12; i++)

{

ddlmonth.Items.Add(i.ToString());

}

for (i = 1970; i <=2010; i++)

{

ddlyear.Items.Add(i.ToString());

}

if (!IsPostBack)

{

string st = "Select * from Country";

objadab= new SqlDataAdapter(st,con);

objdt= new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcountry.DataSource = objdt.DefaultView;

ddlcountry.DataTextField = "cname";

ddlcountry.DataValueField = "cid";

ddlcountry.DataBind();

}

ddlcountry.Items.Insert(0, "Select");

}

protected void submitbtn_Click(object sender, EventArgs e)

{

string name = txtfname.Text + txtlname.Text;

// string location = ddlcountry.SelectedItem + "/" + ddlstate.SelectedItem + "/" + ddlcity.SelectedItem;

string d_o_b = ddldate.Text + "/" + ddlmonth.Text + "/" + ddlyear.Text;

string st = "insert into register(Name,FatherName,Date_Of_Birth,Country,State,City,Address,Quali,Gender,program,DD_No,Mobile,E_mail,Username,SecurityQuestion,Answer,status)values('"+name+ "','" + txtfathername.Text + "','" +d_o_b+ "','"+ddlcountry.SelectedItem+"','"+ddlstate.SelectedItem+"','"+ddlcity.SelectedItem+"','" + txtadd.Text + "','" + txtquali.Text + "','"+ddlgender.Text +"','"+ddlcourse.Text+"',"+txtddno.Text+","+txtmobile.Text+",'"+txtemail.Text+"','"+txtuname.Text +"','"+ddlquestion.Text+"','"+txtanswer.Text+"','pending')";

SqlCommand cmd = new SqlCommand(st,con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Response.Redirect("register_confirm.aspx");

}

protected void txtsequestion_TextChanged(object sender, EventArgs e)

{

}

protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)

{

string st = "Select * from state where cid='" + ddlcountry.SelectedValue + "' ";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlstate.DataSource = objdt.DefaultView;

ddlstate.DataTextField = "sname";

ddlstate.DataValueField = "sid";

ddlstate.DataBind();

}

ddlstate.Items.Insert(0, "Select");

}

protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)

{

string st = "Select * from city where sid='" + ddlstate.SelectedValue + "'";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcity.DataSource = objdt.DefaultView;

ddlcity.DataTextField = "cityname";

ddlcity.DataValueField = "cityid";

ddlcity.DataBind();

}

ddlcity.Items.Insert(0, "Select");

}

protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void txtuname_TextChanged(object sender, EventArgs e)

{

string st = "Select * from register where Username='"+txtuname.Text+"'";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

lbl_checkuser.Text = "Not Available";

txtuname.Text = "";

txtuname.Focus();

lbl_checkuser.Visible = true;

}

else

{

lbl_checkuser.Visible = true;

lbl_checkuser.Text = "User Avaliable";

}

protected void ddlquestion_SelectedIndexChanged(object sender, EventArgs e)

{

}

FORM NAME: Verify Student

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

using System.Net.Mail;

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

{

string pass = "";

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}

public void bindgrid()

{

string st = "select * from register";

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable dtb = new DataTable();

objadab.Fill(dtb);

GridView1.DataSource = dtb;

GridView1.DataBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

string str = GridView1.DataKeys[e.NewEditIndex].Value.ToString();

string str1 = "update register set status='approved' where Username='" + str + "' and status='pending'";

SqlCommand comm1=new SqlCommand(str1,con);

con.Open();

comm1.ExecuteNonQuery();

con.Close();

string password = System.Guid.NewGuid().ToString();

password = password.Substring(0, 6);

string str2 = "insert into login(username,password,type)values('" + str + "','" + password + "','student')";

SqlCommand comm=new SqlCommand(str2,con);

con.Open();

comm.ExecuteNonQuery();

con.Close();

bindgrid();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string st = GridView1.DataKeys[e.RowIndex].Value.ToString();

string stri = "update register set status='reject' where Username='" + st + "' and status='pending'";

SqlCommand comm=new SqlCommand(stri,con);

con.Open();

comm.ExecuteNonQuery();

con.Close();

bindgrid();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

bindgrid();

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void btn_sendmail_Click(object sender, EventArgs e)

{

foreach (GridViewRow row in GridView1.Rows)

{

Label status = (Label)row.FindControl("lbl_status");

//string status1 = status.ToString();

if (status.Text == "Confirmed")

{

string name = row.Cells[0].Text;

string email = row.Cells[3].Text;

mailsend(name, email, pass);

}

public void mailsend(string name, string email, string pass)

{

MailMessage mail = new MailMessage();

mail.To.Add(email);

mail.From = new MailAddress("quicksearch012@gmail.com");

mail.Subject = "Registration Confirmation";

mail.Body = "Thanks '" + name + "'Your Registration has been confirmed your Password No is '" + pass + "'";

mail.IsBodyHtml = true;

SmtpClient smtp = new SmtpClient();

smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address

smtp.Credentials = new System.Net.NetworkCredential("quicksearch012@gmail.com", "quicksearch");

smtp.EnableSsl = true;

smtp.Send(mail);

}

FORM NAME: FACULTY REGISTER

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

}

protected void submit_Click(object sender, EventArgs e)

{

string st = "insert into faculty_register(facname,Address,Mobile,Gender,Course,Username,Password)values('" + fname.Text + "','" + Add.Text + "','" + mobile.Text + "','" + gender.Text + "','" + DDLPROG.Text + "','" + username.Text + "','" + password.Text + "')";

string sr1 ="insert into login (username,password,type)values('"+username.Text+"','"+password.Text+"','faculty')";

SqlCommand comm = new SqlCommand(st, con);

SqlCommand comm1 = new SqlCommand(sr1, con);

con.Open();

comm1.ExecuteNonQuery();

comm.ExecuteNonQuery();

con.Close();

}

FORM NAME: UPLOAD FACULTY

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

string st = "Select * from program";

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlprogram.DataSource = objdt.DefaultView;

ddlprogram.DataTextField = "pname";

ddlprogram.DataValueField = "pid";

ddlprogram.DataBind();

}

ddlprogram.Items.Insert(0, "Select");

}

protected void btnupload_Click(object sender, EventArgs e)

{

if (FileUpload1.HasFile)

{

string str = "~/upload/" + FileUpload1.FileName;

FileUpload1.SaveAs(MapPath(str));

string st = "insert into tutorialdetail(progname,sem,coursecode,tutorialtype,tutorial,topic,postedby)values('" + ddlprogram.SelectedItem + "','" + ddlsem.SelectedItem + "','" + ddlcourse.SelectedItem + "','" + RadioButtonList1.Text + "','" + str + "','" + topictxt.Text + "','" + Session["uname"] + "')";

SqlCommand cmd = new SqlCommand(st, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

protected void ddlprogram_SelectedIndexChanged(object sender, EventArgs e)

{

string st = "Select * from sem where pid='" + ddlprogram.SelectedValue + "' ";

con.Open();

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlsem.DataSource = objdt.DefaultView;

ddlsem.DataTextField = "semname";

ddlsem.DataValueField = "semid";

ddlsem.DataBind();

}

ddlsem.Items.Insert(0, "Select");

con.Close();

}

protected void ddlsem_SelectedIndexChanged(object sender, EventArgs e)

{

ddlcourse.Items.Clear();

string st = "Select * from course where semid='" + ddlsem.SelectedValue + "'";

con.Open();

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcourse.DataSource = objdt.DefaultView;

ddlcourse.DataTextField = "cname";

ddlcourse.DataValueField = "cid";

ddlcourse.DataBind();

}

ddlcourse.Items.Insert(0, "Select");

con.Close();

}

protected void ddlcourse_SelectedIndexChanged(object sender, EventArgs e)

{

FORM NAME:- Home Page(Forget Password)

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

SqlDataAdapter objadap = new SqlDataAdapter();

DataTable dtb = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void submit_Click(object sender, EventArgs e)

{

string st = "select * from register where Username='" + txtusername.Text + "'";

objadap = new SqlDataAdapter(st, con);

dtb = new DataTable();

objadap.Fill(dtb);

lblsecurity.Text = dtb.Rows[0]["SecurityQuestion"].ToString();

HiddenField1.Value = dtb.Rows[0]["Answer"].ToString();

Panel1.Visible = false;

Panel2.Visible = true;

}

protected void btnsubmit_Click(object sender, EventArgs e)

{

if (txtanswer.Text == HiddenField1.Value)

{

string str = "select * from login where username='" + txtusername.Text + "'";

objadap = new SqlDataAdapter(str, con);

dtb = new DataTable();

objadap.Fill(dtb);

lblpass.Text = dtb.Rows[0]["password"].ToString();

}

else

{

lblpass.Text = "wrong answer";

}

FORM NAME:- STUDENT DOWNLOAD

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

using System.IO;

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

{

TableCell topic;

string topic1;

SqlDataAdapter objadab = new SqlDataAdapter();

DataTable objdt = new DataTable();

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

string st = "Select program from register where username= '" + Session["uname"] + "'";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

hf_pname.Value = objdt.Rows[0]["program"].ToString();

string st2 = "Select pid from program where pname= '" + hf_pname.Value + "'";

objadab = new SqlDataAdapter(st2, con);

objdt = new DataTable();

objadab.Fill(objdt);

hf_pcode.Value = objdt.Rows[0]["pid"].ToString();

}

string st1 = "Select * from sem where pid='" + hf_pcode.Value + "' ";

objadab = new SqlDataAdapter(st1, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlsem.DataSource = objdt.DefaultView;

ddlsem.DataTextField = "semname";

ddlsem.DataValueField = "semid";

ddlsem.DataBind();

}

ddlsem.Items.Insert(0, "Select");

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

string st = "Select * from course where semid='" + ddlsem.SelectedValue + "'";

con.Open();

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcourse.DataSource = objdt.DefaultView;

ddlcourse.DataTextField = "cname";

ddlcourse.DataValueField = "cid";

ddlcourse.DataBind();

}

ddlcourse.Items.Insert(0, "Select");

con.Close();

}

protected void ddlcourse_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName == "Select")

{

int index = Convert.ToInt32(e.CommandArgument);

GridViewRow selectedRow = GridView1.Rows[index];

topic = selectedRow.Cells[1];

topic1 = topic.Text;

string st = "select tutorial from tutorialdetail where topic='" + topic1 + "' and sem='" + ddlsem.SelectedItem + "' and coursecode='" + ddlcourse.SelectedItem + "' and tutorialtype='" + RadioButtonList1.Text + "'";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

string url = objdt.Rows[0]["tutorial"].ToString();

try

{

string FilePath = Server.MapPath(url);

System.IO.FileInfo TargetFile = new System.IO.FileInfo(FilePath);

if (TargetFile.Exists)

{

Response.Clear();

Response.AddHeader("Content-Disposition", "attachment; filename=" + TargetFile.Name);

Response.AddHeader("Content-Length", TargetFile.Length.ToString());

Response.ContentType = "application/octet-stream";

Response.WriteFile(TargetFile.FullName);

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

protected void Button_submit_Click(object sender, EventArgs e)

{

string st = "select * from tutorialdetail where progname='" + hf_pname.Value + "' and sem='" + ddlsem.SelectedItem + "' and coursecode='" + ddlcourse.SelectedItem + "'";

objadab = new SqlDataAdapter(st, con);

objdt = new DataTable();

objadab.Fill(objdt);

GridView1.DataSource = objdt;

GridView1.DataBind();

}

FORM NAME:- FORUM

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

DataTable dataTable = new DataTable();

int pageSize = 10;

int currentPage;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ShowFirst(this, System.EventArgs.Empty);

}

//public void Show_Data()

//{

// string st = "select distinct * from topic order by date";

// SqlDataAdapter adp = new SqlDataAdapter(st, con);

// DataSet ds = new DataSet();

// adp.Fill(ds);

// DataList1.DataSource = ds;

// DataList1.DataBind();

//}

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)

{

if (e.CommandName == "Edit")

{

((LinkButton)e.Item.FindControl("lb_reply")).Visible = false;

((LinkButton)e.Item.FindControl("lb_send")).Visible = true;

((TextBox)e.Item.FindControl("txt_reply")).Visible = true;

((LinkButton)e.Item.FindControl("lb_cancel")).Visible = true;

}

if (e.CommandName == "update")

{

string date = System.DateTime.Now.ToString();

string str1 = ((TextBox)e.Item.FindControl("txt_reply")).Text;

string by = Session["uname"].ToString();

string st = "insert into reply(topic_id,ans,postedby,date)values(@topic_id,@ans,@by,@date)";

SqlCommand cmd = new SqlCommand(st, con);

cmd.Parameters.AddWithValue("@topic_id", e.CommandArgument);

cmd.Parameters.AddWithValue("@ans", str1);

cmd.Parameters.AddWithValue("@by", by);

cmd.Parameters.AddWithValue("@date", date);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

((LinkButton)e.Item.FindControl("lb_reply")).Visible = true;

((TextBox)e.Item.FindControl("txt_reply")).Visible = false;

((LinkButton)e.Item.FindControl("lb_send")).Visible = false;

Response.Redirect("forum.aspx");

}

if (e.CommandName == "cancel")

{

((LinkButton)e.Item.FindControl("lb_reply")).Visible = true;

((TextBox)e.Item.FindControl("txt_reply")).Visible = false;

((LinkButton)e.Item.FindControl("lb_send")).Visible = false;

((LinkButton)e.Item.FindControl("lb_cancel")).Visible = false;

Response.Redirect("forum.aspx");

}

protected void Button_submit_Click(object sender, EventArgs e)

{

string id = System.Guid.NewGuid().ToString();

id = id.Substring(0,5);

string str = "insert into topic(topic_id,topic,posted_by,date)values('" + id + "','" + txt_topic.Text + "','" + Session["uname"] + "','" + System.DateTime.Now + "')";

SqlCommand cmd = new SqlCommand(str, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Response.Redirect("forum.aspx");

}

protected void GetData()

{

if (ViewState["Data"] == null)

{

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();

SqlCommand cmd = new SqlCommand();

try

{

Trace.Write("GetData", "Getting data from Database");

//sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection3"].ToString());

cmd = new SqlCommand("select distinct * from topic order by date", con);

//cmd = new SqlCommand("select t.topic_id,t.topic,t.posted_by,t.date,count (r.topic_id)as no from reply r,topic t group by t.topic_id,t.topic,t.posted_by,t.date order by t.date", con);

sqlDataAdapter = new SqlDataAdapter(cmd);

dataTable = new DataTable();

sqlDataAdapter.Fill(dataTable);

ViewState["Data"] = dataTable;

}

catch (Exception ex)

{

//lblError.Text = ex.ToString();

}

else

{

Trace.Write("GetData", "Getting data from ViewState.");

dataTable = (DataTable)ViewState["Data"];

}

protected void ShowFirst(object sender, EventArgs e)

{

currentPage = 1;

ShowPage();

}

protected void ShowLast(object sender, EventArgs e)

{

GetData();

currentPage = Convert.ToInt32(System.Math.Ceiling(Convert.ToDouble(dataTable.Rows.Count) / pageSize));

ShowPage();

}

protected void ShowNext(object sender, EventArgs e)

{

GetData();

currentPage = Convert.ToInt32(ViewState["CurrentPage"]);

if (currentPage <= Convert.ToInt32(System.Math.Ceiling(Convert.ToDouble(dataTable.Rows.Count) / pageSize)))

{

currentPage += 1;

}

ShowPage();

}

protected void ShowPrevious(object sender, EventArgs e)

{

currentPage = Convert.ToInt32(ViewState["CurrentPage"]);

if (currentPage > 1)

{

currentPage -= 1;

}

ShowPage();

}

protected void ShowPage()

{

if (dataTable.Rows.Count == 0)

{

GetData();

}

if (dataTable.Rows.Count == 0)

{

lbl_error.Visible = true;

lbl_error.Text = "No Data Found";

DataList1.Visible = false;

//throw new ApplicationException("Data failed to load.");

}

DataTable dt2 = new DataTable();

dt2 = dataTable.Clone();

//Copy the structure of the data to a new container

for (int i = ((currentPage - 1) * pageSize); i <= (currentPage * pageSize) - 1; i++)

{

if (i >= dataTable.Rows.Count)

{

break;

}

dt2.ImportRow(dataTable.Rows[i]);

}

DataList1.DataSource = dt2;

DataList1.DataBind();

//Display status line

((Label)(DataList1.Controls[DataList1.Controls.Count - 1].FindControl("StatusLabel"))).Text = "Total Records: " + dataTable.Rows.Count + ". Page " + currentPage + " of " + Convert.ToInt32(System.Math.Ceiling(Convert.ToDouble(dataTable.Rows.Count) / pageSize)) + ".";

//Store current page

ViewState["CurrentPage"] = currentPage;

}

FORM NAME:- VIEW PROFILE

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

string st="select * from register where Username='"+Session["uname"]+"'";

SqlDataAdapter objadap = new SqlDataAdapter(st, con);

DataTable dtb = new DataTable();

objadap.Fill(dtb);

lblcontry.Text = dtb.Rows[0]["Country"].ToString();

lbstate.Text = dtb.Rows[0]["State"].ToString();

lblcity.Text = dtb.Rows[0]["City"].ToString();

lbladd.Text = dtb.Rows[0]["Address"].ToString();

lblqua.Text = dtb.Rows[0]["Quali"].ToString();

lblmob.Text = dtb.Rows[0]["Mobile"].ToString();

lblemail.Text = dtb.Rows[0]["E_mail"].ToString();

lblcour.Text = dtb.Rows[0]["program"].ToString();

}

FORM NAME:- EDIT PROFILE

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

fill();

string str = "Select * from Country";

SqlDataAdapter objadab = new SqlDataAdapter(str, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcountry.DataSource = objdt.DefaultView;

ddlcountry.DataTextField = "cname";

ddlcountry.DataValueField = "cid";

ddlcountry.DataBind();

}

ddlcountry.Items.Insert(0, "Select");

}

protected void Button1_Click(object sender, EventArgs e)

{

string sql = "update register set Country='" + ddlcountry.SelectedItem.Text + "',State='" + ddlstate.SelectedItem.Text + "',City='" + ddlcity.SelectedItem.Text + "',Address='" + txtadd.Text + "',Quali='" + txtquali.Text + "',program='" + ddlprogram.SelectedItem.Text + "' where Username ='" + Session["uname"] + "'";

SqlCommand cm = new SqlCommand(sql,con);

con.Open();

cm.ExecuteNonQuery();

con.Close();

Label1.Text = "Profile updated Successhully";

}

protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)

{

string st1 = "Select * from state where cid='" + ddlcountry.SelectedValue + "' ";

SqlDataAdapter objadab = new SqlDataAdapter(st1, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlstate.DataSource = objdt.DefaultView;

ddlstate.DataTextField = "sname";

ddlstate.DataValueField = "sid";

ddlstate.DataBind();

}

ddlstate.Items.Insert(0, "Select");

}

protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)

{

string st = "Select * from city where sid='" + ddlstate.SelectedValue + "'";

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable objdt = new DataTable();

objadab.Fill(objdt);

if (objdt.Rows.Count != 0)

{

ddlcity.DataSource = objdt.DefaultView;

ddlcity.DataTextField = "cityname";

ddlcity.DataValueField = "cityid";

ddlcity.DataBind();

}

ddlcity.Items.Insert(0, "Select");

}

public void fill()

{

string st = "select * from register where Username='" + Session["uname"] + "'";

SqlDataAdapter objadap = new SqlDataAdapter(st, con);

DataTable dtb = new DataTable();

objadap.Fill(dtb);

txtadd.Text = dtb.Rows[0]["Address"].ToString();

txtquali.Text = dtb.Rows[0]["Quali"].ToString();

ddlprogram.Text = dtb.Rows[0]["program"].ToString();

txtmobil.Text = dtb.Rows[0]["Mobile"].ToString();

txtmail.Text = dtb.Rows[0]["E_mail"].ToString();

}

FORM NAME:- CHANGE PASSWORD(STUDENT)

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string st = "select * from login where username='" + Session["uname"] + "'and password='"+txtoldpass.Text+"'";

SqlDataAdapter adp = new SqlDataAdapter(st,con);

DataTable dt = new DataTable();

adp.Fill(dt);

if (dt.Rows.Count == 1)

{

string str = "update login set password='" + txtnewpass.Text + "'where username='" + Session["uname"] + "'";

SqlCommand cmd = new SqlCommand(str, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Label1.Visible = true;

Label1.Text = "Password Changed Successfully!!";

txtconpass.Text = "";

txtnewpass.Text = "";

txtoldpass.Text = "";

}

else

{

Label1.Visible = true;

Label1.Text = "Password Not Matched";

txtoldpass.Text = "";

txtoldpass.Focus();

}

FORM NAME:- UPDATE ANNOUNCES

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnsub_Click(object sender, EventArgs e)

{

string ID = System.Guid.NewGuid().ToString();

ID = ID.Substring(0,6);

string st = "insert into announces(Announces_id,Announcement,Subject,Date)values('" + ID + "','" + multilineanounce.Text + "','" + txtsubject.Text + "','" + txtdate.Text + "')";

SqlCommand cmd = new SqlCommand(st,con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

FORM NAME: UPDATE ANNOUNCES

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnsub_Click(object sender, EventArgs e)

{

string ID = System.Guid.NewGuid().ToString();

ID = ID.Substring(0,6);

string st = "insert into announces(Announces_id,Announcement,Subject,Date)values('" + ID + "','" + multilineanounce.Text + "','" + txtsubject.Text + "','" + txtdate.Text + "')";

SqlCommand cmd = new SqlCommand(st,con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

FORM NAME: VIEW ANNOUNCES

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlDataAdapter objadap = new SqlDataAdapter();

DataTable dtb = new DataTable();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

string st = Request.QueryString["Announces_id"].ToString();

string str = "select * from announces where Announces_id='" + st + "'";

objadap = new SqlDataAdapter(str, con);

dtb = new DataTable();

objadap.Fill(dtb);

txt_announce.Text = dtb.Rows[0]["Announcement"].ToString();

}

FORM NAME: CHANGE PASSWORD OF ADMIN

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

string st = "select * from login where username='" + Session["uname"] + "'and password='" + txtoldpass.Text + "'";

SqlDataAdapter adp = new SqlDataAdapter(st, con);

DataTable dt = new DataTable();

adp.Fill(dt);

if (dt.Rows.Count == 1)

{

string str = "update login set password='" + txtnewpass.Text + "'where username='" + Session["uname"] + "'";

SqlCommand cmd = new SqlCommand(str, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Label1.Visible = true;

Label1.Text = "Password Changed Successfully!!";

txtconpass.Text = "";

txtnewpass.Text = "";

txtoldpass.Text = "";

}

else

{

Label1.Visible = true;

Label1.Text = "Password Not Matched";

txtoldpass.Text = ""; txtoldpass.Focus(); }}

FORM NAME: VIEW STUDENT DETAILS

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

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.Xml.Linq;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dew;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}

public void bindgrid()

{

string st = "select * from register";

SqlDataAdapter objadab = new SqlDataAdapter(st, con);

DataTable dtb = new DataTable();

objadab.Fill(dtb);

GridView1.DataSource = dtb;

GridView1.DataBind();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

bindgrid();

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

FORM NAME: ZEE HOME

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="zeehome.aspx.cs" Inherits="zeehome" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style6

{

width: 263px;

}

.style7

{

font-size: large;

}

.style8

{

font-size: large;

font-style: italic;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<div align="center" style="color: #FFFFFF; background-color: #911715;">Announcements</div>

<asp:DataList ID="DataList1" runat="server" Width="257px">

<tr>

<td>

<ul>

<li>

<asp:LinkButton ID="LinkButton1" runat="server" Text='<%#Eval("Subject") %>' PostBackUrl='<%#Eval("Announces_id","view_announcement.aspx?Announces_id={0}") %>' CausesValidation="false">LinkButton</asp:LinkButton>

</li>

</ul></td>

</tr>

</table>

</ItemTemplate>

</asp:DataList></marquee>

</td>

 <span class="style8">In these days  Online course management system is much help ful for all the students who

want to connect every time with their studies, and update themselves.</span><i><br

class="style7" />

</i><span class="style8">Also it is the better approach for a candidate who can't communicate directly

with the expers ideas............</span><i><br class="style7" />

</i>

</td>

<tr>

</tr>

<tr>

User Name</td>

<asp:TextBox ID="txtusername" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator19" runat="server"

ControlToValidate="txtusername" ErrorMessage="**" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

Password</td>

<asp:TextBox ID="txtpassword" runat="server" TextMode="Password"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator20" runat="server"

ControlToValidate="txtpassword" ErrorMessage="**" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<asp:Button ID="btnlogin" runat="server" Text="LOGIN"

onclick="btnlogin_Click" style="height: 26px" />

</td>

<asp:LinkButton ID="signup" runat="server" onclick="LinkButton1_Click"

CausesValidation="False" Font-Size="Small">SIGN UP NOW</asp:LinkButton>

</td>

</tr>

<tr>

<asp:Label ID="invalid" runat="server" Text="user name or password not match"

Visible="False" ForeColor="Red"></asp:Label>

<br />

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/forgetpass.aspx">

Forget Password</asp:HyperLink>

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: ABOUT COLLEGE

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="Aboutcollege.aspx.cs" Inherits="Aboutcollege" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

p.MsoNormal

{margin-top:0in;

margin-right:0in;

margin-bottom:10.0pt;

margin-left:0in;

line-height:115%;

font-size:11.0pt;

font-family:"Calibri","sans-serif";

}

</style>

</asp:Content>

<asp:Content ID="Content2" runat="server"

contentplaceholderid="ContentPlaceHolder1">

<tr>

<asp:Panel ID="Panel1" runat="server" Height="220px" ScrollBars="Both">

Online Course Management System (OCMS)<span

style="mso-spacerun:yes">  </span>to provide for the establishment and

incorporation of a University for the advancement of technical education and

development thereof in the State of Punjab and for matters connected therewith.

In pursuance of this Act, the University started its journey with 09 engineering

colleges and few management colleges affiliated to it. Since then, the

University has come a long way and during this Academic Session 2011-12, the

University has affiliated 100+ engineering Colleges, 139 Management and Computer

Application courses, 37 institutions imparting Pharmacy education, 11 colleges

imparting Hotel Management education, 06 Colleges providing Architecture

Education and 21 Regional Centre for M.Tech and Ph.D in different branches of

Engineering and Management and 01 Regional Centre for M.Pharmacy. More then 2013

Leacning Centres of PTU are providing professional education through Distance

Learning all over the Country and abroad.</p>

<o:p> </o:p>

</p>

All the time of the University , the students were doing their engineering

courses from the University of other states. PTU achived that height & glory

because of which it became sucessfull in winning the faith of the students. At

present, after 15 year of its existance, PTU is providing education to

approximately 5 lac students in the fields of Engineering, Management,

Architecture and Pharmacy. This number includeds 50 percent students form the

states other than Punjab.</p>

<o:p> </o:p>

</p>

We, at Online Course Management System, are propelled by the vision and wisdom

of our leaders and are continously striving to discharge our duties for the

overall improvement of quality of education and to make sure that the courses we

offer remain relevant to our society and usefull to our students in the

globalized work environment.</p>

<o:p> </o:p>

</p>

</asp:Panel>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: ABOUT COURSES

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="MCA_BCA.aspx.cs" Inherits="MCA_BCA" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

p.MsoNormal

{margin-top:0in;

margin-right:0in;

margin-bottom:10.0pt;

margin-left:0in;

line-height:115%;

font-size:11.0pt;

font-family:"Calibri","sans-serif";

}

{margin-bottom:0in;}

li.MsoNormal

{margin-top:0in;

margin-right:0in;

margin-bottom:10.0pt;

margin-left:0in;

line-height:115%;

font-size:11.0pt;

font-family:"Calibri","sans-serif";

}

</style>

</asp:Content>

<asp:Content ID="Content2" runat="server"

contentplaceholderid="ContentPlaceHolder1">

<tr>

<img src="IMG/AboutMCA103755AM.gif" width="300" height="200"

</td>

<asp:Panel ID="Panel1" runat="server" BackColor="Silver" ScrollBars="Both"

Height="199px">

<br />

MCA is a time bound three-year (six-semester) course, approved by All India

Council of Technical Education (AICTE) and conducted by almost all the

Universities of India.It opens door to an exciting and rewarding career in IT

Industry</p>

<o:p> </o:p>

</p>

We have excellent programmes which will gear & train you to crack various MCA

examinations in India . Our students have consistently performed extremely well

in all MCA Examinations in India .we give comprehensive training for all MCA

Examinations in India</p>

<br />

</asp:Panel>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: REGISTER PAGE

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="zeeRegister.aspx.cs" Inherits="zeeRegister" Title="Untitled Page" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style6

{

color: #000000;

}

.style7

{

font-size: x-large;

font-weight: bold;

}

.style8

{

width: 200px;

}

.style9

{

height: 37px;

}

.style10

{

color: #000000;

height: 37px;

}

.style11

{

height: 41px;

}

.style12

{

color: #000000;

height: 41px;

}

.style13

{

height: 24px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

<td>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

<td>

</tr>

</table>

<table cellpadding="5" cellspacing="5" class="style5" align="left"

bgcolor="#66CCFF" >

<tr>

 </td>

:<span class="style7">STUDENT REGISTRATION</span></td>

</tr>

<tr>

 </td>

FIRST NAME</td>

 </td>

<asp:TextBox ID="txtfname" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

ControlToValidate="txtfname" ErrorMessage="plz enter first name"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

LAST NAME</td>

:</td>

<asp:TextBox ID="txtlname" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"

ControlToValidate="txtlname" ErrorMessage="plz enter last name"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

FATHER'S NAME</td>

:</td>

<asp:TextBox ID="txtfathername" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"

ControlToValidate="txtfathername" ErrorMessage="plz enter father's name"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

</td>

DATE_OF_BIRTH</td>

:</td>

<asp:DropDownList ID="ddldate" runat="server">

<asp:ListItem>day</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator18" runat="server"

ControlToValidate="ddldate" ErrorMessage="enter day" InitialValue="Select"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

<asp:DropDownList ID="ddlmonth" runat="server">

<asp:ListItem>month</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator19" runat="server"

ControlToValidate="ddlmonth" ErrorMessage="enterMonth" InitialValue="Select"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

<asp:DropDownList ID="ddlyear" runat="server">

<asp:ListItem>year</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator20" runat="server"

ControlToValidate="ddlyear" ErrorMessage="enter year" InitialValue="Select"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

COUNTRY</td>

 </td>

<asp:DropDownList ID="ddlcountry" runat="server"

onselectedindexchanged="ddlcountry_SelectedIndexChanged"

AutoPostBack="True">

<asp:ListItem>Select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator5"

runat="server" ControlToValidate="ddlcountry"

ErrorMessage="plz enter country name" InitialValue="Select"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

STATE</td>

 </td>

<asp:DropDownList ID="ddlstate" runat="server"

onselectedindexchanged="ddlstate_SelectedIndexChanged" AutoPostBack="True">

<asp:ListItem>Select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator6"

runat="server" ControlToValidate="ddlstate" ErrorMessage="plz enter state name"

InitialValue="Select" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

CITY</td>

 </td>

<asp:DropDownList ID="ddlcity" runat="server"

onselectedindexchanged="ddlcity_SelectedIndexChanged" AutoPostBack="True">

<asp:ListItem>Select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator7"

runat="server" ControlToValidate="ddlcity" ErrorMessage="plz enter city name"

InitialValue="Select" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

ADDRESS</td>

:</td>

<asp:TextBox ID="txtadd" runat="server" TextMode="MultiLine"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator8"

runat="server" ControlToValidate="txtadd" ErrorMessage="plz enter address"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

QUALIFICATION</td>

:</td>

<asp:TextBox ID="txtquali" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server"

ControlToValidate="txtquali" ErrorMessage="plz enter your qualificiation"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

GENDER</td>

:</td>

<asp:DropDownList ID="ddlgender" runat="server">

<asp:ListItem>Select</asp:ListItem>

<asp:ListItem>Male</asp:ListItem>

<asp:ListItem>Female</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator10"

runat="server" ControlToValidate="ddlgender" ErrorMessage="plz enter gender"

InitialValue="Select" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

PROGRAM</td>

:</td>

<asp:DropDownList ID="ddlcourse" runat="server">

<asp:ListItem>select</asp:ListItem>

<asp:ListItem>MCA</asp:ListItem>

<asp:ListItem>BCA</asp:ListItem>

<asp:ListItem>MBA</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator11"

runat="server" ControlToValidate="ddlcourse" ErrorMessage="plz enter program"

InitialValue="Select" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

</td>

D.D.No</td>

:</td>

<asp:TextBox ID="txtddno" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server"

ControlToValidate="txtddno" ErrorMessage="plz enter draft no."

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

MOBILE</td>

:</td>

<asp:TextBox ID="txtmobile" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator13" runat="server"

ControlToValidate="txtmobile" ErrorMessage="plz enter mobile number"

SetFocusOnError="True"></asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"

ControlToValidate="txtmobile" ErrorMessage="Invalid Mobile No"

ValidationExpression="\d{10,11}$"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

 </td>

E_MAIL</td>

:</td>

<asp:TextBox ID="txtemail" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator14" runat="server"

ControlToValidate="txtemail" ErrorMessage="plz enter email"

SetFocusOnError="True"></asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

ControlToValidate="txtemail" ErrorMessage="Invalid email"

ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>

</td>

</tr>

<tr>

</td>

USER NAME</td>

:</td>

<asp:TextBox ID="txtuname" runat="server" ontextchanged="txtuname_TextChanged"

AutoPostBack="True"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator15" runat="server"

ControlToValidate="txtuname" ErrorMessage="plz enter user name"

SetFocusOnError="True"></asp:RequiredFieldValidator>

<asp:Label ID="lbl_checkuser" runat="server" ForeColor="#FF3300" Text="label"

Visible="False"></asp:Label>

</td>

</tr>

<tr>

 </td>

SECURITY QUESTION</td>

:</td>

<asp:DropDownList ID="ddlquestion" runat="server"

onselectedindexchanged="ddlquestion_SelectedIndexChanged">

<asp:ListItem>Select</asp:ListItem>

<asp:ListItem>What is Your First School Name</asp:ListItem>

<asp:ListItem>What is Your Pets Name</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator16" runat="server"

ControlToValidate="txtfname" ErrorMessage="plz enter security que."

InitialValue="Select" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

</td>

ANSWER </td>

</td>

<asp:TextBox ID="txtanswer" runat="server"></asp:TextBox>

 <asp:RequiredFieldValidator ID="RequiredFieldValidator17" runat="server"

ControlToValidate="txtanswer" ErrorMessage="plz enter answer"

SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

<tr>

 </td>

 </td>

 </td>

<asp:Button ID="submitbtn" runat="server" BackColor="#996633" Text="Submit"

onclick="submitbtn_Click" />

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: USER CONFIRMATION PAGE

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="register_confirm.aspx.cs" Inherits="register_confirm" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

Dear Student....<br />

<br />

Your details sends to Admin successfully...<br />

we will inform you status of registration by  mail in your mail id...  

<br />

THANK YOU<br />

<br />

</td>

</tr>

</table>

</asp:Content>

FORM NAME: ADMIN HOME PAGE

<%@ Page Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="adminhome.aspx.cs" Inherits="adminhome" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

p.MsoNormal

{margin-top:0in;

margin-right:0in;

margin-bottom:10.0pt;

margin-left:0in;

line-height:115%;

font-size:11.0pt;

font-family:"Calibri","sans-serif";

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<asp:Panel ID="Panel1" runat="server" BackColor="#CCCCCC" Height="197px"

ScrollBars="Both">

Admin is the sole or the main body in the Online Course Management<span

style="mso-spacerun:yes">  </span>system .He will

provide access to the<span style="mso-spacerun:yes">  </span>or will provide facilities in the form of

</p>

1)Verify student</p>

2)Register Faculty</p>

3)Update Announcement</p>

4)Change Password</p>

5)View Student Details</p>

In short we can say that the<span

style="mso-spacerun:yes">  </span>admin will confirm whether<span style="mso-spacerun:yes"> 

</span>or not the

status of<span style="mso-spacerun:yes">  </span>student is approved<span

style="mso-spacerun:yes">  </span>or pending..on the basis of that it will confirm<span

style="mso-spacerun:yes">  </span>or not.</p>

Will register new faculty while giving new user name & password<span

style="mso-spacerun:yes">  </span>and will give

program<span style="mso-spacerun:yes">  </span>name<span style="mso-spacerun:yes">  </span>,mobile no

address ,faculty name.</p>

Moreover it will update announces….</p>

It will also change password….in order to make it more secure..</p>

And last but not the least it will view student details..</p>

And finally will log out..</p>

</asp:Panel>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: VERIFY STUDENT PAGE

<%@ Page Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="verifystudent.aspx.cs" Inherits="verifystudent" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2

{

width: 100%;

}

.style3

{

height: 2px;

}

.style4

{

height: 23px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<td>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"

AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC"

BorderStyle="None" BorderWidth="1px" CellPadding="3"

onpageindexchanging="GridView1_PageIndexChanging"

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

onselectedindexchanged="GridView1_SelectedIndexChanged"

DataKeyNames="Username" PageSize="4">

<asp:BoundField DataField="Name" HeaderText="Name" />

<asp:BoundField DataField="FatherName" HeaderText="Father Name" />

<asp:BoundField DataField="Date_Of_Birth" HeaderText="dob" />

<asp:BoundField DataField="Gender" HeaderText="Gender" />

<asp:BoundField DataField="Quali" HeaderText="Qualification" />

<asp:BoundField DataField="program" HeaderText="program" />

<asp:BoundField DataField="Mobile" HeaderText="Mobile" />

<asp:BoundField DataField="E_mail" HeaderText="E_mail" />

<asp:BoundField DataField="Status" HeaderText="Status" />

<asp:ButtonField Text="Confirm" CommandName="Edit" />

<asp:ButtonField Text="Not Confirm" CommandName="Delete" />

</Columns>

</asp:GridView>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

<asp:Button ID="btn_sendmail" runat="server" BackColor="#9999FF"

Font-Bold="True" Font-Names="Times New Roman" Font-Size="Medium"

onclick="btn_sendmail_Click" Text="Send Mail" />

</td>

</tr>

<tr>

<td>

 </td>

</tr>

</table>

</asp:Content>

FORM NAME: REGISTER FACULTY PAGE

<%@ Page Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="register_faculty.aspx.cs" Inherits="register_faculty" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2

{

width: 600px;

}

.style3

{

color: #000000;

}

.style4

{

background-color: #FFFFFF;

}

.style5

{

color: #000000;

background-color: #FFFFFF;

}

.style6

{

color: #000000;

font-weight: bold;

font-size: large;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

</tr>

<tr>

Faculty Name</td>

 </td>

<asp:TextBox ID="fname" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Address</td>

 </td>

<asp:TextBox ID="Add" runat="server" TextMode="MultiLine"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Mobile No</td>

 </td>

<asp:TextBox ID="mobile" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Gender</td>

 </td>

<asp:RadioButtonList ID="gender" runat="server" Width="90px"

style="color: #000000">

<asp:ListItem>Male</asp:ListItem>

<asp:ListItem>Female</asp:ListItem>

</asp:RadioButtonList>

</td>

 </td>

</tr>

<tr>

Programme</td>

 </td>

<asp:DropDownList ID="DDLPROG" runat="server">

<asp:ListItem>select</asp:ListItem>

<asp:ListItem>MCA</asp:ListItem>

<asp:ListItem>BCA</asp:ListItem>

<asp:ListItem>M.TECH</asp:ListItem>

</asp:DropDownList>

</td>

 </td>

</tr>

<tr>

User_name</td>

 </td>

<asp:TextBox ID="username" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

Password</td>

 </td>

<asp:TextBox ID="password" runat="server" TextMode="Password"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

 </td>

<asp:Button ID="submitbtn" runat="server" BackColor="#999966" ForeColor="#00CC00"

Text="SUBMIT" onclick="submit_Click" style="color: #FFFFFF" />

                 </td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</div>

</asp:Content>

FORM NAME: FACULTY HOME PAGE

<%@ Page Language="C#" MasterPageFile="~/faculty.master" AutoEventWireup="true" CodeFile="fachome.aspx.cs" Inherits="home" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

p.MsoNormal

{margin-top:0in;

margin-right:0in;

margin-bottom:10.0pt;

margin-left:0in;

line-height:115%;

font-size:11.0pt;

font-family:"Calibri","sans-serif";

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<asp:Panel ID="Panel1" runat="server" BackColor="#CCCCCC" Height="198px"

ScrollBars="Both">

Faculty is the backbone of any academic institute .Here in the Online Course

Management System faculty plays a vital role by providing help in the form of

providing courses content to the student.</p>

It will upload the courses so that student can download it and can use it to it

full.</p>

Moreover it can change the password of it’s own whenever needed

</asp:Panel>

</td>

</tr>

</table></asp:Content>

FORM NAME: UPLOAD COURSE PAGE

<%@ Page Language="C#" MasterPageFile="~/faculty.master" AutoEventWireup="true" CodeFile="uploadfaculty.aspx.cs" Inherits="uploadfaculty" Title="Untitled Page" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style3

{

height: 27px;

}

.style4

{

height: 31px;

}

.style5

{

color: #000000;

}

.style6

{

height: 31px;

color: #000000;

}

.style7

{

color: #000000;

font-weight: bold;

font-size: large;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

UPLOAD COURSE</td>

</tr>

<tr>

Program code</td>

<asp:DropDownList ID="ddlprogram" runat="server" AutoPostBack="True"

onselectedindexchanged="ddlprogram_SelectedIndexChanged">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

</td>

 </td>

</td>

</tr>

<tr>

Semester</td>

<asp:DropDownList ID="ddlsem" runat="server" AutoPostBack="True"

onselectedindexchanged="ddlsem_SelectedIndexChanged">

<asp:ListItem>Select</asp:ListItem>

</asp:DropDownList>

</td>

</td>

</td>

</tr>

<tr>

Course code</td>

<asp:DropDownList ID="ddlcourse" runat="server"

onselectedindexchanged="ddlcourse_SelectedIndexChanged">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

</td>

 </td>

 </td>

</tr>

<tr>

Tutorial Type</td>

<asp:RadioButtonList ID="RadioButtonList1" runat="server"

RepeatDirection="Horizontal" style="color: #000000">

<asp:ListItem>Text</asp:ListItem>

<asp:ListItem>Video</asp:ListItem>

<asp:ListItem>Audio</asp:ListItem>

</asp:RadioButtonList>

</td>

 </td>

 </td>

</tr>

<tr>

Topic</td>

<asp:TextBox ID="topictxt" runat="server"></asp:TextBox>

</td>

 </td>

 </td>

</tr>

<tr>

Tutorial

</td>

<asp:FileUpload ID="FileUpload1" runat="server" />

</td>

 </td>

 </td>

</tr>

<tr>

 </td>

<asp:Button ID="btnupload" runat="server" onclick="btnupload_Click"

Text="upload" />

</td>

 </td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: STUDENT FORGET PASSWORD PAGE

<%@ Page Language="C#" MasterPageFile="~/zee.master" AutoEventWireup="true" CodeFile="forgetpass.aspx.cs" Inherits="forgetpass" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style6

{

width: 100%;

}

.style7

{

width: 273px;

}

.style8

{

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

<td>

 </td>

</tr>

<tr>

<td>

<asp:Panel ID="Panel1" runat="server">

<tr>

<td>

</td>

<td>

ENTER USERNAME</td>

<td>

:</td>

<td>

<asp:TextBox ID="txtusername" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

 </td>

<td>

<asp:Button ID="submit" runat="server" Text="Submit" onclick="submit_Click" />

<asp:HiddenField ID="HiddenField1" runat="server" />

</td>

</tr>

</table>

</asp:Panel>

</td>

</tr>

<tr>

<td>

 </td>

</tr>

<tr>

<td>

<asp:Panel ID="Panel2" runat="server" Height="111px">

<tr>

SECURITY QUESTION</td>

:</td>

<td>

<asp:Label ID="lblsecurity" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

ANSWER</td>

 </td>

<td>

<asp:TextBox ID="txtanswer" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Label ID="lblpass" runat="server" Text="Label" Visible="False"></asp:Label>

</td>

</tr>

<tr>

<asp:Button ID="btnsubmit" runat="server" onclick="btnsubmit_Click"

Text="Submit" />

</td>

</tr>

<tr>

 </td>

</tr>

</table>

</asp:Panel>

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: STUDENT HOME PAGE

<%@ Page Language="C#" MasterPageFile="~/student.master" AutoEventWireup="true" CodeFile="studenthom.aspx.cs" Inherits="zeestuhm" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style5

{

width: 600px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" runat="server"

contentplaceholderid="ContentPlaceHolder1">

<tr>

<tr>

<asp:Label ID="lblname" runat="server" Text="Label" Font-Size="XX-Large"

ForeColor="Yellow"></asp:Label>

</td>

</tr>

<tr>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: STUDENT DOWNLOAD PAGE

<%@ Page Language="C#" MasterPageFile="~/student.master" AutoEventWireup="true" CodeFile="stu_download.aspx.cs" Inherits="stu_download" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style3

{

width: 700px;

}

.style4

{

height: 21px;

}

.style5

{

font-size: x-large;

font-style: italic;

font-weight: bold;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

DOWNLOAD HERE........</td>

</tr>

<tr>

 </td>

 </td>

 </td>

 </td>

</tr>

<tr>

</td>

SEMESTER</td>

:</td>

<asp:DropDownList ID="ddlsem" runat="server"

onselectedindexchanged="DropDownList1_SelectedIndexChanged"

AutoPostBack="True">

</asp:DropDownList>

</td>

</tr>

<tr>

 </td>

COURSE</td>

:</td>

<asp:DropDownList ID="ddlcourse" runat="server"

onselectedindexchanged="ddlcourse_SelectedIndexChanged">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

 </td>

TUTORIAL TYPE</td>

:</td>

<asp:RadioButtonList ID="RadioButtonList1" runat="server"

RepeatDirection="Horizontal">

<asp:ListItem>Text</asp:ListItem>

<asp:ListItem>Video</asp:ListItem>

<asp:ListItem>Audio</asp:ListItem>

</asp:RadioButtonList>

</td>

</tr>

<tr>

 </td>

 </td>

<asp:Button ID="Button_submit" runat="server" Text="SUBMIT"

onclick="Button_submit_Click" />

</td>

</tr>

<tr>

 </td>

 </td>

<asp:HiddenField ID="hf_pcode" runat="server" />

 <asp:HiddenField ID="hf_pname" runat="server" />

</td>

</tr>

<tr>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

CellPadding="4" ForeColor="#333333" Width="676px"

onrowcommand="GridView1_RowCommand">

<asp:TemplateField HeaderText="SNo">

<%# Container.DataItemIndex + 1 %>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="topic" HeaderText="Topic" />

<asp:BoundField DataField="postedby" HeaderText="Posted By" />

<asp:ButtonField Text="Download" CommandName="Select" />

</Columns>

</asp:GridView>

</td>

</tr>

<tr>

 </td>

 </td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: STUDENT FORUM PAGE

<%@ Page Language="C#" MasterPageFile="~/Student.master" AutoEventWireup="true" CodeFile="forum.aspx.cs" Inherits="forum" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<tr>

<td>

</td>

</tr>

<tr>

<b><i>Student Forum</i></b></td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

<asp:DataList ID="DataList1" runat="server" Width="100%" CellPadding="3"

onitemcommand="DataList1_ItemCommand" BackColor="White" BorderColor="#999999"

BorderStyle="None" BorderWidth="1px" GridLines="Vertical">

<table bgcolor="gray" cellpadding="5" cellspacing="5"

style="width: 100%; font-family:Times New Roman; font-weight:bold">

<tr>

Topic</td>

Posted By</td>

Date</td>

<%-- <td width="5%">

No of Reply</td>--%>

</tr>

</table>

</HeaderTemplate>

<!— Pager Construct —>

<tr>

<b>

<asp:Label ID="StatusLabel" Runat="server" Font-Name="verdana" Font-Size="10pt" />

</b>

</td>

<a href="forum.aspx#this" id="hrefFirst" onserverclick="ShowFirst" runat="server" style="color:White">First</a>

</td>

<a href="forum.aspx#this" id="hrefPrevious" onserverclick="ShowPrevious" runat="server" style="color:White">Previous</a>

</td>

</td>

</td>

</tr>

</table>

</FooterTemplate>

<tr>

<asp:LinkButton ID="lb_topic" runat="server" Text='<%#Eval("topic")%>'

PostBackUrl='<%#Eval("topic_id","forum_reply.aspx?topic_id={0}") %>'></asp:LinkButton>

</td>

<asp:Label ID="lbl_postedby" runat="server" Text='<%#Eval("posted_by") %>'></asp:Label>

</td>

<asp:Label ID="Label3" runat="server" Text='<%#Eval("date") %>'></asp:Label>

</td>

<%-- <td style="width:5%">

<asp:Label ID="Label1" runat="server" Text='<%#Eval("no") %>'></asp:Label>

</td>--%>

</tr>

<tr>

<td>

 </td>

<td>

 </td>

<td>

</td>

<td>

<asp:LinkButton ID="lb_reply" runat="server" CommandName="Edit">Reply</asp:LinkButton>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="txt_reply" runat="server" TextMode="MultiLine" BorderStyle="None" BorderWidth="0px" Visible="False"

Width="469px" ></asp:TextBox>

</td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

<asp:LinkButton ID="lb_send" runat="server" Visible="False"

CommandArgument='<%#Eval("topic_id") %>' CommandName="update">Send</asp:LinkButton>

<asp:LinkButton ID="lb_cancel" runat="server" Visible="False" CommandName="cancel">Cancel</asp:LinkButton>

</td>

<td>

 </td>

<td>

 </td>

</tr>

</table>

</ItemTemplate>

</asp:DataList>

</td>

</tr>

<tr>

<asp:Label ID="lbl_error" runat="server" Font-Bold="True" ForeColor="#FF3300"

Visible="False"></asp:Label>

 </td>

</tr>

<tr>

<td>

<table bgcolor="#C9E4E4" cellpadding="5" cellspacing="5"

style="width: 100%; height: 250px;">

<tr>

<td align="center" colspan="4"

style="font-family: Arial, Helvetica, sans-serif; font-size: large">

<b><i> Ask Your Question Here </i></b></td>

</tr>

<tr>

 </td>

 </td>

 </td>

<td>

 </td>

</tr>

<tr>

<td>

 </td>

<b>Topic</b></td>

<td>

<asp:TextBox ID="txt_topic" runat="server" BorderStyle="None" BorderWidth="0px"

Height="119px" TextMode="MultiLine" Width="560px"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

 </td>

<td>

 </td>

<td>

<asp:Button ID="Button_submit" runat="server" Height="26px"

onclick="Button_submit_Click" Text="Submit" Width="81px" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

 </td>

</tr>

</table>

</ContentTemplate>

</asp:UpdatePanel>

</asp:Content>

FORM NAME: VIEW PROFILE OF STUDENT PAGE

<%@ Page Language="C#" MasterPageFile="~/student.master" AutoEventWireup="true" CodeFile="viewprofile.aspx.cs" Inherits="viewprofile" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2 {

width: 700px;

color: #000000;

padding-left:20px;

}

.style3

{

height: 21px;

}

.style4

{

height: 22px;

}

.style5

{

font-size: large;

color: #000000;

width: 700px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<table cellpadding="5" cellspacing="5" class="left" style="color: #000000"

bgcolor="#CCCCCC" border="1" align="left">

<tr>

PERSONAL DETAILS</td>

</tr>

<tr>

COUNTRY   </td>

<asp:Label ID="lblcontry" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

STATE</td>

<asp:Label ID="lbstate" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

CITY</td>

<asp:Label ID="lblcity" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

ADDRESS</td>

<asp:Label ID="lbladd" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

QUALIFICATION</td>

<asp:Label ID="lblqua" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

PROGRAM</td>

<asp:Label ID="lblcour" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

MOBILE</td>

<asp:Label ID="lblmob" runat="server" Text="Label"></asp:Label>

</td>

</tr>

<tr>

E-MAIL ID</td>

<asp:Label ID="lblemail" runat="server" Text="Label"></asp:Label>

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: EDIT PROFILE OF STUDENT PAGE

<%@ Page Language="C#" MasterPageFile="~/student.master" AutoEventWireup="true" CodeFile="editprofile.aspx.cs" Inherits="editprofile" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2

{

width: 700px;

}

.style3

{

height: 21px;

}

.style4

{

height: 22px;

}

.style5

{

color: #000000;

}

.style6

{

height: 21px;

color: #000000;

}

.style7

{

height: 22px;

color: #000000;

width: 700px;

}

.style8

{

height: 22px;

color: #000000;

width: 700px;

font-weight: bold;

font-size: large;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<table cellpadding="5" cellspacing="5" class="style2" align="left"

bgcolor="#CFCFCF" border="1">

EDIT PERSONAL DETAILS<br />

</td>

</tr>

COUNTRY</td>

<asp:DropDownList ID="ddlcountry" runat="server" AutoPostBack="True"

Height="16px" onselectedindexchanged="ddlcountry_SelectedIndexChanged">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="ddlcountry" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

STATE</td>

<asp:DropDownList ID="ddlstate" runat="server" AutoPostBack="True"

onselectedindexchanged="ddlstate_SelectedIndexChanged">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

ControlToValidate="ddlstate" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

CITY</td>

<asp:DropDownList ID="ddlcity" runat="server" AutoPostBack="True">

<asp:ListItem>select</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"

ControlToValidate="ddlcity" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

ADDRESS</td>

<asp:TextBox ID="txtadd" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"

ControlToValidate="txtadd" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

QUALIFICATION</td>

<asp:TextBox ID="txtquali" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"

ControlToValidate="txtquali" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

PROGRAM</td>

<asp:DropDownList ID="ddlprogram" runat="server">

<asp:ListItem>MCA</asp:ListItem>

<asp:ListItem>BCA</asp:ListItem>

<asp:ListItem>MBA</asp:ListItem>

<asp:ListItem>B.TECH</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server"

ControlToValidate="ddlprogram" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

MOBILE</td>

<asp:TextBox ID="txtmobil" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server"

ControlToValidate="txtmail" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

E-MAIL</td>

<asp:TextBox ID="txtmail" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server"

ControlToValidate="ddlcountry" ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label>

</td>

<asp:Button ID="Button1" runat="server" Text="EDIT" onclick="Button1_Click" />

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: CHANGE PASSWORD OF STUDENT PAGE

<%@ Page Language="C#" MasterPageFile="~/student.master" AutoEventWireup="true" CodeFile="changepassword.aspx.cs" Inherits="changepassword" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2

{

width: 700px;

}

.style3

{

width: 100%;

}

.style4

{

width: 277px;

}

.style5

{

font-size: large;

font-style: italic;

font-weight: bold;

}

.style6

{

height: 26px;

}

.style7

{

height: 26px;

color: #000000;

}

.style8

{

height: 26px;

font-weight: bold;

}

.style9

{

width: 54px;

}

.style10

{

height: 26px;

width: 54px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

 Change Your Password </td>

</tr>

<tr>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

</td>

Old Password</td>

:</td>

<asp:TextBox ID="txtoldpass" runat="server" TextMode="Password"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="txtoldpass" ErrorMessage="enter old passwrd"

Font-Size="Small" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

New Password</td>

<td>

<asp:TextBox ID="txtnewpass" runat="server" TextMode="Password"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

ControlToValidate="txtnewpass" ErrorMessage="enter new passwrd"

Font-Size="Small" SetFocusOnError="True"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

</td>

Confirm Password</td>

<asp:TextBox ID="txtconpass" runat="server" TextMode="Password"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"

ControlToValidate="txtconpass" ErrorMessage="enter confirm passwrd"

Font-Size="Small" SetFocusOnError="True"></asp:RequiredFieldValidator>

<asp:CompareValidator ID="CompareValidator1" runat="server"

ControlToCompare="txtnewpass" ControlToValidate="txtconpass"

ErrorMessage="passwrd not match" Font-Size="Small"></asp:CompareValidator>

</td>

</tr>

<tr>

 </td>

<asp:Label ID="Label1" runat="server" Text="Label" ForeColor="Red"

Visible="False"></asp:Label>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

<asp:Button ID="Button1" runat="server" BackColor="#CC9900" Text="submit"

onclick="Button1_Click" />

</td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

FORM NAME: UPDATE ANNOUNCES PAGE

<%@ Page Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="update_anounces.aspx.cs" Inherits="update_anounces" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

.style2

{

width: 700px;

}

.style3

{

width: 100%;

}

.style5

{

font-size: large;

font-style: italic;

font-weight: bold;

}

.style6

{

height: 26px;

}

.style9

{

width: 304px;

}

.style10

{

height: 26px;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<tr>

<tr>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

ANNOUNCES</td>

</tr>

<tr>

 </td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr>

 </td>

Announcement</td>

<td>

<asp:TextBox ID="multilineanounce" runat="server" TextMode="MultiLine"></asp:TextBox>

</td>

</tr>

<tr>

</td>

Subject</td>

<asp:TextBox ID="txtsubject" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

</td>

Date</td>

<asp:TextBox ID="txtdate" runat="server"></asp:TextBox>

</td>

 </td>

</tr>

<tr>

 </td>

 </td>

 </td>

<asp:Button ID="btnsub" runat="server" onclick="btnsub_Click" Text="submit" />

</td>

 </td>

</tr>

<tr>

 </td>

 </td>

 </td>

 </td>

 </td>

</tr>

<tr>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

CellPadding="4" ForeColor="#333333" Width="890px">

<asp:BoundField DataField="Announcement" HeaderText="Announcement"

ItemStyle-Width="70%">

</asp:BoundField>

<asp:BoundField DataField="Subject" HeaderText="Subject" ItemStyle-Width="20%" >

</asp:BoundField>

<asp:BoundField DataField="Date" HeaderText="Date" ItemStyle-Width="10%" >

</asp:BoundField>

<asp:CommandField ShowEditButton="True" />

<asp:CommandField ShowDeleteButton="True" />

</Columns>

</asp:GridView>

</td>

</tr>

<tr>

 </td>

 </td>

 </td>

 </td>

 </td>

</tr>

</table>

</td>

</tr>

</table>

</asp:Content>

5.2.2 Code Efficiency

Code of the software is said to be efficient, if the complexity of all types is minimum. In the code of the developed software, I have tried to minimize the space and time complexity, so the code is efficient.

The complexities can be minimized in three ranges. They are called as organized simplicity, disorganized complexity and organized complexity.

Organized simplicity is represented by systems that are adequate models of some real world phenomena and yet consist of a very small number of variables, which depend on each other in highly deterministic fashion.

Disorganized complexity possesses characteristics that are represented by the system, with every large number of variables and high degrees of randomness.

Organized complexity is methodologically undeveloped in the sense that neither analytical nor statistical methods are adequate for dealing with systems that fit into it.

Computational complexity

Computational complexity is a characterization of time and space requirements for solving a problem by a particular algorithm. Either of these requirements is usually expressed in terms of a single that represent the size of the problem. Although computational complexity has been predominantly studied in terms of the time it takes to perform a computation, the amount of computer memory is required frequently just as important. This requirement is usually called the space requirement. It is expressed in the terms of a space complexity function, analogous to the time complexity function.

5.3 Testing Approach

The testing phase involves the testing of the developed system using various kinds of data. An elaborated testing of data is prepared and a system is tested using the test data. While testing, errors are noted and corrections remade, the corrections are also noted for future use.

Testing is to determine errors in a software code. It is crucial element of software quality assurance and represents the ultimate review of specifications, design and coding. The increasing visibility of software as a system element and the attendant “costs” associated with a software failure are motivating forces for well planned through testing. Usually software development organizations expend between 30-40 percent of total project effort on testing. Our goal is to design a series of test cases that have a high likelihood of finding errors.

To test the software, there are so many testing techniques which provide systematic guidance for designing tests that exercise the internal logic of software components and exercise the input and output domains of the program to uncover errors in program function, behavior and performance.

If testing is conducted successfully, it will uncover errors in the software. As the secondary benefits, testing demonstrates that software functions appear to be working according to specification, that behavioral and performance requirements appear to have been met. The software can be tested by one of the two ways: -

Knowing the specified function that a product has been designed to perform, tests can be conducted that demonstrate each function is full operational while at the same time searching for errors in each function.

Knowing the internal working of the product, tests can be conducted to ensure that internal operations are performed according to specifications and all internal components have been adequately exercised.

Testing Objectives: -

1. Testing is a process of executing a program with the intent of finding an error.

2. A good test case is one that has a high probability of finding an undiscovered error.

3. A successful test is one that uncovers an as-yet undiscovered error.

4. Testing demonstrated that the software functions appear to be working according to specification and that performance requirements appear to have been met.

5. As a secondary benefit the data collected as testing is conducted provides a good indication of software reliability and some indication of software quality as a whole. But there is one thing that testing cannot do and that is it cannot show the absence of defects, it can only show that software errors are presents.

Testing Principles

· All tests should be traceable to customer requirements.

· Tests should be planned long before testing begins.

· Tests should begin with “in the small” and progress toward testing “in the large”

· Exhaustive testing is not possible.

· To be more effective an independent third party should conduct testing.

5.3.1 Unit Testing

During the implementation of the system each module of the system was tested separately to uncover errors within its boundaries. User interface was used as a guide in the process.

In the unit testing interfaces, local data structures, boundary conditions, independent paths, error-handling paths are tested. Test cases should be design to uncover errors due to erroneous computations, incorrect comparisons, or improper control flow developed, reviewed and verified for correspondence to component level design, . For this purpose basis path and loop testing is done. After source level code has been unit test case design begins. In unit test application ‘drivers’ are developed which are programs, accept test case data, passes such data to the component to be tested and prints relevant results. ‘Stubs’ are also developed which serve to replace modules, that are subordinate the component to be tested.

5.3.2 Integrated Testing

Integration testing is a systematic technique for constructing the program structure while conducting tests to uncover errors associated with interfacing. The objective is to take unit-tested module and build a program structure that has been dictated by design.

Integration testing is systematic technique for constructing the program structure while at the same time conducting the tests to uncover errors associated with interfacing. The objective is to take unit tested components and build a program structure that has been dictated by design. There are two types of integration – Bottom up integration and Top down integration. Regression and smoke testing are done in integration testing strategy.

CHAPTER 6: RESULTS AND DISCUSSION

6.1 Test Reports

Communication problems, Programmers negligence, or Time constraints create errors that must be eliminated before the system is ready for user acceptance testing. A system is tested for online response, volume of transactions, stress, recovery from failure and usability.

Considering the process from the procedural point of view, testing within the context of software engineering is actually a series of four steps that are implemented sequentially. Initially test focus on each component individually, ensuring that it functions properly as unit. Hence, the name unit testing.

Unit testing makes heavy techniques that exercises specific path in a component’s control structure to ensure complete coverage and maximum error detection. Next, component must be assembled or integrated to form the complete package. Integration testing addresses the issues associated with the dual problems of verification and program construction. Test cases design techniques that focus on inputs and outputs are more prevalent during integration. After the software has been integrated, a set of high order tests is conducted. Validation criteria (established during requirement analysis) must be evaluated. Validation testing provides final assurance that software meets all functional, behavioral, and performance requirements. The last high order-testing step falls outside the boundary of software engineering and into the broader context of computer system engineering.

System testing verifies that all elements mesh properly and that overall system function/performance is achieved. Following system testing is acceptance testing, or runningthe system with live data by the actual user. Another reason for system testing is its utility as a user-oriented vehicle before implementation. The best program is worthless if it does not satisfy the user needs.

CHAPTER 7.1 CONCLUSIONS

In this new world of consumerism everyone wants to get more and to achieve the goal one should be competitive. Be it a personal or any organization. We have seen that many small scale business organization faces failure due to lack of information and unorganized office. Now not only big whales of business but small industries and organizations also recognized the importance and necessity of computer based information system and Data Base Management System. Therefore each organization today goes for computer based system project.

This software is been designed in such a manner that it will going to give a flexible environment and any module can be easily added in the future and up gradation can also been done.

This software gives the best performance for online environment, In this time we can do it online for more efficient working, also we can add some other modules such as financial module to handle various prospects of finance.

The system is menu driven, easily maintainable and accessible. Handling of the system in easy and provides study material of their respective course, and can make query from faculty and discuss with students.

The portal “Online Course Management” being developed to help and assist the student to get them best study material and education. The system saves lot of time and effort of the same.

7.2 Limitation of the Security

So many tools and techniques have been used to develop the software according to their requirements. It is not a complete project with its own. But at least there are few limitations of the project which are described below-

Users point of view:

· There is no provision to make online live communication/interview.

Programmer point of view:

· We have used the SQL Server 2000 database. For security reasons it is not stronger database than the Oracle database.

· User’s Interaction could not be seen on the software that how many times that the subscriber has visited the website.

· Subscriber who has forgotten his/her password cannot be regenerated. There is no provision for password hints. He/she will have to create his login id once again.

The project will work on platform supporting windows

7.3 Future Scope of the Project

This project can be further enhanced to suit various type of client requirements .The few enhancements that I have in mind at this moment are:

· Make it more user friendly so that user can handle it with more ease and can exploit all the possible resources.

· The system may be developed for remote access facility.

· It can be extended for multiple platforms.

· The number of clients that is the load tolerance can be improved.

REFERENCES

Software Engineering, Roger S. Pressman, McGraw-Hill
An integrated approach to software engineering, Pankaj Jalote, Narosa Publishing House
System Analysis And Design, Elias M Awad, Galgotia Publication
Mastering in Asp.Net, Evangelos Petroutsos, BPB Publications
Introduction to Sql Server, Kevin Loney & George Koch, Tata McGraw Hill

FREE DOWNLOAD BCA MCA MANAGEMENT SYSTEM PROJECT SYNOPSIS REPORT WITH SOURCE CODE (ASP.NET PHP JAVA)

FREE DOWNLOAD IGNOU BCA MCA PROJECT, SYNOPSIS AND FINAL REPORT WITH SOURCE CODE

Friday, May 15, 2020

Online Course Management Systems

ONLINE COURSE MANAGEMENT SYSTEM PROJECT REPORT | ONLINE COURSE MANAGEMENT SYSTEM

Project Overview

Testing

Unit Testing

Implementation

CHAPTER 7.1 CONCLUSIONS

No comments:

Post a Comment

SQL Server Unique Constraint