/// <summary>
        ///
        /// </summary>
        /// <param name="ModuleID"></param>
        /// <param name="UserGUID"></param>
        /// <returns></returns>
        public TilesDTO GetTilesCount(string ModuleID, string UserGUID)
        {
            List <TblTasks>    Tasks    = (List <TblTasks>)_taskRepository.GetTasksByUserID(UserGUID);
            List <TblProjects> Projects = (List <TblProjects>)_projectRepository.GetProjectsByUserID(ModuleID, UserGUID);
            TilesDTO           tilesDTO = new TilesDTO();

            // For Tiles
            tilesDTO.ActiveProjectsCount  = Projects.Where(x => x.ProjectStatus == 2).ToList().Count(); // In Progress Projects
            tilesDTO.PendingProjectsCount = Projects.Where(x => x.ProjectStatus == 3).ToList().Count(); // In Hold (Pending) Projects

            tilesDTO.TotalTasksCount     = Tasks.Count();
            tilesDTO.CompletedTasksCount = Tasks.Where(x => x.TaskStatus == 4).ToList().Count();        // Completed Tasks

            tilesDTO.OverDueProjectsCount = Projects.Where(x => x.TargetDate < DateTime.Now).Count();
            tilesDTO.OverDueTasksCount    = Tasks.Where(x => x.DueDate < DateTime.Now).Count();

            // For Pie Chart
            tilesDTO.NewProjectsCount  = Projects.Where(x => x.ProjectStatus == 1).ToList().Count();      // New Projects
            tilesDTO.HoldProjectsCount = Projects.Where(x => x.ProjectStatus == 3).ToList().Count();      // Hold Projects
            //ActiveProjectsCount
            tilesDTO.CompletedProjectsCount = Projects.Where(x => x.ProjectStatus == 4).ToList().Count(); // Completed Projects
            tilesDTO.RejectedProjectsCount  = Projects.Where(x => x.ProjectStatus == 5).ToList().Count(); // Rejected Projects

            return(tilesDTO);
        }
예제 #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="UserID"></param>
        /// <param name="ModuleID"></param>
        /// <returns></returns>
        public TilesDTO GetTilesCount(int UserID, string ModuleID)
        {
            List <TblTasks>    Tasks    = (List <TblTasks>)_taskRepository.GetTasksByUserID(UserID);
            List <TblProjects> Projects = (List <TblProjects>)_projectRepository.GetProjectsByUserID(UserID, ModuleID);
            TilesDTO           tilesDTO = new TilesDTO();

            tilesDTO.ActiveTasksCount   = Tasks.Count();
            tilesDTO.OverDueTasksCount  = Tasks.Where(x => x.DueDate < DateTime.Now).Count();
            tilesDTO.TotalProjectsCount = Projects.Count();
            return(tilesDTO);
        }