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