public bool Insert(ref ServiciosRegimenVia Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SERVI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", Item.SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabRGM", Item.CONS_TabRGM, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodRGM", Item.CONS_CodRGM, SqlDbType.Char, 3, 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("@pvchRGVA_Remarks", Item.RGVA_Remarks, SqlDbType.VarChar, 255, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaIngreso", Item.SERV_CuentaIngreso, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaCosto", Item.SERV_CuentaCosto, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaIngresoSAP", Item.SERV_CuentaIngresoSAP, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaCostoSAP", Item.SERV_CuentaCostoSAP, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); //DataAccessEnterpriseSQL.DAAgregarParametro("@pdttAUDI_FecCrea", Item.AUDI_FecCrea, SqlDbType.DateTime,10, ParameterDirection.Input); //DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", Item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input); //DataAccessEnterpriseSQL.DAAgregarParametro("@pdttAUDI_FecMod", Item.AUDI_FecMod, SqlDbType.DateTime, 10, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { Int32 _SERV_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintSERV_Codigo"].Value.ToString(), out _SERV_Codigo)) { Item.SERV_Codigo = _SERV_Codigo; } return(true); } else { return(false); } } else { return(true); } } catch (SqlException ex) { if (ex.Number == 2627) { throw new Exception (String.Format("# Hay mas de un registro con el mismo Documento y el Tipo de Mov.(I/C) #" + ex.Message, ex)); } else { throw; } } catch (Exception ex) { throw ex; } }
public BLServiciosRegimenVia(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <ServiciosRegimenVia>(); ServiciosRegimenVia Item = new ServiciosRegimenVia(); Loader.EntityType = Item.GetType(); }
public bool Delete(ref ServiciosRegimenVia Item) { try { if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) //&& Item.SEDO_Seleccionar == 0) { DataAccessEnterpriseSQL.DAAsignarProcedure("SERVD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", Item.SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabRGM", Item.CONS_TabRGM, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodRGM", Item.CONS_CodRGM, SqlDbType.Char, 3, 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("@pvchRGVA_Remarks", Item.RGVA_Remarks, SqlDbType.VarChar, 255, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaIngreso", Item.SERV_CuentaIngreso, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaCosto", Item.SERV_CuentaCosto, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaIngresoSAP", Item.SERV_CuentaIngresoSAP, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchSERV_CuentaCostoSAP", Item.SERV_CuentaCostoSAP, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdttAUDI_FecCrea", Item.AUDI_FecCrea, SqlDbType.DateTime, 10, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", Item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdttAUDI_FecMod", Item.AUDI_FecMod, SqlDbType.DateTime, 10, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception) { throw; } }
public Boolean Save(ref ServiciosRegimenVia Item) { try { Boolean m_isCorrect = true; 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); break; } return(m_isCorrect); } catch (Exception) { throw; } }
private ObservableCollection <ServiciosRegimenVia> SelectAll() { try { ObservableCollection <ServiciosRegimenVia> items = new ObservableCollection <ServiciosRegimenVia>(); ServiciosRegimenVia item = new ServiciosRegimenVia(); DataAccessEnterpriseSQL.DAAsignarProcedure("SERVSS_Todos"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new ServiciosRegimenVia(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
private ObservableCollection <ServiciosRegimenVia> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters) { try { ObservableCollection <ServiciosRegimenVia> items = new ObservableCollection <ServiciosRegimenVia>(); ServiciosRegimenVia item = new ServiciosRegimenVia(); if (!String.IsNullOrEmpty(x_procedure)) { DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure); } else { DataAccessEnterpriseSQL.DAAsignarProcedure("SERVSS_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 ServiciosRegimenVia(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }
private ServiciosRegimenVia SelectOne(Int32 SERV_Codigo) { try { ServiciosRegimenVia item = new ServiciosRegimenVia(); DataAccessEnterpriseSQL.DAAsignarProcedure("SERVSS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", SERV_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; } }
private ObservableCollection <ServiciosRegimenVia> SelectAllServiciosRegimenViaByServCodigo(Int32 SERV_Codigo) { try { ObservableCollection <ServiciosRegimenVia> items = new ObservableCollection <ServiciosRegimenVia>(); ServiciosRegimenVia item = new ServiciosRegimenVia(); DataAccessEnterpriseSQL.DAAsignarProcedure("SERVS_ServiciosRegimenViaPorServicio"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new ServiciosRegimenVia(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception) { throw; } }