public ActionResult IncomingExpenditureSummaryOperations(DateTime fromDate, DateTime toDate) { var nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone(); nfi.NumberGroupSeparator = " "; var model = new ExpenditureSummaryOperationsViewModel { Items = (from ie in _db.IncomingExpenditures .Include(ie => ie.FinancialAccountOperation).ThenInclude(fao => fao.Counterparty) where ie.IsProcessed == false && ie.FinancialAccountOperation.OperationDateTime >= fromDate && ie.FinancialAccountOperation.OperationDateTime < toDate.AddDays(1) select new ExpenditureSummaryOperationsItem { OperationDateTime = ie.FinancialAccountOperation.OperationDateTime.ToString("dd.MM.yyyy HH:mm"), Amount = ie.FinancialAccountOperation.Amount.ToString("#,0.00", nfi), PaymentType = "Безнал", Counterparty = ie.FinancialAccountOperation.Counterparty.Name, Comment = ie.FinancialAccountOperation.Description }).ToList() }; return(PartialView("ExpenditureSummaryOperations", model)); }
public ActionResult ExpenditureSummaryOperations(int deskGroupId, int?objectId, DateTime fromDate, DateTime toDate) { var nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone(); nfi.NumberGroupSeparator = " "; var model = new ExpenditureSummaryOperationsViewModel { Items = (from expenditure in _db.Expenditures .Include(e => e.DeskGroup).Include(e => e.Type).Include(e => e.Object) .Include(e => e.IncomingExpenditure).ThenInclude(ie => ie.FinancialAccountOperation).ThenInclude(fao => fao.Counterparty) from eo in _db.ExpenditureOperations.Where(eo => expenditure.ExpenditureId == eo.ExpenditureId) .OrderByDescending(eo => eo.OperationDateTime).Take(1).DefaultIfEmpty() where ((expenditure.PaymentTypeId == PaymentTypes.Cash && eo.OperationDateTime >= fromDate && eo.OperationDateTime < toDate.AddDays(1)) || (expenditure.PaymentTypeId == PaymentTypes.Cashless && expenditure.IncomingExpenditure.FinancialAccountOperation.OperationDateTime >= fromDate && expenditure.IncomingExpenditure.FinancialAccountOperation.OperationDateTime < toDate.AddDays(1))) && eo.OperationTypeId == ExpenditureOperation.EOType.New && expenditure.DeskGroupId == deskGroupId && (objectId == null || expenditure.ObjectId == objectId) select new ExpenditureSummaryOperationsItem { OperationDateTime = expenditure.PaymentTypeId == PaymentTypes.Cash ? eo.OperationDateTime.ToString("dd.MM.yyyy HH:mm") : expenditure.IncomingExpenditure.FinancialAccountOperation.OperationDateTime.ToString("dd.MM.yyyy HH:mm"), Amount = expenditure.Amount.ToString("#,0.00", nfi), PaymentType = expenditure.PaymentTypeId == PaymentTypes.Cash ? "Нал" : "Безнал", Counterparty = expenditure.PaymentTypeId == PaymentTypes.Cash ? "" : expenditure.IncomingExpenditure.FinancialAccountOperation.Counterparty.Name, Comment = expenditure.PaymentTypeId == PaymentTypes.Cash ? expenditure.Name : expenditure.IncomingExpenditure.FinancialAccountOperation.Description }).ToList() }; return(PartialView(model)); }