public JsonResult DataRequested()
{
var gridModel = new LeasingDatabase.Models.Grid.OverheadRateJqGridModel();
var db = new AuleaseEntities();
SetUpGrid(gridModel.OrdersGrid);
List <Overhead> overhead = new List <Overhead>();
var Overhead = db.Overheads.Select(n => new { n.TypeId, n.Term, n.RateLevel }).Distinct();
foreach (var over in Overhead)
{
overhead.Add(db.Overheads.Where(n => n.TypeId == over.TypeId && n.Term == over.Term && n.RateLevel == over.RateLevel).OrderByDescending(n => n.BeginDate).FirstOrDefault());
}
var model = overhead.Select(n => new OverheadModel
{
Id = n.Id,
Type = n.Type.Name,
Rate = n.Rate,
RateLevel = n.RateLevel,
Term = n.Term
}).AsQueryable();
return(gridModel.OrdersGrid.DataBind(model));
}
//
// GET: /OverheadRate/
public ActionResult Index()
{
var gridModel = new LeasingDatabase.Models.Grid.OverheadRateJqGridModel();
var ordersGrid = gridModel.OrdersGrid;
SetUpGrid(ordersGrid);
return(View(gridModel));
}
