public ActionResult Create([Bind(Include="EmployeeID,FirstName,LastName,JobTitle,Supervisor,ContractLabor,WageRateRT,WageRateOT,HomePhone,CellPhone,Address,EmailAddress,Notes")] EmployeeViewModel employeeViewModel)
{
if (ModelState.IsValid)
{
// save data into the employee table based on the information in the EmployeeViewModel
Employee employee = new Employee();
employee.EmployeeID = employeeViewModel.EmployeeID;
employee.FirstName = employeeViewModel.FirstName;
employee.LastName = employeeViewModel.LastName;
employee.JobTitle = employeeViewModel.JobTitle;
employee.Supervisor = employeeViewModel.Supervisor;
employee.ContractLabor = employeeViewModel.ContractLabor;
employee.HomePhone = employeeViewModel.HomePhone;
employee.CellPhone = employeeViewModel.CellPhone;
employee.Address = employeeViewModel.Address;
employee.EmailAddress = employeeViewModel.EmailAddress;
employee.Notes = employeeViewModel.Notes;
db.Employees.Add(employee);
db.SaveChanges();
int employeeCount = db.Employees.ToList().Count();
int EmployeeId = db.Employees.ToList()[employeeCount - 1].EmployeeID;
WageHistory wageHistory = new WageHistory();
wageHistory.EmployeeID = EmployeeId;
wageHistory.WageOT = employeeViewModel.WageRateOT;
wageHistory.WageRT = employeeViewModel.WageRateRT;
wageHistory.IsCurrent = true;
wageHistory.DateStart = DateTime.Now.Date;
db.WageHistories.Add(wageHistory);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(employeeViewModel);
}
public ContentResult UpdateWageHistoryData(WageHistory wageHistory)
{
if (ModelState.IsValid)
{
db.Entry(wageHistory).State = EntityState.Modified;
db.SaveChanges();
}
else
{
string error = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError err in modelState.Errors)
{
error = error + " \n" + err.ErrorMessage;
}
}
return Content("", "application/json");
}
var wageHistories = db.WageHistories;
var wageHistoryData = (from wh in wageHistories
where wh.WageHistoryID == wageHistory.WageHistoryID
select new
{
wh.WageHistoryID,
wh.WageRT,
wh.WageOT,
DateStart = wh.DateStart == null ? null : SqlFunctions.DateName("mm", wh.DateStart) + " " + SqlFunctions.DateName("day", wh.DateStart) + ", " + SqlFunctions.DateName("year", wh.DateStart),
DateEnd = wh.DateEnd == null ? null : SqlFunctions.DateName("mm", wh.DateEnd) + " " + SqlFunctions.DateName("day", wh.DateEnd) + ", " + SqlFunctions.DateName("year", wh.DateEnd),
wh.IsCurrent
}).SingleOrDefault();
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
string output = jsonSerializer.Serialize(wageHistoryData);
return Content(output, "application/json");
}
public ContentResult DeleteWageHistoryData(WageHistory wageHistory)
{
var wageHistoryData = db.WageHistories;
WageHistory removeWageHistory = db.WageHistories.Find(wageHistory.WageHistoryID);
if (ModelState.IsValid)
{
db.WageHistories.Remove(removeWageHistory);
db.SaveChanges();
}
else
{
string error = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError err in modelState.Errors)
{
error = error + " \n" + err.ErrorMessage;
}
}
return Content("", "application/json");
}
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
string output = jsonSerializer.Serialize(removeWageHistory);
return Content(output, "application/json");
}