public UsersController() { try { _dbContext = new AGH_DBContext(); } catch (Exception) { throw new Exception("Problem occured with DB"); } }
public override string[] GetRolesForUser(string userName) { using (AGH_DBContext db = new AGH_DBContext()) { var userRoles = (from U in db.Users join T in db.User_Type on U.User_Type_ID equals T.ID where U.User_First_Name == userName select T.Type).ToArray(); return(userRoles); } }
public ActionResult Login(userLogin objUser) { //var error = ModelState.Values; try { if (ModelState.IsValid) { using (AGH_DBContext db = new AGH_DBContext()) { var obj = db.Users.Where(a => a.User_ID.Equals(objUser.User_ID)).FirstOrDefault(); if (obj.Is_User_Deleted == false) { // Checks if entered password matches the password in DB if (HashPasswordService.CompareHash(objUser.User_Password, obj.User_Password_Salt, obj.User_Password)) { Session["UserID"] = obj.User_ID; Session["UserRoleID"] = obj.User_Type.ID; Session["UserName"] = obj.User_First_Name.ToString() + " " + obj.User_Last_Name.ToString(); return(RedirectToAction("Index")); } ViewBag.LoginErrorMessage = "Please check your login credentials and try again"; return(View("Login")); } ViewBag.LoginErrorMessage = "Your user has been deactivated. GET LOST!"; return(View("Login")); } } return(View(objUser)); } catch (Exception e) { ViewBag.ErrorMessage = e.Message; return(View("Error")); } }
public override bool IsUserInRole(string userName, string roleName) { try { using (AGH_DBContext db = new AGH_DBContext()) { var userRoles = (from U in db.Users join T in db.User_Type on U.User_Type_ID equals T.ID where U.User_First_Name == userName select T.Type).ToArray(); if (userRoles.Contains(roleName)) { return(true); } return(false); } } catch { throw new NotImplementedException(); } }