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