public ActionResult HoursWorkedDestroy([DataSourceRequest] DataSourceRequest request, HoursWorkedViewModel hoursWorkedViewModel) { try { if (hoursWorkedViewModel != null) { using (ASJDE context = new ASJDE()) { HoursWorked hoursWorked = (from hw in context.HoursWorkeds where hw.ID == hoursWorkedViewModel.ID select hw).FirstOrDefault(); context.HoursWorkeds.Remove(hoursWorked); context.SaveChanges(); } } } catch (Exception e) { logger.Error("Exception", e); } return(Json(ModelState.ToDataSourceResult())); }
public ActionResult HoursWorked() { var teachers = db.getTeacherList(); var model = new HoursWorkedViewModel { Teachers = teachers }; return(View(model)); }
public ActionResult HoursWorkedList(FormCollection collection) { IEnumerable <Schedule> schedList = TempData["schedList"] as IEnumerable <Schedule>; List <HoursWorkedViewModel> reportList = new List <HoursWorkedViewModel>(); foreach (Schedule sched in schedList) { HoursWorkedViewModel item = new HoursWorkedViewModel(); var classe = db.getClass(sched.Class_Id); var teacher = db.getUserById(sched.Teacher_Id); item.Class_Date = sched.Class_Date; item.U_First_Name = teacher.U_First_Name; item.U_Last_Name = teacher.U_Last_Name; item.Class_Name = classe.Class_Name; item.Class_Length = classe.Class_Length; reportList.Add(item); } return(View(reportList)); }
public ActionResult HoursWorkedUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, HoursWorkedViewModel hoursWorkedViewModel) { try { if (ModelState.IsValid) { using (ASJDE context = new ASJDE()) { var user = Session["user"] as User; HoursWorked hoursWorked = (from hw in context.HoursWorkeds where hw.ID == hoursWorkedViewModel.ID select hw).FirstOrDefault(); hoursWorked.Hours = hoursWorkedViewModel.Hours; hoursWorked.EntityID = hoursWorkedViewModel.EntityID; hoursWorked.EditedByUserName = user.UserName; hoursWorked.EditedByDate = DateTime.Now; hoursWorked.EditedByName = user.LastName + ", " + user.FirstName; context.SaveChanges(); hoursWorkedViewModel.EditedBy = user.LastName + ", " + user.FirstName; } } } catch (DbEntityValidationException) { return(null); } catch (Exception e) { logger.Error("Exception", e); } return(Json(new[] { hoursWorkedViewModel }.ToDataSourceResult(dataSourceRequest, ModelState))); }