public bool modificarDB(in_linea_Info info)
{
try
{
using (Entities_inventario Context = new Entities_inventario())
{
in_linea Entity = Context.in_linea.FirstOrDefault(q => q.IdEmpresa == info.IdEmpresa && q.IdCategoria == info.IdCategoria && q.IdLinea == info.IdLinea);
if (Entity == null)
{
return(false);
}
Entity.nom_linea = info.nom_linea;
Entity.cod_linea = info.cod_linea;
Entity.IdUsuarioUltMod = info.IdUsuarioUltMod;
Entity.Fecha_UltMod = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public in_linea_Info get_info(int IdEmpresa, string IdCategoria, int IdLinea)
{
try
{
in_linea_Info info = new in_linea_Info();
using (Entities_inventario Context = new Entities_inventario())
{
in_linea Entity = Context.in_linea.FirstOrDefault(q => q.IdEmpresa == IdEmpresa && q.IdCategoria == IdCategoria && q.IdLinea == IdLinea);
if (Entity == null)
{
return(null);
}
info = new in_linea_Info
{
IdEmpresa = Entity.IdEmpresa,
IdCategoria = Entity.IdCategoria,
IdLinea = Entity.IdLinea,
cod_linea = Entity.cod_linea,
nom_linea = Entity.nom_linea,
Estado = Entity.Estado
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(in_linea_Info info)
{
try
{
using (Entities_inventario Context = new Entities_inventario())
{
in_linea Entity = new in_linea
{
IdEmpresa = info.IdEmpresa,
IdCategoria = info.IdCategoria,
IdLinea = info.IdLinea = get_id(info.IdEmpresa, info.IdCategoria),
cod_linea = info.cod_linea,
nom_linea = info.nom_linea,
Estado = info.Estado = "A",
IdUsuario = info.IdUsuario,
Fecha_Transac = DateTime.Now
};
Context.in_linea.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public Boolean GrabarDB(in_linea_info info, ref int IdLinea, ref string msg)
{
try
{
using (EntitiesInventario context = new EntitiesInventario())
{
var lst = from q in context.in_linea
where q.IdEmpresa == info.IdEmpresa &&
q.IdCategoria == info.IdCategoria &&
q.IdLinea == info.IdLinea
select q;
if (lst.Count() == 0)
{
in_linea objLinea = new in_linea();
objLinea.IdEmpresa = info.IdEmpresa;
objLinea.IdCategoria = info.IdCategoria;
objLinea.IdLinea = IdLinea = (info.IdLinea == null || info.IdLinea == 0) ? GetIdLinea(info.IdEmpresa, info.IdCategoria) : info.IdLinea;
if (info.cod_linea == null || info.cod_linea == "")
{
info.cod_linea = objLinea.IdLinea.ToString();
}
objLinea.cod_linea = info.cod_linea.Trim();
objLinea.nom_linea = info.nom_linea.Trim();
objLinea.Estado = "A";
if (info.Observacion == "" || info.Observacion == null)
{
info.Observacion = "";
}
objLinea.observacion = info.Observacion;
objLinea.IdUsuario = (info.IdUsuario == null) ? "SysAdmin" : info.IdUsuario;
objLinea.Fecha_Transac = DateTime.Now;
objLinea.nom_pc = info.nom_pc;
objLinea.ip = info.ip;
context.in_linea.Add(objLinea);
context.SaveChanges();
}
msg = "Grabación ok..";
}
return(true);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
