public string GetTaskDisplayValue(int taskId, string value, string propname) { Worktask task = this.worktaskRepository.Detail(taskId); if (task != null) { if (propname.Equals("Status")) { int id = (int)(task.WorkflowInstance.WorkflowID == null ? 0 : task.WorkflowInstance.WorkflowID); return(WorkflowService.GetInstance().GetState(id, int.Parse(value)).Name); } else if (propname.Equals("Priority")) { return(CategoryService.GetInstance().GetCategoryName(int.Parse(value), Contain.CatType.Priority)); } else if (propname.Equals("TaskType")) { return(CategoryService.GetInstance().GetCategoryName(int.Parse(value), Contain.CatType.Category)); } else if (propname.Equals("BoardID")) { return(task.Board.Title); } else if (propname.Equals("Assignee")) { return(AccountHelper.GetUserFullname(task.AssigneeAcc.UserName)); } else if (propname.Equals("Reporter")) { return(AccountHelper.GetUserFullname(task.ReporterAcc.UserName)); } } return(value); }
public string loadReportFile(List <TaskReportRecordModel> data, List <TaskReportRecordModel> dataPrev) { var fileinfo = new FileInfo(strTempFile); try { using (_reportExcelPck = new ExcelPackage(fileinfo)) { ExcelWorkbook excelWorkBook = _reportExcelPck.Workbook; // generate sheet 1 ExcelWorksheet excelWorksheet = excelWorkBook.Worksheets.First(); String reporttitle = excelWorksheet.Cells[4, 1].Value.ToString(); reporttitle = reporttitle.Replace("[month]", _reportTime.Month.ToString()).Replace("[year]", _reportTime.Year.ToString()); excelWorksheet.Cells[4, 1].Value = reporttitle; int index = 0; int catid = -1; bool newcat = false; int groupcount = 0; int startingrow = 10; foreach (TaskReportRecordModel item in data) { newcat = false; if (catid < 0 || catid != (int)item.TaskType) { catid = (int)item.TaskType; newcat = true; } if (newcat) { excelWorksheet.InsertRow(startingrow + index + groupcount, 1, startingrow - 1); excelWorksheet.Cells[startingrow + index + groupcount, 1].Value = Convert.ToChar(65 + groupcount).ToString(); excelWorksheet.Cells[startingrow + index + groupcount, 2].Value = CategoryService.GetInstance().GetCategoryName((int)item.TaskType, Contain.CatType.Category); groupcount++; } excelWorksheet.InsertRow(startingrow + 1 + index + groupcount, 1, startingrow + index + groupcount); excelWorksheet.Cells[startingrow + index + groupcount, 1].Value = index + 1; excelWorksheet.Cells[startingrow + index + groupcount, 2].Value = item.Title; excelWorksheet.Cells[startingrow + index + groupcount, 3].Value = item.AssigneeName; if (item.CreationDate.Month == _reportTime.Month && item.CreationDate.Year == _reportTime.Year) { excelWorksheet.Cells[startingrow + index + groupcount, 4].Value = "X"; } if (item.LastUpdateDate.Month == _reportTime.Month && item.LastUpdateDate.Year == _reportTime.Year) { excelWorksheet.Cells[startingrow + index + groupcount, 5].Value = "X"; } if (item.Status == 1 || item.Status == 2) { excelWorksheet.Cells[startingrow + index + groupcount, 6].Value = "X"; } if (item.Status == 3 || item.Status == 4 || item.Status == 5) { excelWorksheet.Cells[startingrow + index + groupcount, 7].Value = "X"; } if (item.Status == 6) { excelWorksheet.Cells[startingrow + index + groupcount, 8].Value = "X"; } index++; } //_reportExcelPck.Save(); // generate sheet 2 excelWorksheet = excelWorkBook.Worksheets[2]; DateTime prevMonth = _reportTime.AddMonths(-1); reporttitle = excelWorksheet.Cells[4, 1].Value.ToString(); reporttitle = reporttitle.Replace("[month]", prevMonth.Month.ToString()).Replace("[year]", prevMonth.Year.ToString()); excelWorksheet.Cells[4, 1].Value = reporttitle; index = 0; catid = -1; newcat = false; groupcount = 0; foreach (TaskReportRecordModel item in dataPrev) { newcat = false; if (catid < 0 || catid != (int)item.TaskType) { catid = (int)item.TaskType; newcat = true; } if (newcat) { excelWorksheet.InsertRow(startingrow + index + groupcount, 1, startingrow - 1); excelWorksheet.Cells[startingrow + index + groupcount, 1].Value = Convert.ToChar(65 + groupcount).ToString(); excelWorksheet.Cells[startingrow + index + groupcount, 2].Value = CategoryService.GetInstance().GetCategoryName((int)item.TaskType, Contain.CatType.Category); groupcount++; } excelWorksheet.InsertRow(startingrow + 1 + index + groupcount, 1, startingrow + index + groupcount); excelWorksheet.Cells[startingrow + index + groupcount, 1].Value = index + 1; excelWorksheet.Cells[startingrow + index + groupcount, 2].Value = item.Title; excelWorksheet.Cells[startingrow + index + groupcount, 3].Value = item.AssigneeName; excelWorksheet.Cells[startingrow + index + groupcount, 4].Value = item.CreationDate.ToString("dd-MM-yyyy"); excelWorksheet.Cells[startingrow + index + groupcount, 5].Value = item.LastUpdateDate.ToString("dd-MM-yyyy"); if (item.Status == 1 || item.Status == 2) { excelWorksheet.Cells[startingrow + index + groupcount, 6].Value = "X"; } if (item.Status == 3 || item.Status == 4 || item.Status == 5) { excelWorksheet.Cells[startingrow + index + groupcount, 7].Value = "X"; } if (item.Status == 6) { excelWorksheet.Cells[startingrow + index + groupcount, 8].Value = "X"; } index++; } _reportExcelPck.Save(); _reportExcelPck.Dispose(); return(strTempFile); } } catch { } return(String.Empty); }
public static void Initialize() { ICategoryRepository catRepository = (ICategoryRepository)System.Web.Mvc.DependencyResolver.Current.GetService(typeof(ICategoryRepository)); IAccountRepository accRepository = (IAccountRepository)System.Web.Mvc.DependencyResolver.Current.GetService(typeof(IAccountRepository)); IBoardRepository boardRepository = (IBoardRepository)System.Web.Mvc.DependencyResolver.Current.GetService(typeof(IBoardRepository)); IWorkflowRepository workflowRepository = (IWorkflowRepository)System.Web.Mvc.DependencyResolver.Current.GetService(typeof(IWorkflowRepository)); IWorktaskRepository worktaskRepository = (IWorktaskRepository)System.Web.Mvc.DependencyResolver.Current.GetService(typeof(IWorktaskRepository)); CategoryService catService; UserPermissionService userService; KanbanService kanbanService; WorkflowService workflowService; BoardService boardService; WorktaskService worktaskService; if (CategoryService.GetInstance() == null) { catService = new CategoryService(catRepository); } else { catService = CategoryService.GetInstance(); } if (UserPermissionService.GetInstance() == null) { userService = new UserPermissionService(accRepository); } else { userService = UserPermissionService.GetInstance(); } if (KanbanService.GetInstance() == null) { kanbanService = new KanbanService(boardRepository, accRepository); } else { kanbanService = KanbanService.GetInstance(); } if (WorkflowService.GetInstance() == null) { workflowService = new WorkflowService(workflowRepository); } else { workflowService = WorkflowService.GetInstance(); } if (BoardService.GetInstance() == null) { boardService = new BoardService(boardRepository); } else { boardService = BoardService.GetInstance(); } if (WorktaskService.GetInstance() == null) { worktaskService = new WorktaskService(worktaskRepository, catRepository); } else { worktaskService = WorktaskService.GetInstance(); } }