void Application_PostRequestHandlerExecute(object sender, EventArgs e) { if (HttpContext.Current.Session != null && HttpContext.Current.Session["userid"] != null) { int userID = (int)HttpContext.Current.Session["userid"]; var t = new Project1DBEntities(); var user = t.Users.Where(g => g.ID == userID).FirstOrDefault(); if (user != null) { if (user.LastActionDate.HasValue) { if (user.LastActionDate.Value.Date == DateTime.Now.Date) { user.NumOfActions += 1; user.LastActionDate = DateTime.Now; } else { user.NumOfActions = 1; user.LastActionDate = DateTime.Now; } } else { user.LastActionDate = DateTime.Now; user.NumOfActions = 1; } t.SaveChanges(); } } }
void Application_AcquireRequestState(object sender, EventArgs e) { if (Request.Url.AbsolutePath != "/Login/Logout" && HttpContext.Current.Session != null && HttpContext.Current.Session["userid"] != null) { int userID = (int)HttpContext.Current.Session["userid"]; var t = new Project1DBEntities(); var user = t.Users.Where(g => g.ID == userID).FirstOrDefault(); if (user != null) { if (user.LastActionDate.HasValue) { if (user.LastActionDate.Value.Date == DateTime.Now.Date) { if (user.NumOfActions > LIMIT_ACTIONS_PER_DAY) { Response.Redirect("/Login/Logout"); } } } } } //int? userID = (int)Session["userid"]; //if (userID.HasValue) //{ // var t = new Project1DBEntities(); // // var currentUser = //} }
public ActionResult AddShiftToEmployee(EmployeeShift empShift) { var t = new Project1DBEntities(); t.EmployeeShifts.Add(empShift); t.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Add(Shift shift) { var t = new Project1DBEntities(); t.Shifts.Add(shift); t.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddShiftToEmployee(int empID) { var t = new Project1DBEntities(); var model = new EmployeeShift(); model.EmployeeID = empID; var shifts = t.Shifts.ToList(); var employeeShifts = t.EmployeeShifts.Where(g => g.EmployeeID == empID).ToList(); var shiftsToAdd = shifts.Where(g => !employeeShifts.Any(p => p.ShiftID == g.ID)).ToList(); ViewData.Add("ShiftsList", shiftsToAdd); ViewData.Add("EmpID", empID); return(View(model)); }
// GET: Shift public ActionResult Index() { var t = new Project1DBEntities(); var model = t.Shifts.ToList(); var employeesListToShift = t.EmployeeShifts.ToList(); // get list of employees and shifts together var EmployeesToShiftDic = new Dictionary <int, List <Employee1> >(); foreach (var shift in model) { var employees = employeesListToShift.Where(g => g.ShiftID == shift.ID).Select(g => g.Employee1).ToList(); EmployeesToShiftDic.Add(shift.ID, employees); } ViewBag.EmployeesByShift = EmployeesToShiftDic; return(View(model)); }
public ActionResult Login(User userObj) { if (ModelState.IsValid) { int LIMIT_ACTIONS_PER_DAY = Convert.ToInt32(ConfigurationManager.AppSettings["limitedActionsPerUser"]); using (Project1DBEntities db = new Project1DBEntities()) { var obj = db.Users.Where(x => x.UserName == userObj.UserName && x.Password == userObj.Password).FirstOrDefault(); if (obj != null) { if (obj.NumOfActions.HasValue && obj.LastActionDate.HasValue && obj.LastActionDate.Value.Date == DateTime.Now.Date && obj.NumOfActions.Value > LIMIT_ACTIONS_PER_DAY) { TempData["message"] = "Used all your actions for today, come back tomorrow!"; return(RedirectToAction("Index")); } else { Session["username"] = obj.UserName; Session["userid"] = obj.ID; } } else { //ViewBag.ErrorMessage = "Wrong Credentials!"; TempData["message"] = "Login Failed!"; return(RedirectToAction("Index")); // return RedirectToAction("Index", "Login"); } } } // return View(userObj) return(RedirectToAction("Index", "Home")); }