public ActionResult Allocations()
        {
            ViewBag.Message = "Your project allocation page.";

            var allocations = _repo.GetAllocation();

            var allocationsList = new List <AllocationDTO>();

            foreach (var allocation in allocations)
            {
                var users    = _repo.GetUsers().Where(u => u.Id == allocation.UsersId).FirstOrDefault();
                var projects = _repo.GetProjects().Where(p => p.Id == allocation.ProjectsId).FirstOrDefault();

                //data transfer object
                allocationsList.Add(new AllocationDTO()
                {
                    Username = users.Username, ProjectName = projects.ProjectName
                });
            }

            return(View(allocationsList));
        }