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; }
}
