// 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));
}
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));
}