public byte[] GetCustomerExcel(int pageNumber, string searchTerm, int numberOfRecords, int rating) { CustomerDataAccess obj = new CustomerDataAccess(); var result = obj.GetAllCustomers(pageNumber, searchTerm, numberOfRecords, rating); return(EnquiryBusinessLogic.ExportExcel(MapDataTableForCustomer(result), "Customer", false, "")); }
public byte[] GetUserTaskExcel(string pageNumber, string projectName, string phaseName, string userId, string fromDate, string toDate, string numberOfrecords, string userName) { ReportsDataAccess obj = new ReportsDataAccess(); var result = obj.GetAllUserTaskReport(pageNumber, projectName, phaseName, userId, fromDate, toDate, numberOfrecords); return(EnquiryBusinessLogic.ExportExcel(MapDataTableForTask(result), string.Format("User Task - {0}", userName), false, "")); }
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)); }