public ActionResult Edit(tblWorkzone workzone, int id)
{
workzone.IdWorkzone = id;
var exits = _workzone.checkIfWorkzoneAlreadyExits(workzone);
var username = "";
try
{
username = AuthorizationHelper.GetSystem().Usuario.ChaveAmericas;
}
catch
{
username = "";
}
workzone.UsuarioAlteracao = username;
workzone.DataAlteracao = DateTime.Now;
if (ModelState.IsValid)
{
if (!exits)
{
_workzone.UpdateWorkzone(workzone);
return(RedirectToAction("Index"));
}
}
return(View("Edit", workzone));
}
public tblWorkzone CreateWorkzone(tblWorkzone Workzone)
{
_db.tblWorkzone.Add(Workzone);
_db.SaveChanges();
var wz = _db.tblWorkzone
.OrderByDescending(w => w.DataCriacao)
.FirstOrDefault();
return(wz);
}
public bool checkIfWorkzoneAlreadyExits(tblWorkzone workzone)
{
var query = from f in _db.tblWorkzone
where f.Nome == workzone.Nome
orderby f.Nome ascending
select f;
if (query.Count() == 1 && query.FirstOrDefault().IdWorkzone != workzone.IdWorkzone)
{
return(true);
}
return(false);
}
public tblWorkzone UpdateWorkzone(tblWorkzone Workzone)
{
var wzToUpdate = _db.tblWorkzone.Find(Workzone.IdWorkzone);
wzToUpdate.Nome = Workzone.Nome;
wzToUpdate.idBU = Workzone.idBU;
wzToUpdate.idCC = Workzone.idCC;
wzToUpdate.idLinha = Workzone.idLinha;
wzToUpdate.DataAlteracao = Workzone.DataAlteracao;
wzToUpdate.MotivoUltimaAlteracao = Workzone.MotivoUltimaAlteracao;
wzToUpdate.PessoasNecessarias = Workzone.PessoasNecessarias;
wzToUpdate.UsuarioAlteracao = Workzone.UsuarioAlteracao;
wzToUpdate.UsuarioDesativacao = Workzone.UsuarioDesativacao;
wzToUpdate.MotivoUltimaAlteracao = Workzone.MotivoUltimaAlteracao;
_db.Entry(wzToUpdate).State = EntityState.Modified;
_db.SaveChanges();
return(Workzone);
}
public ActionResult Create(tblWorkzone workzone)
{
var username = "";
try
{
username = AuthorizationHelper.GetSystem().Usuario.ChaveAmericas;
}
catch
{
username = "";
}
var exits = _workzone.checkIfWorkzoneAlreadyExits(workzone);
workzone.UsuarioCriacao = username;
workzone.DataCriacao = DateTime.Now;
if (ModelState.IsValid)
{
if (!exits && workzone.PessoasNecessarias.ToString().Length <= 5)
{
workzone.FlagAtivo = true;
var returnedElement = _workzone.CreateWorkzone(workzone);
return(RedirectToAction("Details", new { id = returnedElement.IdWorkzone }));
}
}
if (exits)
{
ModelState.AddModelError("Nome", "Posto de Trabalho já existe");
}
if (workzone.PessoasNecessarias.ToString().Length > 5)
{
ModelState.AddModelError("PessoasNecessarias", "Pessoas Necessárias deve conter no máximo 5 caracteres");
}
return(View("Create"));
}
