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