CET Admission System Project in C#.Net with ASP & SQL

Project Profile

University allots Examination centers (As per Candidate’s preferences of examination centre provided in the Application Form) and Seat numbers to the Candidates and generates admit cards informing the seat number, centre and date and time. University publishes the Information of the Hall Tickets & Examination centers allotted on the admission website. The Candidate can print his/her Admit Card by visiting admission website.

University publishes the CET result on admission web site on the stipulated date.

University generates merit list with Combined Score (Academic score + CET score) for admission quota and publishes it on the admission website as well as provides facility to the Candidate to print his/her Scorecard.

As per the data of number of seats available in the college the combined merit (Academic score + CET score) of the candidate, and the preferences given by the candidates in the Option form University allocates seats to the candidates and publishes the college wise candidates list on the admission website.

The Candidate can print his/her provisional Admission Letter by visiting admission website. System administrator adds different colleges with their Admission seat capacity,

also Exam centers list with its capacity along with its unique Id should be maintained. 

Features of the system :

• Candidate can make enquiry about the CET.
• Candidate can apply online for CET.
• Candidate can give online CET Exam.
• Results will be put on the website.
• After getting results, Candidate can apply online for Admission.

The total Project can be divided into different sub-systems as follows : 

1. Application Stage
2. Pre-CET Stage (Admit Cards)
3. Online Exam(OES)
4. Post-CET Stage (Score Cards)
5. Post-CET Stage (Option Form Filling)
6. Admission Process
7. General set-up system

Ajax Functionality Used In Project:

1. In the Online CET Project, We used Calendar Control with Ajax Functionality in it.
2. When you forgot your password then there is one Forgot password Page in that page Selected Question
3. Brings City name into the City DropDownList, whenever user selects the particular State name from the State DropDownList.

TOOLS:- 

C#.NET:-

C- Sharp is used as Front-End Tool. C- Sharp is a general user Interface Programming Language. Programming in C- Sharp is much simple and understandable compared to other programming languages. Even if some error in software remains uncovered, other S/W Professionals can easily handle errors.

MS-SQL :-

MS-SQL is used as Back-End Tool.

Microsoft Word :-

Word is used for basic purpose of writing Help Files because it offers great new ways to polish the formatting in document. 

PLATFORM:- 

Windows XP :-

Windows XP is more convenient and easier to use. All the tools mentioned above works better under Windows compared to other platform.

VALIDATIONS 

USER FORMS : 

Following forms have been validated, through ASP.NET validation controls in each & every fields. 

• Confirmation Form
• Forgot Password Form
• Change Password Form
• Admission Form
• Hall Ticket Form
• Show Detail Form
• Show Detail1 Form
• Login Form
• Signup Form
• Status Form 

ADMIN FORMS :

DATA DICTIONARY

TBL_CANDIDATE_INFO

This table is used to store candidate personal information, qualification and DD Details.

Primary Key: Candidate_ID

Field_Name	Data_Type	Size	Description
Candidate_ID	nvarchar	10	This will be the Id of the candidate & the primary key of the table.
First_Name	nvarchar	40	First name of the candidate.
Middle_Name	nvarchar	40	Middle name of the candidate.
Last_Name	nvarchar	40	Last name of the candidate.
Address_1	nvarchar	MAX	Address1 of the candidate.
Address_2	nvarchar	MAX	Address2 of the candidate.
Address_3	nvarchar	MAX	Address3 of the candidate.
Gender	Nvarchar	6	Sex of the candidate.
City	nvarchar	30	City of the candidate.
State	nvarchar	10	State of the candidate.
Pincode	numeric	6	Pincode of the city.
Country	nvarchar	20	Country of the candidate.
Nationality	nvarchar	20	Nationality of the candidate.
Birthdate	smalldatetime		Birthdate of the candidate.
Age	int		Age of the candidate.
STD_Code	Int		STD code of the Candidate’s Phone no.
Phone_No	Numeric	10	Phone number of the Candidate
Mobile_No	Numeric	10	Mobile number of the Candidate
Email_ID	nvarchar	50	Email id of the candidate.
SSC_percentage	numeric	4,2	SSC percentage of the candidate.
SSC_year	numeric	4	SSC passing year of the candidate.
SSC_board	nvarchar	50	Education board from where the candidate passed SSC.
HSC_percentage	numeric	4,2	HSC percentage of the candidate.
HSC_year	numeric	4	HSC passing year of the candidate.
HSC_board	nvarchar	50	Education board from where the candidate passed HSC.
Graduation_Degree	nvarchar	10	Graduation Degree of Candidate.
Graduation_percentage	numeric	4,2	Graduation percentage of the candidate.
Graduation_year	numeric	4	Graduation passing year of the candidate.
University	nvarchar	50	University from where the candidate completed Graduation.
Choice_of_center1	nvarchar	30	Examination Centre1 of choice for the candidate.
Choice_of_center2	nvarchar	30	Examination Centre2 of choice for the candidate.
Choice_of_center3	nvarchar	30	Examination Centre3 of choice for the candidate.
DD_no	numeric	10	Demand Draft number issued to the candidate.
MICR_Code	Numeric	10	MICR_Code of the DD issued to the Candidate.
DD_Date	Smalldatetime		Date of the issued DD.
DD_Received	bit		It shows the status, whether DD is received or not.
Amount	Int		Amount of the DD paid by the candidate.
Bank_Code	nvarchar	10	Bank name which draw the DD.
Branch_Code	numeric	10	Branch code of the drawee bank.
Batch_year	numeric	4	Batch year for which the candidate is applying.
HallTicket	Nvarchar	10	Hall Ticket no. of candidate will be stored.
Seatno	Nvarchar	3	Seat no. of the candidate will be stored.
ExamCenter_Id	Nvarchar	10	Exam center Id will be stored.

 

TBL_CENTER_COLLEGE

This table is used to store details of the entire examination center.

Primary Key: College_ID

Foreign Key: Center_ID

Field Name	Data Type	Length	Description
Center_Id	nvarchar	10	This Column is used to store CenterID which works as a Foreign Key.
College_Id	nvarchar	10	This Column is used to store CollegeID which is Unique.
College_Name	nvarchar	30	This Column is used to store Center Name.
Address_1	nvarchar	MAX	This Column is used to store Address.
Address_2	nvarchar	MAX	This Column is used to store Address.
State_Id	nvarchar	10	This Column is used to store State.
Pincode	nvarchar	6	This Column is used to store State’s Pincode No.
Course_Id	nvarchar	10

 

TBL_GRADUATION

This table is used to store all the graduation’s degree name.

Primary Key: Graduation_ID

Field Name	Data Type	Length	Description
Graduation_Id	Nvarchar	10	This Column is used to store GraduationID which is Unique.
Graduation_Name	Nvarchar	50	This Column is used to store Graduation Name.

 

TBL_BANK

 

This table is used to store Bank name for DD Details.

Primary Key: – Bank_ID

 

Field Name	Data Type	Length	Description
Bank_Id	Nvarchar	10	This Column is used to store BankID which is Unique.
Bank_Name	Nvarchar	50	This Column is used to store Bank Name.

 

TBL_COURSE 

This table is used to store courses offered by the colleges.

Primary Key: – Course_ID

Field Name	Data Type	Length	Description
Course_Id	Nvarchar	10	This Column is used to store CourseID which is Unique.
Course_Name	Nvarchar	50	This Column is used to store Course Name.

 

TBL_STATE 

This table is used to store states.

Primary Key: – State_ID

Field_Name	Data_Type	Size	Description
State_Id	Nvarchar	10	It is used to store State Id.
State_Name	Nvarchar	30	It is used to store State Name.

 

TBL_EXAMCITYCENTER 

This table is used to all the examination center of any city.

Primary Key: – ExamCenter_ID

Foreign Key: – ExamCity_Id

Field_Name	Data_Type	Size	Description
ExamCity_Id	Nvarchar	10	It is used to store city Id.
ExamCenter_Id	Nvarchar	10	It is used to store Exam Center Id.
ExamCenter_Name	Nvarchar	30	It is used to store Exam Center Name.
Address	Nvarchar	MAX	It is used to store Exam Address.
Phone_no	Nvarchar	20	It is used to Phone No.
TotalSeat	Int
AllotedSeat	Int

TBL_USERS 

This table is used to store Login related information. Candidate ID will be used as user name.

Foreign Key: – Candidate_ID 

Field_Name	Data_Type	Size	Description
Candidate_ID	Nvarchar	10	This Column is used to store UserID of the user which is Unique.
Password	Nvarchar	30	Password will be stored in the Encrypted Form.
SecQue	Nvarchar	MAX	Security question will be stored.
SecAns	Nvarchar	MAX	Security Answer will be stored.
Type	Nvarchar	20	Type of the user will be stored whether He is administrator or User.

 

TBL_EXAMMASTER 

This table is used to store all the exams which are available in this system.

Primary Key: – Exam_ID 

Field_Name	Data_Type	Size	Description
Exam_ID	Nvarchar	10	This Column is used to store ExamID of the Exam which is Unique.
Exam_Name	Nvarchar	30	This Column is used to store Exam Name.
Totalque	Int		This Column is used to store total no. of question related with the exam.
Timing	Numeric	5,2	This column will be having value of allotted time for the exam.
Total_Marks	Int		It shows the total marks of the examination.
QueSet	Int		Question that will appear in the exam. Question will be selected randomly from the question paper Entity.

  

TBL_USERRESULT

This table is used to store information about the various exams given by the user, status of the exam (whether user has completed it or not) and his marks.

Foreign Key: – Candidate_ID and Exam_ID 

Field_Name	Data_Type	Size	Description
Candidate_ID	Nvarchar	10	This Column is used to store UserID of the user which works as a Foreign Key.
Exam_ID	Nvarchar	10	This Column works as a Foreign Key and used to store the exams given by the user.
Status	Bit		This column shows that whether user has completed the exam or not. If It is set to 1 that means exam is completed by user.
MarksScored	Int		Marks Scored by the user.

 

TBL_CITY

This table is used to all the city of examination center.

Primary Key: – City_ID

Foreign Key: – State_Id

Field_Name	Data_Type	Size	Description
City_Id	Nvarchar	10	It is used to store city Id.
City_Name	Nvarchar	30	It is used to store city Name.
State_Id	Nvarchar	10	It is used to store State Id.

 Following forms have been validated, through ASP.NET validation controls in each & every fields. 

• Login Form
• Admit Center Form
• Candidate DD Form
• Candidate Result Form
• Bank Form
• City Form
• State Form
• College Form
• Course Form
• Exam Center Form
• Graduation Form
• Hall Ticket Form
• Candidate Information 

NOTE : More information about validation you can find in TEST CASES sheet.