// 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));
        }
示例#2
0
        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));
        }