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