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 ListarDetalle(GridDataRequest request) { int transferenciaid = request.DataFilters().Count > 0 ? int.Parse(request.DataFilters()["TransferenciaId"]) : 0; if (transferenciaid == 0) { return(Json(null, JsonRequestBehavior.AllowGet)); } const int totalRecords = 10; var productsData = new { total = 1, page = 1, records = totalRecords, rows = (from item in TransferenciaBL.ListarDetalleTransferencia(transferenciaid) select new { id = item.ArticuloId, cell = new string[] { item.TransferenciaId.ToString(), item.ArticuloId.ToString(), item.Articulo, item.Cantidad.ToString(), item.Series, item.TransferenciaId.ToString() + "," + item.ArticuloId.ToString() } } ).ToArray() }; return(Json(productsData, JsonRequestBehavior.AllowGet)); }
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 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 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 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 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); }