public ActionResult LogIn(UserModel model)
{
using (LMSDBEntities db = new LMSDBEntities())
{
Student_tbl std = db.Student_tbl.FirstOrDefault(st => st.Email == model.Email);
Lecturer_tbl lec = db.Lecturer_tbl.FirstOrDefault(st => st.Email == model.Email);
Admin_tbl ad = db.Admin_tbl.FirstOrDefault(st => st.Email == model.Email);
//Confirmation booleans
bool IsValidStudent = false; bool IsValidLecturer = false; bool IsValidAdmin = false;
if (std != null)
{
var pass_std = Convert.ToBase64String(ComputeHMAC_SHA256(Encoding.UTF8.GetBytes(model.Password), std.Salt));
IsValidStudent = db.Student_tbl.Any(user => user.Email.ToLower() == model.Email.ToLower() && user.Password == pass_std);
}
else if (lec != null)
{
var pass_lec = Convert.ToBase64String(ComputeHMAC_SHA256(Encoding.UTF8.GetBytes(model.Password), lec.Salt));
IsValidLecturer = db.Lecturer_tbl.Any(user => user.Email.ToLower() == model.Email.ToLower() && user.Password == pass_lec);
}
else if (ad != null)
{
var pass_ad = Convert.ToBase64String(ComputeHMAC_SHA256(Encoding.UTF8.GetBytes(model.Password), ad.Salt));
IsValidAdmin = db.Admin_tbl.Any(user => user.Email.ToLower() == model.Email.ToLower() && user.Password == pass_ad);
}
//-----------------------------------------------------
if (IsValidStudent)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
//Session["UserID"] = std.ID;
//Go to profile page
return(RedirectToAction("Index", "Home"));
}
if (IsValidLecturer)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
//Session["UserID"] = lec.ID;
//Go to profile page
return(RedirectToAction("Index", "Home"));
}
if (IsValidAdmin)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
//Session["UserID"] = ad.ID;
//Go to profile page
return(RedirectToAction("Index", "Home"));
}
ModelState.AddModelError("", "invalid Username or Password");
return(View("LogIn"));
}
}
public AssesionMappingService()
{
context = new LMSDBEntities();
}
public FineService()
{
context = new LMSDBEntities();
}
public SubjectService()
{
context = new LMSDBEntities();
}
public MemberService()
{
context = new LMSDBEntities();
}
public BookIssueRetService()
{
context = new LMSDBEntities();
}
public BookCategoryService()
{
context = new LMSDBEntities();
}
public AuthorService()
{
context = new LMSDBEntities();
}
public MemberCategoryService()
{
context = new LMSDBEntities();
}
public BookService()
{
context = new LMSDBEntities();
}
