public Boolean GrabarDB(cp_proveedor_codigo_SRI_Info info)
{
try
{
using (EntitiesCuentasxPagar context = new EntitiesCuentasxPagar())
{
EntitiesCuentasxPagar EDB = new EntitiesCuentasxPagar();
var address = new cp_proveedor_codigo_SRI();
address.IdEmpresa = info.IdEmpresa;
address.IdProveedor = info.IdProveedor;
address.IdCodigo_SRI = info.IdCodigo_SRI;
address.observacion = info.observacion == null ? "" : info.observacion.Trim();
context.cp_proveedor_codigo_SRI.Add(address);
context.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.InnerException + " " + ex.Message;
throw new Exception(ex.InnerException.ToString());
}
}
public List <cp_proveedor_codigo_SRI_Info> Get_List_proveedor_codigo_SRI(int IdEmpresa, decimal Iproveedor)
{
try
{
List <cp_proveedor_codigo_SRI_Info> lM = new List <cp_proveedor_codigo_SRI_Info>();
EntitiesCuentasxPagar db = new EntitiesCuentasxPagar();
var select_ = from T in db.cp_proveedor_codigo_SRI
where T.IdEmpresa == IdEmpresa && T.IdProveedor == Iproveedor
select T;
foreach (var item in select_)
{
cp_proveedor_codigo_SRI_Info dat = new cp_proveedor_codigo_SRI_Info();
dat.IdEmpresa = item.IdEmpresa;
dat.IdProveedor = item.IdProveedor;
dat.IdCodigo_SRI = item.IdCodigo_SRI;
// dat.IdCtaCble = item.IdCtaCble;
dat.observacion = item.observacion;
lM.Add(dat);
}
return(lM);
}
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.InnerException + " " + ex.Message;
throw new Exception(ex.InnerException.ToString());
}
}
public Boolean EliminarDB(cp_proveedor_codigo_SRI_Info Info)
{
try
{
using (EntitiesCuentasxPagar context = new EntitiesCuentasxPagar())
{
var contact = context.cp_proveedor_codigo_SRI.FirstOrDefault(min => min.IdEmpresa == Info.IdEmpresa && min.IdProveedor == Info.IdProveedor && min.IdCodigo_SRI == Info.IdCodigo_SRI);
if (contact != null)
{
context.cp_proveedor_codigo_SRI.Remove(contact);
context.SaveChanges();
context.Dispose();
}
}
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());
}
}
public Boolean GrabarDB(cp_proveedor_codigo_SRI_Info info)
{
try
{
cp_proveedor_codigo_SRI_Data data = new cp_proveedor_codigo_SRI_Data();
return data.GrabarDB(info);
}
catch(Exception ex)
{
Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "GrabarDB", ex.Message), ex) { EntityType = typeof(cp_proveedor_codigo_SRI_Bus) };
}
}
public Boolean ModificarDB(cp_proveedor_codigo_SRI_Info info)
{
try
{
using (EntitiesCuentasxPagar context = new EntitiesCuentasxPagar())
{
var select = from A in context.cp_proveedor_codigo_SRI
where A.IdEmpresa == info.IdEmpresa &&
A.IdProveedor == info.IdProveedor &&
A.IdCodigo_SRI == info.IdCodigo_SRI
select A;
if (select.ToList().Count < 1)
{
GrabarDB(info);
}
else
{
var contact = context.cp_proveedor_codigo_SRI.FirstOrDefault(minfo => minfo.IdEmpresa == info.IdEmpresa && minfo.IdProveedor == info.IdProveedor && minfo.IdCodigo_SRI == info.IdCodigo_SRI);
if (contact != null)
{
contact.observacion = info.observacion;
context.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());
}
}
