public JsonResult DataRequested() { var gridModel = new LeasingDatabase.Models.Grid.BillingJqGridModel(); var db = new AuleaseEntities(); string SN = Session["SN"].ToString(); SetUpGrid(gridModel.OrdersGrid); var leases = db.Leases.Where(n => n.Component.SerialNumber == SN); var model = leases.Select(n => new BillingModel { Id = n.Id, BeginDate = n.BeginDate, EndDate = n.EndDate, StatementName = n.StatementName, Timestamp = n.Timestamp, ContractNumber = n.ContractNumber, Fund = n.Department.Fund, Org = n.Department.Org, Program = n.Department.Program, RateLevel = n.Overhead.RateLevel, MonthlyCharge = n.MonthlyCharge.HasValue ? n.MonthlyCharge.Value : 0M, //n.MonthlyCharge??0M, Term = n.Overhead.Term, PrimaryCharge = (n.Charges.Where(o => o.Type.Name == "CPU" || o.Type.Name == "Laptop" || o.Type.Name == "Server" || o.Type.Name == "Monitor").Count() > 0) ? n.Charges.Where(o => o.Type.Name == "CPU" || o.Type.Name == "Laptop" || o.Type.Name == "Server" || o.Type.Name == "Monitor").Where(p => p.Price != null).Sum(o => o.Price) : 0M, SecondaryCharges = (n.Charges.Where(o => o.Type.Name != "CPU" && o.Type.Name != "Laptop" && o.Type.Name != "Server" && o.Type.Name != "Monitor").Count() > 0) ? n.Charges.Where(o => o.Type.Name != "CPU" && o.Type.Name != "Laptop" && o.Type.Name != "Server" && o.Type.Name != "Monitor").Where(p => p.Price != null).Sum(o => o.Price) : 0M }); return(gridModel.OrdersGrid.DataBind(model)); }
public ActionResult SerialNumber(string SerialNumber) { Session["SN"] = SerialNumber; var gridModel = new LeasingDatabase.Models.Grid.BillingJqGridModel(); var ordersGrid = gridModel.OrdersGrid; SetUpGrid(ordersGrid); return(View(gridModel)); }