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