public async Task <IActionResult> Index() { var currentUser = await GetCurrentUserAsync(); var roleList = await _userManager.GetRolesAsync(currentUser); //var CompletedTasks = await _context.WorkTasks.Where(m => m.Status.ToString() == "Completed" && m.employeeId == currentUser.name).ToListAsync(); var ActiveTasks = await _context.WorkTasks.Where(m => m.Status.ToString() != "Completed" && m.employeeId == currentUser.name).ToListAsync(); if (roleList.Contains("Employee") || roleList.Contains("Purchaser")) { var user = await _userManager.Users.ToListAsync(); var EmployeeTodo = await _context.ToDos.Include(m => m.EmployeeTodo).ToListAsync(); List <ToDo> pick2List = new List <ToDo>(); List <EmployeeTodo> bridge = await _context.EmployeeTodo.ToListAsync(); List <int> toIDs = new List <int>(); foreach (EmployeeTodo et in bridge) { if (currentUser.Id == et.employee.Id) { toIDs.Add(et.ToDoId); } } foreach (ToDo td in EmployeeTodo) { if (toIDs.Contains(td.ToDoId) && td.Status.ToString() == "Active") { pick2List.Add(td); } } Dashboard_WorkTaskToDo WorkTaskToDo = new Dashboard_WorkTaskToDo() { EmpToDo = pick2List, ActiveTasks = ActiveTasks, //CompletedTasks = CompletedTasks, User = user }; return(View(WorkTaskToDo)); } else { var user = await _userManager.Users.ToListAsync(); var EmployeeTodo = await _context.ToDos.Include(m => m.EmployeeTodo).ToListAsync(); Dashboard_WorkTaskToDo WorkTaskToDo = new Dashboard_WorkTaskToDo() { EmpToDo = EmployeeTodo, ActiveTasks = ActiveTasks, //CompletedTasks = CompletedTasks, User = user }; return(View(WorkTaskToDo)); } }
public async Task <IActionResult> AllTasks() { var allTasksActive = await _context.WorkTasks.Where(m => m.Status.ToString() != "Completed").ToListAsync(); var allTasksCompleted = await _context.WorkTasks.Where(m => m.Status.ToString() == "Completed").ToListAsync(); Dashboard_WorkTaskToDo WorkTaskToDo = new Dashboard_WorkTaskToDo(); WorkTaskToDo.ActiveTasks = allTasksActive; WorkTaskToDo.CompletedTasks = allTasksCompleted; return(View(WorkTaskToDo)); }