// GET: Owner public ActionResult Index() { Context _context = new Context(); OwnerInventoryViewModel ownerInv = new OwnerInventoryViewModel(); ownerInv.Inventory = (from aw in _context.ArtWork join ip in _context.IndividualPiece on aw.ArtWorkId equals ip.ArtWorkId join ar in _context.Artist on aw.ArtistId equals ar.ArtistId orderby ip.IndividualPieceId select new OwnerInventory { Title = aw.Title, Name = ar.Name, Cost = ip.Cost, Price = ip.Price, IndividualPieceId = ip.IndividualPieceId }).ToList(); return(View(ownerInv)); }
public ActionResult Sold(double days) { var today = DateTime.Today; Context _context = new Context(); OwnerInventoryViewModel soldInv = new OwnerInventoryViewModel(); soldInv.Inventory = (from aw in _context.ArtWork join ip in _context.IndividualPiece on aw.ArtWorkId equals ip.ArtWorkId join ar in _context.Artist on aw.ArtistId equals ar.ArtistId join inv in _context.Invoice on ip.IndividualPieceId equals inv.IndividualPieceId orderby ip.IndividualPieceId where ip.Sold == true && DbFunctions.DiffDays(inv.InvoiceDate, DateTime.Now) <= days select new OwnerInventory { Title = aw.Title, Name = ar.Name, Cost = ip.Cost, Price = ip.Price, Profit = ip.Price - ip.Cost, IndividualPieceId = ip.IndividualPieceId }).ToList(); decimal totalProfit = 0; for (var i = 0; i < soldInv.Inventory.Count; i++) { totalProfit += soldInv.Inventory[i].Profit; } soldInv.TotalProfit = totalProfit; return(View(soldInv)); }