public tblWorkzoneXFuncionario CreateWorzoneXEmployee(tblWorkzoneXFuncionario WorzoneXEmployee)
{
_db.tblWorkzoneXFuncionario.Add(WorzoneXEmployee);
_db.SaveChanges();
return(WorzoneXEmployee);
}
public bool checkIfWorzoneXEmployeeAlreadyExits(tblWorkzoneXFuncionario WorzoneXEmployee)
{
var query = from f in _db.tblWorkzoneXFuncionario
where f.idFuncionario == WorzoneXEmployee.idFuncionario &&
f.idWorkzone == WorzoneXEmployee.idWorkzone
select f;
if (query.Count() == 1)
{
return(true);
}
return(false);
}
public tblWorkzoneXFuncionario UpdateWorzoneXEmployee(tblWorkzoneXFuncionario WorzoneXEmployee)
{
var trainingToUpdate = _db.tblWorkzoneXFuncionario.Find(WorzoneXEmployee.idWorkzoneFuncionario);
trainingToUpdate.idWorkzone = WorzoneXEmployee.idWorkzone;
trainingToUpdate.idFuncionario = WorzoneXEmployee.idFuncionario;
_db.Entry(trainingToUpdate).State = EntityState.Modified;
_db.SaveChanges();
return(trainingToUpdate);
}
public ActionResult Pop(int id, int idwz)
{
tblWorkzoneXFuncionario wzXemployee = _workzoneXemployee.GetWorzoneXEmployeeById(idwz, id);
if (ModelState.IsValid)
{
_workzoneXemployee.DeleteWorzoneXEmployee(wzXemployee.idWorkzoneFuncionario);
}
var workzone = _workzone.GetWorkzoneById(idwz);
return(RedirectToAction("Details", new { id = idwz }));
}
public ActionResult Push(int id, int idwz)
{
tblWorkzoneXFuncionario infoToPush = new tblWorkzoneXFuncionario();
infoToPush.idFuncionario = id;
infoToPush.idWorkzone = idwz;
var exists = _workzoneXemployee.checkIfWorzoneXEmployeeAlreadyExits(infoToPush);
if (ModelState.IsValid && !exists)
{
_workzoneXemployee.CreateWorzoneXEmployee(infoToPush);
}
return(RedirectToAction("Details", new { id = idwz }));
}
