private bool Delete(ref Det_Tarifa_Servicio item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDTAS_Item", item.DTAS_Item, SqlDbType.Int, 4, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
private Det_Tarifa_Servicio SelectOne(Int32 CTAR_Codigo, String CTAR_Tipo, Int32 DTAS_Item) { try { Det_Tarifa_Servicio item = new Det_Tarifa_Servicio(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDTAS_Item", DTAS_Item, 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 BLDet_Tarifa_Servicio(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Det_Tarifa_Servicio>(); Det_Tarifa_Servicio item = new Det_Tarifa_Servicio(); Loader.EntityType = item.GetType(); }
public Boolean SaveDet_Tarifa_Servicio(ref Det_Tarifa_Servicio Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Det_Tarifa_Servicio.Save(ref Item)); } return(true); } catch (Exception) { throw; } }
private void NuevoDetalleServicioTarifa(String xCtarTipo) { try { TempItemDet_TarifaServicio = new Det_Tarifa_Servicio { AUDI_UsrCrea = Session.UserName, AUDI_FecCrea = Session.Fecha, Instance = InstanceEntity.Added, CTAR_Tipo = xCtarTipo }; } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
private bool Insert(ref Det_Tarifa_Servicio item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDTAS_Item", item.DTAS_Item, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", item.SERV_Codigo, 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("@pnumDTAS_Costo", item.DTAS_Costo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAS_Venta", item.DTAS_Venta, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAS_Profit", item.DTAS_Profit, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pbitDTAS_IGV", item.DTAS_IGV, SqlDbType.Bit, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { Int32 _CTAR_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintCTAR_Codigo"].Value.ToString(), out _CTAR_Codigo)) { item.CTAR_Codigo = _CTAR_Codigo; } item.CTAR_Tipo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCTAR_Tipo"].Value.ToString(); Int32 _DTAS_Item; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintDTAS_Item"].Value.ToString(), out _DTAS_Item)) { item.DTAS_Item = _DTAS_Item; } return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Det_Tarifa_Servicio Item) { try { Boolean m_isCorrect = true; if (Item.Trasanct) { 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); break; } if (m_isCorrect) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction(); } else { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); } } else { 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) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }
private ObservableCollection <Det_Tarifa_Servicio> SelectAll() { try { ObservableCollection <Det_Tarifa_Servicio> items = new ObservableCollection <Det_Tarifa_Servicio>(); Det_Tarifa_Servicio item = new Det_Tarifa_Servicio(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSS_Todos"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Tarifa_Servicio(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private ObservableCollection <Det_Tarifa_Servicio> SelectAllServiciosTarifaByCotizacion(Int32?x_CTAR_CodigoLogistico, Int32?x_CTAR_CodigoAduanero) { try { ObservableCollection <Det_Tarifa_Servicio> items = new ObservableCollection <Det_Tarifa_Servicio>(); Det_Tarifa_Servicio item = new Det_Tarifa_Servicio(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSS_TodosByCotizacion"); if (x_CTAR_CodigoLogistico != null) { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoLogistico", x_CTAR_CodigoLogistico.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoLogistico", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } if (x_CTAR_CodigoAduanero != null) { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoAduanero", x_CTAR_CodigoAduanero.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoAduanero", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Tarifa_Servicio(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private bool Update(ref Det_Tarifa_Servicio item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDTAS_Item", item.DTAS_Item, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", item.SERV_Codigo, 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("@pnumDTAS_Costo", item.DTAS_Costo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAS_Venta", item.DTAS_Venta, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAS_Profit", item.DTAS_Profit, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pbitDTAS_IGV", item.DTAS_IGV, 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 ObservableCollection <Det_Tarifa_Servicio> SelectAllByTarifario(Int32 x_CTAR_Codigo, String x_CTAR_Tipo) { try { ObservableCollection <Det_Tarifa_Servicio> items = new ObservableCollection <Det_Tarifa_Servicio>(); Det_Tarifa_Servicio item = new Det_Tarifa_Servicio(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTASSS_TodosByTarifa"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", x_CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", x_CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Tarifa_Servicio(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Cab_Tarifa 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); if (m_isCorrect) { /* Items Detalle Tarifa */ if (Item.ItemsDet_Tarifa != null && Item.ItemsDet_Tarifa.Count > 0) { foreach (var _item in Item.ItemsDet_Tarifa) { Det_Tarifa _Deta = new Det_Tarifa(); _Deta = _item; _Deta.CTAR_Codigo = Item.CTAR_Codigo; _Deta.CTAR_Tipo = Item.CTAR_Tipo; _Deta.Trasanct = false; m_isCorrect = BLDet_Tarifa.Save(ref _Deta); if (!m_isCorrect) { break; } } } /* Items Servicios */ if (Item.ItemsDet_Tarifa_Servicio != null && Item.ItemsDet_Tarifa_Servicio.Count > 0) { foreach (var _itemServ in Item.ItemsDet_Tarifa_Servicio) { Det_Tarifa_Servicio _Servicio = new Det_Tarifa_Servicio(); _Servicio = _itemServ; _Servicio.CTAR_Codigo = Item.CTAR_Codigo; _Servicio.CTAR_Tipo = Item.CTAR_Tipo; _Servicio.Trasanct = false; m_isCorrect = BLDet_Tarifa_Servicio.Save(ref _Servicio); if (!m_isCorrect) { break; } } } } break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(ref Item); if (m_isCorrect) { /* Items Detalle Tarifa */ if (Item.ItemsDet_Tarifa != null && Item.ItemsDet_Tarifa.Count > 0) { foreach (var _item in Item.ItemsDet_Tarifa) { Det_Tarifa _Deta = new Det_Tarifa(); _Deta = _item; _Deta.CTAR_Codigo = Item.CTAR_Codigo; _Deta.CTAR_Tipo = Item.CTAR_Tipo; _Deta.Trasanct = false; m_isCorrect = BLDet_Tarifa.Save(ref _Deta); if (!m_isCorrect) { break; } } } /* Items Servicios */ if (Item.ItemsDet_Tarifa_Servicio != null && Item.ItemsDet_Tarifa_Servicio.Count > 0) { foreach (var _itemServ in Item.ItemsDet_Tarifa_Servicio) { Det_Tarifa_Servicio _Servicio = new Det_Tarifa_Servicio(); _Servicio = _itemServ; _Servicio.CTAR_Codigo = Item.CTAR_Codigo; _Servicio.CTAR_Tipo = Item.CTAR_Tipo; _Servicio.Trasanct = false; m_isCorrect = BLDet_Tarifa_Servicio.Save(ref _Servicio); if (!m_isCorrect) { break; } } } } break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(ref Item); 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; } }