protected void loginButton_Click(object sender, EventArgs e)
{
LoginModel loginModel = new LoginModel();
loginModel.ID = idTextBox.Text;
loginModel.Email = emailTextBox.Text;
loginModel.Password = passwordTextBox.Text;
if (idTextBox.Text.Length <20 && emailTextBox.Text.Length <30 && passwordTextBox.Text.Length <20)
{
LoginModel loginModelFromDB = adminBll.GetLoginInformation(loginModel.ID, loginModel.Email);
SHA256 sha256 = SHA256.Create();
string passwordToCompare = Convert.ToBase64String(sha256.ComputeHash(System.Text.UnicodeEncoding.Unicode.GetBytes(loginModel.Password + loginModelFromDB.Salt)));
if (passwordToCompare == loginModelFromDB.Hash)
{
Session["loginInformation"] = loginModelFromDB;
Response.Redirect("Home.aspx");
}
else
{
failStatusLabel.InnerText = "Login information is incorrect.";
}
}
else
{
failStatusLabel.InnerText = "Please enter the information in correct format";
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 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);
}
}
}
}
public LoginModel GetLoginInformation(string id1, string email1)
{
LoginModel loginModel = null;
string query = String.Format("Select * from tblLogin where id=@id and email=@email");
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
using (SqlCommand command = new SqlCommand(query,connection))
{
command.Parameters.Clear();
command.Parameters.AddWithValue("@id",id1);
command.Parameters.AddWithValue("@email", email1);
connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
loginModel = new LoginModel();
loginModel.Salt = rdr[0].ToString();
loginModel.Hash = rdr[1].ToString();
loginModel.ID = rdr[2].ToString();
loginModel.Email = rdr[3].ToString();
loginModel.Type = Convert.ToInt32(rdr[4]);
loginModel.Name = rdr[5].ToString();
}
connection.Close();
}
}
return loginModel;
}
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;
}
}
}
}