// GET: MerchantReciepts/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var merchantReciept = await _context.MerchantReciepts .Include(m => m.Merchant) .FirstOrDefaultAsync(m => m.MerchantRecieptID == id); if (merchantReciept == null) { return(NotFound()); } ViewBag.Items = _context.MerchantRecieptItems.Where(i => i.MerchantRecieptID == id).Include(x => x.Fish).Include(x => x.ProductionType).Include(x => x.Boat); MerchantRecDetailsVm model = new MerchantRecDetailsVm(); model.MerchantReciept = merchantReciept; model.NormalMerchantItems = _context.MerchantRecieptItems.Include(c => c.Fish).Include(c => c.Boat).Include(c => c.ProductionType).Where(c => c.MerchantRecieptID == merchantReciept.MerchantRecieptID && c.AmountId == null).ToList(); model.AmountMerchantItems = _context.MerchantRecieptItems.Include(c => c.Fish).Include(c => c.Boat).Include(c => c.ProductionType).Where(c => c.MerchantRecieptID == merchantReciept.MerchantRecieptID && c.AmountId != null).ToList(); var results = from p in model.AmountMerchantItems group p.MerchantRecieptItemID by p.AmountId into g select new AmountVm { AmountId = g.Key, items = g }; model.Amounts = results; return(View(model)); }
public IActionResult LatestRec(int?id) { //System.Threading.Thread.Sleep(5000); if (id == null) { return(NotFound()); } var merchantReceipts = _context.MerchantReciepts.Include(b => b.Merchant).Where(x => x.MerchantID == id); int merchantReceiptID; MerchantReciept mRec; if (merchantReceipts.Count() == 0) { return(NotFound()); } else { merchantReceiptID = merchantReceipts.Max(x => x.MerchantRecieptID); mRec = _context.MerchantReciepts.Find(merchantReceiptID); } if (mRec == null) { return(NotFound()); } MerchantRecDetailsVm model = new MerchantRecDetailsVm(); model.MerchantReciept = mRec; model.NormalMerchantItems = _context.MerchantRecieptItems.Include(c => c.Fish).Include(c => c.Boat).Include(c => c.ProductionType).Where(c => c.MerchantRecieptID == mRec.MerchantRecieptID && c.AmountId == null).ToList(); model.AmountMerchantItems = _context.MerchantRecieptItems.Include(c => c.Fish).Include(c => c.Boat).Include(c => c.ProductionType).Where(c => c.MerchantRecieptID == mRec.MerchantRecieptID && c.AmountId != null).ToList(); var results = from p in model.AmountMerchantItems group p.MerchantRecieptItemID by p.AmountId into g select new AmountVm { AmountId = g.Key, items = g }; model.Amounts = results; return(PartialView(model)); }