public int AddStaffingTable(StaffingTable data)
{
var res = _context.StaffingTable.Add(data);
_context.SaveChanges();
return(res.Entity.Id);
}
public IActionResult StaffAdd(StaffingTable staff)
{
if (ModelState.IsValid)
{
db.Staffs.Add(staff);
db.SaveChanges();
return(Redirect("StaffingTable"));
}
return(View(staff));
}
public IActionResult StaffEdit(StaffingTable sta)
{
if (ModelState.IsValid)
{
//db.Entry(sta).State = EntityState.Modified;
db.Update(sta);
db.SaveChanges();
return(RedirectToAction("StaffingTable"));
}
return(View(sta));
}
public IActionResult StaffDel(int?id)
{
if (id == null)
{
return(RedirectToAction("StaffingTable"));
}
StaffingTable sta = db.Staffs.Find(id);
db.Staffs.Remove(sta);
db.SaveChanges();
return(Redirect("StaffingTable"));
}
public async Task <IActionResult> StaffingEdit(int?id)
{
if (id != null)
{
StaffingTable sta = await db.Staffs.FirstOrDefaultAsync(p => p.Id == id);
if (sta != null)
{
return(View(sta));
}
}
return(NotFound());
}
public IActionResult PutStaffingTable(int id, [FromBody] StaffingTable data)
{
try
{
var res = _repository.UpdateStaffingTable(id, data);
if (!res)
{
return(Conflict(409));
}
return(Ok(res));
}
catch (Exception error)
{
return(BadRequest(error));
}
}
public IActionResult PostStaffingTable(StaffingTable data)
{
try
{
var res = _repository.AddStaffingTable(data);
if (res == -1)
{
return(Conflict(409));
}
return(Ok(res));
}
catch (Exception error)
{
return(BadRequest(error));
}
}
public bool UpdateStaffingTable(int id, StaffingTable data)
{
var res = _context.StaffingTable.FirstOrDefault(x => x.Id == id);
if (res == null)
{
return(false);
}
res.FOTId = data.FOTId;
res.title = data.title;
res.unitId = data.unitId;
res.positionId = data.positionId;
res.countRates = data.countRates;
res.acceptEmployeeId = data.acceptEmployeeId;
res.dateAccept = data.dateAccept;
res.daysVacation = data.daysVacation;
res.employeeId = data.employeeId;
//res.salaryId = data.salaryId;
res.vacationEntitlementId = data.vacationEntitlementId;
_context.SaveChanges();
return(true);
}
