public Linea_Info GetInfo(int IdCategoria, int IdLinea)
{
try
{
Linea_Info info = new Linea_Info();
using (EntitiesGeneral db = new EntitiesGeneral())
{
Linea Entity = db.Linea.Where(q => q.IdCategoria == IdCategoria && q.IdLinea == IdLinea).FirstOrDefault();
if (Entity == null)
{
return(null);
}
info = new Linea_Info
{
IdLinea = Entity.IdLinea,
IdCategoria = Entity.IdCategoria,
li_Codigo = Entity.li_Codigo,
li_Descripcion = Entity.li_Descripcion,
li_Estado = Entity.li_Estado
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public ActionResult Modificar(Linea_Info model)
{
if (!bus_linea.ModificarDB(model))
{
ViewBag.IdCategoria = model.IdCategoria;
cargar_combos();
return(View(model));
}
return(RedirectToAction("Index", new { IdCategoria = model.IdCategoria }));
}
public ActionResult Nuevo(int IdCategoria = 0)
{
Linea_Info model = new Linea_Info
{
IdCategoria = IdCategoria
};
cargar_combos();
return(View(model));
}
public bool AnularDB(Linea_Info info)
{
try
{
return(odata.AnularDB(info));
}
catch (Exception)
{
throw;
}
}
public bool ModificarDB(Linea_Info info)
{
try
{
return(odata.ModificarDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Anular(int IdCategoria = 0, int IdLinea = 0)
{
Linea_Info model = bus_linea.GetInfo(IdCategoria, IdLinea);
if (model == null)
{
return(RedirectToAction("Index", new { IdCategoria = IdCategoria }));
}
ViewBag.IdCategoria = IdCategoria;
cargar_combos();
return(View(model));
}
public bool AnularDB(Linea_Info info)
{
try
{
using (EntitiesGeneral db = new EntitiesGeneral())
{
Linea Entity = db.Linea.Where(q => q.IdCategoria == info.IdCategoria && q.IdLinea == info.IdLinea).FirstOrDefault();
if (Entity == null)
{
return(false);
}
Entity.li_Estado = false;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool GuardarDB(Linea_Info info)
{
try
{
using (EntitiesGeneral db = new EntitiesGeneral())
{
db.Linea.Add(new Linea
{
IdLinea = info.IdLinea = GetId(),
IdCategoria = info.IdCategoria,
li_Codigo = info.li_Codigo,
li_Descripcion = info.li_Descripcion,
li_Estado = true
});
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
