protected void saveRegistrationPermissionButton_Click(object sender, EventArgs e)
{
RegistrationPermissionModel registrationPermissionModel = new RegistrationPermissionModel();
registrationPermissionModel.DeptId = Convert.ToInt32(departmentDropDownList.SelectedValue);
registrationPermissionModel.SessionId = Convert.ToInt32(sessionDropDownList.SelectedValue);
registrationPermissionModel.YearTermId = Convert.ToInt32(yearTermDropDownList.SelectedValue);
if (addStudentBll.IsRegistrationPermissionExist(registrationPermissionModel))
{
failStatusLabel.InnerText = "This registration permission already given";
successStatusLabel.InnerText = "";
}
else
{
if (addStudentBll.SaveRegistrationPermission(registrationPermissionModel) > 0)
{
successStatusLabel.InnerText = "Permission is given to the " + " " + departmentDropDownList.SelectedItem.Text + "," + " " + sessionDropDownList.SelectedItem.Text + "," + " " + yearTermDropDownList.SelectedItem.Text;
failStatusLabel.InnerText = "";
}
else
{
failStatusLabel.InnerText = "Not saved";
successStatusLabel.InnerText = "";
}
}
}
public void GetDeptIdAndSessionId()
{
LoginModel loginModel = new LoginModel();
if (Session["loginInformation"] != null)
{
loginModel = (LoginModel)Session["loginInformation"];
string email = loginModel.Email;
string studentId = loginModel.ID;
StudentModel studentModel = new StudentModel();
studentModel = studentBll.GetStudentInfirmation(studentId);
AddStudentModel addStudentModel = new AddStudentModel();
addStudentModel = studentBll.GetDeptIdAndSessionIdByStudentIdAndEmail(studentId, email);
int maxValueOfYearTerm = adminBll.GetMaxValueOfYearTermIdFromRegPermission(addStudentModel.DeptId,
addStudentModel.SessionId);
if (maxValueOfYearTerm == 0)
{
registerButton.Enabled = false;
headerTextLabel.Text = "Registration not available";
regStatusLabel.Text = "Not registered for first semister";
studentIdLabel.Text = studentId;
departmentNameLabel.Text = studentModel.DepartmentName;
sessionLabel.Text = studentModel.Session;
//yearTermLabel.Text = studentBll.GetYearTermByYearTermId(maxValueOfYearTerm);
yearTermLabel.Text = "1st year;1st term";
}
else
{
RegistrationPermissionModel registrationPermissionModel = new RegistrationPermissionModel();
registrationPermissionModel.studentId = studentId;
registrationPermissionModel.DeptId = addStudentModel.DeptId;
registrationPermissionModel.SessionId = addStudentModel.SessionId;
registrationPermissionModel.YearTermId = maxValueOfYearTerm;
if (adminBll.IsSemisterRegisteredForStudentId(registrationPermissionModel))
{
registerButton.Enabled = false;
regStatusLabel.Text = "You are registered for the current semister";
studentIdLabel.Text = studentId;
departmentNameLabel.Text = studentModel.DepartmentName;
sessionLabel.Text = studentModel.Session;
yearTermLabel.Text = studentBll.GetYearTermByYearTermId(maxValueOfYearTerm);
}
else
{
registerButton.Enabled = true;
}
}
}
}
public int SaveRegistrationPermission(RegistrationPermissionModel registrationPermissionModel)
{
return addStudentDal.SaveRegistrationPermission(registrationPermissionModel);
}
public bool IsRegistrationPermissionExist(RegistrationPermissionModel registrationPermissionModel)
{
return addStudentDal.IsRegistrationPermissionExist(registrationPermissionModel);
}
public int SaveRegistrationPermission(RegistrationPermissionModel registrationPermissionModel)
{
string query = String.Format("insert into tblRegistrationPermission values(@deptId, @sessionId, @yearTermId)");
int rowsInserted = 0;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.Clear();
command.Parameters.AddWithValue("@deptId", registrationPermissionModel.DeptId);
command.Parameters.AddWithValue("@sessionId", registrationPermissionModel.SessionId);
command.Parameters.AddWithValue("@yearTermId", registrationPermissionModel.YearTermId);
connection.Open();
rowsInserted = command.ExecuteNonQuery();
connection.Close();
}
}
return rowsInserted;
}
public bool IsRegistrationPermissionExist(RegistrationPermissionModel registrationPermissionModel)
{
string query = String.Format("Select * from tblRegistrationPermission where deptId=@deptId and sessionId=@sessionId and yearTermId=@yearTermId");
bool isRegistrationPermissionExist = false;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
using (SqlCommand command = new SqlCommand(query,connection))
{
command.Parameters.Clear();
command.Parameters.AddWithValue("@deptId",registrationPermissionModel.DeptId);
command.Parameters.AddWithValue("@sessionId", registrationPermissionModel.SessionId);
command.Parameters.AddWithValue("@yearTermId", registrationPermissionModel.YearTermId);
connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
isRegistrationPermissionExist = true;
}
connection.Close();
}
}
return isRegistrationPermissionExist;
}
public int SaveSemisterRegistrationForStudent(RegistrationPermissionModel registrationPermissionModel)
{
return studentDal.SaveSemisterRegistrationForStudent(registrationPermissionModel);
}
public bool IsSemisterRegisteredForStudentId(RegistrationPermissionModel registrationPermissionModel)
{
return studentDal.IsSemisterRegisteredForStudentId(registrationPermissionModel);
}
public void GetDeptIdAndSessionId()
{
LoginModel loginModel = new LoginModel();
if (Session["loginInformation"] != null)
{
loginModel = (LoginModel)Session["loginInformation"];
string email = loginModel.Email;
string studentId = loginModel.ID;
StudentModel studentModel = new StudentModel();
studentModel = studentBll.GetStudentInfirmation(studentId);
AddStudentModel addStudentModel = new AddStudentModel();
addStudentModel = studentBll.GetDeptIdAndSessionIdByStudentIdAndEmail(studentId, email);
int maxValueOfYearTerm = adminBll.GetMaxValueOfYearTermIdFromRegPermission(addStudentModel.DeptId,
addStudentModel.SessionId);
if (maxValueOfYearTerm == 0)
{
registerButton.Enabled = false;
headerTextLabel.Text = "Registration not available now.";
headerTextLabel.CssClass = "text-danger";
headerTextLabel.CssClass = "glyphicon glyphicon-hand-right";
regStatusLabel.Text = "Not registered for first semister";
studentIdLabel.Text = studentId;
departmentNameLabel.Text = studentModel.DepartmentName;
sessionLabel.Text = studentModel.Session;
//yearTermLabel.Text = studentBll.GetYearTermByYearTermId(maxValueOfYearTerm);
yearTermLabel.Text = "1st year;1st term";
}
else
{
RegistrationPermissionModel registrationPermissionModel = new RegistrationPermissionModel();
registrationPermissionModel.studentId = studentId;
registrationPermissionModel.DeptId = addStudentModel.DeptId;
registrationPermissionModel.SessionId = addStudentModel.SessionId;
registrationPermissionModel.YearTermId = maxValueOfYearTerm;
if (studentBll.IsSemisterRegisteredForStudentId(registrationPermissionModel))
{
registerButton.Enabled = false;
regStatusLabel.Text = "You are registered for the current semister";
studentIdLabel.Text = studentId;
departmentNameLabel.Text = studentModel.DepartmentName;
sessionLabel.Text = studentModel.Session;
yearTermLabel.Text = studentBll.GetYearTermByYearTermId(maxValueOfYearTerm);
}
else
{
registerButton.Enabled = true;
studentIdLabel.Text = studentId;
departmentNameLabel.Text = studentModel.DepartmentName;
sessionLabel.Text = studentModel.Session;
yearTermLabel.Text = studentBll.GetYearTermByYearTermId(maxValueOfYearTerm);
regStatusLabel.Text = "Not registered yet";
List<CourseModel> courseModels = new List<CourseModel>();
courseModels = studentBll.GetAllCoursesByDeptIdAndYearTermId(addStudentModel.DeptId,
maxValueOfYearTerm);
decimal totalCredit = 0;
int totalSubject = 0;
foreach (CourseModel courseModel in courseModels)
{
totalCredit = courseModel.Credit + totalCredit;
totalSubject++;
}
courseGridView.DataSource = courseModels;
courseGridView.DataBind();
totalCreditTextBox.Text = Convert.ToString(totalCredit);
courseNumberTextBox.Text = Convert.ToString(totalSubject);
}
}
}
}
protected void registerButton_Click(object sender, EventArgs e)
{
if (Session["loginInformation"] != null)
{
LoginModel loginModel = new LoginModel();
loginModel = (LoginModel)Session["loginInformation"];
string studentId = loginModel.ID;
string email = loginModel.Email;
AddStudentModel addStudentModel = new AddStudentModel();
addStudentModel = studentBll.GetDeptIdAndSessionIdByStudentIdAndEmail(studentId, email);
RegistrationPermissionModel registrationPermissionModel = new RegistrationPermissionModel();
registrationPermissionModel.studentId = studentId;
registrationPermissionModel.DeptId = addStudentModel.DeptId;
registrationPermissionModel.SessionId = addStudentModel.SessionId;
int maxValueOfYearTerm = adminBll.GetMaxValueOfYearTermIdFromRegPermission(addStudentModel.DeptId,
addStudentModel.SessionId);
registrationPermissionModel.YearTermId = maxValueOfYearTerm;
if (studentBll.IsSemisterRegisteredForStudentId(registrationPermissionModel))
{
failStatusLabel.InnerText = "You are already registered";
successStatusLabel.InnerText = "";
}
else
{
if (studentBll.SaveSemisterRegistrationForStudent(registrationPermissionModel) >0)
{
failStatusLabel.InnerText = "";
successStatusLabel.InnerText = "Your registration completed";
regStatusLabel.Text = "You are registered for current semister";
registerButton.Enabled = false;
}
}
}
}
