Yogita CMS
Yogita CMS
Yogita CMS
PROJECT
Of
DECLARATION BY CANDIDATE
Certified that the project “College Management System” is the bonafide work
carried out by me under the supervision of Ms. Harsha Batra for the partial
fulfillment of the requirements for the award of the Degree of Master of Computer
Applications.
I further certify that this project is not submitted by me for the award of any other
degree from this or any other Institution /University.
SIGNATURE SIGNATURE
Dr. Deepti Sharma Ms. Harsha Batra
(iv)
ACKNOWLEDGEMENT
Through this acknowledgment, we express our sincere gratitude to all those people who have
been associated with this project and have helped us with it and made it a worthwhile experience.
Firstly we extend our thanks to the various people who have shared their opinions and
experiences through which we received the required information crucial for our report.
I am highly indebted to Mr. Baldev Batra, our project guide for their guidance and constant
supervision as well as for providing necessary information regarding the project & also for their
support in completing the project.
My thanks and appreciations also go to my colleague in developing the project and people who
have willingly helped me out with their abilities
Finally, we express our thanks to Mr. Anil Batra, Director of STG who guided us and gave us
valuable suggestions regarding the project report.
YOGITA
(v)
Table of Contents
NO.
Acknowledgement (v)
Table of contents
1 ORGANIZATION PROFILE 1
2 INTRODUCTION TO PROJECT 3
4 16
SYSTEM DESIGN
1
4.1 System Analysis and Design 17
4.1.1 New Form
17
4.1.2 Search
18
4.1.3 Update
4.1.4 Delete 19
4.1.5 Enquiry Form
20
4.1.6 Enquiry to Admission Form
21
4.1.7 Fee Received
4.1.8 Due Fee 22
4.1.9 Due Fee Received
23
4.2 Entity Relationship Diagram
24
4.3 Data Flow Diagrams
4.3.1 Context Level DFD 25
4.3.2 Level 1 DFD (Registration Form)
26
4.3.3 Level 1 DFD (Enquiry Form)
27
4.3.4 Level 1 DFD (Fee Form)
28
5 IMPLEMENTATION 29
6 TESTING 58
2
67
8 References 69
3
4
1. ORGANIZATION PROFILE
5
6
2. INTRODUCTION TO PROJECT
7
Manage course and specialty
Manage semester and year
Admission seat management
Exam scheduling
Result management
Subject management
Block management
In College Management System, every user has a Login ID and Password. Also all the
users have different permission rights to access the applications. These rights are Dynamic and
can be changed.
There are three main roles in the system. Admin, accountant and operator. Admin has complete
access to the whole system, while accountant is only concerned with payment of fees for the
admission of the student. Operator is the role that is responsible for the use of the system.
The Admin role can be as follow:
Introduce new quota, board, category, course, etc
Set fees structures
Manage faculties
Manage subjects
Seat management
Management of semester
Generation of student roll number
Set examination
8
2.2 PURPOSE
The project is about to handle all the information of the student regarding admission,
examination and fees. Also it manages resources which were managed and handled by
manpower previously. The main purpose of the project is to integrate distinct sections of the
organization into consistent manner so that complex functions can be handled smoothly by any
technical or non-technical persons.
All the above-mentioned matters are to be incorporated in the application along with some
additional requirements.
The main purpose of the Admin Module is to introduce new things and configure
important aspects. For e.g. only admin is authorized to introduce quota, university, subject,
category, etc. and only admin is allowed to configure exam and set fees structure. So the master
screens for all these are visible to only admin role. This is done by the Admin Module. It also
can create the users and Physical and Logical Locations. Thus the main purpose of the Admin
Module is to managing the dynamic working of the system.
9
2.3 SCOPE
Source code written in C# is compiled into an intermediate language (IL) that conforms to the
CLI specification. The IL code and resources, such as bitmaps and strings, are stored on disk in an
executable file called an assembly, typically with an extension of .exe or .dll.
When the C# program is executed, the assembly is loaded into the CLR, which might take
various actions based on the information in the manifest. Then, if the security requirements are met, the
CLR performs just in time (JIT) compilation to convert the IL code to native machine instructions. The
CLR also provides other services related to automatic garbage collection, exception handling, and
resource management. Code that is executed by the CLR is sometimes referred to as "managed code," in
contrast to "unmanaged code" which is compiled into native machine language that targets a specific
system.
10
Language interoperability is a key feature of the .NET Framework. Because the IL code
produced by the C# compiler conforms to the Common Type Specification (CTS), IL code
generated from C# can interact with code that was generated from the .NET versions of Visual
Basic, Visual C++, or any of more than 20 other CTS-compliant languages.
Advantages:
C# borrows concepts from Java and C++, adopting only the good bits from those
languages and eliminating overly confusing and error prone features, which are the
major sources of bugs in a code.
C# is a terse language. It’s very tiny even with the commands. Visual Basic on the
other hand has a command for almost any kind of situation that the developer may
face during the development of the code making its reference a real hefty one.
C# supports effective and reusable components.
11
C# is portable at the same time it is cross language compatible for all Microsoft
Windows based languages and programs specifically targeted to that particular
platform can be coded to interoperate with the code of other languages.
C# implements the modern programming concept of Object Oriented Programming
which enables the developer to produce secure data centric applications and take the
user to the next level of experience.
C# programs can be written in as simple as a text pad and a command line which are
common to any operating system provided the developer has installed the CLR and
the framework priory. Microsoft’s Rapid Application Development Suite products,
named Microsoft Visual Studio ships with a separate Visual tool for C#, and gives
developers visually rich tools for development and deployment.
Disadvantages:
All though portability is what with C# was developed, C# programs are largely for
Microsoft Windows Environment which although happens to be the most widely used
Operating system over the globe, but with Open Source technologies, especially
platforms like Linux catching up, C# still has to long way to go. This is one major
shortcoming of C#.
C# has eliminated the “unsafe” code functionalities from C++ (from which it was
developed); it has its own set of functionalities which are to be used with caution by
the user. More of this will be discussed further on in the book.
Although C# programs can be written as little as a text editor and compiled using
command line, it still needs the .NET framework to be present on the system, which
cripples down the portability in the development of C# programs by a large amount,
and makes it more Microsoft Windows dependent.
12
13
3. SOFTWARE REQUIREMENT & ANALYSIS
Since, the present system is manual all the work is done in papers and ink by hand so it is
Much costly and difficult to use and to operate and it is also time consuming.
So our automated computerized College Management System is much feasible, in cost, time,
And efforts as compare to the previous manual system.
It is economically feasible, it will only require a single operator to operate the system,
who is responsible for entering the data into the database via a user interface provided to him,
Who can also able to show all the data in .Net tabular form so to provide information
Regarding the students who are either taken admission or to take admission, since it
requires Only a single person to operate the whole system thus reduces the cost to operate the
System.
It is technically feasible, since the whole system is designed into the latest technologies
like.NET using C# and SQL Server which are the most recent technologies to Develop web
based systems and design databases.
It uses the latest hardware technologies like Intel i3 Systems so easy to operate. It is Behavioral
feasible, since the system is providing a attractive user interface to the
Operator/end user, so he feel very easy to work onto it. Response to operator/end user is
Very fast and very good.
14
Since, as we mentioned above that it requires much less amount of cost, it uses computer
Work so it is very fast to operate and it is very easy for user to work on it.
In present, all work is done manually by hand in bulk of files which is hard to operate and
Hard to maintain the reports of the student presently, took admission in institute.
1. When the student comes in college.
2. First of all, he/she takes admission form from reception.
3. Fills it and submits it into office.
4. Filled form is first checked with documents like merit list and details came from
University and verified by an official person, if there is any mistake then it is corrected.
5. At the time of submission of it the fees is deposited by the candidate.
6. At the time of submission of admission form enrollment no. is assigned to the candidate
By the institute.
7. Candidate gets the receipt of fees deposition.
1. Require much man power i.e. much efforts, much cost and hard to operate and
Maintain.
2. Since, all the work is done in papers so it is very hard to locate a particular student
Record when it is required.
Proposed System:
15
3.3 Hardware/Software Requirement
Software Requirements :
Technology C# .NET
Hardware requirements :
16
3.4 List of Tables Used
1. Rg RegistrationNo Varchar[50]
Auto Generated
Name Varchar[50]
FatherName Varchar[50]
MotherName Varchar[50]
EmailID Varchar[50]
MobileNo Numeric (18,0)
OtherMobileNo Numeric (18,0)
Category Varchar[50]
Gender Varchar[50]
DOB Varchar[50]
Age Numeric (18,0)
MaritalStatus Varchar[50]
SpouseName Varchar[50]
PermanentAddress Varchar[50]
City Varchar[50]
State Varchar[50]
Country Varchar[50]
PinCode Integer
PreviousCourse Varchar[50]
SemesterYear Integer
SchoolCollege Varchar[50]
Percentage Integer
Course Varchar[50]
TotalFee Integer
University Varchar[50]
2. Education RegistrationNo Varchar[50]
Auto Generated
Subject Varchar[50]
School_College Varchar[50]
Board_University Varchar[50]
RollNo Numeric (18,0)
RegNo Varchar[50]
Marks_Obtained Numeric (18,0)
Total_Marks Numeric (18,0)
Percentage Numeric (18,0)
Year Integer
3. Enquiry SrNo Integer
Auto Generated
Name Varchar[50]
FatherName Varchar[50]
MotherName Varchar[50]
Gender Varchar[50]
PhoneNo1 Numeric (18,0)
PhoneNo2 Numeric (18,0)
Address Varchar[50]
17
City Varchar[50]
State Varchar[50]
Country Varchar[50]
Date Varchar[50]
Course Varchar[50]
Session Varchar[50]
University Varchar[50]
Reference Varchar[50]
RefName Varchar[50]
RefAddress nchar(10)
Status Varchar[50]
4. Fee RegistrationNo Varchar[50]
Auto Generated
Name Varchar[50]
FatherName Varchar[50]
MotherName Varchar[50]
Course Varchar[50]
University Varchar[50]
Semester Integer
dofr Varchar[50]
FeesRec Numeric (18,0)
BalFees Numeric (18,0)
18
4 SYSTEM DESIGN
19
4.1 System Analysis & Design
4.1.1.1 Process
The Registration Form is used to fill all the related details of an student . All the
fields that are in the form are mandatory to fill. If any of the detail is filled
incorrectly the form will not submit.The Registration No. of student will
generated automatically as the student select their respective course.
4.1.1.2 Input:
Complete Details of the student including personal, academic records.
After filling all the details in the form. The record will get inserted in to Database.
4.1.1.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Student’ will be displayed.
(3) After clicking on student select the ‘New’ record.
(4)Registration form will be opened fill the related details.
20
4.1.2.1 Process :-
In this form we can search the record of an Student through their Name,Roll
No,Father’s name or Phone No. When we enter the name of a student and click on
the Search button the record will be searched and all the filelds related to student
details wll be filled.
4.1.2.2 Input:
Select from the alternate choices like Name, Roll No,Father’s name,Phone No ,etc
from which we want to search the record.
Output:
The details that are filled in the text box according to them the related details of
the students that are already in the Database will be shown.
4.1.2.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Student’ will be displayed.
(3) After clicking on student select the ‘Search’ record.
(4)Search form will be opened fill the related details.
4.1.3.1 Process :-
In this form we can Update any changes that are Required.With the Help of
Update form we can update the record of an student and can do ant necessary
changes in to the data of Student. After the updation of record click on Update
button .
4.1.3.2 Input:
21
First we search the record of a student.
And then if any changes needs to be done we will do that.
Output:
The record will be updated successfully.
4.1.3.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Student’ will be displayed.
(3) After clicking on student select the ‘Update’ record.
(4)Update form will be opened, update the related details.
4.1.4.1 Process :-
In this form we can Delete the record that is already inserted in to the DataBase.
For Deleting the record firstly we need to search the record that we want to
delete.after searching that record,click on the delete button the record will be no
longer in the Database
4.1.4.2 Input:
First we search the record of a student.
When the related record will be find then click on the Delete button
Output: The record will be Deleted successfully.
4.1.4.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Student’ will be displayed.
(3) After clicking on student select the ‘Delete’ record.
(4) The record will be Deleted successfully.
Module Description (Enquiry) :
22
4.1.5 Module: Enquiry Form
4.1.5.1 Process :-
The Enquiry Form is used to fill all the related details of an student who come for the
enquiry related to the admission . All the fields that are in the form are mandatory to fill.
If any of the detail is filled incorrectly the form will not submit.The Serial No. of
Enquiry will generated automatically as the no. of students come for enquiry.
4.1.5.2 Input:
Complete Details of the student including personal, academic records.
After filling all the details in the form. The record will get inserted in to
DataBase.
Output:
The Data about the student will inserted in to the Database.
4.1.5.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Enquiry’ will be displayed.
(3) After clicking on student select the ‘New’ record.
(4)Enquiry form will be opened fill the related details.
23
4.1.6.1 Process :-
This form is used to convert Enquiry to Admission. By using this form we don’t need
to fill all the details again of a student .We can convert details that are filled in the
Enquiry form to Admission form by using this Enquiry to Admission Form.
4.1.6.2 Input:
Select the Enquiry button, and fill the name of the student
Click on the button ’Convert to Admission.
Output:
All the details will be filled in to the registration form and the data about the student
will inserted in to the Database.
4.1.6.3 Flow:
(1) Admin clicks on ‘Main’ form link.
(2) Then the option ‘Enquiry’ will be displayed.
(3) After clicking on student select the ‘Convert to Admission’ record.
(4) Enquiry form will be opened fill the related details.
4.1.7.1 Process :-
The Fee received Form is used to fill all the related details of an student . All the
fields that are in the form are mandatory to fill. If any of the detail is filled
incorrectly the form will not submit.The Registration No. of student is checked
in database ,if found all the related data is fetched automatically. Now we have to
fill the amount received from student and on leave event it will display the
balance fee automatically.
4.1.7.2 Input:
We just need to fill registration no. and the amount received from the student.
After filling these details in the form. The record will get inserted in to Database.
Output:
Record inserted successfully.
4.1.7.3 Flow:
(1) User clicks on fee menu .
(2) Then click on the ‘FeeRec’option.
(3) Fee Rec form will be opened fill the related details.
4.1.8.1 Process :-
The Due Fee received Form is used to check the record of those students who paid
their fee in between the particular period of time. For retrieving the data for a
particular period we have to enter two dates Start date and End date.start date can’t be
greater than the end date ,and End date can’t be greater than the current date.
4.1.8.2 Input:
25
We just need to enter the Start date and End date. And click on the below button.
Output:
Record retrieved successfully.
4.1.8.3 Flow:
4.1.9.1 Process :-
The Due Fee received Form is used to check the record of those students who did
not pay their fee in between the particular period of time. For retrieving the data for a
particular period we have to enter two dates Start date and End date.start date can’t be
greater than the end date ,and End date can’t be greater than the current date.
4.1.9.2 Input:
We just need to enter the Start date and End date. And click on the below button.
Output:
Record retrieved successfully.
4.1.9.3 Flow:
26
An entity-relationship diagram (ERD) is an abstract and conceptual representation of
data. Entity-relationship modeling is a database modeling method, used to produce a type of
conceptual schema or semantic data model of a system, often a relational database, and its
requirements in a top-down fashion.
27
4.3.1 Context Level DFD
28
Insert Search
Registration /
Database Admission Database
Form
Update Delete
29
Student provides their personal details
At Enquiry Counter and
Discuss about the courses.
If student wants the
admission then this Enquiry Form
will get convert into Admission
Form.
30
Fee
Received
Students will pay their
Monthly fee though this portal and it will get
stored into the Database.
31
5.1 Screen Shots
32
5.1.1
Main Form
33
5.1.3 Search and Update Form
34
35
36
5.1.4 Delete Form
37
5.1.5 Enquiry Form
38
5.1.6 Convert to Admission
39
5.1.7 Fee Received
40
5.1.8 Due Fee
41
5.1.9 Due Fee Received
42
5.2 CODING
43
}
}
}
}
using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection conn;
SqlCommand comm;
int r = 0;
public Form1()
{
InitializeComponent();
}
44
comm.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Record insterted");
string st = dateTimePicker1.Text;
Form2 f1 = new Form2();
f1.Show();
conn.Open();
DateTimePicker d = new DateTimePicker();
String st = "select max(rollno) from rg where course='" +
comboBox4.SelectedItem + "' and session='" + comboBox7.SelectedItem + "'";
MessageBox.Show(st);
comm = new SqlCommand(st);
comm.Connection = conn;
SqlDataReader reader;
reader = comm.ExecuteReader();
if (reader.Read())
{
if (reader.GetValue(0).ToString() == "")
{
r = 1;
}
else
{
r = Convert.ToInt32(reader.GetValue(0)) + 1;
}
textBox10.Text = "" + r;
}
45
textBox13.Text = "Stg/" + r + "/" + comboBox4.SelectedItem + "/" +
d.Value.Year.ToString();
conn.Close();
MessageBox.Show("recored stored successfully");
}
textBox16.Text = this.dateTimePicker1.Value.Year.ToString();
textBox16.Text = Convert.ToString(dp.Value.Year -
dateTimePicker1.Value.Year);
}
}
}
namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
int fl=0;
public Form3()
{
InitializeComponent();
}
46
conn.Close();
conn.Open();
comm =
newSqlCommand("selectRegistrationNo,Name,FatherName,MotherName,EmailID,MobileNo,OtherMobi
leNo,Category,Gender,DOB,MaritalStatus,SpouseName,PermanentAddress,City,State,Country,Pin
Code,Course,TotalFee from rg where " + comboBox1.SelectedItem + " like '%" +
textBox1.Text + "%' or " + comboBox2.SelectedItem + " like '%" + textBox2.Text + "%'");
comm.Connection = conn;
reader = comm.ExecuteReader();
fl = 1;
if (reader.Read())
{
textBox13.Text = reader.GetValue(0).ToString();
textBox11.Text = reader.GetValue(1).ToString();
textBox3.Text = reader.GetValue(2).ToString();
textBox10.Text = reader.GetValue(3).ToString();
textBox5.Text = reader.GetValue(4).ToString();
textBox6.Text = reader.GetValue(5).ToString();
textBox7.Text = reader.GetValue(6).ToString();
comboBox6.SelectedItem = reader.GetValue(7).ToString();
comboBox3.SelectedItem = reader.GetValue(8).ToString();
dateTimePicker1.Value = Convert.ToDateTime(reader.GetValue(9));
comboBox5.SelectedItem = reader.GetValue(10).ToString();
textBox4.Text = reader.GetValue(11).ToString();
textBox8.Text = reader.GetValue(12).ToString();
comboBox7.SelectedItem = reader.GetValue(13).ToString();
comboBox4.SelectedItem = reader.GetValue(14).ToString();
textBox17.Text = reader.GetValue(15).ToString();
textBox9.Text = reader.GetValue(16).ToString();
comboBox8.SelectedItem = reader.GetValue(17).ToString();
textBox15.Text = reader.GetValue(18).ToString();
}
else
{
MessageBox.Show("record not found");
}
}
47
textBox6.Text = reader.GetValue(5).ToString();
textBox7.Text = reader.GetValue(6).ToString();
comboBox6.SelectedItem = reader.GetValue(7).ToString();
comboBox3.SelectedItem = reader.GetValue(8).ToString();
dateTimePicker1.Value = Convert.ToDateTime(reader.GetValue(9));
comboBox5.SelectedItem = reader.GetValue(10).ToString();
textBox4.Text = reader.GetValue(11).ToString();
textBox8.Text = reader.GetValue(12).ToString();
comboBox7.SelectedItem = reader.GetValue(13).ToString();
comboBox4.SelectedItem = reader.GetValue(14).ToString();
textBox17.Text = reader.GetValue(15).ToString();
textBox9.Text = reader.GetValue(16).ToString();
comboBox8.SelectedItem = reader.GetValue(17).ToString();
textBox15.Text = reader.GetValue(18).ToString();
}
else
{
MessageBox.Show("record not found");
MessageBox.Show(st);
comm.CommandText = st;
comm.Connection = conn;
int n = comm.ExecuteNonQuery();
MessageBox.Show("record updated successfully " + n);
}
}
48
5.2.4 DELETE
using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Delete : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataAdapter ad;
DataTable dt;
public Delete()
{
InitializeComponent();
}
if (ConnectionState.Open == conn.State)
conn.Close();
conn.Open();
comm = new SqlCommand("select * from rg where " + comboBox1.SelectedItem
+ " like '%" + textBox1.Text + "%' or " + comboBox2.SelectedItem + " like '%" +
textBox2.Text + "%'");
49
comm.Connection = conn;
comm.ExecuteNonQuery();
ad = new SqlDataAdapter(comm);
dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
else
{
MessageBox.Show("cancelled");
}
}
}
}
50
5.2.5 ENQUIRY
using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class enquiry : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
public enquiry()
{
InitializeComponent();
}
private void textBox12_TextChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (ConnectionState.Open == conn.State)
conn.Close();
conn.Open();
string st = "insert into enquiry
(SrNo,Name,FatherName,MotherName,PhoneNo1,PhoneNo2,Address,City,State,Country,Date,Course
,Session,University,Reference,RefName,RefAddress,status,Gender) values (" + textBox1.Text
+ ",'" + textBox12.Text + "','" + textBox2.Text + "','" + textBox3.Text + "'," +
textBox5.Text + "," + textBox6.Text + ",'" + textBox7.Text + "','" + textBox8.Text +
"','" + textBox9.Text + "','" + textBox10.Text + "','" + dateTimePicker1.Value + "','" +
comboBox2.SelectedItem + "','" + comboBox5.SelectedItem + "','" + comboBox3.SelectedItem
+ "','" + comboBox4.SelectedItem + "','" + textBox4.Text + "','" + textBox11.Text +
"' ,'yes','" + comboBox1.SelectedItem + "')";
MessageBox.Show(st);
comm.CommandText = st;
comm.Connection = conn;
comm.ExecuteNonQuery();
conn.Close();
conn.Open();
MessageBox.Show("Record saved successfully");
string st1 = "select max(SrNo) from enquiry";
int sn;
comm.CommandText = st1;
comm.Connection = conn;
reader = comm.ExecuteReader();
while (reader.Read())
{
string val = reader.GetValue(0).ToString();
if (val == "")
sn = 1;
else
sn = Convert.ToInt32(val) + 1;
textBox1.Text = "" + sn;
}
conn.Close();
textBox1.Text = "";
textBox12.Text = "";
textBox2.Text = "";
51
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox4.Text = "";
textBox11.Text = "";
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
}
if (val == "")
sn = 1;
else
sn = Convert.ToInt32(val) + 1;
textBox1.Text = "" + sn;
}
conn.Close();
}
}
}
52
5.2.6 Enquiry to Admission
using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form4 : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
public Form4()
{
InitializeComponent();
}
private void Form4_Load(object sender, EventArgs e)
{
conn = new SqlConnection("Data Source=.;Initial Catalog='reg form';Persist
Security Info=True;User ID=sa;Password=garima001");
comm = new SqlCommand();
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
string st = "select * from enquiry where status='yes'";
comm.CommandText = st;
comm.Connection = conn;
comm.ExecuteNonQuery();
SqlDataAdapter ad = new SqlDataAdapter(comm);
DataTable dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
if (radioButton2.Checked == true)
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
string st = "select * from enquiry where status='no'";
comm.CommandText = st;
comm.Connection = conn;
comm.ExecuteNonQuery();
SqlDataAdapter ad = new SqlDataAdapter(comm);
DataTable dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close(); }
}
53
private void dataGridView1_CellContentClick(object sender,
DataGridViewCellEventArgs e) {
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
DialogResult dr;
int SrNo =
Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["SrNo"].Value);
string na = dataGridView1.Rows[e.RowIndex].Cells["Name"].Value.ToString();
dr = MessageBox.Show("Are you sure u want to convert this student to
admission", "confirm", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
MessageBox.Show("yes");
if (ConnectionState.Open == conn.State)
conn.Close();
conn.Open();
string st = "update enquiry set status='no' where SrNo=" + SrNo + "and
Name='" + na + "'";
MessageBox.Show(st);
comm.CommandText = st;
comm.Connection = conn;
int i = comm.ExecuteNonQuery();
MessageBox.Show("record updated successfully " + i);
Form1 ns = new Form1();
ns.textBox1.Text =
dataGridView1.Rows[e.RowIndex].Cells["Name"].Value.ToString();
ns.textBox2.Text =
dataGridView1.Rows[e.RowIndex].Cells["FatherName"].Value.ToString();
ns.textBox3.Text =
dataGridView1.Rows[e.RowIndex].Cells["MotherName"].Value.ToString();
ns.textBox6.Text =
dataGridView1.Rows[e.RowIndex].Cells["MobileNo"].Value.ToString();
ns.textBox7.Text =
dataGridView1.Rows[e.RowIndex].Cells["OtherMobileNo"].Value.ToString();
ns.textBox8.Text =
dataGridView1.Rows[e.RowIndex].Cells["PermanentAddress"].Value.ToString();
ns.comboBox1.Text =
dataGridView1.Rows[e.RowIndex].Cells["City"].Value.ToString();
ns.comboBox2.Text =
dataGridView1.Rows[e.RowIndex].Cells["State"].Value.ToString();
ns.textBox17.Text =
dataGridView1.Rows[e.RowIndex].Cells["Country"].Value.ToString();
// ns.textBox18.Text = "enquiry";
ns.comboBox8.SelectedItem =
dataGridView1.Rows[e.RowIndex].Cells["University"].Value.ToString();
ns.comboBox4.SelectedItem =
dataGridView1.Rows[e.RowIndex].Cells["Course"].Value.ToString();
ns.comboBox3.SelectedItem =
dataGridView1.Rows[e.RowIndex].Cells["Gender"].Value.ToString();
MessageBox.Show("Gender " +
dataGridView1.Rows[e.RowIndex].Cells["Gender"].Value.ToString());
ns.Show();
}
else
{
MessageBox.Show("No"); } } } }
54
5.2.7 FEE RECEIVED
using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class FeeRec : Form
{
SqlCommand comm;
SqlConnection conn;
SqlDataReader reader;
public FeeRec()
{
InitializeComponent();
}
}
private void FeeRec_Load(object sender, EventArgs e)
{
conn = new SqlConnection("Data Source=.;Initial Catalog='reg form';Persist
Security Info=True;User ID=sa;Password=garima001");
comm = new SqlCommand();
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
55
private void textBox1_Leave(object sender, EventArgs e)
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
MessageBox.Show("bye");
string st = "select Name,FatherName,MotherName,Course,University from rg
where RegistrationNo='" + textBox1.Text + "'";
comm.CommandText = st;
comm.Connection = conn;
reader = comm.ExecuteReader();
if (reader.Read())
{
MessageBox.Show(reader.GetValue(0).ToString());
if (reader.GetValue(0).ToString() != "")
{
textBox2.Text = reader.GetValue(0).ToString();
textBox3.Text = reader.GetValue(1).ToString();
textBox4.Text = reader.GetValue(2).ToString();
comboBox1.SelectedItem = reader.GetValue(3).ToString();
comboBox2.SelectedItem = reader.GetValue(4).ToString();
}
}
else
{
MessageBox.Show("student doesn't exists re enter RegistrationNo");
textBox1.Focus();
}
conn.Close();
conn.Open();
56
case 5:
comboBox3.SelectedIndex = sem;
break;
case 6:
comboBox3.SelectedIndex = sem;
break;
case 7:
comboBox3.SelectedIndex = sem;
break;
case 8:
comboBox3.SelectedIndex = sem;
break;
case 9:
comboBox3.SelectedIndex = sem;
break;
}
}
else
{
comboBox3.SelectedIndex = 0;
}
conn.Close();
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
int totalfees = 0, FeesRec = 0;
string st = "select totalfee from rg where RegistrationNo='" + textBox1.Text
+ "'";
comm.CommandText = st;
comm.Connection = conn;
reader = comm.ExecuteReader();
if (reader.Read())
{
totalfees = Convert.ToInt32(reader.GetValue(0));
}
MessageBox.Show("total fees = " + totalfees);
conn.Close();
conn.Open();
57
if (reader.GetValue(0).ToString() != "")
FeesRec = Convert.ToInt32(reader.GetValue(0).ToString());
textBox6.Text = "" + (totalfees - FeesRec -
Convert.ToInt32(textBox5.Text));
}
}
}
}
58
MessageBox.Show("start date can't be greater then end date");
dateTimePicker1.Focus();
}
}
private void dateTimePicker2_Leave(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
if (dateTimePicker2.Value.Date > dt)
{
MessageBox.Show("date can't be greater then today date");
dateTimePicker2.Focus();
}
}
}
}
59
}
private void dateTimePicker2_Leave(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
if (dateTimePicker2.Value.Date > dt)
{
MessageBox.Show("date can't be greater then today date");
dateTimePicker2.Focus();
}
}
private void due_fee_rcvd_Load(object sender, EventArgs e)
{
conn = new SqlConnection("Data Source=.;Initial Catalog='reg form';Persist
Security Info=True;User ID=sa;Password=garima001");
comm = new SqlCommand();
}
}
}
60
61
SYSTEM TESTING
Software Testing has a dual function; it is used to identify the defects in program and it is
used to help judge whether or not program is usable in practice. Thus software testing is used for
validation and verification, which ensure that software conforms to its specification and meets
need of the software customer.
Developer resorted Alpha testing, which usually comes in after the basic design of the
program has been completed. The project scientist will look over the program and give
suggestions and ideas to improve or correct the design. They also report and give ideas to get rid
of around any major problems. There is bound to be a number of bugs after a program have been
created.
Unit Testing
Module
Testing
Sub-
system
Testing
System
Testing
Acceptance
Testing
62
Fig: - Testing Step
Branch coverage
It is strategy in which test cases are designed to make each branch condition
assume true & false values.
Conditional coverage
In this testing test cases are designed to make each component of composite
conditional expression both true & false.
We test the software process activities such as Design, Implementation, and Requirement
Engineering. Because, design errors are very costly to repair once system has been started to
operate, it is quite obvious to repair them at early stage of the system. So analysis is the most
important process of any project.
Requirement Traceability
As most interested portion is whether the system is meeting its requirements or not, for that
testing should be planned so that all requirements are individually tested. We checked the output
of certain combination of inputs so that we can know whether it gives desirable results or not.
Strictly sticking to your requirements specifications, give you the path to get desirable results
from the system.
63
Testing Schedule
We have tested each procedure back-to-back so that errors and omissions can be found as
early as possible. Once the system has been developed fully we tested it on other machines,
which differs in configuration.
While deciding on the focus of testing activities, study project priorities. For example, for
an on-line system, pay more attention to response time. Spend more time on the features
used frequently.
Decide on the effort required for testing based on the usage of the system. If the system is
to be used by a large number of users, evaluate the impact on users due to a system
failure before deciding on the effort.
A necessary part of the test case is a definition of the expected result.
Write test cases for invalid and unexpected as well as valid and expected input
conditions.
Thoroughly inspect the results of each test.
64
We have performed both Unit Testing and System Testing on College Management System to
detect and fix errors. A brief description of both is given below.
Objective
The objective of Unit Testing is to test a unit of code (program or set of programs) using
the Unit Test Specifications, after coding is completed. Since the testing will depend on the
completeness and correctness of test specifications, it is important to subject these to quality and
verification reviews.
Input
Testing Process
Checking for availability of Code Walk-through reports which have documented the
existence of and conformance to coding standards.
Verify the Unit Test Specifications conform to the program specifications.
Verify that all boundary and null data conditions are included.
After our individual modules were tested out we proceed to the integration testing to
create a complete system. This integration process involves building the system and testing the
resultant system for problems that arise from component interactions.
65
6.1.4 System Testing
System testing is actually a series of tests whose purpose is to fully exercise the
computer-based system. It verifies that system elements have been properly integrated and
perform allocated functions. It checks whether the system as a whole works as per requirement.
We have used Performance testing. Performance testing - designed to test the run-time
performance of software, especially real-time software.
66
6.2 TEST CASES DESIGN
A test case is a set of conditions or variables and inputs that are developed for a particular
goal or objective to be achieved on a certain application to judge its capabilities or features.
It might take more than one test case to determine the true functionality of the application being
tested. Every requirement or objective to be achieved needs at least one test case. Some software
development methodologies like Rational Unified Process (RUP) recommend creating at least
two test cases for each requirement or objective; one for performing testing through positive
perspective and the other through negative perspective.
Information
Information consists of general information about the test case. Information incorporates
Identifier, test case creator, test case version, name of the test case, purpose or brief description
and test case dependencies.
Activity
Activity consists of the actual test case activities. Activity contains information about the
test case environment, activities to be done at test case initialization, activities to be done after
test case is performed, and step by step actions to be done while testing and the input data that is
to be supplied for testing.
Results
Results are outcomes of a performed test case. Results data consist of information about
expected results and the actual results.
67
Designing Test Cases
Test cases should be designed and written by someone who understands the function or
technology being tested. A test case should include the following information -
Designing test cases can be time consuming in a testing schedule, but they are worth
giving time because they can really avoid unnecessary retesting or debugging or at least lower it.
Organizations can take the test cases approach in their own context and according to their own
perspectives. Some follow a general step way approach while others may opt for a more detailed
and complex approach. It is very important for you to decide between the two extremes and
judge on what would work the best for you. Designing proper test cases is very vital for your
software testing plans as a lot of bugs, ambiguities, inconsistencies and slip ups can be recovered
in time as also it helps in saving your time on continuous debugging and re-testing test cases.
68
6.3 System Testing:
As a rule, system testing takes, as its input, all of the "integrated" software components
that have passed integration testing and also the software system itself integrated with any
applicable hardware system(s). The purpose of integration testing is to detect any inconsistencies
between the software units that are integrated together (called assemblages) or between any of
the assemblages and the hardware. System testing is a more limited type of testing; it seeks to
detect defects both within the "inter-assemblages" and also within the system as a whole.
Usually software is only one element of a larger computer based system. Ultimately, software is
interfaced with other software/hardware systems. System testing is actually a series of different
tests whose sole purpose is to exercise the full computer based system.
System testing falls under the black box testing category of software testing. White box
testing is the testing of the internal workings or code of a software application. In contrast, black
box or system testing is the opposite. System testing involves the external workings of the
software from the user's perspective.
These are the steps taken to fully test new software in preparation for marketing it:
Unit testing - testing performed on each module or block of code during development. Unit
testing is normally done by the programmer who writes the code.
Integration testing - testing done before, during and after integration of a new module into the
main software package. This involves testing of each individual code module. One piece of
software can contain several modules which are often created by several different programmers.
It is crucial to test each module's effect on the entire program model.
System testing - testing done by a professional testing agent on the completed software product
before it is introduced to the market.
Acceptance testing - beta testing of the product done by the actual end users.
69
6.3.1 Types of System testing:
Software testing life cycle is the process that explains the flow of the tests that are to be
carried on each product. The V- Model i.e Verification and Validation Model is a perfect model
which is used in the improvement of the software project. This model contains software
development life cycle on one side and software testing life cycle on the other hand side. The
checklists for software tester sets a baseline that guides him to carry on the day-to-day activities.
Black Box Testing: It explains the process of giving the input to the system and checking the
output, without considering how the system generates the output. It is also known as Behavioral
Testing.
Functional Testing: The software is tested for the functional requirements. This checks whether
the application is behaving according to the specification.
Performance Testing: This testing checks whether the system is performing properly, according
to the user's requirements. Performance testing depends upon the Load and Stress Testing that is
internally or externally applied to the system. Load Testing: In this type of performance testing,
the system is raised beyond the limits in order to check the performance of the system when
higher loads are applied. Stress Testing: In this type of performance testing, the system is tested
beyond the normal expectations or operational capacity. Usability Testing: This is also known as
'Testing for User Friendliness'. It checks the ease of use of an application.
Regression Testing: Regression testing is one of the most important types of testing, which
checks whether a small change in any component of the application affects the unchanged
components or not. This is done by re-executing the previous versions of the application.
70
7 CONCLUSION AND DISCUSSION
7.1 CONCLUSION
College Management System will be helpful to perform paperless work and manage all
data.
This provides easy, accurate, unambiguous and faster data access.
Lesser learning curve - Consistent user interface, customized for the group of users,
statistical information in various graphical and tabular forms.
7.2 DISCUSSION
Problem of creating control using .NET were faced during development. But with help of
internal guide and other team members problems were solved.
The problems encountered during the training undergone at STG were purely due to lack
of knowledge in various technical aspects. The lack of in depth knowledge in various
concepts of .NET, database concepts, etc. was the problems faced.
Moreover the lack of practical know-how of these aspects did cause a few hindrances in early
stages of training but later with the help and guidance of team members it became easier to cope
up with these concepts and applications.
71
8 REFERENCES
Web Sites
www.msdn.microsoft.com
-Microsoft official website
http://sourceforge.net/
- Largest repository of open source code and applications available on the internet
http://www.gnu.org
- Web site of the Free Software Foundation (FSF) which supports the open source
community
http://www.thefreecountry.com
- Large collection of good programming resources
http://www.1001tutorials.com/
- Large collection of good tutorials for reference
http://www.codeguru.com/
- Good articles on programming.
72
Books
73