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