private bool Delete(ref GRR Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception) { throw; } }
public GRR GetOne(String REBA_Tipo, Int32 REBA_Codigo) { try { if (REBA_Tipo == null || REBA_Codigo == null) { return(null); } GRR Item = SelectOne(REBA_Tipo, REBA_Codigo); ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _filters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrREBA_Tipo", FilterValue = Item.REBA_Tipo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1 }); _filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintREBA_Codigo", FilterValue = Item.REBA_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); Item.ListGRR_Paquetes = BL_GRR_Paquetes.GetAllFilter("COM_GPACSS_Todos", _filters); Item.ListGRR_Contratos = BL_GRR_Contrato.GetAllFilter("COM_GCONSS_Todos", _filters); return(Item); } catch (Exception) { throw; } }
private GRR SelectOne(String REBA_Tipo, Int32 REBA_Codigo) { try { GRR item = new GRR(); DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", REBA_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) { throw; } }
public BLGRR(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <GRR>(); GRR Item = new GRR(); Loader.EntityType = Item.GetType(); }
public Boolean SaveGRR(GRR Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_GRR.Save(ref Item)); } return(true); } catch (Exception ex) { throw ex; } }
private bool Insert(ref GRR Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", Item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", Item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecCalc", Item.REBA_FecCalc, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_Valor", Item.REBA_Valor, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteSup", Item.REBA_LimiteSup, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteInf", Item.REBA_LimiteInf, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFlete", Item.REBA_CostoFlete, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFleteDes", Item.REBA_CostoFleteDes, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", Item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMND", Item.TIPO_TabMND, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMND", Item.TIPO_CodMND, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value != DBNull.Value && String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value.ToString())) { Item.REBA_Tipo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value.ToString(); } Int32 _REBA_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintREBA_Codigo"].Value.ToString(), out _REBA_Codigo)) { Item.REBA_Codigo = _REBA_Codigo; } return(true); } else { return(false); } } else { return(true); } } catch (Exception) { throw; } }
private bool Update(ref GRR Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", Item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", Item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecCalc", Item.REBA_FecCalc, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_Valor", Item.REBA_Valor, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteSup", Item.REBA_LimiteSup, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteInf", Item.REBA_LimiteInf, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFlete", Item.REBA_CostoFlete, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFleteDes", Item.REBA_CostoFleteDes, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", Item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMND", Item.TIPO_TabMND, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMND", Item.TIPO_CodMND, SqlDbType.Char, 3, 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 ObservableCollection <GRR> SelectAll() { try { ObservableCollection <GRR> items = new ObservableCollection <GRR>(); GRR item = new GRR(); DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_Todos"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new GRR(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
private ObservableCollection <GRR> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters) { try { ObservableCollection <GRR> items = new ObservableCollection <GRR>(); GRR item = new GRR(); if (!String.IsNullOrEmpty(x_procedure)) { DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure); } else { DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_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); } } using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new GRR(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
public Boolean Save(ref GRR Item) { try { Boolean m_isCorrect = true; Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DABeginTransaction(); switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(ref Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(ref Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(ref Item); if (m_isCorrect) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction(); } else { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } if (m_isCorrect) { if (m_isCorrect) { for (int i = 0; i < Item.ListGRR_Paquetes.Count; i++) { GRR_Paquetes _itemGRR_Paquetes = Item.ListGRR_Paquetes[i]; _itemGRR_Paquetes.REBA_Tipo = Item.REBA_Tipo; _itemGRR_Paquetes.REBA_Codigo = Item.REBA_Codigo; m_isCorrect = BL_GRR_Paquetes.Save(ref _itemGRR_Paquetes); if (!m_isCorrect) { break; } } } //if (m_isCorrect) //{ // for (int i = 0; i < Item.ListGRR_PaquetesDeleted.Count; i++) // { // GRR_Paquetes _itemGRR_Paquetes = Item.ListGRR_PaquetesDeleted[i]; // m_isCorrect = BL_GRR_Paquetes.Save(ref _itemGRR_Paquetes); // if (!m_isCorrect) { break; } // } //} if (m_isCorrect) { for (int i = 0; i < Item.ListGRR_Contratos.Count; i++) { GRR_Contrato _itemGRR_Contrato = Item.ListGRR_Contratos[i]; _itemGRR_Contrato.REBA_Tipo = Item.REBA_Tipo; _itemGRR_Contrato.REBA_Codigo = Item.REBA_Codigo; m_isCorrect = BL_GRR_Contrato.Save(ref _itemGRR_Contrato); if (!m_isCorrect) { break; } } } //if (m_isCorrect) //{ // for (int i = 0; i < Item.ListGRR_ContratosDeleted.Count; i++) // { // GRR_Contrato _itemGRR_Contrato = Item.ListGRR_ContratosDeleted[i]; // m_isCorrect = BL_GRR_Contrato.Save(ref _itemGRR_Contrato); // if (!m_isCorrect) { break; } // } //} } if (m_isCorrect) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction(); } else { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } catch (Exception) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }