private string getFee()
{
DB_Connection.OpenConection();
Query = "select fee from Fee where department_id='" + department_id + "' AND degree_id='" + degree_id + "' ";
value = DB_Connection.ExecuteScalarQueries(Query);
return(value);
}
private string getDepartmentID(string DepartmentName)
{
Query = "select department_id from Department where department_name='" + DepartmentName + "'";
value = DB_Connection.ExecuteScalarQueries(Query);
return(value);
}
private string getDegreeID(string DegreeName)
{
Query = "select degree_id from Degree where degree_name='" + DegreeName + "'";
degree_id = DB_Connection.ExecuteScalarQueries(Query);
return(degree_id);
}
//Functions to Register New Student
private void insertStudent_Function()
{
getAllData();
DB_Connection.OpenConection();
Query = "insert into StudentRegisration.dbo.StudentInformation (student_FName,student_LName,student_Email,student_CNIC,student_PhoneNo,student_Address,student_Department,student_Degree,student_Class,student_InstallmentCount,student_PaidCount,student_RemainingCount,student_Gender)"
+ "values ('" + fname + "','" + lname + "','" + email + "','" + cnic + "','" + phone + "','" + address + "','" + department + "','" + degree + "','" + studentClass + "','" + installments + "','" + 0 + "','" + installments + "','" + gender + "') SELECT SCOPE_IDENTITY()";
student_id = DB_Connection.ExecuteScalarQueries(Query);
department_id = getDepartmentID(comboBox_Department.Text);
degree_id = getDegreeID(comboBox_Degree.Text);
fee = getFee();
installmentCount(Convert.ToInt32(fee));
}