public IEnumerable <ActivityRetrieveViewModel> getAllUnassinedTasks() { List <ActivityRetrieveViewModel> activityViewModelList = new List <ActivityRetrieveViewModel>(); var allItems = db.Activities.ToList().Where(ac => ac.assignee == 0 || ac.status == "Rated"); if (allItems != null) { foreach (var allItem in allItems) { ActivityRetrieveViewModel activityViewModel = new ActivityRetrieveViewModel(); var assignerDetailsByName = db.UserTu_Tu.Find(allItem.assigner); var assigneeDetailsByName = db.UserTu_Tu.Find(allItem.assignee); if (assignerDetailsByName != null) { activityViewModel.assigner = assignerDetailsByName.name; } if (assigneeDetailsByName != null) { activityViewModel.assignee = assigneeDetailsByName.name; } int days = (allItem.expiryDate - DateTime.Today).Days; activityViewModel.title = allItem.title; activityViewModel.description = allItem.description; activityViewModel.expiryDate = allItem.expiryDate.ToString("MM/dd/yyyy"); activityViewModel.completeness = allItem.completeness; activityViewModel.status = allItem.status; activityViewModel.starCount = allItem.starCount; activityViewModel.filePath = allItem.filePath; activityViewModel.remainingDays = days; activityViewModelList.Add(activityViewModel); } } return(activityViewModelList); }
/// <summary> /// return todo,progress and done Activities /// </summary> /// <returns></returns> public IEnumerable <ActivityRetrieveViewModel> getActivityList() { List <ActivityRetrieveViewModel> activityViewModelList = new List <ActivityRetrieveViewModel>(); int loggedUserId = 0; if (AccountController.uName != null) { User_TuTU user = db.UserTu_Tu.Where(ac => ac.name.Equals(AccountController.uName)).FirstOrDefault(); loggedUserId = user.uid; } var allItems = db.Activities.ToList().Where(ac => ac.assignee != 0 && ac.assignee == loggedUserId); if (allItems != null) { foreach (var allItem in allItems) { ActivityRetrieveViewModel activityViewModel = new ActivityRetrieveViewModel(); var assignerDetailsByName = db.UserTu_Tu.Find(allItem.assigner); var assigneeDetailsByName = db.UserTu_Tu.Find(allItem.assignee); if (assignerDetailsByName != null) { activityViewModel.assigner = assignerDetailsByName.name; } if (assigneeDetailsByName != null) { activityViewModel.assignee = assigneeDetailsByName.name; } int days = (allItem.expiryDate - DateTime.Today).Days; activityViewModel.title = allItem.title; activityViewModel.description = allItem.description; activityViewModel.expiryDate = allItem.expiryDate.ToString("MM/dd/yyyy"); activityViewModel.completeness = allItem.completeness; activityViewModel.status = allItem.status; activityViewModel.starCount = allItem.starCount; activityViewModel.filePath = allItem.filePath; activityViewModel.remainingDays = days; activityViewModelList.Add(activityViewModel); } } return(activityViewModelList); }