public ActionResult Listar(GridDataRequest request) { int totalRecords = 0; var lstGrd = MovimientoBL.LstEntradaJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.MovimientoId, cell = new string[] { item.MovimientoId.ToString(), item.Tipo, item.TipoMovimientoId.ToString(), item.TipoMovimiento, item.Fecha.ToString(), item.Documento, item.Estado, item.Observacion } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult Listar(GridDataRequest request) { int totalRecords = 0; var lstGrd = ArticuloBL.LstListaArticulosJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.ArticuloId, cell = new string[] { item.ArticuloId.ToString(), item.ListaPrecioId.ToString(), item.TipoArticulo, item.ArticuloDesc, item.PuntosCanje.ToString(), item.Estado.ToString(), item.ListaPrecioId.ToString() + "," + (item.Estado ? "1":"0") } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarCliente(GridDataRequest request) { int totalRecords = 0; var lstGrd = ClienteBL.LstClienteJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.ClienteId, cell = new string[] { item.ClienteId.ToString(), item.Persona.NombreCompleto, item.Persona.TipoDocumento + " " + item.Persona.NumeroDocumento, item.Persona.EmailPersonal, item.Persona.Celular1, item.Persona.Direccion, item.Estado.ToString(), item.ClienteId.ToString() + "," + (item.Estado ? "1":"0") } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarBovedaMovJgrid(GridDataRequest request) { int totalRecords = 0; var lstItem = BovedaBL.LstBovedaMovJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstItem select new { id = item.MovimientoBovedaId, cell = new string[] { item.MovimientoBovedaId.ToString(), item.FechaReg.ToString(), item.CodOperacion, item.Glosa, item.Importe.ToString(), item.MovimientoBovedaId.ToString() } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarOrdenesVentaJgrid(GridDataRequest request) { int totalRecords = 0; var lstGrd = OrdenVentaBL.LstOrdenesVentaJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.OrdenVentaId, cell = new string[] { item.OrdenVentaId.ToString(), item.FechaReg.ToString(), item.Cliente, item.TotalDescuento.ToString(), item.TotalNeto.ToString(), ObtenerTipoOv(item.TipoVenta,item.EstadoCredito), ObtenerCondicion(item.Estado,item.TipoVenta), item.OrdenVentaId.ToString() + "," + ObtenerEliminarOv(item.Estado,item.TipoVenta,item.EstadoCredito) } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarRolJgrid(GridDataRequest request) { int totalRecords = 0; var lstGrd = RolBL.LstRolJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.RolId, cell = new string[] { item.RolId.ToString(), item.Denominacion, item.Estado.ToString(), item.RolId.ToString() + "," + (item.Estado ? "1":"0") } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarCajasAsignadas(GridDataRequest request) { var lstGrd = CajaBL.LstCajaDiarioOficina(); var productsData = new { total = (int)Math.Ceiling((float)lstGrd.Count / (float)request.rows), page = request.page, records = lstGrd.Count, rows = (from item in lstGrd select new { id = item.CajaDiarioId, cell = new string[] { item.CajaDiarioId.ToString(), item.NombreCaja, item.IndCierre ? "CERRADO":"ABIERTO", item.Cajero, item.FechaIniOperacion.ToString(), item.FechaFinOperacion.HasValue?item.FechaFinOperacion.Value.ToString():string.Empty, item.SaldoInicial.ToString(), item.Entradas.ToString(), item.Salidas.ToString(), item.SaldoFinal.ToString() } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarSaldoCajaDiario(GridDataRequest request) { int totalRecords = 0; var lstItem = CajaDiarioBL.LstSaldosCajaDiarioJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstItem select new { id = item.CajaDiarioId, cell = new string[] { item.CajaDiarioId.ToString(), item.Caja.Denominacion, item.Usuario.NombreUsuario, item.SaldoInicial.ToString(), item.SaldoFinal.ToString(), item.FechaIniOperacion.ToString(), item.FechaFinOperacion.ToString(), item.IndCierre ? "SI":"NO", item.TransBoveda ? "SI":"NO", item.CajaDiarioId.ToString() } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarDocs(GridDataRequest request) { int movimientoid = request.DataFilters().Count > 0 ? int.Parse(request.DataFilters()["MovimientoId"]) : 0; if (movimientoid==0) return Json(null, JsonRequestBehavior.AllowGet); const int totalRecords = 10; var productsData = new { total = 1,page = 1,records = totalRecords, rows = (from item in MovimientoDocBL.Listar(x => x.MovimientoId == movimientoid , null, "TipoDocumento,Movimiento") select new { id = item.MovimientoDocId, cell = new string[] { item.MovimientoDocId.ToString(), item.TipoDocumento.Denominacion, item.SerieDocumento, item.NroDocumento, item.Movimiento.EstadoId==1?item.MovimientoDocId.ToString():string.Empty } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarMovimientosCajaJGrid(GridDataRequest request) { int totalRecords = 0; var lstItem = CajaDiarioBL.LstMovimientosCajaJGrid(request, ref totalRecords); var data = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstItem select new { id = item.MovimientoCajaId, cell = new string[] { item.MovimientoCajaId.ToString(), item.Estado?item.MovimientoCajaId.ToString():"", item.CajaDiarioId.ToString(), item.FechaReg.ToString(), item.IndEntrada?"ENTRADA":"SALIDA", item.Persona, item.Operacion, item.Descripcion, item.ImportePago.ToString(), item.Estado?"ACTIVO":"ANULADO", item.Estado?item.MovimientoCajaId.ToString():"" } } ).ToArray() }; return Json(data, JsonRequestBehavior.AllowGet); }
public ActionResult ListarCuotasPendientesJGrid(GridDataRequest request) { int totalRecords = 0; string totales = string.Empty; var lstItem = CajaDiarioBL.LstCuotasPendientesJGrid(request, ref totalRecords, ref totales); VendixGlobal<string>.Crear("TotalesCuotasPendientes", totales); var data = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstItem select new { id = item.PlanPagoId, cell = new string[] { item.PlanPagoId.ToString(), item.Glosa, item.FechaVencimiento.ToShortDateString(), item.Amortizacion.ToString(), item.Interes.ToString(), item.GastosAdm.ToString(), item.Cuota.ToString(), item.DiasAtrazo.ToString(), item.ImporteMora.ToString(), item.InteresMora.ToString(), item.PagoLibre.ToString(), item.PagoCuota.ToString() } } ).ToArray() }; return Json(data, JsonRequestBehavior.AllowGet); }
public ActionResult ListarCuentasxCobrarJGrid(GridDataRequest request) { int totalRecords = 0; var lstItem = CajaDiarioBL.LstCuentasxCobrarJGrid(request, ref totalRecords); var data = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstItem select new { id = item.Id, cell = new string[] { item.OrdenVentaId.ToString(), item.CuentaxCobrarId.ToString(), item.Oficina, ObtenerOp(item.Operacion), item.Origen, item.Monto.ToString(), item.Estado, item.FechaReg.ToString() } } ).ToArray() }; return Json(data, JsonRequestBehavior.AllowGet); }
public void LookForPage(int pageNumber, int resultsPerPage) { _paging = new GridDataRequest(pageNumber, resultsPerPage, null, true); }
public ActionResult ListarCreditosGrd(GridDataRequest request) { int totalRecords = 0; var lstGrd = CreditoBL.ListarCreditosGrd(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.CreditoId, cell = new string[] { item.CreditoId.ToString(), item.MontoProducto.ToString(), item.MontoInicial.ToString(), item.MontoCredito.ToString(), item.FormaPago, item.NumeroCuotas.ToString(), item.Estado } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarCargoGrd(GridDataRequest request) { int totalRecords = 0; var lstGrd = CargoBL.ListarCargoJGrid(request, ref totalRecords); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.CargoId, cell = new string[] { item.CargoId.ToString(), item.UsuarioCargo, item.TipoCargo, item.Importe.ToString(), item.Descripcion, item.NumCuota.ToString(), item.Estado } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public async Task <GridDataResponse> PostPeople([JsonGridDataRequest] GridDataRequest gridDataRequest) => gridDataRequest.CreateGridDataResponse((await Person.GetDataAsync().ConfigureAwait(false)).AsQueryable());
public ActionResult ListarDetalle(GridDataRequest request) { int movimientoid = request.DataFilters().Count > 0 ? int.Parse(request.DataFilters()["MovimientoId"]) : 0; if (movimientoid == 0) return Json(null, JsonRequestBehavior.AllowGet); const int totalRecords = 10; var productsData = new { total = 1, page = 1, records = totalRecords, rows = (from item in MovimientoBL.ObtenerEntradaDetalle(movimientoid ) select new { id = item.MovimientoDetId, cell = new string[] { item.MovimientoDetId.ToString(), item.ArticuloId.ToString(), item.UnidadMedidaT10.ToString(), item.Cantidad.ToString(), item.UnidadMedida, item.Descripcion, item.PrecioUnitario.ToString(), item.Descuento.ToString(), item.Importe.ToString(), item.IndCorrelativo.ToString(), item.Elimina?item.MovimientoDetId.ToString():string.Empty } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarPlanPagoActGrd(GridDataRequest request) { var lstGrd = CreditoBL.ListarEstadoPlanPago(int.Parse(request.DataFilters()["pCreditoId"])); int totalRecords = lstGrd.Count; var lstGrdPen = lstGrd.Where(x => x.Estado == "PAG").ToList(); lstGrd.Add(new usp_EstadoPlanPago_Result() { PlanPagoId = -1, Amortizacion = lstGrdPen.Sum(x => x.Amortizacion), Interes = lstGrdPen.Sum(x => x.Interes), GastosAdm = lstGrdPen.Sum(x => x.GastosAdm), Cuota = lstGrdPen.Sum(x => x.Cuota), ImporteMora = lstGrdPen.Sum(x => x.ImporteMora), InteresMora = lstGrdPen.Sum(x => x.InteresMora), PagoCuota = lstGrdPen.Sum(x => x.PagoCuota) }); lstGrdPen = lstGrd.Where(x => x.Estado == "PEN").ToList(); lstGrd.Add(new usp_EstadoPlanPago_Result() { PlanPagoId = -2, Amortizacion = lstGrdPen.Sum(x => x.Amortizacion), Interes = lstGrdPen.Sum(x => x.Interes), GastosAdm = lstGrdPen.Sum(x => x.GastosAdm), Cuota = lstGrdPen.Sum(x => x.Cuota), ImporteMora = lstGrdPen.Sum(x => x.ImporteMora), InteresMora = lstGrdPen.Sum(x => x.InteresMora), PagoCuota = lstGrdPen.Sum(x => x.PagoCuota) }); lstGrdPen = lstGrd.Where(x => x.Estado == "PEN" || x.Estado == "PAG" || x.Estado == "CRE").ToList(); lstGrd.Add(new usp_EstadoPlanPago_Result() { PlanPagoId = 0, Amortizacion = lstGrdPen.Sum(x => x.Amortizacion), Interes = lstGrdPen.Sum(x => x.Interes), GastosAdm = lstGrdPen.Sum(x => x.GastosAdm), Cuota = lstGrdPen.Sum(x => x.Cuota), ImporteMora = lstGrdPen.Sum(x => x.ImporteMora), InteresMora = lstGrdPen.Sum(x => x.InteresMora), PagoCuota = lstGrdPen.Sum(x => x.PagoCuota) }); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.PlanPagoId, cell = new string[] { item.PlanPagoId<=0?String.Empty:item.Numero.ToString(), item.PlanPagoId<=0?String.Empty:item.Capital.ToString(), item.PlanPagoId>0?item.FechaVencimiento.ToShortDateString():(item.PlanPagoId==0?"TOTAL":(item.PlanPagoId==-1?"PAGADO":"PENDIENTE")), item.Amortizacion.ToString(), item.Interes.ToString(), item.GastosAdm.ToString(), item.Cuota.ToString(), item.DiasAtrazo.ToString(), item.ImporteMora.ToString(), item.InteresMora.ToString(), item.Cargo.ToString(), item.PagoLibre.ToString(), item.PagoCuota.ToString(), item.Estado, item.FechaPagoCuota.HasValue?item.FechaPagoCuota.Value.ToShortDateString():string.Empty } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public ActionResult ListarPlanPagoHistGrd(GridDataRequest request, int pCreditoId) { var lstGrd = PlanPagoBL.Listar(x => x.CreditoId == pCreditoId); int totalRecords = lstGrd.Count; lstGrd.Add(new PlanPago() { PlanPagoId = 0, Amortizacion = lstGrd.Sum(x => x.Amortizacion), Interes = lstGrd.Sum(x => x.Interes), GastosAdm = lstGrd.Sum(x => x.GastosAdm), ImporteMora = lstGrd.Sum(x => x.ImporteMora), InteresMora = lstGrd.Sum(x => x.InteresMora) }); var productsData = new { total = (int)Math.Ceiling((float)totalRecords / (float)request.rows), page = request.page, records = totalRecords, rows = (from item in lstGrd select new { id = item.PlanPagoId, cell = new string[] { item.PlanPagoId==0?String.Empty:item.Numero.ToString(), item.PlanPagoId==0?String.Empty:item.Capital.ToString(), item.PlanPagoId==0?"TOTAL:":item.FechaVencimiento.ToShortDateString(), item.Amortizacion.ToString(), item.Interes.ToString(), item.GastosAdm.ToString(), item.PlanPagoId==0?String.Empty:item.Cuota.ToString(), item.ImporteMora.ToString(), item.InteresMora.ToString(), item.PlanPagoId==0?String.Empty:item.PagoCuota.ToString(), item.Estado, item.FechaPagoCuota.HasValue?item.FechaPagoCuota.Value.ToShortDateString():string.Empty } } ).ToArray() }; return Json(productsData, JsonRequestBehavior.AllowGet); }
public IHttpActionResult GetGridData([FromBody] GridDataRequest request) { return(Ok(request.CreateGridDataResponse(_repository.GetData()))); }