public async Task <DashBoardItemSummaryVM> GetDashboardSummary() { var vm = new DashBoardItemSummaryVM { IssueCountsByStatus = await issueRepository.GetIssueCountsPerStatus(this.userSessionHelper.TeamId) }; return(vm); }
/* * public List<ActivityVM> GetTeamActivityVMs(int teamId) * { * List<ActivityVM> activityVMList = new List<ActivityVM>(); * try * { * var activityList = repo.GetTeamActivity(teamId).OrderByDescending(s => s.CreatedDate).ToList(); * * ActivityVM activityVM=new ActivityVM(); * foreach (var item in activityList) * { * if (item.ObjectType.ToUpper() == "ISSUE") * { * activityVM = GetActivityVM(item); * } * else if (item.ObjectType.ToUpper() == "ISSUECOMMENT") * { * activityVM = new CommentService(repo,SiteBaseURL).GetActivityVM(item); * } * * activityVMList.Add(activityVM); * } * } * catch (Exception ex) * { * * } * return activityVMList; * } */ /* * public ActivityVM GetActivityVM(Activity item) * { * var activityVM = new ActivityVM() { Author = item.User.FirstName, CreatedDateRelative = item.CreatedDate.ToString() }; * if (item.ActivityDesc.ToUpper() == "CREATED") * { * activityVM.Activity = item.ActivityDesc; * activityVM.ObjectTite = item.NewState; * activityVM.ObjectURL = String.Format("{0}Issues/details/{1}", SiteBaseURL, item.ObjectID); * } * return activityVM; * }*/ public DashBoardItemSummaryVM GetDashboardSummaryVM(int teamId) { var vm = new DashBoardItemSummaryVM(); var issues = repo.GetIssues(teamId); vm.CurrentItems = issues.Where(s => s.Location == LocationType.SPRNT.ToString()).Count(); vm.CompletedItems = issues.Where(s => s.Location == LocationType.ARCHV.ToString()).Count(); vm.BacklogItems = issues.Where(s => s.Location == LocationType.BKLOG.ToString()).Count(); vm.ItemsInProgress = issues.Where(s => s.Status.Name.ToUpper() == "IN PROGRESS").Count(); vm.NewItems = issues.Where(s => s.Status.Name.ToUpper() == "NEW").Count(); return(vm); }
//var issueVM = new IssueVM { ID = bug.ID, Title = bug.Title, Description = bug.Description }; //issueVM.OpenedBy = bug.CreatedBy.FirstName; // issueVM.PriorityName = bug.PriorityName.Name; // issueVM.StatusName = bug.StatusName.Name; // issueVM.CategoryName = bug.CategoryName.Name; // issueVM.Project = (bug.Project!=null?bug.Project.Name:""); // issueVM.CreatedDate = bug.CreatedDate.ToShortDateString(); public DashBoardItemSummaryVM GetDashboardSummaryVM(int teamId) { var vm = new DashBoardItemSummaryVM(); using (var db = new TeamEntitiesConn()) { var statusCounts = db.Issues .Where(s => s.TeamID == teamId) .GroupBy(d => d.Status, g => g.ID, (k, i) => new ItemCount { ItemId = k.ID, ItemName = k.Name, Count = i.Count() }).ToList(); vm.IssueCountsByStatus = statusCounts; } return(vm); }