public static bool AdminRole(string user) { HOTP_Entities db = new HOTP_Entities(); bool adminUser = false; try { adminUser = (from e in db.tblHOTP_Employees where e.Email == user select e.Admin).First(); } catch { } // orderby g.PillarGoalName // select g; return adminUser; }
public static string GetWeight(int employeeID, int goalID) { HOTP_Entities db = new HOTP_Entities(); string currWeight = ""; try { int weight = (from eg in db.tblHOTP_EmployeeGoals where eg.EmployeeID == employeeID && eg.GoalID == goalID select eg.Weight).First(); currWeight = weight.ToString(); } catch {} // orderby g.PillarGoalName // select g; return currWeight.ToString(); }
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return View(model); } // Require the user to have a confirmed email before they can log on. var user = await UserManager.FindByNameAsync(model.Email); if (user != null) { if (!await UserManager.IsEmailConfirmedAsync(user.Id)) { ViewBag.errorMessage = "You must have a confirmed email to log on."; return View("Error"); } } if(await UserManager.CheckPasswordAsync(user, model.Password)) { // Require user to be set up in employee table. HOTP_Entities db = new HOTP_Entities(); tblHOTP_Employees tblHOTP_Employees = db.tblHOTP_Employees.Where(e => e.Email == model.Email).SingleOrDefault(); if (tblHOTP_Employees == null) { ViewBag.errorMessage = "Not a valid user in this system."; return View("Error"); } // Require user to be active if (tblHOTP_Employees.EmpStatus != "Active") { ViewBag.errorMessage = "Inactive employee."; return View("Error"); } } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false); switch (result) { case SignInStatus.Success: { HOTP_Entities db = new HOTP_Entities(); tblHOTP_Employees tblHOTP_Employees = db.tblHOTP_Employees.Where(e => e.Email == model.Email).Single(); //if (tblHOTP_Employees.Admin) user.AdminUser = "******"; //else user.AdminUser = "******"; SetCookie(tblHOTP_Employees); return RedirectToLocal(returnUrl); } case SignInStatus.LockedOut: return View("Lockout"); case SignInStatus.RequiresVerification: return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return View(model); } }