Пример #1
0
        private void UsuarioDeseaMarcarComoCobrados()
        {
            var lista = new List <ServicioPorCobrar>();

            foreach (var servicio in UiVistaEdicion.GetSelectedRows().Select(indice => (ServicioPorCobrar)UiVistaEdicion.GetRow(indice)).Where(servicio => servicio.IS_CHARGED == 0))
            {
                servicio.IS_CHARGED   = 1;
                servicio.CHARGED_DATE = DateTime.Today;
                lista.Add(servicio);
            }
            UsuarioDeseaMarcarComoCobrado?.Invoke(null, new ServicioPorCobrarArgumento {
                ListaDeServiciosPorCobrar = lista
            });
            var servicioPorCobrar = new ServicioPorCobrar {
                CLIENT_CODE = ObtenerClientesSeleccionados()
            };

            if (!UiSwiftIncluirServiciosCobrados.Checked)
            {
                servicioPorCobrar.IS_CHARGED = 0;
            }

            UsuarioDeseaCargarServiciosPorCobrarPorFecha?.Invoke(null, new ServicioPorCobrarArgumento {
                FechaInicio = DateTime.Parse(UiFechaInicio.EditValue.ToString()), FechaFinal = DateTime.Parse(UiFechaFinal.EditValue.ToString()), ServicioPorCobrar = servicioPorCobrar
            });
            UiVistaEdicion.ExpandAllGroups();
        }
Пример #2
0
        private void UiBotonRefrescar_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var servicioPorCobrar = new ServicioPorCobrar {
                CLIENT_CODE = ObtenerClientesSeleccionados()
            };

            if (!UiSwiftIncluirServiciosCobrados.Checked)
            {
                servicioPorCobrar.IS_CHARGED = 0;
            }

            UsuarioDeseaCargarServiciosPorCobrarPorFecha?.Invoke(sender, new ServicioPorCobrarArgumento {
                FechaInicio = DateTime.Parse(UiFechaInicio.EditValue.ToString()), FechaFinal = DateTime.Parse(UiFechaFinal.EditValue.ToString()), ServicioPorCobrar = servicioPorCobrar
            });
        }
Пример #3
0
        private void UsuarioDeseaGuardarCambiosDePrecio()
        {
            UsuarioDeseaGuardarCambioDePrecio?.Invoke(null, new ServicioPorCobrarArgumento {
                ListaDeServiciosPorCobrar = ListaDeServiciosPorCobrar.ToList()
            });
            var servicioPorCobrar = new ServicioPorCobrar {
                CLIENT_CODE = ObtenerClientesSeleccionados()
            };

            if (!UiSwiftIncluirServiciosCobrados.Checked)
            {
                servicioPorCobrar.IS_CHARGED = 0;
            }

            UsuarioDeseaCargarServiciosPorCobrarPorFecha?.Invoke(null, new ServicioPorCobrarArgumento {
                FechaInicio = DateTime.Parse(UiFechaInicio.EditValue.ToString()), FechaFinal = DateTime.Parse(UiFechaFinal.EditValue.ToString()), ServicioPorCobrar = servicioPorCobrar
            });
            UiVistaEdicion.ExpandAllGroups();
        }
Пример #4
0
        public Operacion ModificarServicioPorCobrar(ServicioPorCobrar servicioPorCobrar)
        {
            BaseDeDatosServicio.BeginTransaction();
            try
            {
                DbParameter[] parameters =
                {
                    new OAParameter
                    {
                        ParameterName = "@SERVICES_TO_BILL_ID",
                        Value         = servicioPorCobrar.SERVICES_TO_BILL_ID
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@QTY",
                        Value         = servicioPorCobrar.QTY == new decimal()? (decimal?)null: servicioPorCobrar.QTY
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@TRANSACTION_TYPE",
                        Value         = servicioPorCobrar.TRANSACTION_TYPE
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@PRICE",
                        Value         = (servicioPorCobrar.IS_CHARGED == 0)?(servicioPorCobrar.PRICE_TO_CHANGE): (servicioPorCobrar.PRICE)
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@TOTAL_AMOUNT",
                        Value         = servicioPorCobrar.TOTAL_AMOUNT
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@PROCESS_DATE",
                        Value         = servicioPorCobrar.PROCESS_DATE == new DateTime()? (DateTime?)null: servicioPorCobrar.PROCESS_DATE
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@LAST_UPDATED_BY",
                        Value         = servicioPorCobrar.LAST_UPDATED_BY
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@TYPE_CHARGE_ID",
                        Value         = servicioPorCobrar.TYPE_CHARGE_ID
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@TYPE_CHARGE_DESCRIPTION",
                        Value         = servicioPorCobrar.TYPE_CHARGE_DESCRIPTION
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@CLIENT_CODE",
                        Value         = servicioPorCobrar.CLIENT_CODE
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@CLIENT_NAME",
                        Value         = servicioPorCobrar.CLIENT_NAME
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@IS_CHARGED",
                        Value         = servicioPorCobrar.IS_CHARGED
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@INVOICE_REFERENCE",
                        Value         = servicioPorCobrar.INVOICE_REFERENCE
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@CHARGED_DATE",
                        Value         = servicioPorCobrar.CHARGED_DATE
                    }

                    ,
                    new OAParameter
                    {
                        ParameterName = "@LICENSE_ID",
                        Value         = servicioPorCobrar.LICENSE_ID
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@LOCATION",
                        Value         = servicioPorCobrar.LOCATION
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@SERVICE_ID",
                        Value         = servicioPorCobrar.SERVICE_ID
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@SERVICE_CODE",
                        Value         = servicioPorCobrar.SERVICE_CODE
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@SERVICE_DESCRIPTION",
                        Value         = servicioPorCobrar.SERVICE_DESCRIPTION
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@REGIMEN",
                        Value         = servicioPorCobrar.REGIMEN
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@DOC_NUM",
                        Value         = servicioPorCobrar.DOC_NUM
                    }
                    ,
                    new OAParameter
                    {
                        ParameterName = "@TRANSACTION_ID",
                        Value         = servicioPorCobrar.TRANSACTION_ID
                    }
                };

                var op = BaseDeDatosServicio.ExecuteQuery <Operacion>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_UPDATE_SERVICE_TO_BILL", CommandType.StoredProcedure, parameters)[0];
                BaseDeDatosServicio.Commit();
                return(op);
            }
            catch (DbException e)
            {
                BaseDeDatosServicio.Rollback();
                return(new Operacion
                {
                    Codigo = e.ErrorCode,
                    Mensaje = e.Message,
                    Resultado = ResultadoOperacionTipo.Error
                });
            }
            catch (Exception ex)
            {
                BaseDeDatosServicio.Rollback();
                return(new Operacion
                {
                    Codigo = -1,
                    Mensaje = ex.Message,
                    Resultado = ResultadoOperacionTipo.Error
                });
            }
        }
Пример #5
0
 public IList <ServicioPorCobrar> ConsultarServiciosPorCobrarPorFecha(DateTime fechaInicio, DateTime fechaFin, ServicioPorCobrar servicioPorCobrar)
 {
     DbParameter[] parameters =
     {
         new OAParameter
         {
             ParameterName = "@INICIAL_DATE",
             Value         = fechaInicio
         },
         new OAParameter
         {
             ParameterName = "@FINAL_DATE"
             , Value       = fechaFin
         },
         new OAParameter
         {
             ParameterName = "@CLIENT_CODE"
             , Value       = servicioPorCobrar.CLIENT_CODE
         },
         new OAParameter
         {
             ParameterName = "@IS_CHARGED"
             ,
             Value = servicioPorCobrar.IS_CHARGED
         }
     };
     return(BaseDeDatosServicio.ExecuteQuery <ServicioPorCobrar>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_GET_SERVICE_TO_BILL_BY_DATES", CommandType.StoredProcedure, parameters));
 }