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