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