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