Yogita CMS

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 80

COLLEGE MANAGEMENT SYSTEM

PROJECT

Submitted in partial fulfillment for the award of the degree

Of

M.Sc. Computer Science

Submitted By: Supervised By:


Yogita Ms. Nisha

Kalinga University , Raipur,


PALWAL

MAHARSHI DAYANAND UNIVERSITY, ROHTAK


June 2016
ADVANCED INSTITUTE OF TECHNOLOGY & MANAGEMENT,
PALWAL

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.

Name of Candidate: Yogita


Univ.Roll No. : 9402936
Session MCA 2014-2016
(iii)

ADVANCED INSTITUTE OF TECHNOLOGY & MANAGEMENT,


PALWAL

DECLARATION BY INTERNAL SUPERVISOR

Certified that the project “COLLEGE MANAGEMENT SYSTEM”


Is the bonafide work of “YOGITA” who carried out the work as Major Project
under my supervision from Jan – June 2016 in the partial fulfillment of the
requirements for the award of the Degree of Master of Computer Applications.

SIGNATURE SIGNATURE
Dr. Deepti Sharma Ms. Harsha Batra

HEAD OF THE DEPARTMENT ASSISTANT PROFESSOR


(CSE Department) ( CSE Department)
AITM AITM

(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

CHAPTER TITLE PAGE

NO.

Certificate by Candidate (iii)

Certificate by Internal Guide (iv)

Acknowledgement (v)

Table of contents

1 ORGANIZATION PROFILE 1

1.1 About Organization 2


1.2 Aims & Objectives
2
1.3 Services
2

2 INTRODUCTION TO PROJECT 3

2.1 Project Summary 4


2.2 Purpose
6
2.3 Scope
7
2.4 Advantages and Disadvantages of C#
3 SOFTWARE REQUIREMENT AND ANALYSIS 10

3.1 Feasibility Study 11

3.2 Hardware / Software Requirement 13

3.3 List of Tables Used in the Project 14

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

5.1 Screen Shots 30


5.2 Coding
40

6 TESTING 58

6.1 Testing Objectives 59


6.1.1 Testing Strategy
61
6.1.2 Unit Testing
6.1.3 Integration Testing 62

6.1.4 System Testing 63


6.2 Test Case Design
64
6.3 System Testing
6.3.1 Types of System Testing 66

2
67

7 Summary and Conclusion 68

8 References 69

3
4
1. ORGANIZATION PROFILE

1.1 About STG:


Success Technology Group (STG) is committed to customer satisfaction. In the
past 17 years, we have created a very friendly learning environment with the latest
computer hardware and software technologies. Whether you are new to the computer
industry or are looking to improve your skills, we have the right course for you. Well-
qualified, experienced certified instructors train the participants with easy-to-use step by
step training material in the most optimized period of time. We provide life time free
telephone support to our clients. we deals with many universities such as Maharishi
Dayanand University, Singhania University, The Global Open University , Lovely
Professional University, Guru Jambheshwar University and so on.

1.2 Aim of STG:


A machine can do the work of fifty ordinary me, but no machine can do the work
of one extra ordinary man. Based on this assumption, at STG institute, our mission is to
make the professionals equipped with knowledge and skills.
This institute provides various amenities to its students for the sake of their
overall development. Vision of STG Institute is “be not afraid of growing slowly, be
afraid of standing still”, so do not stand still. Success will surely come to you and remain
with you forever.
Our mission is to achieve excellence through people and this reflects in all our
endeavors. It's the storehouse of skills and knowledge that transforms our students as true
global leaders. Welcome you all with a promise to transform your future.

1.3 Service Overview:


We are providing the training on many courses related to computer as well as.
And also providing some different service given below.
 Project Training.
 IT Training.
 Software development.

5
6
2. INTRODUCTION TO PROJECT

2.1 PROJECT SUMMARY

A College Management System for Institute Management Information System (IMIS) is


a System that manages the records of student regarding admission and examination, fees part.
A College Management System is designed to help colleges for management of UG/PG
student. Extensive information is available at your fingertips through this System. Viewing
student data, managing admission and reshuffling ,managing seats, quota, university, semester,
faculty, category and for examination, block allocation, subject management , scheduling exam,
result and related issues are made simple and easy. There are custom search capabilities to aid in
finding student information and working on student records. This can make the system easier to
navigate and to use maximizing the effectiveness of time and other resources. College
Management System allows the keeping of personnel data in a form that can be easily accessed
and analyzed in a consistent way.
The College Management System module is a component covering many other student
aspects from application to retirement. The system records basic personal information, admission
information, education information regarding student. Leading edge systems provide the ability
to "read" applications and enter relevant data to applicable database fields, notify student and
provide result. Student management functions involve:
 Manage new admission and enrolment
 Manage quota
 Manage university
 Manage category
 Manage Fees Structure
 Roll number generation
 Fees payment
 Student Basic Information
 Manage faculty
 Manage designation

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

The operator role can:


 New admission and enrolment
 Search student
 Block allocation
 Result, etc.

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.

The project aims at the following matters:


 Automation of admission and enrolment as per university, quota, category and available
seats.
 Assistance in decision-making.
 To manage information of student, faculty and courses.
 Consistently update information of all the students.
 Reports- To gather all the related information about any application of the HRMS.

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

The scope of the project includes the following:

 Any college can use this system as it is not client centric.


 All admission and examination related work for the student can be done using this system.
 Deliver Electronic Workplace.
 Application Support & Maintenance after deployment to production
 The Admin Module can be reused for projects as well which have many users with different
rights. Hence it is reusable.

.NET Framework Platform Architecture


C# programs run on the .NET Framework, an integral component of Windows that includes a
virtual execution system called the common language runtime (CLR) and a unified set of class libraries.
The CLR is the commercial implementation by Microsoft of the common language infrastructure (CLI),
an international standard that is the basis for creating execution and development environments in which
languages and libraries work together seamlessly.

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.

2.4 Advantages and Disadvantages of C#:

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

3.1 Feasibility Study:

It is to serve as a decision document. It has three questions to answer.

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.

Working of the Present System:

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.

Disadvantages of Present System:-

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:

1. It is automated computerized web based software system.


2. It uses latest technologies like .NET using C# and SQL Server.
3. It is easy to operate.
4. Attractive User Interface

15
3.3 Hardware/Software Requirement

 Software Requirements :

Operating System Windows 7 Professional/Windows 8

Technology C# .NET

Database SQL Server

 Hardware requirements :

Processor Intel Core i3 Processor

At least CD-ROM or DVD-ROM drive.


Drive

Memory Minimum 2 GB of RAM.

Hard Disk Minimum 500 MB on system drive, 4.0


gigabytes (GB) on installation drive.

16
3.4 List of Tables Used

S. No. Table Name Fields Type Primary Key

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

Module Description (Registration)

4.1.1 Module: New Form

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.

Output: Student ID is generated and student is admitted.

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.

4.1.1.4 Alternate Flow:


(1) If the mandatory fields are not filled then alert is shown.

4.1.2 Module : Search

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 Module : Update

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 Module : Delete

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.

4.1.6 Module: Enquiry to Admission Form

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.

Module Description (Fee)


24
4.1.7 Module: Fee Received

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 Module: Due Fee Received

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:

(1) User clicks on fee menu.


(2) Then click on the ‘Due FeeRec’option.
(3) Fee Rec form will be opened fill the related details.

4.1.9 Module: Due Fee :-

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:

(1) User clicks on fee menu.


(2) Then click on the ‘Due Fee ‘option.
(3) Fee Rec form will be opened fill the related details

4.2 Entity Relationship Diagram

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.

Fig: - ER Diagram for College Management System

4.3 DFD (Data Flow Diagrams)

27
4.3.1 Context Level DFD

Move to registration form


where user enter personal details.
Move to Enquiry
Form where user will Enquire
about Courses and enter the
details in the enquiry form.

Move to Fee Form where user will


submit its fee and check is there any Due
Fee from their Annual Fee.

Fig: - Context Level DFD

4.3.2 Level 1 DFD (Registration / Admission Form)

28
Insert Search

Insert all the personal and


Academic details of the student
Into Database.
Search the Student details by Name,
Father’s Name, Mother’s
Name and Roll No.

Registration /
Database Admission Database
Form

Update the details of the


Student in the Database if needed.
Delete the student record
from the Database.

Update Delete

Fig: - Level 1 DFD (Registration/ Admission Form)

4.3.3 Level 1 DFD (Enquiry Form)

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.

All the details of the student will get


Inserted into Database.
All the details of the
student will get inserted into
Database.

Fig: - Level 1 DFD (Enquiry Form)

4.3.4 Level 1 DFD (Fee Form)

30
Fee
Received
Students will pay their
Monthly fee though this portal and it will get
stored into the Database.

It shows the Students Due fee


which was not paid on the
time.

When students paid their Due fee


Then it will get inserted into Database.

Fig: - Level 1 DFD (Fee form)

31
5.1 Screen Shots

32
5.1.1

Main Form

5.1.2 Registration 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

5.2.1 Main Form


using System;
namespace WindowsFormsApplication1
{
public partial class Main : Form
{
public Main()
{
InitializeComponent();
}

private void newToolStripMenuItem_Click(object sender, EventArgs e)


{
Form1 f1 = new Form1();
f1.MdiParent = this;
f1.Show();
}

private void searchToolStripMenuItem_Click(object sender, EventArgs e)


{
Form3 f2 = new Form3();
f2.MdiParent = this;
f2.Show();
}

private void updateToolStripMenuItem_Click(object sender, EventArgs e)


{
Form3 f3 = new Form3();
f3.MdiParent = this;
f3.Show();
}

private void convertToAdmissionToolStripMenuItem_Click(object sender, EventArgs


e)
{
Form4 f4 = new Form4();
f4.MdiParent = this;
f4.Show();
}

private void dueFeeToolStripMenuItem_Click(object sender, EventArgs e)


{
due_fee df = new due_fee();
df.MdiParent = this;
df.Show();
}

private void dueFeeRcvdToolStripMenuItem_Click(object sender, EventArgs e)


{
due_fee_rcvd dfr = new due_fee_rcvd();
dfr.MdiParent = this;
dfr.Show();

43
}

private void feeRecToolStripMenuItem_Click(object sender, EventArgs e)


{
FeeRec fr = new FeeRec();
fr.MdiParent = this;
fr.Show();

}
}
}

5.2.2 Registration Form

using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection conn;
SqlCommand comm;
int r = 0;
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)


{
conn = new SqlConnection("Data Source=.;Initial Catalog='reg form';User
ID=sa;Password=garima001");
comboBox7.SelectedIndex = 0;

private void button1_Click(object sender, EventArgs e)


{
conn.Open();

comm = new SqlCommand("insert into


rg(RollNo,Session,RegistrationNo,Name,FatherName,MotherName,EmailID,MobileNo,OtherMobileN
o,Category,Gender,DOB,Age,MaritalStatus,SpouseName,PermanentAddress,City,State,Country,Pi
nCode,Course,TotalFee,University) values('"+ textBox10.Text+
"','"+comboBox7.SelectedItem+ "', '" + textBox13.Text + "','" + textBox1.Text + "','" +
textBox2.Text + "','" + textBox3.Text + "','" + textBox5.Text + "'," + textBox6.Text +
"," + textBox7.Text + ",'" + comboBox6.SelectedItem + "','" + comboBox3.SelectedItem +
"','" + dateTimePicker1.Value + "'," + textBox16.Text + ",'" + comboBox5.SelectedItem +
"','" + textBox4.Text + "','" + textBox8.Text + "','" + comboBox1.SelectedItem + "','" +
comboBox2.SelectedItem + "','" + textBox17.Text + "'," + textBox9.Text + ",'" +
comboBox4.SelectedItem + "'," + textBox15.Text + ",'"+ comboBox8.SelectedItem+"')");
comm.Connection = conn;

44
comm.ExecuteNonQuery();

conn.Close();
MessageBox.Show("Record insterted");

string st = dateTimePicker1.Text;
Form2 f1 = new Form2();
f1.Show();

private void button4_Click(object sender, EventArgs e)


{
openFileDialog2.ShowDialog();
pictureBox2.ImageLocation = openFileDialog2.FileName;
}

private void button3_Click(object sender, EventArgs e)


{
openFileDialog1.ShowDialog();
pictureBox1.ImageLocation = openFileDialog1.FileName;

private void textBox10_TextChanged(object sender, EventArgs e)


{

private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)


{

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");
}

private void comboBox5_SelectedIndexChanged_1(object sender, EventArgs e)


{
if (comboBox5.SelectedItem.ToString() == "UnMarried")
textBox4.Enabled = false;
else
textBox4.Enabled = true;
}

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)


{
DateTimePicker dp = new DateTimePicker();

textBox16.Text = this.dateTimePicker1.Value.Year.ToString();
textBox16.Text = Convert.ToString(dp.Value.Year -
dateTimePicker1.Value.Year);
}
}
}

5.2.3 Search And Update


using System;
using System.Data.SqlClient;

namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
int fl=0;
public Form3()
{
InitializeComponent();
}

private void Form3_Load(object sender, EventArgs e)


{
conn = new SqlConnection("Data Source=.;Initial Catalog='reg form';User
ID=sa;Password=garima001");
}

private void button1_Click(object sender, EventArgs e)


{
if (fl == 1)

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");
}
}

private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)


{
if(comboBox5.SelectedItem.ToString()=="Unmarried")
textBox4.Enabled = false;
else
textBox4.Enabled = true;
}

private void button2_Click(object sender, EventArgs e)


{
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();

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");

private void button5_Click(object sender, EventArgs e)


{
if (fl == 1)
conn.Close();
conn.Open();
String st = "update rg set rollno=" + textBox12.Text + ", RegistrationNo=" +
textBox13.Text + ", Name='" + textBox11.Text + "',FatherName='" + textBox3.Text +
"',MotherName='" + textBox10.Text + "',Gender='" + comboBox3.SelectedItem +
"' ,EmailId='" + textBox5.Text + "',MobileNo=" + textBox6.Text + ",OtherMobileNo=" +
textBox7.Text + ",Category='" + comboBox6.SelectedItem + "', DOB='" +
dateTimePicker1.Value + "',MaritalStatus='" + comboBox5.SelectedItem + "',SpouseName='" +
textBox4.Text + "',PermanentAddress='" + textBox8.Text + "',City='" +
comboBox7.SelectedItem + "',state='" + comboBox4.SelectedItem + "',Country='" +
textBox17.Text + "',Pincode=" + textBox9.Text + ",Course='" + comboBox8.SelectedItem +
"',age='" + textBox16.Text + "' where " + comboBox1.SelectedItem + " = '" + textBox1.Text
+ "' and " + comboBox2.SelectedItem + " = '" + textBox2.Text + "'";

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();
}

private void Delete_Load(object sender, EventArgs e)


{
conn = new SqlConnection(" Data Source=.;Initial Catalog='reg form';Persist
Security Info=True;User ID=sa;Password=garima001");
}

private void dataGridView1_CellDoubleClick(object sender,


DataGridViewCellEventArgs e)
{
DialogResult dr;
string regn =
dataGridView1.Rows[e.RowIndex].Cells["RegistrationNo"].Value.ToString();
string na = dataGridView1.Rows[e.RowIndex].Cells["Name"].Value.ToString();
dr = MessageBox.Show("Are you sure u want to delete this student", "confirm",
MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
MessageBox.Show("yes");
if (ConnectionState.Open == conn.State)
conn.Close();
conn.Open();
string st = "delete from rg where RegistrationNo='" + regn + "' and
Name='" + na + "'";
MessageBox.Show(st);
comm.CommandText = st;
comm.Connection = conn;
int i = comm.ExecuteNonQuery();

MessageBox.Show("record deleted successfully " + i);

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");
}
}

private void button1_Click(object sender, EventArgs e)


{
comm = new SqlCommand("select
RegistrationNo,Name,FatherName,MotherName,EmailID,MobileNo,OtherMobileNo,Category,Gender,
DOB,MaritalStatus,SpouseName,PermanentAddress,City,State,Country,PinCode,Course,TotalFee
from rg where " + comboBox1.SelectedItem + " like '%" + textBox1.Text + "%' or " +
comboBox2.SelectedItem + " like '%" + textBox2.Text + "%'");
if (ConnectionState.Open == conn.State)
conn.Close();
conn.Open();
comm.Connection = conn;
comm.ExecuteNonQuery();
ad = new SqlDataAdapter(comm);
dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}

}
}

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;
}

private void enquiry_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();
conn.Open();
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();

}
}
}

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 button1_Click(object sender, EventArgs e)


{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
string st = "insert into FeeRec
(RegistrationNo,Name,FatherName,MotherName,Course,University,Semester,dofr,FeesRec,BalFee
s) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" +
textBox4.Text + "','" + comboBox1.SelectedItem + "','" + comboBox2.SelectedItem + "'," +
comboBox3.SelectedItem + ",'" + dateTimePicker1.Value + "'," + textBox5.Text + "," +
textBox6.Text + ")";
MessageBox.Show(st);
comm.CommandText = st;
comm.Connection = conn;
int i = comm.ExecuteNonQuery();
MessageBox.Show("record inserted successfully " + i);
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";

}
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();

st = "select max(Semester) from feerec where RegistrationNo='" +


textBox1.Text + "'";
comm.CommandText = st;
comm.Connection = conn;
reader = comm.ExecuteReader();
if (reader.Read())
{
if (reader.GetValue(0).ToString() != "")
{
int sem = Convert.ToInt32(reader.GetValue(0));
MessageBox.Show("prvious sem =" + sem);
switch (sem)
{
case 1:
comboBox3.SelectedIndex = sem;
break;
case 2:
comboBox3.SelectedIndex = sem;
break;
case 3:
comboBox3.SelectedIndex = sem;
break;
case 4:
comboBox3.SelectedIndex = sem;
break;

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();

private void textBox5_Leave(object sender, EventArgs e)


{

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();

st = "select sum(FeesRec) from FeeRec where RegistrationNo='" + textBox1.Text


+ "'";
comm.CommandText = st;
comm.Connection = conn;
reader = comm.ExecuteReader();
while (reader.Read())
{
MessageBox.Show(reader.GetValue(0).ToString());

57
if (reader.GetValue(0).ToString() != "")
FeesRec = Convert.ToInt32(reader.GetValue(0).ToString());
textBox6.Text = "" + (totalfees - FeesRec -
Convert.ToInt32(textBox5.Text));
}

}
}
}

5.2.8 DUE FEE


using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class due_fee : Form
{
SqlConnection conn;
SqlCommand comm;
SqlDataAdapter sda;
public due_fee()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string st = "select * from feerec where dofr not between '" +
dateTimePicker1.Value.Date + "' and '" + dateTimePicker2.Value.Date + "' and balfees!=0";
MessageBox.Show(st);
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
DataTable dt = new DataTable();
comm.CommandText = st;
comm.Connection = conn;
comm.ExecuteNonQuery();
sda = new SqlDataAdapter(comm);
sda.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
private void due_fee_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 dateTimePicker1_Leave(object sender, EventArgs e)
{
if (dateTimePicker1.Value.Date > dateTimePicker2.Value.Date)
{

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();
}
}

}
}

5.2.9 DUE FEE RECEIVED


using System;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class due_fee_rcvd : Form
{
SqlCommand comm;
SqlConnection conn;
SqlDataAdapter sda;
public due_fee_rcvd()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string st = "select * from FeeRec where dofr between '" +
dateTimePicker1.Value.Date + "' and '" + dateTimePicker2.Value.Date + "' ";
MessageBox.Show(st);
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
DataTable dt = new DataTable();
comm.CommandText = st;
comm.Connection = conn;
comm.ExecuteNonQuery();
sda = new SqlDataAdapter(comm);
sda.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
private void dateTimePicker1_Leave(object sender, EventArgs e)
{
if (dateTimePicker1.Value.Date > dateTimePicker2.Value.Date)
{
MessageBox.Show("start date can't be greater then end date");
dateTimePicker1.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

6.1 TESTING OBJECTIVES

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.

The Testing Process

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.

6.1.1 TESTING STRATEGY

There are types of testing that we implement. They are as follows:

 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.

6.1.2 Unit Testing

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

 Unit Test Specifications


 Code to be tested

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.

6.1.3 Integration Testing

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.

We have applied top-down strategy to validate high-level components of a system before


design and implementations have been completed. Our development process started with high-
level components and we worked down the component hierarchy.

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.

 Test Case Structure

A formal written test case comprises of three parts -

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 -

 Purpose of the test


 Software requirements and Hardware requirements (if any)
 Specific setup or configuration requirements
 Description on how to perform the test(s)
 Expected results or success criteria for the test

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:

System testing of software or hardware is testing conducted on a complete, integrated


system to evaluate the system's compliance with its specified requirements. System testing falls
within the scope of black-box testing, and as such, should require no knowledge of the inner
design of the code or logic.

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

7.2.1 Self Analysis of Project Viabilities

College Management System is a very efficient system for the management of


student admission and examination. Most of all the task of admission and examination can be
easily done with this system. This can be used by any organization.
Also this system uses the latest technologies like SQL,.NET using C#. So it was
easy enough to develop the project. If any changes in the system are to be made then they can
be done very easily.

7.2.2 Problem Encountered and Possible Solutions

 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

 Asp.net Professional 1.1 (Wrox Publication)


By: Wrox Publication
 Mastering SQL Server 2000
 Software Engineering – A Practitioner’s Approach
By: Roger S. Pressman
 Software Engineering
By: Ian Somerville
 C# Professional (Wrox Publication)
By: Wrox Publication

73

You might also like