public void ShowItems()
{
try
{
BSItems.DataSource = Presenter.ItemsCab_Operacion;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
if (grdItems.RowCount > 0)
{
grdItems.Enabled = true;
btnExportar.Enabled = true;
Infrastructure.WinFormsControls.GridAutoFit.Fit(this.grdItems);
grdItemsServicios.Enabled = true;
}
else
{
grdItems.Enabled = false;
btnExportar.Enabled = false;
BSItemsServicvios.DataSource = null;
grdItemsServicios.DataSource = BSItemsServicvios;
navItemsServicios.BindingSource = BSItemsServicvios;
BSItemsServicvios.ResetBindings(true);
grdItemsServicios.Enabled = false;
}
}
catch (Exception ex)
{ Infrastructure.WinFormsControls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.ShowItems, ex); }
}
public void ShowItems()
{
try
{
BSItems.DataSource = Presenter.Items;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
if (grdItems.RowCount > 0)
{
grdItems.Enabled = true;
btnExportar.Enabled = true;
Infrastructure.WinForms.Controls.GridAutoFit.Fit(this.grdItems);
}
else
{
grdItems.Enabled = false;
btnExportar.Enabled = false;
}
grdItems.ShowFilteringRow = false;
grdItems.EnableFiltering = false;
grdItems.MasterTemplate.EnableFiltering = false;
grdItems.EnableGrouping = false;
grdItems.MasterTemplate.EnableGrouping = false;
grdItems.EnableSorting = false;
grdItems.MasterTemplate.EnableCustomSorting = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error cargando los items.", ex); }
}
/// <summary>
/// Realiza la conciliación de Agentes.
/// </summary>
private void Conciliar()
{
try
{
spcBase.Panel2Collapsed = true;
spcResultado.Panel2Collapsed = true;
Presenter.MsgError = "";
pgbBase.Visible = true;
if (Presenter.Conciliar(ref pgbBase))
{
/* Cuando todo el archivo a conciliar fue procesado integramente */
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeSatisfactorio(Presenter.Title, "Conciliación Procesada Satisfactoriamente.");
}
else if (Presenter.ConciliacionProcesado)
{
/* Muestra el resultado de los registros no procesados por que no existen en el listado de documentos a se
* cancelados/cobrados, y las observaciones de cada registro genera cuando no es procesado/conciliado
**/
spcResultado.Panel2Collapsed = !(Presenter.MsgError.Length > 0);
if (Presenter.DTNoProcesados != null && Presenter.DTNoProcesados.Rows.Count > 0)
{
BSItemsNoProcesados = new BindingSource();
BSItemsNoProcesados.DataSource = Presenter.DTNoProcesados;
grdItemsNoProcesados.DataSource = BSItemsNoProcesados;
bindingNavigator1.BindingSource = BSItemsNoProcesados;
spcBase.Panel2Collapsed = false;
Infrastructure.WinForms.Controls.GridAutoFit.Fit(this.grdItemsNoProcesados);
grdItemsNoProcesados.ShowFilteringRow = false;
grdItemsNoProcesados.EnableFiltering = false;
grdItemsNoProcesados.MasterTemplate.EnableFiltering = false;
grdItemsNoProcesados.EnableGrouping = false;
grdItemsNoProcesados.MasterTemplate.EnableGrouping = false;
grdItemsNoProcesados.EnableSorting = false;
grdItemsNoProcesados.MasterTemplate.EnableCustomSorting = false;
grdItemsNoProcesados.AllowColumnHeaderContextMenu = false;
grdItemsNoProcesados.AllowCellContextMenu = false;
BSItems.ResetBindings(false);
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Presenter.Title, "No se proceso el archivo completo de conciliación, podra ver los registro no procesados en la zona inferior.", Presenter.MsgError);
}
else
{
/* Solo muestra las observaciones de los registros que al ser procesados tienen alguna observación */
spcResultado.Panel1Collapsed = false;
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Presenter.Title, "No se proceso la conciliacion, se sucitaron los siguientes errores.", Presenter.MsgError);
}
}
pgbBase.Visible = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al Conciliar.", ex); }
}
public void ShowItemsDetalles()
{
try
{
BSItems.DataSource = Presenter.ItemsDet_Seguimientos;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
grdItems.Enabled = grdItems.RowCount > 0;
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.ShowItems, ex); }
}
public void ShowItems()
{
try
{
_CargaGrid = true;
BSItems.DataSource = Presenter._dtDireccionamiento;
grdItems.DataSource = BSItems;
//navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
HabilitaBotones(grdItems.RowCount > 0 ? true : false);
_CargaGrid = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.ShowItems, ex); }
}
void grdItems_ValueChanged(object sender, EventArgs e)
{
try
{
if (grdItems.ActiveEditor is RadCheckBoxEditor)
{
grdItems.EndEdit();
grdItems.EndUpdate();
BSItems.EndEdit();
Presenter.ItemsGrillaDet_Tarifa = (ObservableCollection <Det_Tarifa>)BSItems.DataSource;
}
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido una error al activar la casilla de verificación", ex); }
}
private void Deshacer()
{
try
{
BSItems.DataSource = null;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
grdItems.Enabled = true;
btnNuevo.Enabled = true;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al deshacer la vista.", ex); }
}
void grdItems_ValueChanged(object sender, EventArgs e)
{
try
{
if (!(grdItems.ActiveEditor is RadCheckBoxEditor))
{
return;
}
grdItems.EndEdit();
grdItems.EndUpdate();
BSItems.EndEdit();
//Presenter.Items = (ObservableCollection<DocsVta>)BSItems.DataSource;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido una error al activar la casilla", ex); }
}
public void LoadView()
{
try
{
BSItems.DataSource = null;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
FormatDataGrid();
grdItems.Enabled = false;
btnNuevo.Enabled = true;
btnBuscar.Enabled = true;
btnExportar.Enabled = false;
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.LoadView, ex); }
}
private void Deshacer()
{
try
{
BSItems.DataSource = null;
BSItemsDetalle.DataSource = null;
grdItems.DataSource = BSItems;
BSItems.ResetBindings(true);
BSItemsDetalle.ResetBindings(true);
grdItems.Enabled = true;
grdItemsDetalle.Enabled = true;
btnBuscar.Enabled = true;
btnAsignar.Enabled = false;
btnExportar.Enabled = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al deshacer la vista.", ex); }
}
public void ShowItemsDetalleTarifario()
{
try
{
if (Presenter.TipoTarifa.Equals("L"))
{
BSItems.DataSource = Presenter.ItemsGrillaDet_Tarifa.Where(var => var.Instance != InstanceEntity.Deleted).ToObservableCollection();
}
else
{
BSItems.DataSource = Presenter.ItemsDet_Tarifa.Where(var => var.Instance != InstanceEntity.Deleted).ToObservableCollection();
}
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.ShowItems, ex); }
}
public void LoadView()
{
try
{
AyudaEntidadCliente.ContainerService = Presenter.ContainerService;
BSItems.DataSource = null;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
AyudaEntidadCliente.TipoEntidad = Delfin.Controls.TiposEntidad.TIPE_Cliente;
mdtFecDesde.NSFecha = Presenter.Session.Fecha;
mdtFecHasta.NSFecha = Presenter.Session.Fecha;
List <KeyValuePair <int, string> > itemsFiltros = new List <KeyValuePair <int, string> >();
itemsFiltros.Add(new KeyValuePair <int, string>(0, "< todos >"));
itemsFiltros.Add(new KeyValuePair <int, string>(1, "No Facturada"));
itemsFiltros.Add(new KeyValuePair <int, string>(2, "Facturada Parcial"));
itemsFiltros.Add(new KeyValuePair <int, string>(3, "Facturada Total"));
CbSituacionFacturaProveedor.DataSource = new BindingSource(itemsFiltros, null);
CbSituacionFacturaProveedor.DisplayMember = "Value";
CbSituacionFacturaProveedor.ValueMember = "Key";
CbSituacionFacturaCliente.DataSource = new BindingSource(itemsFiltros, null);
CbSituacionFacturaCliente.DisplayMember = "Value";
CbSituacionFacturaCliente.ValueMember = "Key";
FormatDataGrid();
FormatDataGridServicio();
grdItems.Enabled = false;
btnNuevo.Enabled = true;
btnBuscar.Enabled = true;
btnExportar.Enabled = false;
grdItemsServicios.Enabled = false;
}
catch (Exception ex)
{ Infrastructure.WinFormsControls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.LoadView, ex); }
}
public void CargaDataDocumentos(DataTable dt, Boolean IncluyePago = false)
{
try
{
if (dt.Rows.Count > 0)
{
CbTIPO_CodMND.TiposSelectedValue = dt.Rows[0]["TIPO_CodMND"].ToString();
}
if (!IncluyePago)
{
DataColumn _Col = dt.Columns.Add("Pago", typeof(Decimal));
foreach (DataRow _dt in dt.Rows)
{
_dt["Pago"] = _dt["CCCT_Saldo"];
}
}
if (dt.Rows.Count > 0)
{
dt.Columns.Remove("ENTC_Codigo");
dt.Columns.Remove("Cliente");
}
BSItems.DataSource = dt;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
if (grdItems.RowCount > 0)
{
grdItems.Enabled = true;
}
else
{
grdItems.Enabled = false;
}
grdItems.Columns["Pago"].ReadOnly = false;
HabilitaObj();
CalculaTotal();
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.ShowItems, ex); }
}
public void ShowItems(CAJ006LiquidacionAgentesPresenter.TBusqueda x_opcion)
{
try
{
BSItems.DataSource = Presenter.Item.ListCtaCte;
grdItems.DataSource = BSItems;
navItems.BindingSource = BSItems;
BSItems.ResetBindings(true);
if (grdItems.RowCount > 0)
{
grdItems.Enabled = true;
grdItems.BestFitColumns();
grdItems.ReadOnly = false;
grdItems.AllowEditRow = true;
grdItems.Columns["Seleccionar"].ReadOnly = false;
grdItems.Columns["Seleccionar"].Width = 90;
switch (x_opcion)
{
case CAJ006LiquidacionAgentesPresenter.TBusqueda.Normal:
btnNuevo.Enabled = true;
btnLiquidar.Enabled = true;
btnAprobar.Enabled = false;
btnAnular.Enabled = false;
btnImprimir.Enabled = false;
btnConciliar.Enabled = true;
break;
case CAJ006LiquidacionAgentesPresenter.TBusqueda.Apertura:
ShowControlesApertura();
break;
default:
btnNuevo.Enabled = true;
btnLiquidar.Enabled = false;
btnAprobar.Enabled = false;
btnAnular.Enabled = false;
btnImprimir.Enabled = false;
btnConciliar.Enabled = false;
grdItems.ReadOnly = true;
break;
}
//Infrastructure.WinForms.Controls.GridAutoFit.Fit(this.grdItems);
}
else
{
grdItems.Enabled = false;
switch (x_opcion)
{
case CAJ006LiquidacionAgentesPresenter.TBusqueda.Normal:
btnNuevo.Enabled = true;
btnLiquidar.Enabled = false;
btnAprobar.Enabled = false;
btnAnular.Enabled = false;
btnImprimir.Enabled = false;
btnConciliar.Enabled = false;
break;
case CAJ006LiquidacionAgentesPresenter.TBusqueda.Apertura:
ShowControlesApertura();
btnLiquidar.Enabled = false;
btnImprimir.Enabled = false;
btnConciliar.Enabled = false;
break;
default:
btnNuevo.Enabled = true;
btnLiquidar.Enabled = false;
btnAprobar.Enabled = false;
btnAnular.Enabled = false;
btnImprimir.Enabled = false;
btnConciliar.Enabled = false;
break;
}
}
//grdItems.ShowFilteringRow = false;
//grdItems.EnableFiltering = false;
//grdItems.MasterTemplate.EnableFiltering = false;
//grdItems.EnableGrouping = false;
//grdItems.MasterTemplate.EnableGrouping = false;
//grdItems.EnableSorting = false;
//grdItems.MasterTemplate.EnableCustomSorting = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error cargando los items.", ex); }
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
Int32?ENCT_Codigo = null; if (txaENTC_Codigo.SelectedItem != null)
{
ENCT_Codigo = txaENTC_Codigo.SelectedItem.ENTC_Codigo;
}
DateTime?Fecha = null; if (dtpMOVI_FecEmision.NSFecha.HasValue)
{
Fecha = dtpMOVI_FecEmision.NSFecha;
}
String TipoDocumento = null; if (cmbTipoDocumento.ConstantesSelectedItem != null)
{
TipoDocumento = cmbTipoDocumento.ConstantesSelectedItem.CONS_CodTipo;
}
String MBL = null; if (!String.IsNullOrEmpty(txtMBL.Text))
{
MBL = txtMBL.Text;
}
String HBL = null; if (!String.IsNullOrEmpty(txtHBL.Text))
{
HBL = txtHBL.Text;
}
String F_TIPO_CodTDO = null; if (cmbTIPO_CodTDO.TiposSelectedItem != null)
{
F_TIPO_CodTDO = cmbTIPO_CodTDO.TiposSelectedItem.TIPO_CodTipo;
}
String F_CCCT_Serie = null; if (!String.IsNullOrEmpty(txtCCCT_Serie.Text))
{
F_CCCT_Serie = txtCCCT_Serie.Text;
}
String F_CCCT_Numero = null; if (!String.IsNullOrEmpty(txtCCCT_Numero.Text))
{
F_CCCT_Numero = txtCCCT_Numero.Text;
}
Boolean x_TipoDocumento = true;
if (TipoMovimiento == TipoMovimientoCtaCte.Egresos)
{
if (String.IsNullOrEmpty(TipoDocumento))
{
x_TipoDocumento = false;
}
}
//grdItemsDocumentos.Columns["MODULO"].IsVisible = x_TipoDocumento;
if (ENCT_Codigo.HasValue && Fecha.HasValue && x_TipoDocumento)
{
ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>();
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@psinEMPR_Codigo", FilterValue = Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pintENTC_Codigo", FilterValue = ENCT_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pdtmCCCT_FechaEmision", FilterValue = Fecha, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@TipoDocumento", FilterValue = TipoDocumento, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 8
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@HBL", FilterValue = HBL, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 50
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@MBL", FilterValue = MBL, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 50
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pchrTIPO_CodTDO", FilterValue = F_TIPO_CodTDO, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pvchCCCT_Serie", FilterValue = F_CCCT_Serie, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pvchCCCT_Numero", FilterValue = F_CCCT_Numero, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20
});
if (txaNVIA_Codigo.Value != null)
{
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pintNVIA_Codigo", FilterValue = (txaNVIA_Codigo.Value as Entities.NaveViaje).NVIA_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4
});
}
String _procedure = "CAJ_CCCTSS_TodosPendientes";
switch (TipoMovimiento)
{
case TipoMovimientoCtaCte.Ingresos:
_procedure = "CAJ_CCCTSS_TodosPendientesIngresos";
break;
case TipoMovimientoCtaCte.Egresos:
_procedure = "CAJ_CCCTSS_TodosPendientesEgresos";
if (cmbTipoDocumento.ConstantesSelectedItem.CONS_CodTipo.Equals("LI"))
{
FormatGridDocumentos(CAJ002IngresosEgresosPresenter.TBusqueda.Liquidaciones);
Presenter.TipoBusqueda = CAJ002IngresosEgresosPresenter.TBusqueda.Liquidaciones;
Presenter.Item.EsLiquidacion = true;
}
else
{
FormatGridDocumentos(CAJ002IngresosEgresosPresenter.TBusqueda.Base);
Presenter.TipoBusqueda = CAJ002IngresosEgresosPresenter.TBusqueda.Base;
Presenter.Item.EsLiquidacion = false;
}
break;
}
Items = Presenter.Client.GetAllDetCtaCteFilter(_procedure, _listFilters);
if (Presenter.Item.ListDetCtaCte != null && Presenter.Item.ListDetCtaCte.Count > 0)
{
foreach (Entities.DetCtaCte idetCtaCte in Presenter.Item.ListDetCtaCte)
{
Entities.DetCtaCte _delete =
Items.Where(Del => Del.CCCT_Codigo == idetCtaCte.CCCT_Codigo).FirstOrDefault();
if (_delete != null)
{
Items.Remove(_delete);
}
}
}
BSItems.DataSource = Items;
BSItems.ResetBindings(true);
grdItemsDocumentos.BestFitColumns();
}
else
{
String msg = "";
if (!ENCT_Codigo.HasValue)
{
msg += "* Seleccione una Entidad" + Environment.NewLine;
}
if (!Fecha.HasValue)
{
msg += "* Seleccione una fecha" + Environment.NewLine;
}
if (String.IsNullOrEmpty(TipoDocumento))
{
msg += "* Seleccione el tipo de busqueda" + Environment.NewLine;
}
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Presenter.Title, "No puede realizar la busqueda, faltan datos, haga click en el boton detalles", msg);
}
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha Ocurrido al consultar", ex); }
}
