public bool guardarDB(tb_transportista_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_transportista Entity = new tb_transportista
{
IdEmpresa = info.IdEmpresa,
IdTransportista = info.IdTransportista = get_id(info.IdEmpresa),
Cedula = info.Cedula,
Nombre = info.Nombre,
Estado = info.Estado = "A",
Placa = info.Placa
};
Context.tb_transportista.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public tb_transportista_Info get_info(int IdEmpresa, decimal IdTransportista)
{
try
{
tb_transportista_Info info = new tb_transportista_Info();
using (Entities_general Context = new Entities_general())
{
tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == IdEmpresa && q.IdTransportista == IdTransportista);
if (Entity == null)
{
return(null);
}
info = new tb_transportista_Info
{
IdEmpresa = Entity.IdEmpresa,
IdTransportista = Entity.IdTransportista,
Cedula = Entity.Cedula,
Nombre = Entity.Nombre,
Estado = Entity.Estado,
Placa = Entity.Placa
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool anularDB(tb_transportista_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == info.IdEmpresa && q.IdTransportista == info.IdTransportista);
if (Entity == null)
{
return(false);
}
Entity.Estado = info.Estado = "I";
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(tb_transportista_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == info.IdEmpresa && q.IdTransportista == info.IdTransportista);
if (Entity == null)
{
return(false);
}
Entity.Cedula = info.Cedula;
Entity.Nombre = info.Nombre;
Entity.Placa = info.Placa;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public Boolean GuardarDB(tb_transportista_Info Info, ref decimal IdTransportista)
{
try
{
using (EntitiesGeneral oEnti = new EntitiesGeneral())
{
var consulta = from q in oEnti.tb_transportista
where q.IdEmpresa == Info.IdEmpresa && q.IdTransportista == Info.IdTransportista
select q;
if (consulta.ToList().Count == 0)
{
var registo = new tb_transportista();
registo.IdEmpresa = Info.IdEmpresa;
registo.IdTransportista = Info.IdTransportista = IdTransportista = GetIdTransportista(Info.IdEmpresa);
registo.Nombre = Info.Nombre;
registo.Cedula = Info.Cedula;
registo.Estado = Info.Estado;
registo.Placa = Info.Placa;
oEnti.tb_transportista.Add(registo);
oEnti.SaveChanges();
}
}
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());
}
}
