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