示例#1
0
        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);
        }
示例#2
0
        /// <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);
        }