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