public async Task <ActionResult <WorkEmployee> > PostWorkEmployee(WorkEmployee workEmployee) { _context.WorkEmployee.Add(workEmployee); await _context.SaveChangesAsync(); return(CreatedAtAction("GetWorkEmployee", new { id = workEmployee.IdEmploye }, workEmployee)); }
public async Task <IActionResult> PutWorkEmployee(uint id, WorkEmployee workEmployee) { if (id != workEmployee.IdEmploye) { return(BadRequest()); } _context.Entry(workEmployee).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WorkEmployeeExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Edit(int id, [Bind("EmployeeId,WorkId,Workload")] WorkEmployee workEmployee) { if (id != workEmployee.EmployeeId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(workEmployee); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WorkEmployeeExists(workEmployee.EmployeeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["EmployeeId"] = new SelectList(_context.Employees, "EmployeeId", "Name", workEmployee.EmployeeId); ViewData["WorkId"] = new SelectList(_context.Works, "WorkId", "Name", workEmployee.WorkId); return(View(workEmployee)); }
public Work save(Work work, int idEmployee) { if (work.Id == 0) { var result = todoListDBContext.Work.Add(work); todoListDBContext.SaveChanges(); WorkEmployee workEmployee = new WorkEmployee(); workEmployee.IdEmployee = idEmployee; workEmployee.IdWork = result.Entity.Id; todoListDBContext.WorkEmployee.Add(workEmployee); todoListDBContext.SaveChanges(); return(result.Entity); } else { var result = todoListDBContext.Work.Find(work.Id); result.IdWorkStatus = work.IdWorkStatus; result.WorkContent = work.WorkContent; result.WorkName = work.WorkName; result.StartDate = work.StartDate; result.EndDate = work.EndDate; todoListDBContext.SaveChanges(); return(todoListDBContext.Work.Find(work.Id)); } }
public Work addEmployee(int idEmployee, int idWork) { WorkEmployee workEmployee = new WorkEmployee(); workEmployee.IdEmployee = idEmployee; workEmployee.IdWork = idWork; todoListDBContext.WorkEmployee.Add(workEmployee); todoListDBContext.SaveChanges(); var result = todoListDBContext.Work.Find(idWork); var workList = todoListDBContext.WorkList.Find(result.IdWorkList); var workListEmployeeExist = from wle in todoListDBContext.WorkListEmployee where wle.IdWorkList == result.IdWorkList && wle.IdEmployee == idEmployee select wle; if (workListEmployeeExist.Count() > 0) { return(result); } WorkListEmployee workListEmployee = new WorkListEmployee(); workListEmployee.IdWorkList = workList.Id; workListEmployee.IdEmployee = idEmployee; todoListDBContext.WorkListEmployee.Add(workListEmployee); todoListDBContext.SaveChanges(); return(result); }
public async Task <IActionResult> Create([Bind("EmployeeId,WorkId,Workload")] WorkEmployee workEmployee) { if (ModelState.IsValid) { _context.Add(workEmployee); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["EmployeeId"] = new SelectList(_context.Employees, "EmployeeId", "Name", workEmployee.EmployeeId); ViewData["WorkId"] = new SelectList(_context.Works, "WorkId", "Name", workEmployee.WorkId); return(View(workEmployee)); }