public bool RecalculateRequestTotal(int Id)
{
var request = _context.Requests.Find(Id);
var reqTotal = (from li in _context.Lineitems.ToList()
join pr in _context.Products.ToList()
on li.ProductId equals pr.Id
where li.RequestId == Id
select new {
LineTotal = li.Quantity * pr.Price
}).Sum(t => t.LineTotal);
request.Total = reqTotal;
_context.SaveChanges();
return(true);
}
