public tbArea GetId(int pIdData, int pIdAction)
{
tbArea registro = new tbArea();
try
{
using (dbWebEventoEntities dbContext = new dbWebEventoEntities())
{
registro = (from x in dbContext.tbArea
where x.tbArea_Id == pIdData
select x).FirstOrDefault();
registro.idAction = pIdAction;
}
}
catch (Exception ex)
{
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "GetId",
ExceptionMsg = ex.Message,
ResultAction = false,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
return(registro);
}
public ActionResult Area(tbArea Area)
{
switch (Area.idAction)
{
case 1:
Area.tbArea_Ativo = Area.Ativo == "Sim" ? true : false;
resultado = new AreaFacade().Insert(Area);
ViewBag.Msgtype = resultado.ResultAction == true ? 1 : 0;
break;
case 2:
Area.tbArea_Ativo = Area.Ativo == "Sim" ? true : false;
resultado = new AreaFacade().Update(Area);
ViewBag.Msgtype = resultado.ResultAction == true ? 2 : 0;
break;
case 3:
Area.tbArea_Ativo = Area.Ativo == "Sim" ? true : false;
resultado = new AreaFacade().Delete(Area);
ViewBag.Msgtype = resultado.ResultAction == true ? 3 : 0;
break;
}
ViewBag.ListaAtivo = new SelectList(new tbArea().ListaAtivo(), "Id", "Value", area.tbArea_Ativo == true ? "Sim" : "Não");
return(View(Area));
}
public ActionResult DeleteConfirmed(int id)
{
tbArea tbArea = db.tbArea.Find(id);
db.tbArea.Remove(tbArea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Area/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbArea tbArea = db.tbArea.Find(id);
if (tbArea == null)
{
return(HttpNotFound());
}
return(View(tbArea));
}
public ActionResult Area(int idData, int idAction)
{
if (idData > 0)
{
area = new AreaFacade().GetId(idData, idAction);
}
else
{
area.idAction = 1;
}
ViewBag.ListaAtivo = new SelectList(new tbArea().ListaAtivo(), "Id", "Value", area.tbArea_Ativo == true ? "Sim" : "Não");
return(View(area));
}
public ActionResult Edit([Bind(Include = "are_Id,are_Descripcion,are_UsuarioCrea,are_FechaCrea,are_UsuarioModifica,are_FechaModifica")] tbArea tbArea)
{
string UserName = "";
try
{
int EmployeeID = Function.GetUser(out UserName);
if (ModelState.IsValid)
{
if (db.tbArea.Any(a => a.are_Descripcion == tbArea.are_Descripcion && a.are_Id != tbArea.are_Id))
{
string Error = "Ya existe un Área con el mismo nombre.";
Function.BitacoraErrores("Area", "EditPost", UserName, Error);
ModelState.AddModelError("", Error);
return(View(tbArea));
}
IEnumerable <object> _List = null;
string ErrorMessage = "";
_List = db.UDP_Gral_tbArea_Update(tbArea.are_Id, tbArea.are_Descripcion, EmployeeID, Function.DatetimeNow());
foreach (UDP_Gral_tbArea_Update_Result _Area in _List)
{
ErrorMessage = _Area.MensajeError;
}
if (ErrorMessage.StartsWith("-1"))
{
Function.BitacoraErrores("Area", "EditPost", UserName, ErrorMessage);
ModelState.AddModelError("", "No se pudo insertar el registro, favor contacte al administrador.");
return(View(tbArea));
}
if (ErrorMessage.StartsWith("-2"))
{
ModelState.AddModelError("", "Ya existe un estado con el mismo nombre.");
return(View(tbArea));
}
else
{
return(RedirectToAction("Index"));
}
}
}
catch (Exception Ex)
{
Function.BitacoraErrores("Area", "EditPost", UserName, Ex.Message.ToString());
ModelState.AddModelError("", "No se pudo insertar el registro, favor contacte al administrador.");
return(View(tbArea));
}
return(View(tbArea));
}
public Resultado Update(tbArea pArea)
{
try
{
using (dbWebEventoEntities dbContext = new dbWebEventoEntities())
{
var area = dbContext.tbArea.Where(x => x.tbArea_Id == pArea.tbArea_Id).FirstOrDefault();
if (area != null)
{
area.tbArea_Descricao = string.IsNullOrWhiteSpace(pArea.tbArea_Descricao) ? area.tbArea_Descricao : pArea.tbArea_Descricao;
area.tbArea_Ativo = pArea.tbArea_Ativo;
area.tbArea_UpdateTime = DateTime.Now;
dbContext.SaveChanges();
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Update",
ExceptionMsg = "Atualização efetuada com sucesso",
ResultAction = true,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
}
}
catch (Exception ex)
{
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Update",
ExceptionMsg = ex.Message,
ResultAction = false,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
return(resultado);
}
public Resultado Delete(tbArea pArea)
{
try
{
using (dbWebEventoEntities dbContext = new dbWebEventoEntities())
{
var area = dbContext.tbArea.Where(x => x.tbArea_Id == pArea.tbArea_Id).FirstOrDefault();
if (area != null)
{
dbContext.tbArea.Remove(area);
dbContext.SaveChanges();
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Delete",
ExceptionMsg = "Exclusão efetuada com sucesso",
ResultAction = true,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
}
}
catch (Exception ex)
{
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Delete",
ExceptionMsg = ex.Message,
ResultAction = false,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
return(resultado);
}
public ActionResult Create([Bind(Include = "are_Id,are_Descripcion,are_UsuarioCrea")] tbArea tbArea)
{
string UserName = "";
try
{
int EmployeeID = Function.GetUser(out UserName);
if (ModelState.IsValid)
{
IEnumerable <object> _List = null;
string ErrorMessage = "";
_List = db.UDP_Gral_tbArea_Insert(tbArea.are_Descripcion, EmployeeID, Function.DatetimeNow());
foreach (UDP_Gral_tbArea_Insert_Result Area in _List)
{
ErrorMessage = Area.MensajeError;
}
if (ErrorMessage.StartsWith("-1"))
{
Function.BitacoraErrores("Area", "CreatePost", UserName, ErrorMessage);
ModelState.AddModelError("", "No se pudo insertar el registro, favor contacte al administrador.");
return(View(tbArea));
}
if (ErrorMessage.StartsWith("-2"))
{
ModelState.AddModelError("", "Ya existe un Área con el mismo nombre.");
return(View(tbArea));
}
else
{
TempData["swalfunction"] = "true";
return(RedirectToAction("Index"));
}
}
return(View(tbArea));
}
catch (Exception Ex)
{
Function.BitacoraErrores("Area", "CreatePost", UserName, Ex.Message.ToString());
ModelState.AddModelError("", "No se pudo insertar el registro, favor contacte al administrador.");
return(View(tbArea));
}
}
// GET: Area/Details/5
public ActionResult Details(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbArea tbArea = db.tbArea.Find(id);
if (tbArea == null)
{
return(HttpNotFound());
}
return(View(tbArea));
}
catch (Exception Ex)
{ //throw;
return(RedirectToAction("Error500", "Home"));
}
}
public Resultado Insert(tbArea pArea)
{
try
{
using (dbWebEventoEntities dbContext = new dbWebEventoEntities())
{
pArea.tbArea_UpdateTime = DateTime.Now;
dbContext.tbArea.Add(pArea);
dbContext.SaveChanges();
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Insert",
ExceptionMsg = "Cadastro efetuado com sucesso",
ResultAction = true,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
}
catch (Exception ex)
{
resultado = new Resultado()
{
PageName = "Area",
ClassName = "AreaProcess",
MethodName = "Insert",
ExceptionMsg = ex.Message,
ResultAction = false,
DateAction = DateTime.Now,
IdUserAction = 1
};
}
return(resultado);
}
public Resultado Delete(tbArea pArea)
{
return(new AreaProcess().Delete(pArea));
}
public Resultado Update(tbArea pArea)
{
return(new AreaProcess().Update(pArea));
}
public Resultado Insert(tbArea pArea)
{
return(new AreaProcess().Insert(pArea));
}
