private bool Delete(ref Det_Tarifa item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSD_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("@psinDTAR_Item", item.DTAR_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
private Det_Tarifa SelectOne(Int32 CTAR_Codigo, String CTAR_Tipo, String DTAR_Item) { try { Det_Tarifa item = new Det_Tarifa(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSS_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("@pchrDTAR_Item", DTAR_Item, SqlDbType.Char, 18, 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(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Det_Tarifa>(); Det_Tarifa item = new Det_Tarifa(); Loader.EntityType = item.GetType(); }
public Boolean SaveDet_Tarifa(ref Det_Tarifa Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Det_Tarifa.Save(ref Item)); } return(true); } catch (Exception) { throw; } }
private bool Update(ref Det_Tarifa item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSU_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("@psinDTAR_Item", item.DTAR_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintPACK_Codigo", item.PACK_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_CostoSada", item.DTAR_CostoSada, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_VentaSada", item.DTAR_VentaSada, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Venta", item.DTAR_Venta, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Peso", item.DTAR_Peso, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Volumen", item.DTAR_Volumen, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Minimo", item.DTAR_Minimo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodBas", item.CONS_CodBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabBas", item.CONS_TabBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabZON", item.TIPO_TabZON, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONDestino", item.TIPO_CodZONDestino, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONOrigen", item.TIPO_CodZONOrigen, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pbitDTAR_Roundtrip", item.DTAR_Roundtrip, SqlDbType.Bit, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Costo", item.DTAR_Costo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Profit", item.DTAR_Profit, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_ProfitMinimo", item.DTAR_ProfitMinimo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodTRA", item.CONS_CodTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabTRA", item.CONS_TabTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinTIPE_Codigo", item.TIPE_Codigo, SqlDbType.SmallInt, 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 ex) { throw ex; } }
public void NuevoDetalleTarifarios() { try { TempItemDET_Tarifa = new Det_Tarifa { CTAR_Tipo = TipoTarifa, AUDI_UsrCrea = Session.UserName, AUDI_FecCrea = Session.Fecha, Instance = InstanceEntity.Added }; } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
public Boolean Save(ref Det_Tarifa 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 // sin transacción { 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> SelectAllTarifasByCotizacion(Int32?x_CTAR_CodigoLogistico, Int32?x_CTAR_CodigoAduanero, Int32?x_CTAR_CodigoTransporte, Boolean x_Filtros) { try { ObservableCollection <Det_Tarifa> items = new ObservableCollection <Det_Tarifa>(); Det_Tarifa item = new Det_Tarifa(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSS_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); } if (x_CTAR_CodigoTransporte != null) { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoTransporte", x_CTAR_CodigoTransporte.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_CodigoTransporte", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } DataAccessEnterpriseSQL.DAAgregarParametro("@pbitFiltros", x_Filtros, SqlDbType.Bit, 1, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Tarifa(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private ObservableCollection <Det_Tarifa> SelectAll() { try { ObservableCollection <Det_Tarifa> items = new ObservableCollection <Det_Tarifa>(); Det_Tarifa item = new Det_Tarifa(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSS_Todos"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Tarifa(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
public void LoadDetalleTarifario(InstanceView xInstance) { try { DView.ClearItem(TipoTarifa); switch (xInstance) { case InstanceView.New: DView.SetInstance(InstanceView.New); ItemDET_Tarifa = new Det_Tarifa(); InstanciaDet_Tarifa = InstanceView.New; break; case InstanceView.Edit: InstanciaDet_Tarifa = InstanceView.Edit; DView.SetInstance(InstanceView.Edit); break; } ((PRO001DTarifa)DView).ShowDialog(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
public void Nuevo() { try { if (!isMViewShow) { MView = new PRO001MView(); MView.Presenter = this; MView.LoadView(); } MView.ClearItem(); ItemCAB_Tarifa = new Cab_Tarifa { AUDI_UsrCrea = Session.UserName, AUDI_FecCrea = Session.Fecha, Instance = InstanceEntity.Added, TIPO_TabMnd = "MND", CONS_TabReg = "RGM", CTAR_Tipo = TipoTarifa }; MView.ClearItemsDetalles(); ItemDET_Tarifa = new Det_Tarifa(); ItemsGrillaDet_Tarifa = new ObservableCollection <Det_Tarifa>(); ItemsDet_Tarifa = new ObservableCollection <Det_Tarifa>(); ItemsDet_TarifaServicio = new ObservableCollection <Det_Tarifa_Servicio>(); MView.ClearItemsDetalleServicios(); MView.SetInstance(InstanceView.New); isMViewShow = true; ((PRO001MView)MView).Show(); ((PRO001MView)MView).BringToFront(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
private ObservableCollection <Det_Tarifa> SelectAllByTarifa(Int32 x_CTAR_Codigo, String x_CTAR_Tipo) { try { ObservableCollection <Det_Tarifa> items = new ObservableCollection <Det_Tarifa>(); Det_Tarifa item = new Det_Tarifa(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSS_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(); 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; } }
public void SetItemST20_ST40(ref ObservableCollection <Det_Tarifa> x_items) { try { if (x_items != null) { decimal tempCosto20 = 0; decimal tempCostoSada20 = 0; decimal tempCosto40 = 0; decimal tempCostoSada40 = 0; Int32 _Fila = 0; for (int i = 0; i < x_items.Count; i++) { Det_Tarifa detTarifa; if (((i % 2) == 0) && i == 0) /* primer registro */ { detTarifa = new Det_Tarifa(); detTarifa = x_items.ElementAt(i); _Fila = 1; } else { detTarifa = x_items.ElementAt(i); detTarifa.DTAR_Costo20 = tempCosto20; detTarifa.DTAR_CostoSada20 = tempCostoSada20; detTarifa.DTAR_Costo40 = tempCosto40; detTarifa.DTAR_CostoSada40 = tempCostoSada40; } if (detTarifa.PACK_Codigo == 1) { tempCosto20 = 0; tempCostoSada20 = 0; detTarifa.DTAR_Costo20 = x_items[i].DTAR_Costo != null ? x_items[i].DTAR_Costo.Value : 0; if (detTarifa.DTAR_CostoSada != null) { detTarifa.DTAR_CostoSada20 = detTarifa.DTAR_CostoSada.Value; } tempCosto20 = detTarifa.DTAR_Costo20; tempCostoSada20 = detTarifa.DTAR_CostoSada20; detTarifa.DTAR_Fila = _Fila; } if (detTarifa.PACK_Codigo == 2) { tempCosto40 = 0; tempCostoSada40 = 0; detTarifa.DTAR_Costo40 = x_items[i].DTAR_Costo != null ? x_items[i].DTAR_Costo.Value : 0; if (detTarifa.DTAR_CostoSada != null) { detTarifa.DTAR_CostoSada40 = detTarifa.DTAR_CostoSada.Value; } tempCosto40 = detTarifa.DTAR_Costo40; tempCostoSada40 = detTarifa.DTAR_CostoSada40; if (detTarifa.TIPE_Codigo != null && detTarifa.TIPE_Codigo.Value.ToString(CultureInfo.InvariantCulture) != "13") /* Maritimo */ { detTarifa.DTAR_Fila = _Fila; Presenter.ItemsGrillaDet_Tarifa.Add(detTarifa); _Fila++; } else { detTarifa.DTAR_Fila = _Fila; } } if (detTarifa.TIPE_Codigo != null && detTarifa.TIPE_Codigo.Value.ToString(CultureInfo.InvariantCulture).Equals("13")) /* Maritimo */ { if (detTarifa.PACK_Codigo == null) { detTarifa.DTAR_CostoHBL = x_items[i].DTAR_Costo != null ? x_items[i].DTAR_Costo.Value : 0; if (detTarifa.DTAR_CostoSada != null) { detTarifa.DTAR_CostoSadaHBL = detTarifa.DTAR_CostoSada.Value; } detTarifa.DTAR_Fila = _Fila; Presenter.ItemsGrillaDet_Tarifa.Add(detTarifa); _Fila++; } } } } } catch (Exception ex) { Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al agregar el nuevo registro.", ex); } }
public void GenerarST20_ST40_HBL() { try { int registros = 0; registros = CbTipoEntidad.SelectedValue.ToString().Equals("13") ? 3 : 2; Det_Tarifa _Item; for (int i = 0; i < registros; i++) { if (Presenter.ItemDET_Tarifa.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { Presenter.TempItemDET_Tarifa = Presenter.ItemDET_Tarifa; } else { Presenter.NuevoDetalleTarifarios(); } if (i == 2) /* HBL no tiene PACK_Codigo */ { Presenter.TempItemDET_Tarifa.PACK_Codigo = null; } else { Presenter.TempItemDET_Tarifa.PACK_Codigo = i == 0 ? 1 : 2; // 1 => 20 , 2 => 40 :) } /* Tipo Entidad */ Presenter.TempItemDET_Tarifa.TIPE_Codigo = short.Parse(CbTipoEntidad.SelectedValue.ToString()); /* Entidad */ Presenter.TempItemDET_Tarifa.ENTC_Codigo = (Convert.ToInt32(ENTC_CodigoEntidad.Value.ENTC_Codigo)); switch (i) { case 0: /* ST 20 */ if (Presenter.ItemsDet_Tarifa.Count > 0 && Presenter.ItemDET_Tarifa.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { _Item = new Det_Tarifa(); _Item = Presenter.ItemsDet_Tarifa.FirstOrDefault(tipo => tipo.CTAR_Tipo == Presenter.TipoTarifa && tipo.PACK_Codigo == 1 && tipo.TIPE_Codigo == Presenter.TempItemDET_Tarifa.TIPE_Codigo && tipo.ENTC_Codigo == Presenter.TempItemDET_Tarifa.ENTC_Codigo); _Item.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_Costo20; _Item.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_Costo); _Item.DTAR_Profit = Presenter.Profit; _Item.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSada20; _Item.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); _Item.AUDI_UsrMod = Presenter.Session.UserName; } Presenter.TempItemDET_Tarifa.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_Costo20; Presenter.TempItemDET_Tarifa.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_Costo); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; /* ST 20 Sada */ Presenter.TempItemDET_Tarifa.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSada20; Presenter.TempItemDET_Tarifa.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; break; case 1: /* ST 40 */ if (Presenter.ItemsDet_Tarifa.Count > 0 && Presenter.ItemDET_Tarifa.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { _Item = new Det_Tarifa(); _Item = Presenter.ItemsDet_Tarifa.FirstOrDefault(tipo => tipo.CTAR_Tipo == Presenter.TipoTarifa && tipo.PACK_Codigo == 2 && tipo.TIPE_Codigo == Presenter.TempItemDET_Tarifa.TIPE_Codigo && tipo.ENTC_Codigo == Presenter.TempItemDET_Tarifa.ENTC_Codigo); _Item.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_Costo40; _Item.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_Costo); _Item.DTAR_Profit = Presenter.Profit; _Item.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSada40; _Item.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); _Item.AUDI_UsrMod = Presenter.Session.UserName; } Presenter.TempItemDET_Tarifa.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_Costo40; Presenter.TempItemDET_Tarifa.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_Costo); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; /* ST 40 SADA */ Presenter.TempItemDET_Tarifa.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSada40; //Presenter.TempItemDET_Tarifa.DTAR_VentaSada = ((Presenter.Profit / 100) * Presenter.TempItemDET_Tarifa.DTAR_CostoSada); Presenter.TempItemDET_Tarifa.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; break; case 2: /* HBL */ if (Presenter.ItemsDet_Tarifa.Count > 0 && Presenter.ItemDET_Tarifa.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { _Item = new Det_Tarifa(); _Item = Presenter.ItemsDet_Tarifa.FirstOrDefault(tipo => tipo.CTAR_Tipo == Presenter.TipoTarifa && tipo.PACK_Codigo == null && tipo.TIPE_Codigo == Presenter.TempItemDET_Tarifa.TIPE_Codigo && tipo.ENTC_Codigo == Presenter.TempItemDET_Tarifa.ENTC_Codigo); _Item.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_CostoHBL; _Item.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoHBL); _Item.DTAR_Profit = Presenter.Profit; _Item.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSadaHBL; _Item.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); _Item.AUDI_UsrMod = Presenter.Session.UserName; } Presenter.TempItemDET_Tarifa.DTAR_Costo = Presenter.ItemDET_Tarifa.DTAR_CostoHBL; Presenter.TempItemDET_Tarifa.DTAR_Venta = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_Costo); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; /* HBL SADA */ Presenter.TempItemDET_Tarifa.DTAR_CostoSada = Presenter.ItemDET_Tarifa.DTAR_CostoSadaHBL; Presenter.TempItemDET_Tarifa.DTAR_VentaSada = (Presenter.Profit + Presenter.TempItemDET_Tarifa.DTAR_CostoSada); Presenter.TempItemDET_Tarifa.DTAR_Profit = Presenter.Profit; Presenter.TempItemDET_Tarifa.CONS_CodBas = "004"; Presenter.TempItemDET_Tarifa.CONS_TabBas = "BSL"; break; } int ultimo = 0; if (Presenter.ItemsDet_Tarifa != null && Presenter.ItemsDet_Tarifa.Count > 0) { ultimo = Presenter.ItemsDet_Tarifa.Max(data => data.DTAR_Fila); } ultimo++; Presenter.TempItemDET_Tarifa.DTAR_Fila = ultimo; if (Presenter.ItemsDet_Tarifa != null) { Presenter.ItemsDet_Tarifa.Add(Presenter.TempItemDET_Tarifa); } } } catch (Exception ex) { Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al agregar el nuevo registro.", ex); } }
public void AgregarDetalleTarifario() { try { if (TipoTarifa.Equals("L")) { if (InstanciaDet_Tarifa == InstanceView.Edit) { if (ItemDET_Tarifa.DTAR_Item > 0) { //ItemsDet_Tarifa.Remove(ItemDET_Tarifa); ItemDET_Tarifa.Instance = InstanceEntity.Modified; ItemDET_Tarifa.AUDI_UsrMod = Session.UserName; } else { while (ItemsDet_Tarifa.FirstOrDefault(tipo => tipo.CTAR_Tipo == TipoTarifa && tipo.TIPE_Codigo == ItemDET_Tarifa.TIPE_Codigo && tipo.ENTC_Codigo == ItemDET_Tarifa.ENTC_Codigo) != null) { var item = ItemsDet_Tarifa.FirstOrDefault(tipo => tipo.CTAR_Tipo == TipoTarifa && tipo.TIPE_Codigo == ItemDET_Tarifa.TIPE_Codigo && tipo.ENTC_Codigo == ItemDET_Tarifa.ENTC_Codigo); ItemsDet_Tarifa.Remove(item); } } ItemsGrillaDet_Tarifa.Remove(ItemDET_Tarifa); //continuar: //foreach (var item in ItemsDet_Tarifa) //{ // if (ItemDET_Tarifa.DTAR_Fila == item.DTAR_Fila) // { // if (item.DTAR_Item > 0) // { // item.Instance = InstanceEntity.Deleted; // } // else // { // ItemsDet_Tarifa.Remove(item); // goto continuar; // } // } //} } else { ItemDET_Tarifa.Instance = InstanceEntity.Added; ItemDET_Tarifa.AUDI_UsrCrea = Session.UserName; } //ItemDET_Tarifa = new Det_Tarifa //{ // AUDI_UsrCrea = Session.UserName, // AUDI_FecCrea = Session.Fecha, // Instance = InstanceEntity.Added //}; DView.GetItem(); if (ItemDET_Tarifa.Validar()) { if (ItemsDet_Tarifa != null && ItemsDet_Tarifa.Count > 0) { if (ItemDET_Tarifa.TIPE_Codigo != null && ItemDET_Tarifa.TIPE_Codigo.Value.ToString(CultureInfo.InvariantCulture).Equals("13")) //maritimo { const short tipeCodigo = 13; if (ItemsGrillaDet_Tarifa.Count(tipo => tipo.TIPE_Codigo != null && tipo.TIPE_Codigo.Value == tipeCodigo) > 0) { Dialogos.MostrarMensajeInformacion(Title, "No puede haber mas de un agente maritimo."); return; } } else { if (ItemsGrillaDet_Tarifa.Any(entCodigo => entCodigo.ENTC_Codigo == ItemDET_Tarifa.ENTC_Codigo && entCodigo.TIPE_Codigo == ItemDET_Tarifa.TIPE_Codigo && entCodigo.Instance == InstanceEntity.Added)) { Dialogos.MostrarMensajeInformacion(Title, "No puede haber mas de una entidad duplicada."); return; } } } // if (InstanciaDet_Tarifa == InstanceView.New) ItemsGrillaDet_Tarifa.Add(ItemDET_Tarifa); DView.GenerarST20_ST40_HBL(); MView.ShowItemsDetalleTarifario(); DView.CerrarVenta(); } else { DView.ShowValidation(); } } else // Tarifa Aduanera || Tarifa Transporte { if (InstanciaDet_Tarifa == InstanceView.Edit) { if (ItemDET_Tarifa.DTAR_Item > 0) { ItemDET_Tarifa.AUDI_UsrMod = Session.UserName; ItemDET_Tarifa.Instance = InstanceEntity.Modified; } else { ItemsDet_Tarifa.Remove(ItemDET_Tarifa); } } else { ItemDET_Tarifa.AUDI_UsrCrea = Session.UserName; ItemDET_Tarifa.Instance = InstanceEntity.Added; TempItemDET_Tarifa = new Det_Tarifa { AUDI_UsrCrea = Session.UserName, AUDI_FecCrea = Session.Fecha, Instance = InstanceEntity.Added }; } DView.GetItem(); if (TempItemDET_Tarifa.Validar()) { if (ItemsDet_Tarifa != null && ItemsDet_Tarifa.Count > 0) { if (TempItemDET_Tarifa.CTAR_Tipo.Equals("A")) { if (ItemsDet_Tarifa.Any(codBase => codBase.CONS_CodBas == TempItemDET_Tarifa.CONS_CodBas && codBase.Instance != InstanceEntity.Modified)) { Dialogos.MostrarMensajeInformacion(Title, "No puede haber mas de un base duplicada."); return; } } if (TempItemDET_Tarifa.CTAR_Tipo.Equals("T")) { if (ItemsDet_Tarifa.Any(data => data.CONS_CodTRA == TempItemDET_Tarifa.CONS_CodTRA && data.TIPO_CodZONDestino == TempItemDET_Tarifa.TIPO_CodZONDestino && data.Instance != InstanceEntity.Modified)) { Dialogos.MostrarMensajeInformacion(Title, "No puede haber mas de una mismo tipo y destino."); return; } } } if (ItemsDet_Tarifa != null && InstanciaDet_Tarifa != InstanceView.Edit) { ItemsDet_Tarifa.Add(TempItemDET_Tarifa); } MView.ShowItemsDetalleTarifario(); DView.CerrarVenta(); } else { DView.ShowValidation(); } } } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
private bool Insert(ref Det_Tarifa item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DTARSI_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("@psinDTAR_Item", item.DTAR_Item, SqlDbType.SmallInt, 2, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pintPACK_Codigo", item.PACK_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_CostoSada", item.DTAR_CostoSada, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_VentaSada", item.DTAR_VentaSada, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Venta", item.DTAR_Venta, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Peso", item.DTAR_Peso, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Volumen", item.DTAR_Volumen, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Minimo", item.DTAR_Minimo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodBas", item.CONS_CodBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabBas", item.CONS_TabBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabZON", item.TIPO_TabZON, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONDestino", item.TIPO_CodZONDestino, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONOrigen", item.TIPO_CodZONOrigen, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pbitDTAR_Roundtrip", item.DTAR_Roundtrip, SqlDbType.Bit, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Costo", item.DTAR_Costo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_Profit", item.DTAR_Profit, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDTAR_ProfitMinimo", item.DTAR_ProfitMinimo, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodTRA", item.CONS_CodTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabTRA", item.CONS_TabTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinTIPE_Codigo", item.TIPE_Codigo, SqlDbType.SmallInt, 2, 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(); Int16 _DTAR_Item; if (Int16.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@psinDTAR_Item"].Value.ToString(), out _DTAR_Item)) { item.DTAR_Item = _DTAR_Item; } return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }