public bool EliminarDB(imp_ordencompra_ext_x_imp_gastosxImport_Info Info, ref string msg)
{
try
{
using (EntitiesImportacion oEnt = new EntitiesImportacion())
{
var a = Get_List_ordencompra_ext_x_imp_gastosxImport_Det(Info);
if (a != null)
{
foreach (var item in a)
{
imp_ordencompra_ext_x_imp_gastosxImport_det contact = oEnt.
imp_ordencompra_ext_x_imp_gastosxImport_det.FirstOrDefault(q => q.IdEmpresa == item.IdEmpresa && q.IdSucursal == item.IdSucusal && q.IdOrdenCompraExt == item.IdOrdenCompraExt && q.IdRegistroGasto == item.IdRegistroGasto);
if (contact != null)
{
oEnt.imp_ordencompra_ext_x_imp_gastosxImport_det.Remove(contact);
}
}
oEnt.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());
}
}
public Boolean GuardarDB(List <imp_ordencompra_ext_x_imp_gastosxImport_Det_Info> LstDetalle)
{
try
{
int c = 1;
foreach (var item in LstDetalle)
{
using (EntitiesImportacion Context = new EntitiesImportacion())
{
var address = new imp_ordencompra_ext_x_imp_gastosxImport_det();
address.IdEmpresa = item.IdEmpresa;
address.IdRegistroGasto = item.IdRegistroGasto;
address.IdSucursal = item.IdSucusal;
address.IdOrdenCompraExt = item.IdOrdenCompraExt;
address.Secuencia = c;
address.IdGastoImp = item.IdGastoImp;
address.Valor = item.Valor;
c++;
Context.imp_ordencompra_ext_x_imp_gastosxImport_det.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.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
