public IActionResult GenerateIncome(DateTime date1, DateTime date2)
{
var incomeByDates = _context.Protocols
.Include(p => p.Patient)
.Include(t => t.Therapy)
.Include(a => a.Anamnesis)
.Include(d => d.Diagnosis).Where(x => x.Date >= date1 && x.Date <= date2).ToList();
var expenses = _context.Expenses
.Include(et => et.ExpensesType)
.Where(x => x.ExpenseDate >= date1 && x.ExpenseDate <= date2).OrderBy(x => x.ExpenseDate).ToList();
var ProcurementExpenses = _context.Procurements
.Include(s => s.Supplier)
.Where(x => x.ProcurementDate >= date1 && x.ProcurementDate <= date2).ToList();
incomeByDates = incomeByDates.Where(x => x.PaidFavor == true).ToList();
var vm = new ProtocolDatesViewModel()
{
Protocols = incomeByDates,
Expenses = expenses,
Procurements = ProcurementExpenses,
StartDate = date1,
EndDate = date2
};
return(new ViewAsPdf("IncomeReport", vm));
}
public IActionResult GeneratePDFRange(DateTime date1, DateTime date2)
{
var protocolByDates = _context.Protocols
.Include(p => p.Patient)
.Include(t => t.Therapy)
.Include(a => a.Anamnesis)
.Include(d => d.Diagnosis).Where(x => x.Date >= date1 && x.Date <= date2).OrderBy(x => x.Date).ToList();
var vm = new ProtocolDatesViewModel()
{
Protocols = protocolByDates,
StartDate = date1,
EndDate = date2
};
return(new ViewAsPdf("RangeReportProtocol", vm));
}
