コード例 #1
0
        // GET: TotalOfProfits/Details/5



        public IActionResult Summation(DateTime Date)
        {
            SummationVm model = new SummationVm();
            string      Datee = Date.ToShortDateString();

            var IMerchantReciepts = _context.IMerchantReciept.Include(m => m.Merchant).ToList();

            model.IMerchantReciepts = IMerchantReciepts.Where(m => m.Date.ToShortDateString() == Datee).ToList();

            var ISellerReciepts = _context.ISellerReciepts.Include(m => m.Merchant).ToList();

            model.ISellerReciepts = ISellerReciepts.Where(m => m.Date.ToShortDateString() == Datee).ToList();
            // labour
            var additionalLabour = _context.AdditionalPayments.ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Name == "عمال").Sum(x => x.Value);
            //var debtSarhaLabour = _context.Debts_Sarhas.Include(x=>x.Debt).ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Debt.DebtName == "عمال").Sum(x => x.Price);
            var HalakaHalekLabour = _context.HalakaHaleks.Include(x => x.Debt).ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Debt.DebtName == "عمال").Sum(x => x.Price);

            model.Labour = additionalLabour + HalakaHalekLabour;
            // ice
            var additionalIce = _context.AdditionalPayments.ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Name == "ثلج").Sum(x => x.Value);
            //var debtSarhaIce = _context.Debts_Sarhas.Include(x => x.Debt).ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Debt.DebtName == "ثلج").Sum(x => x.Price);
            var HalakaHalekIce = _context.HalakaHaleks.Include(x => x.Debt).ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString() && x.Debt.DebtName == "ثلج").Sum(x => x.Price);

            model.Ice = additionalIce + HalakaHalekIce;
            var TodayProfit = _context.TotalOfProfits.ToList().Where(x => x.Date.ToShortDateString() == Date.ToShortDateString());

            if (TodayProfit.Count() > 0)
            {
                ViewBag.Profit = TodayProfit.FirstOrDefault().Profit;
            }
            return(View(model));
        }
コード例 #2
0
        public IActionResult SummationOfAday()
        {
            SummationVm model = new SummationVm();
            string      Datee = TimeNow().AddDays(10).ToShortDateString();

            var IMerchantReciepts = _context.IMerchantReciept.Include(m => m.Merchant).ToList();

            model.IMerchantReciepts = IMerchantReciepts.Where(m => m.Date.ToShortDateString() == Datee).ToList();

            var ISellerReciepts = _context.ISellerReciepts.Include(m => m.Merchant).ToList();

            model.ISellerReciepts = ISellerReciepts.Where(m => m.Date.ToShortDateString() == Datee).ToList();
            return(View(model));
        }