public ActionResult Edit([Bind(Include = "ShiftId,ShiftName,StateId")] tbl_shift tbl_shift) { try { if (ModelState.IsValid) { if (Session["OnlineUser"] != null) { if (Session["UserRole"].Equals("SUPERADMIN")) { ViewBag.OnlineUser = Session["UserName"].ToString(); ViewBag.OnlineUserRole = Session["UserRole"].ToString(); db.Entry(tbl_shift).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("Accessdenied", "Home")); } } else { return(RedirectToAction("Login", "Account")); } } ViewBag.StateId = new SelectList(db.tbl_State, "StateId", "StateName", tbl_shift.StateId); return(View(tbl_shift)); } catch (Exception ex) { ModelState.AddModelError(ex.Message, ex.InnerException.ToString()); return(View()); } }
// GET: shift/Details/5 public ActionResult Details(int?id) { if (Session["OnlineUser"] != null) { if (Session["UserRole"].Equals("SUPERADMIN")) { ViewBag.OnlineUser = Session["UserName"].ToString(); ViewBag.OnlineUserRole = Session["UserRole"].ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_shift tbl_shift = db.tbl_shift.Find(id); if (tbl_shift == null) { return(HttpNotFound()); } ViewBag.fireman = (from i in db.tbl_Employee join ai in db.tbl_ShiftEmployee on i.EmployeeId equals ai.EmployeeId join a in db.tbl_shift on ai.Shiftid equals a.ShiftId where ai.Shiftid == id orderby a.ShiftId select i).ToList(); return(View(tbl_shift)); } else { return(RedirectToAction("Accessdenied", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
// GET: shift/Edit/5 public ActionResult Edit(int?id) { if (Session["OnlineUser"] != null) { if (Session["UserRole"].Equals("SUPERADMIN")) { ViewBag.OnlineUser = Session["UserName"].ToString(); ViewBag.OnlineUserRole = Session["UserRole"].ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_shift tbl_shift = db.tbl_shift.Find(id); if (tbl_shift == null) { return(HttpNotFound()); } ViewBag.StateId = new SelectList(db.tbl_State, "StateId", "StateName", tbl_shift.StateId); return(View(tbl_shift)); } else { return(RedirectToAction("Accessdenied", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult Create([Bind(Include = "ShiftId,ShiftName,StateId")] tbl_shift tbl_shift, List <int> Employee) { try { Random rand = new Random(); int ra = 0; if (ModelState.IsValid) { if (Session["OnlineUser"] != null) { if (Session["UserRole"].Equals("SUPERADMIN")) { ViewBag.OnlineUser = Session["UserName"].ToString(); ViewBag.OnlineUserRole = Session["UserRole"].ToString(); ra = rand.Next(1111, 9999); while (db.tbl_shift.FirstOrDefault(x => x.StateId == ra) != null) { ra = rand.Next(1111, 9999); } tbl_shift.ShiftId = ra; db.tbl_shift.Add(tbl_shift); db.SaveChanges(); foreach (int item in Employee) { tbl_ShiftRegisterEmployee oEmployee = new tbl_ShiftRegisterEmployee(); int re = rand.Next(111111, 999999); while (db.tbl_ShiftRegisterEmployee.FirstOrDefault(f => f.ID == re) != null) { re = rand.Next(111111, 999999); } oEmployee.ShiftRegisterID = re; oEmployee.EmployeeID = item; db.tbl_ShiftRegisterEmployee.Add(oEmployee); db.SaveChanges(); } return(RedirectToAction("Index")); } else { return(RedirectToAction("Accessdenied", "Home")); } } else { return(RedirectToAction("Login", "Account")); } } ViewBag.StateId = new SelectList(db.tbl_State, "StateId", "StateName", tbl_shift.StateId); return(View(tbl_shift)); } catch (Exception ex) { ModelState.AddModelError(ex.Message, ex.InnerException.ToString()); return(View()); } }
public ActionResult DeleteConfirmed(int id) { var em = db.tbl_ShiftEmployee.Where(x => x.Shiftid == id).ToList(); foreach (var item in em) { tbl_ShiftEmployee tbl_ShiftEmployee = db.tbl_ShiftEmployee.Find(item.ShiftEmployeeId); db.tbl_ShiftEmployee.Remove(tbl_ShiftEmployee); db.SaveChanges(); } tbl_shift tbl_shift = db.tbl_shift.Find(id); db.tbl_shift.Remove(tbl_shift); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: shift/Delete/5 public ActionResult Delete(int?id) { try { if (Session["OnlineUser"] != null) { if (Session["UserRole"].Equals("SUPERADMIN")) { ViewBag.OnlineUser = Session["UserName"].ToString(); ViewBag.OnlineUserRole = Session["UserRole"].ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_shift tbl_shift = db.tbl_shift.Find(id); if (tbl_shift == null) { return(HttpNotFound()); } ViewBag.fireman = (from i in db.tbl_Employee join ai in db.tbl_ShiftRegisterEmployee on i.EmployeeId equals ai.EmployeeID join a in db.tbl_shift on ai.ShiftRegisterID equals a.ShiftId where ai.ShiftRegisterID == id orderby a.ShiftId select i).ToList(); return(View(tbl_shift)); } else { return(RedirectToAction("Accessdenied", "Home")); } } else { return(RedirectToAction("Login", "Account")); } } catch (Exception ex) { ModelState.AddModelError(ex.Message, ex.InnerException.ToString()); return(View()); } }
public ActionResult DeleteConfirmed(int id) { try { var em = db.tbl_ShiftRegisterEmployee.Where(x => x.ShiftRegisterID == id).ToList(); foreach (var item in em) { tbl_ShiftRegisterEmployee tbl_ShiftEmployee = db.tbl_ShiftRegisterEmployee.Find(item.EmployeeID); db.tbl_ShiftRegisterEmployee.Remove(tbl_ShiftEmployee); db.SaveChanges(); } tbl_shift tbl_shift = db.tbl_shift.Find(id); db.tbl_shift.Remove(tbl_shift); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError(ex.Message, ex.InnerException.ToString()); return(View()); } }