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"));
}
public ActionResult getWageHistory(int?id)
{
ViewBag.employeeID = id;
List <WageHistory> list = db.WageHistories.Include(x => x.Employee).Where(x => x.EmployeeID == id).ToList();
WageHistory w = list[0];
return(PartialView("_getWageHistory", w));
}
public ActionResult saveWageHistory(WageHistory wageHistory)
{
if (ModelState.IsValid)
{
try
{
db.Entry(wageHistory).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true }));
}
catch (Exception e) {
ModelState.AddModelError("", e.Message);
}
}
return(PartialView("_getWageHistory", wageHistory));
//return RedirectToAction("Edit", new { Id = wageHistory.EmployeeID, @target="parent"});
}
// GET: /Employee/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employee employee = db.Employees.Find(id);
if (employee == null)
{
return(HttpNotFound());
}
List <WageHistory> wageHistory = db.WageHistories.Where(x => x.EmployeeID == id && x.IsCurrent).ToList();
WageHistory wh = wageHistory[0];
employee.WageRateOT = wh.WageOT;
employee.WageRateRT = wh.WageRT;
return(View(employee));
}
public ActionResult Create([Bind(Include = "EmployeeID,FirstName,LastName,JobTitle,Supervisor,ContractLabor,WageRateRT,WageRateOT,HomePhone,CellPhone,Address,EmailAddress,Notes")] Employee employee)
{
if (ModelState.IsValid)
{
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 = (Int32)employee.WageRateOT;
wageHistory.WageRT = (Int32)employee.WageRateRT;
wageHistory.IsCurrent = true;
wageHistory.DateStart = DateTime.Now.Date;
db.WageHistories.Add(wageHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
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"));
}
