public ActionResult Login(login_tab usermodel) { using (DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1()) { if (ModelState.IsValid) { var userdetails = db.login_tab.Where(x => x.userid == usermodel.userid && x.passwrd == usermodel.passwrd).FirstOrDefault(); if (userdetails == null) { Response.Write("<script>alert('Please enter valid credentials')</script>"); return(View("Login")); } else { ObjectParameter o = new ObjectParameter("userrole", 0); db.checkrole(usermodel.userid, usermodel.passwrd, o); if (o.Value.ToString() == "CAE") { db.login(usermodel.userid, usermodel.passwrd); Session["userID"] = userdetails.userid; return(RedirectToAction("startpage", "Executive")); } else { db.login(usermodel.userid, usermodel.passwrd); Session["userID"] = userdetails.userid; return(RedirectToAction("startpage", "Account")); } } } } return(View()); }
public static void addLogin(string login, string pass, string role, bool status, short u_id) { login_tab new_log = new login_tab(); new_log.login = login; new_log.password = hashing.GetMd5Hash(MD5.Create(), pass); new_log.role = role; new_log.status = status; new_log.u_id = u_id; DataClassesDataContext context = new DataClassesDataContext(); new_log.Id = (short)((context.login_tab.OrderByDescending(u => u.Id).FirstOrDefault()).Id + 1); context.login_tab.InsertOnSubmit(new_log); context.SubmitChanges(); }