public List <ExpenseReportModel> GetAllExpensesReport(string pageNumber, string searchTerm, string category, string fromDate, string toDate, string expenseFor) { ReportsDataAccess obj = new ReportsDataAccess(); var result = obj.GetAllExpensesReport(pageNumber, searchTerm, category, fromDate, toDate, expenseFor, 10); return(MapExpenseReport(result)); }
public byte[] GetExpenseExcel(string pageNumber, string searchTerm, string category, string fromDate, string toDate, string expenseFor) { ReportsDataAccess obj = new ReportsDataAccess(); var result = obj.GetAllExpensesReport(1.ToString(), searchTerm, category, fromDate, toDate, expenseFor, 10000); string[] columns = { Convert.ToString(result.Rows[0]["TotalExpense"]) }; return(EnquiryBusinessLogic.ExportExcel(MapDataTableForExpense(result), "Expense", false, columns)); }