private bool Update(ref CabPerfilAsientos Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Desc", Item.CABP_Desc, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodREG", Item.TIPO_CodREG, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabREG", Item.TIPO_TabREG, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecCABP_ValorRef", Item.CABP_ValorRef, SqlDbType.Decimal, 15, 2, 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 CabPerfilAsientos SelectOne(String CABP_Ano, String CABP_Codigo) { try { CabPerfilAsientos item = new CabPerfilAsientos(); DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", CABP_Codigo, SqlDbType.VarChar, 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; } }
public BLCabPerfilAsientos(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <CabPerfilAsientos>(); CabPerfilAsientos Item = new CabPerfilAsientos(); Loader.EntityType = Item.GetType(); }
public Boolean SaveCabPerfilAsientos(ref CabPerfilAsientos Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_CabPerfilAsientos.Save(ref Item)); } return(true); } catch (Exception) { throw; } }
private bool Insert(ref CabPerfilAsientos Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Desc", Item.CABP_Desc, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodREG", Item.TIPO_CodREG, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabREG", Item.TIPO_TabREG, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecCABP_ValorRef", Item.CABP_ValorRef, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value != DBNull.Value && !String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value.ToString())) { Item.CABP_Ano = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value.ToString(); } if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value != DBNull.Value && !String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value.ToString())) { Item.CABP_Codigo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value.ToString(); } return(true); } else { return(false); } } else { return(true); } } catch (Exception) { throw; } }
private bool Delete(ref CabPerfilAsientos Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (SqlException ex) { if (ex.Number == 547) { throw new Exception (String.Format("# No se puede Eliminar este Registro por tener relaciones activas. #" + ex.Message, ex)); } else { throw; } } catch (Exception) { throw; } }
private ObservableCollection <CabPerfilAsientos> SelectAll() { try { ObservableCollection <CabPerfilAsientos> items = new ObservableCollection <CabPerfilAsientos>(); CabPerfilAsientos item = new CabPerfilAsientos(); DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_Todos"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new CabPerfilAsientos(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
private ObservableCollection <CabPerfilAsientos> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters) { try { ObservableCollection <CabPerfilAsientos> items = new ObservableCollection <CabPerfilAsientos>(); CabPerfilAsientos item = new CabPerfilAsientos(); if (!String.IsNullOrEmpty(x_procedure)) { DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure); } else { DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_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 CabPerfilAsientos(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
public Boolean Save(ref CabPerfilAsientos Item) { try { DataAccessEnterpriseSQL.DABeginTransaction(); Boolean m_isCorrect = true; String x_usuario = ""; switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(ref Item); x_usuario = Item.AUDI_UsrCrea; break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(ref Item); x_usuario = Item.AUDI_UsrMod; break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(ref Item); break; } #region Guardar Detalles if (Item.ListDetPerfilAsientosEliminados != null && Item.ListDetPerfilAsientosEliminados.Count > 0) { foreach (DetPerfilAsientos item in Item.ListDetPerfilAsientosEliminados) { item.Instance = InstanceEntity.Deleted; Entities.DetPerfilAsientos _item = item; m_isCorrect = BL_DetPerfilAsientos.Save(ref _item); if (!m_isCorrect) { throw new Exception(String.Format("No se puede eliminar el item {0}", item.DETP_Item)); } } } if (Item.ListDetPerfilAsientos != null && Item.ListDetPerfilAsientos.Count > 0) { foreach (DetPerfilAsientos item in Item.ListDetPerfilAsientos) { item.CABP_Ano = Item.CABP_Ano; item.CABP_Codigo = Item.CABP_Codigo; switch (item.Instance) { case InstanceEntity.Added: item.AUDI_UsrCrea = x_usuario; break; case InstanceEntity.Modified: item.AUDI_UsrMod = x_usuario; break; } Entities.DetPerfilAsientos _item = item; m_isCorrect = BL_DetPerfilAsientos.Save(ref _item); if (!m_isCorrect) { throw new Exception(String.Format("No se puede grabar el item {0}", item.DETP_Item)); } } } #endregion if (m_isCorrect) { DataAccessEnterpriseSQL.DACommitTransaction(); } else { DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } catch (Exception) { DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }