private Cab_Tarifa SelectOne(String CTAR_Tipo, Int32 CTAR_Codigo)
{
try
{
Cab_Tarifa item = new Cab_Tarifa();
DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CTARSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private bool Delete(Det_Seguimientos item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DSEGSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCSEG_Codigo", item.CSEG_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
public Boolean SaveDiferido(ref Movimiento Item)
{
try
{
DataAccessEnterpriseSQL.DABeginTransaction();
Boolean m_isCorrect = true;
switch (Item.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
m_isCorrect = UpdateEjecutarDiferido(ref Item);
break;
}
#region [ Generar el asiento de Diferido ]
GAsientos genAsientos = new GAsientos(GAsientos.TipoAsiento.AsientoCajaDiferido);
genAsientos.ItemMovimiento = Item;
genAsientos.GenerarAsientoBD(Item.AUDI_UsrMod);
#endregion
if (m_isCorrect)
{
DataAccessEnterpriseSQL.DACommitTransaction();
}
else
{
DataAccessEnterpriseSQL.DARollbackTransaction();
}
return(m_isCorrect);
}
catch (Exception)
{ DataAccessEnterpriseSQL.DARollbackTransaction(); throw; }
}
private ObservableCollection <PreDocsVta> SelectAllPorFiltrosLView(String x_DOCV_Numero, DateTime x_DOCV_FechaEmisionIni, DateTime x_DOCV_FechaEmisionFin, Int32?x_ENTC_Codigo, String x_Estado)
{
try
{
ObservableCollection <PreDocsVta> items = new ObservableCollection <PreDocsVta>();
PreDocsVta item = new PreDocsVta();
DataAccessEnterpriseSQL.DAAsignarProcedure("VEN_PDOCSS_TodosPorFiltros");
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOCV_Numero", x_DOCV_Numero, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOCV_FechaEmisionIni", x_DOCV_FechaEmisionIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOCV_FechaEmisionFin", x_DOCV_FechaEmisionFin, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", x_ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (x_Estado == null)
{
DataAccessEnterpriseSQL.DAAgregarParametro("@Estado", DBNull.Value, SqlDbType.Char, 1, ParameterDirection.Input);
}
else
{
DataAccessEnterpriseSQL.DAAgregarParametro("@Estado", x_Estado, SqlDbType.Char, 1, ParameterDirection.Input);
}
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new PreDocsVta();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{ throw ex; }
}
private Det_Cotizacion_OV_Flete SelectOne(Int32 CCOT_Numero, Int32 DCOT_Item, Int16 CCOT_Tipo)
{
try
{
Det_Cotizacion_OV_Flete item = new Det_Cotizacion_OV_Flete();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Det_Cotizacion_OV_Flete");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDCOT_Item", DCOT_Item, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private EntidadCuentaBancaria SelectOne(Int32 ENTC_Codigo, String TIPO_TabBCO, String TIPO_CodBCO)
{
try
{
EntidadCuentaBancaria item = new EntidadCuentaBancaria();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_ENCBSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabBCO", TIPO_TabBCO, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodBCO", TIPO_CodBCO, SqlDbType.Char, 3, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
private bool Delete(ref EntidadCuentaBancaria Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_ENCBSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", Item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabBCO", Item.TIPO_TabBCO, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodBCO", Item.TIPO_CodBCO, SqlDbType.Char, 3, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private PreDetDocsVta SelectOne(Int16 PDDO_Item, Int32 DOCV_Codigo)
{
try
{
PreDetDocsVta item = new PreDetDocsVta();
DataAccessEnterpriseSQL.DAAsignarProcedure("VEN_PDDOSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinPDDO_Item", PDDO_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOCV_Codigo", DOCV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private Contrato SelectOne(Int16 EMPR_Codigo, Int32 CONT_Codigo)
{
try
{
Contrato item = new Contrato();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Contrato");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.Int, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCONT_Codigo", CONT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
public DataTable SelectAllServiciosDetTarjas(Int32 x_DOCV_Codigo, String x_TIPO_CodMND, Decimal x_TipoCambio)
{
try
{
DataSet _dt = new DataSet();
DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTAJSS_TodosFacturaTarjas");
if (x_DOCV_Codigo > 0)
{
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOCV_Codigo", x_DOCV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
}
else
{
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOCV_Codigo", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input);
}
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMND", x_TIPO_CodMND, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdcmTIPOCambio", x_TipoCambio, SqlDbType.Decimal, 10, 4, ParameterDirection.Input);
_dt = DataAccessEnterpriseSQL.DAExecuteDataSet();
if (_dt != null && _dt.Tables.Count > 0 && _dt.Tables[0].Rows.Count > 0)
{
return(_dt.Tables[0]);
}
return(null);
}
catch (Exception ex)
{ throw ex; }
}
private bool Delete(ref PreDetDocsVta item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("VEN_PDDOSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinPDDO_Item", item.PDDO_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOCV_Codigo", item.DOCV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(true);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private bool Update(ref ResultGestion item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ACTUALIZAR_ResultGestion");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinRESG_Codigo", item.RESG_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinRESG_CodPadre", item.RESG_CodPadre, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchRESG_Desc", item.RESG_Desc, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchRESG_DescC", item.RESG_DescC, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinRESG_PositivoNegativo", item.RESG_PositivoNegativo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pbitRESG_Activo", item.RESG_Activo, SqlDbType.Bit, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private DetNaveViaje SelectOne(Int32 DVIA_Codigo, Int32 NVIA_Codigo)
{
try
{
DetNaveViaje item = new DetNaveViaje();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_DetNaveViaje");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDVIA_Codigo", DVIA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintNVIA_Codigo", NVIA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private bool Update(ref DetNaveViaje item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ACTUALIZAR_DetNaveViaje");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDVIA_Codigo", item.DVIA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintNVIA_Codigo", item.NVIA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_Codigo", item.PUER_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDVIA_FecETA_EXPO_ETDMaster_IMPO", item.DVIA_FecETA_EXPO_ETDMaster_IMPO, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmAUDI_UsrMod", item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private bool UpdateRediferirMovimiento(ref Movimiento Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_MOVISU_UnRegRediferirMovimiento");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintMOVI_Codigo", Item.MOVI_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmMOVI_FecDiferido", Item.MOVI_FecDiferido, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", Item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private bool Update(ref Nave item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ACTUALIZAR_Nave");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinNave_Codigo", item.NAVE_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchNave_Nombre", item.NAVE_Nombre, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabVia", item.CONS_TabVia, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodVia", item.CONS_CodVia, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pNAVE_Matricula", item.NAVE_Matricula, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pNAVE_EntidadEmisora", item.NAVE_EntidadEmisora, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pCONS_TabEntEmi", item.CONS_TabEntEmi, SqlDbType.Char, 3, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private bool UpdateAnular(ref Movimiento Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_MOVISU_UnRegAnular");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintMOVI_Codigo", Item.MOVI_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodEST", Item.CONS_CodEST, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchMOVI_UserAnulacion", Item.MOVI_UserAnulacion, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmMOVI_FecAnulacion", Item.MOVI_FecAnulacion, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchMOVI_GlosaAnulacion", Item.MOVI_GlosaAnulacion, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", Item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@Transferencia", Item.Transferencia, SqlDbType.Bit, 1, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private ObservableCollection <Nave> SelectAll(string x_ENTC_CodTransportista)
{
try
{
ObservableCollection <Nave> items = new ObservableCollection <Nave>();
Nave item = new Nave();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_NAVE_By_Filtros");
if (x_ENTC_CodTransportista == null)
{
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input);
}
else
{
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", x_ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
}
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Nave();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{ throw ex; }
}
private bool Update(ref EntidadCuentaBancaria Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_ENCBSU_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", Item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabBCO", Item.TIPO_TabBCO, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodBCO", Item.TIPO_CodBCO, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrENCB_TipoCuenta", Item.ENCB_TipoCuenta, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchENCB_NroCuentaSol", Item.ENCB_NroCuentaSol, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchENCB_NroCuentaDol", Item.ENCB_NroCuentaDol, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", Item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private Excepciones SelectOne(Int32 EXCE_Interno, Int16 EMPR_Codigo)
{
try
{
Excepciones item = new Excepciones();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_EXCESS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintEXCE_Interno", EXCE_Interno, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
private System.Data.DataTable SelectAllByFilterDT(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
DataSet _ds = new DataSet();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_ENCBSS_TodosByFilters");
}
if (x_filters != null && x_filters.Count > 0)
{
foreach (Infrastructure.Aspect.DataAccess.DataAccessFilterSQL _itemFilter in x_filters)
{
DataAccessEnterpriseSQL.DAAgregarParametro(_itemFilter.FilterName, _itemFilter.FilterValue, _itemFilter.FilterSQLType, _itemFilter.FilterSize);
}
}
_ds = DataAccessEnterpriseSQL.DAExecuteDataSet();
if (_ds != null && _ds.Tables.Count == 1)
{
_ds.Tables[0].TableName = "EntidadCuentaBancaria"; return(_ds.Tables[0]);
}
else
{
return(null);
}
}
catch (Exception)
{ throw; }
}
private CuentasBancarias SelectOne(Int16 EMPR_Codigo, String CUBA_Codigo)
{
try
{
CuentasBancarias item = new CuentasBancarias();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_CUBASS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCUBA_Codigo", CUBA_Codigo, SqlDbType.Char, 3, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
private bool Delete(ref Det_Cotizacion_OV_Flete item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ELIMINAR_Det_Cotizacion_OV_Flete");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDCOT_Item", item.DCOT_Item, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", item.CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private bool Delete(ref CuentasBancarias Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_CUBASD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCUBA_Codigo", Item.CUBA_Codigo, SqlDbType.Char, 3, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private Entidad_Acuerdo SelectOne(Int32 ENTC_Codigo)
{
try
{
Entidad_Acuerdo item = new Entidad_Acuerdo();
DataAccessEnterpriseSQL.DAAsignarProcedure("T_SP_CONSULTAR_Entidad_Acuerdo");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
return(null);
}
//else
//{ throw new Exception("No se encontro el registro."); }
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private bool DeleteChequeBlanco(ref Movimiento Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_MOVISD_UnRegChequeBlanco");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintMOVI_Codigo", Item.MOVI_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private ObservableCollection <Rebate> SelectAll(string x_CONC_TabReb, string x_CONC_CodReb, string x_ENTC_CodTransportista, DateTime x_REBA_FecIni)
{
try
{
ObservableCollection <Rebate> items = new ObservableCollection <Rebate>();
Rebate item = new Rebate();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_RebateAllByFiltros");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_TabReb", x_CONC_TabReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_CodReb", x_CONC_CodReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", x_ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", x_REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Rebate();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{ throw ex; }
}
private Planillas SelectOnePlanillas(Int16 EMPR_Codigo, String PLAN_Tipo, String PLAN_Codigo)
{
try
{
Planillas item = new Planillas();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_PLANSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrPLAN_Tipo", PLAN_Tipo, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchPLAN_Codigo", PLAN_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
LoaderPlanillas = new BusinessEntityLoader <Planillas>();
LoaderPlanillas.EntityType = item.GetType();
LoaderPlanillas.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
private bool Delete(ref Puerto item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ELIMINAR_Puerto");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_Codigo", item.PUER_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private bool Delete(ref Cab_Tarifa item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CTARSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
