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