1.1 An Overview: Chapter-I
1.1 An Overview: Chapter-I
1.1 An Overview: Chapter-I
INTRODUCTION
1.1 AN OVERVIEW
All the present college web portals are static in nature and are not very
interactive with the user and even for the developer. Static Web portals have several
limitations over extensibility and interoperability where the web designer has to
modify the whole content of the web site for any enhancement. So there is a need for
developing a Dynamic portal. This Dynamic college web portal provides an online
solution for the day-to-day operation of an organization. This dynamic environment is
provided a easy way of updating the information about the college News,
Announcements and various activities of the institution anywhere, anytime on the
network.
FEASIBILITY STUDY
An important objective of conducting the system analysis is the determination of
the feasibility. All projects are feasible if given unlimited resources and infinite time. But
our systems have shortage of resources. It is necessary to evaluate the feasibility of a
project at the earliest possible time. Feasibility and risk analysis are related in many ways.
If project risk is great, the feasibility of producing quality software is reduced. During
system engineering, however, we concentrate our attention on three primary areas of
interest
TECHINICAL FEASBILITY
It is a study of function, performance and constraints that may affect the ability to
achieve an acceptable system. The proposed system is web technology based system and
all the technical requirements are available with the organization and the Internet
technology is available for most of the people in this World. So the proposed system will
definitely work with the current equipment, existing software technology, and available
personnel. The proposed system is developed in such a way that, it is simple enough to
understand and manipulate.
OPERATIONAL FEASIBILITY
Will the system be used if it is developed and implemented? Will there be
resistance from users that will undermine the possible application benefits? Since
Household items and all other Consumer products are being used worldwide for human
purposes there will be worldwide interest in the information about these items. Hence the
system will be definitely used by the users. By considering the various factors, the
proposed system gives high performance, it is reliable, maintainable. Hence the proposed
system is feasible.
ECONOMICAL FEASIBILITY
It is an evaluation of development of cost weighed against the ultimate income or
benefit derived from the developed system. Economic justification Includes a broad range
of concerns that include costbenefit analysis, long-term corporate income strategies, cost
of resources needed for development.
1.3.1
DRAWBACKS
In the existing system
The present web portal system is static in nature and is not very interactive
It cannot install on any web server hosting company
No link to different department details and a forum where in the user can
share their ideas
Designer has to modify the whole content of the web site for any
enhancement.
CHAPTER - II
SYSTEM ANALYSIS
2.1 STUDY ON PROPOSED SYSTEM
The proposed system is designed to provide a solution for the drawbacks of
present system.
All the present college web portals are static in nature and are not very interactive
with the user and even for the developer. Static Web portals have several limitations
over extensibility and interoperability where the web designer has to modify the whole
content of the web site for any enhancement. So there is a need for developing a
Dynamic portal.
Replace Manual Processing system with an automated one.
Speedup Transactions
Reduce the chances of malpractices associated in a manual system.
Reduce the workload involved in processing
Update information system and provide easy access to corresponding
information.
MODULE DESCRIPTION
The project titled Online Course Portal website which can be used for
conducting web based apply for colleges. This project has been designed in ASP.NET as
front-end which itself is a user-friendly language and it also provides a very good support.
MICROSOFT SQL Server as back-end, which gives full security.
The modules covered in the project are
Student Registration module
This module is used for getting the personal details of the student, and the details
regarding the subject they have selected. Then only they can get the training from this
website.
The project is developed as a web portal , that can be implemented in any
educational organization that handles students from all walks of life , situated in different
geographical locations . The examiner can be anyone who need not have physical presence
for conducting the examinations.
Issues regarding security has been taken care of , no unauthorized personnel will be
able to handle the online examination system . Examiners when they create a question
paper can store it in the question bank for later use so that retrival of previous questions
papers is very easy .
Staff Registration module
This module is used for getting the personal details of the staff, and the details
regarding the subject they have selected. Staffs register the details and apply for registered
colleges. College admin can view the staff details and finally appoint to our college .
College Administrator module
College admin can view all applying staff details and verify our records like
personal details, working experience details than finally post to appoint order.
System RAM
1GB
500 GB
Keyboard
Mouse
Optical Mouse
Monitor
15 Color Monitor
ASP.Net 2008
Back end
Operating system
Windows XP
Many parts of C# are context sensitive. Context sensitive means we can get
help on these parts directly without having to go through the help menu. For
example, to get help on any keyword in the C# language, place the insertion
point on that keyword in the code window and press F1.
C# interprets our code as we enter it, catching and highlighting most syntax or
spelling errors on the fly. Its almost like having an expert watching over our
shoulder as we enter our code.
FRONT END:ASP.NET:
FEATURES OF .NET
Microsoft .NET is a set of Microsoft software technologies for rapidly building and
integrating XML Web services, Microsoft Windows-based applications, and Web
solutions. The .NET Framework is a language-neutral platform for writing programs that
can easily and securely interoperate. Theres no language barrier with .NET: there are
numerous languages available to the developer including Managed C++, C#, Visual Basic
and Java Script. The .NET framework provides the foundation for components to interact
seamlessly, whether locally or remotely on different platforms. It standardizes common
data types and communications protocols so that components created in different
languages can easily interoperate.
.NET is also the collective name given to various software components built upon
the .NET platform. These will be both products (Visual Studio.NET and Windows.NET
Server, for instance) and services (like Passport, .NET My Services, and so on).
optimally tested for type safety by using the verifier before the Just-In-Time (JIT) compiler
comes to play. The JIT compiler processes the IL, creating managed native code. Then,
the managed native code is passes on to the .NET runtime manager. Finally, the .NET
runtime manager executes the native code. The native code is cached and users can select
the caching schemes that best fit their execution environments.
10
A language used to insert, retrieve, modify, and delete data relational database. SQL also
contains statements for defining and administering the objects in a database. SQL is the
language supported by most relational databases, and is the subject of standards published
by the International Standards Organization (ISO) and the American National
Standards Institute (ANSI). SQL Server 2000 uses the SQL language called
Transact-SQL.
SQL server Query Analyzer is a graphical toll that allows you to
Edit and SQL scripts queries.
View a graphical representation of a querys ( estimated) execution plan.
Return query results to grid or text.
Perform index analysis.
Retrieve Transact-SQL syntax help.
View statistic information about an executed query.
UTILITIES
The interactive SQL utility (SQL Server Query analyzer) allow you to enter
Transact-SQL statements, system stored procedures, and scripts files. You can up shortcuts
or create batch file to launch a per configured SQL Server Query analyzer.
11
12
Rs.10000/month
Programmer
Rs.5000/month
13
OPERATING COST
Operating cost include all costs associated with day to day operation of the System.
To install a system the estimated cost is given below:
PC-P4
Rs.30000
Printer
Rs.6500
UPS
Rs.5000
Others
Rs.7000
Total
Rs.48500
Rs.2000
Repairs
Rs.1000
Maintenance Charges :
Rs.3000
Total
Rs.6000
14
CHAPTER - III
DESIGN AND DEVELOPMENT PROCESS
3.1 DESIGN NOTATION
There are several software design concepts that evolved over the past three
decades. Depending upon the interest of the programmer involved in a project the design
process varies. This design process also helps the programmer to decompose our project
into various parts to complete the work and it separates the conceptual representation from
the datastructure. The above all provides a developer with a foundation from which more
sophisticated design methods can be applied, because there is a lot of differences in a
program that is working and getting it right. It depends upon the
Abstraction.
Refinement.
Modularity.
15
CAD DIAGRAM
Student selection
Student entry
Staff entry
Online
Course
Portal
Staff selection
College entry
LEVEL 0
Student &
staff
selection
process
Admin
16
Reports
LEVEL 1
Entry
Student
registration
process
Registration Details
Staff
details
process
College
details
Selection
details
process
Final Report
17
studnet_data
staff_data
college_data
Selection
3.1.2 ER DIAGRAM
Entity
Entity
Attribute
are
the
properties
or
characteristics of an entity
Key attribute
A
Attribute
key
attribute
is
the
unique,
an
employees
social
security
Relationship
illustrate
how
two
Weak relationship
To connect a weak entity with others,
Relationship
18
Staff
name
ER DIAGRAM
Mother
name
Father
name
student
name
Student
_ID
Email_id
S no
cpaswrd
Studentreg
student
name
dept
Staffreg
Date_bir
th
Ten
percen
paswrd
position
Mobile
no
Email_id
Clg_id
login_ID
Staff_id
gender
passwor
d
courses
Date_bi
rth
Twelth
percen
Address
gender
Stfname
Student\stafft
UploadDetails
Apply
resume
Email_id
Clg_nam
e
courses
student
name
Student
_ID
appl
y
colleg_id
collegeID
college
name
Select
type
appr
ove
StudentApprovedDetails
College
courses
College
name
Status
Email id
College details
Con
password
No of
vacancy
Status
password
date
Staff_id
Vacancyde
partment
StaffApprovedDetails
Email id
Staff
name
departmen
t
colleg_id
courses
College
name
19
is
concerned
with
identifying
software
components
specifying
Relationships among components. Specifying software structure and providing blue print
for the document phase.
Modularity is one the desirable properties of large systems. It implies that the
system is divided into several parts. In such a manner, the interaction between parts is
minimal clearly specified.
Design will explain software components in detail. This will help the
implementation of the system. Moreover, this will guide the further changes in the system
to satisfy the future requirements.
20
DATA TYPE
DESCRIPTION
stud_id
varchar(10)
Student Id
Sname
char(20)
Student Name
father_name
char(20)
Father Name
mother_name
char(20)
Mother Name
Gender
char(10)
Gender
date_Birth
Datetime
Date of Birth
Email_Id
varchar(50)
Email Id
Address
varchar(50)
Address
Department
char(20)
Twelth Department
twelth_percentage
char(20)
Twelth Percentage
twelth_passingyear
Datetime
tenth_percentage
varchar(20)
Tenth Percentage
tenth_passingyear
Datetime
Password
Varchar(10)
Password
Date
Datetime
Current Date
21
DATA TYPE
DESCRIPTION
serial_no
varchar(10)
Serial Identification
Department
char(20)
Department
Position
char(20)
Position
staff_id
varchar(10)
Staff Identification
Stname
char(20)
Staff Name
date_birth
Datetime
Date of Birth
Gender
char(20)
Gender
email_id
varchar(50)
Email Id
Password
varchar(10)
Password
Cpassword
varchar(10)
Confirm Password
mobile_no
Bigint
Mobile No
Date
Datetime
Date
DATA TYPE
DESCRIPTION
College_id
Varchar(10)
College Identification
Col_name
Char(20)
College Name
Select_type
Char(20)
Select Type
Col_courses
Char(20)
Courses
Vacancy courses
Int
Vacancy in Courses
Department
Char(20)
Select Department
Vacancy_Department
Int
No of Vacancy in
Department
Password
Varchar(10)
Password
Confirm_Password
Varchar(10)
Confirm_Password
Date
Datetime
Current Date
22
DATA TYPE
DESCRIPTION
student_id
varchar(10)
Student Identification
Sname
char(20)
Student Name
Courses
char(20)
Courses
College_id
Varchar(10)
College Identification
college_name
char(20)
College Name
email_id
varchar(50)
Email Id
Resume
varchar(MAX)
Resume Details
Date
Datetime
Date
DATA TYPE
DESCRIPTION
staff_id
varchar(10)
Staff Identification
Staffname
char(20)
Staff Name
Deparment
char(20)
Deparment
College_id
Varchar(10)
College Identification
college_name
char(20)
College Name
email_id
varchar(50)
Email Id
Resume
varchar(MAX)
Resume Details
Date
Datetime
Date
Apply for
Char(20)
Dep _vacancy
Varchar(50)
Deparment vacancy
23
DATA TYPE
DESCRIPTION
student_id
varchar(10)
Student Identification
Sname
char(20)
Student Name
Courses
char(20)
Courses
College_id
Varchar(10)
College Identification
college_name
char(20)
College Name
email_id
varchar(50)
Email Id
Status
Char(20)
Status
Date
Datetime
Date
DATA TYPE
DESCRIPTION
staff_id
varchar(10)
Staff Identification
Staffname
char(20)
Staff Name
Courses
char(20)
Courses
College_id
Varchar(10)
College Identification
college_name
char(20)
College Name
email_id
varchar(50)
Email Id
Status
Char(20)
Status
Date
Datetime
Date
Eligibility
Varchar(50)
Eligibility
24
25
26
An inevitable activity in the system is the proper design of input and output in
form acceptable to the user. Outputs from the system are required primarily to
communicate the result of processing to users. Outputs also provide a permanent copy of
the results for later consultations. An intelligible output design will improve system
relationships with the user and help in the decision-making process.
27
CHAPTER - IV
TESTING AND IMPLEMENTATION
4.1 SYSTEM TESTING
The purpose of testing is to discover errors. Testing is the process of trying to
discover every conceivable fault or weakness in a work product. It provides a way to check
the functionality of components, sub assemblies, assemblies and/or a finished product It is
the process of exercising software with the intent of ensuring that the
Software system meets its requirements and user expectations and does not fail in an
unacceptable manner. There are various types of test. Each test type addresses a specific
testing requirement.
28
UNIT TESTING
Unit testing is testing changes made in an existing or new program. This test is
carried out during the programming and each module is found to be working satisfactory.
INTEGRATION TESTING
A comprehensive integration testing is carried out using integrated test plans in the
design phase of the development as guide to ensure the behavior of functions with live
data.
VALIDATION TESTING
Software validation is achieved through a series of tests that demonstrates
conformity with requirements. Thus the proposed system under consideration has been
tested by validation and found to be working satisfactorily.
OUTPUT TESTING
Asking the users about the format required by them tests the outputs generated by
system under consideration. It can be considered in two ways. One on the screen and the
other is printed format. The output format on the screen is found to be correct as the
format designed in the system design.
This is to verify that all the system elements have been properly integrated and
perform allocated functions. Testing is executing a program to test the logic changes made
in it and with intention of finding errors. Tests are also conducted to find discrepancies
between system and its original objective, current specification and documents.
implementation is
29
30
31
CHAPTER - V
CONCLUSION
The project entitled Online Course Portal, which is currently developed and
implemented using ASP.Net and MS SQL Server 2000, could be further developed using
web based technologies. The same Intranet project could be upgraded to Internet based
application with .NET and Oracle 9i as a web server. By implementing the concept, in
future all the branches of the company could share the data across the web.
The system has been designed, developed and implemented after tedious testing
and debugging the goals of the system have reached in such a manner that the system is
flexible for any change in the near future. The coding has been done cautiously so that any
developer can follow the program easily with the knowledge of the convections followed
hence it is easy to be maintained. Testing has been completed and a third person, with little
knowledge of coding, tested the system for user friendliness and simplicity.
32
BIBLIOGRAPHY
BOOK REFERENCES :
User Interfaces in C#: Windows Forms and Custom Controls by Matthew MacDonald.
Applied Microsoft .NET Framework Programming (Pro-Developer) by Jeffrey Richter.
Practical .Net2 and C#2: Harness the Platform, the Language, and the Framework by
Patrick Smacchia.
WEBSITE REFERRED:
http://www.sourcefordgde.com
http://www.networkcomputing.com/
http://www.ieee.org
http://www.almaden.ibm.com/software/quest/Resources/
http://www.computer.org/publications/dlib
http://www.ceur-ws.org/Vol-90/
http://www.microsoft.com/isapi/redir.dll?prd=ie&pver=6&ar=msnhome
33
ANNEXURE-A
INPUT DESIGN
STUDENT REGISTRATION DETAILS
34
35
36
37
OUTPUT DESIGN
STUDENT REGISTRATION DETAILS
38
39
40
SOURCE CODE
Sample Coding:
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.Configuration;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
using System.IO;
#region Connection
41
#endregion
42
ControlsClear();
con.Close();
}
public void AutoNumber()
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT COUNT(staff_id) as Tot FROM
StaffDetails", con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
int i = Convert.ToInt32(dr["tot"]);
if (i > 0)
{
int j = i + 1;
TxtSid.Text = "STF0" + j.ToString();
}
else
{
TxtSid.Text = "STF01";
}
}
con.Close();
}
protected void Button4_Click(object sender, EventArgs e)
43
{
con.Open();
SqlCommand cmd = new SqlCommand("Select (MAX(serial_no)+1) From
StaffDetails", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
TxtSno.Text = dr.GetValue(0).ToString();
}
con.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("HomePage.aspx");
}
44
}
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.Web.Configuration;
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
45
46
47
}
else if (DropDownList2.Text == "B.com ca")
{
Txtvd.Text = "4";
}
else if (DropDownList2.Text == "Msc cs")
{
Txtvd.Text = "2";
}
else if (DropDownList2.Text == "mca")
{
Txtvd.Text = "3";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("CollegeLogDetails.aspx");
}
}
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.Configuration;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
48
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
using System.IO;
#region Connection
#endregion
49
{
Label24.Text = "Male";
}
else if(rdbFemale.Checked==true)
{
Label24.Text = "Female";
}
string filenames = Path.GetFileName(FileUpload1.PostedFile.FileName).ToString();
FileUpload1.SaveAs(Server.MapPath("~/StaffDetails/" + filenames));
SqlCommand cmd = new SqlCommand("insert into StaffDetails values('" +
TxtSno.Text + "', '" + ddlDept.Text + "', '" + ddlPosition.Text + "','" + TxtSid.Text + "','" +
TxtSname.Text + "','" + TxtDob.Text + "','" + Label24.Text + "','" + TxtEid.Text + "','" +
TxtPass.Text + "','" + TxtCpass.Text + "','" + TxtMob.Text + "','" + filenames + "','" +
TxtDate.Text + "')", con);
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(typeof(Page), "Validate", "<script>alert('Staff
Registered And Uploaded Successfully');</script>");
ControlsClear();
con.Close();
}
public void AutoNumber()
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT COUNT(staff_id) as Tot FROM
StaffDetails", con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
int i = Convert.ToInt32(dr["tot"]);
50
if (i > 0)
{
int j = i + 1;
TxtSid.Text = "STF0" + j.ToString();
}
else
{
TxtSid.Text = "STF01";
}
}
con.Close();
}
protected void Button4_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("Select (MAX(serial_no)+1) From
StaffDetails", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
TxtSno.Text = dr.GetValue(0).ToString();
}
con.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("HomePage.aspx");
}
51
}
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;
52
using System.Web.Configuration;
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("StaffRegistrationDetails.aspx");
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("LoginForm.aspx");
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
53
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.Web.Configuration;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownList1.Text == "STUDENT")
{
Session["UserId"] = TxtLid.Text;
try
{
con.Open();
54
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Redirect("StudentLogDetails.aspx");
}
else
{
}
catch (Exception ex)
{
Response.Write(ex.ToString());
con.Close();
}
if (DropDownList1.Text == "STAFF")
{
Session["UserId"] = TxtLid.Text;
try
{
con.Open();
55
Response.Redirect("StaffLogDetails.aspx");
}
else
{
}
catch (Exception ex)
{
Response.Write(ex.ToString());
con.Close();
}
}
if (DropDownList1.Text == "COLLEGE")
{
try
{
con.Open();
56
Response.Redirect("CollegeLogDetails.aspx");
}
else
{
}
catch (Exception ex)
{
Response.Write(ex.ToString());
con.Close();
}
}
}
}
57
ANNEXURE-B
ABBREVIATIONS:
OOPS
TCP/IP
CLR
58