public List <UserTaskReportModel> GetAllUserTaskReport(string pageNumber, string projectName, string phaseName, string userId, string fromDate, string toDate, string numberOfrecords)
{
ReportsDataAccess obj = new ReportsDataAccess();
var result = obj.GetAllUserTaskReport(pageNumber, projectName, phaseName, userId, fromDate, toDate, numberOfrecords);
return(MapUserTaskReport(result));
}
/// <summary>
/// 檢查是否有資料可匯出
/// </summary>
/// <returns></returns>
public ActionResult CheckExportData()
{
var data = ReportsDataAccess.GetARAPReportData(isAll: true);
var canExport = data.Count > 0;
return(Json(new { canExport = canExport, total = data.Count }, JsonRequestBehavior.AllowGet));
}
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[] 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 bool DeleteSubTask(int taskId)
{
ReportsDataAccess obj = new ReportsDataAccess();
obj.DeleteProjectTask(taskId);
return(true);
}
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));
}
public Reports(string ExchangeConnectionString, string TicketingConnectionString)
{
reportsDataAccess = new ReportsDataAccess(CommonUtilities.SiteConnectionString(ExchangeConnectionString), CommonUtilities.TicketingConnectionString(TicketingConnectionString));
}
public Reports()
{
reportsDataAccess = new ReportsDataAccess();
}
public ReportsManager()
{
_reportsDataAccess = new ReportsDataAccess();
}
