public ActionResult DeleteConfirmed(int id)
{
Dth dth = db.Dths.Find(id);
db.Dths.Remove(dth);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "DthID,EmployeeID,TimeEntered,TimeCleared")] Dth dth)
{
if (ModelState.IsValid)
{
db.Entry(dth).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "FirstName", dth.EmployeeID);
return(View(dth));
}
public ActionResult Create([Bind(Include = "DthID,EmployeeID,TimeEntered,TimeCleared,EmpSent")] Dth dth)
{
if (ModelState.IsValid)
{
db.Dths.Add(dth);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "FirstName", dth.EmployeeID);
return(View(dth));
}
// GET: Dths/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Dth dth = db.Dths.Find(id);
if (dth == null)
{
return(HttpNotFound());
}
return(View(dth));
}
// GET: Dths/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Dth dth = db.Dths.Find(id);
if (dth == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "FirstName", dth.EmployeeID);
return(View(dth));
}
public ActionResult Lunch()
{
var breaks = db.Breaks.ToList();
foreach (var item in breaks)
{
Break mdl = new Break();
mdl.BreakID = item.BreakID;
mdl.Employee = item.Employee;
mdl.TimeEntered = item.TimeEntered;
mdl.TimeCleared = item.TimeCleared;
mdl.PositionID = item.PositionID;
if (db.Breaks != null)
{
db.Breaks.Add(mdl);
}
db.Breaks.Add(mdl);
}
var employee = db.Employees.ToList();
foreach (var item in employee)
{
Employee mdl = new Employee();
mdl.EmployeeID = item.EmployeeID;
mdl.FirstName = item.FirstName;
mdl.LastName = item.LastName;
mdl.NotActive = item.NotActive;
mdl.Schedule = item.Schedule;
mdl.Force = item.Force;
mdl.DisplayName = item.DisplayName;
if (db.Employees != null)
{
db.Employees.Add(mdl);
}
}
var dthmodel = db.Dths.ToList();
foreach (var item in dthmodel)
{
Dth mdl = new Dth();
mdl.DthID = item.DthID;
mdl.Employee = item.Employee;
mdl.TimeCleared = item.TimeCleared;
mdl.TimeEntered = item.TimeEntered;
mdl.PositionID = item.PositionID;
if (db.Dths != null)
{
db.Dths.Add(mdl);
}
}
var scheduleModel = db.Schedules.ToList();
foreach (var item in scheduleModel)
{
Schedule mdl = new Schedule();
mdl.ScheduleID = item.ScheduleID;
mdl.ScheduleTime = item.ScheduleTime;
if (db.Schedules != null)
{
db.Schedules.Add(mdl);
}
}
var lunchModel = db.Lunches.ToList();
foreach (var item in lunchModel)
{
Lunch mdl = new Lunch();
mdl.Employee = item.Employee;
mdl.LunchID = item.LunchID;
mdl.PositionID = item.PositionID;
mdl.LunchTime = item.LunchTime;
mdl.LongerLunch = item.LongerLunch;
mdl.Double = item.Double;
if (db.Lunches != null)
{
db.Lunches.Add(mdl);
}
}
var positionModel = db.Positions.ToList();
foreach (var item in positionModel)
{
Position mdl = new Position();
mdl.PositionID = item.PositionID;
mdl.PositionName = item.PositionName;
if (db.Positions != null)
{
db.Positions.Add(mdl);
}
}
ViewBag.EmployeesNames = db.Employees.Where(x => x.NotActive == false).OrderBy(x => x.DisplayName).ToList();
ViewBag.PositionNames = db.Positions.ToList();
ViewBag.ScheduleTimes = db.Schedules.OrderBy(x => x.ScheduleTime).ToList();
ViewBag.LunchTimes = db.Lunches.ToList();
ViewBag.OverTimes = Helper.Common.getTimesOver();
return(View(db));
}
public ActionResult DeleteDth(int dthID)
{
try
{
var oldDthModel = db.Dths.Where(x => x.DthID == dthID).FirstOrDefault();
oldDthModel.TimeCleared = DateTime.Now;
var breaksList = db.Breaks.ToList();
foreach (var item in breaksList)
{
Break mdl = new Break();
mdl.BreakID = item.BreakID;
mdl.Employee = item.Employee;
mdl.TimeEntered = item.TimeEntered;
mdl.TimeCleared = item.TimeCleared;
mdl.PositionID = item.PositionID;
if (db.Breaks != null)
{
db.Breaks.Add(mdl);
}
db.Breaks.Add(mdl);
}
var employee = db.Employees.ToList();
foreach (var item in employee)
{
Employee mdl = new Employee();
mdl.EmployeeID = item.EmployeeID;
mdl.FirstName = item.FirstName;
mdl.LastName = item.LastName;
mdl.NotActive = item.NotActive;
mdl.Schedule = item.Schedule;
mdl.Force = item.Force;
mdl.DisplayName = item.DisplayName;
if (db.Employees != null)
{
db.Employees.Add(mdl);
}
}
var dthmodel = db.Dths.ToList();
foreach (var item in dthmodel)
{
Dth mdl = new Dth();
mdl.DthID = item.DthID;
mdl.Employee = item.Employee;
mdl.TimeCleared = item.TimeCleared;
mdl.TimeEntered = item.TimeEntered;
mdl.PositionID = item.PositionID;
if (db.Dths != null)
{
db.Dths.Add(mdl);
}
}
var scheduleModel = db.Schedules.ToList();
foreach (var item in scheduleModel)
{
Schedule mdl = new Schedule();
mdl.ScheduleID = item.ScheduleID;
mdl.ScheduleTime = item.ScheduleTime;
if (db.Schedules != null)
{
db.Schedules.Add(mdl);
}
}
var lunchModel = db.Lunches.OrderBy(x => x.LunchTime);
foreach (var item in lunchModel)
{
Lunch mdl = new Lunch();
mdl.Employee = item.Employee;
mdl.LunchID = item.LunchID;
mdl.PositionID = item.PositionID;
mdl.LunchTime = item.LunchTime;
mdl.LongerLunch = item.LongerLunch;
mdl.Double = item.Double;
if (db.Lunches != null)
{
db.Lunches.Add(mdl);
}
}
var positionModel = db.Positions.ToList();
foreach (var item in positionModel)
{
Position mdl = new Position();
mdl.PositionID = item.PositionID;
mdl.PositionName = item.PositionName;
if (db.Positions != null)
{
db.Positions.Add(mdl);
}
}
ViewBag.EmployeesNames = db.Employees.Where(x => x.NotActive == false).OrderBy(x => x.DisplayName).ToList();
ViewBag.PositionNames = db.Positions.ToList();
ViewBag.ScheduleTimes = db.Schedules.OrderBy(x => x.ScheduleTime).ToList();
ViewBag.LunchTimes = db.Lunches.OrderBy(x => x.LunchTime).ToList();
ViewBag.positionOrdered = db.Positions.OrderBy(m => m.PositionName).ToList();
ViewBag.Dths = db.Dths.ToList();
ViewBag.Breaks = db.Breaks.ToList();
ViewBag.Lunches = db.Lunches.ToList();
string partialHtml = Common.RenderRazorViewToString(ControllerContext, "~/Views/Home/_DropDowns.cshtml");
return(Json(new { success = true, html = partialHtml }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false }));
}
}
