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"));
}
