public ActionResult Login(appUser appUser) { using (kalingaPPDOEntities db = new kalingaPPDOEntities()) { try { var UserCredentials = db.appUsers.Single(u => u.username == appUser.username && u.password == appUser.password); var Name = db.EmpMasterProfiles.Single(n => n.empid == UserCredentials.empid); if (UserCredentials != null) { RemainSession.Username = UserCredentials.username; RemainSession.Firstname = Name.FirstName; RemainSession.Lastname = Name.LastName; RemainSession.EmployeeID = UserCredentials.empid.ToString(); RemainSession.Roles = UserCredentials.roles; return(RedirectToAction("Index", "Dashboard")); } else { ModelState.AddModelError("", "Username or Password is wrong"); } } catch { ModelState.AddModelError("", "Username or Password is wrong"); } } return(View()); }