示例#1
0
        /// <summary>
        /// The PersonReport displays all the people and the projects they are assigned to, with the associated roles, plus hourly rate.
        /// </summary>
        /// <returns>The <see cref="IActionResult"/></returns>
        public IActionResult PersonReport()
        {
            //Read in all the repos for manipulation.
            var projects     = _projectRepo.ReadAll().ToList();
            var people       = _personRepo.ReadAll().ToList();
            var roles        = _roleRepo.ReadAll().ToList();
            var projectRoles = _projectRoleRepo.ReadAll().ToList();


            //Instantiate and declaire ProjectReport VM
            PersonReportVM model = new PersonReportVM
            {
                Projects                = _projectRepo.ReadAll().ToList(),
                Person                  = _personRepo.ReadAll().ToList(),
                Roles                   = _roleRepo.ReadAll().ToList(),
                ProjectRoles            = _projectRoleRepo.ReadAll().ToList(),
                HourlyTotal             = new Dictionary <Project, decimal>(),
                ListOfProjectsAndPeople = new Dictionary <string, Dictionary <Project, Dictionary <Role, decimal> > >()
            };


            //Loop through each project
            foreach (var pro in model.Person)
            {
                List <int> projectsList = new List <int>();
                projectsList = _projectRoleRepo.SelectProjectsAssignedToPeople(pro.Id);
                Dictionary <Project, Dictionary <Role, decimal> > projectAndRole = new Dictionary <Project, Dictionary <Role, decimal> >();

                //Loop through each person
                foreach (var p in projectsList)
                {
                    //Get a person
                    var projectAssigned = _projectRepo.Read(p);

                    //Get all the project role by user id and project id
                    List <int> roleIds = _projectRoleRepo.SelectRoleOnProjectByPersonId(p, pro.Id);

                    //Create a list to store roles and hourly rate relationships
                    Dictionary <Role, decimal> assignedRoles = new Dictionary <Role, decimal>();

                    //Loop through each role
                    foreach (var role in roleIds)
                    {
                        //Get each hourly rate for each project, person, and role. Then add it to a dictionary.
                        var readRoles = _roleRepo.Read(role);
                        var hourly    = _projectRoleRepo.HourlyRate(pro.Id, p, role);

                        //If the role does not come back null, add it to the list.
                        if (readRoles != null)
                        {
                            assignedRoles.Add(readRoles, hourly);
                        }
                    }


                    //Check to see if the project has been added
                    if (!projectAndRole.ContainsKey(projectAssigned))
                    {
                        //Add the user and roles if they have not been added
                        projectAndRole.Add(projectAssigned, assignedRoles);
                    }
                }

                //Define full name
                string fullName = $"{pro.FirstName} {pro.LastName}";

                //Check to see if the person key has been added.
                if (!model.ListOfProjectsAndPeople.ContainsKey(fullName))
                {
                    //Put all the dictionaries together.
                    model.ListOfProjectsAndPeople.Add(fullName, projectAndRole);
                }
            }

            return(View(model));
        }
示例#2
0
        /// <summary>
        /// The ProjectReport gathers a list of the projects, people working on the project, and roles that each person has on each project. (See User Stories #7)
        /// </summary>
        /// <returns>The <see cref="IActionResult"/> containing the VM</returns>
        public IActionResult ProjectReport()
        {
            var projects     = _projectRepo.ReadAll().ToList();
            var people       = _personRepo.ReadAll().ToList();
            var roles        = _roleRepo.ReadAll().ToList();
            var projectRoles = _projectRoleRepo.ReadAll().ToList();


            //Instantiate and declaire ProjectReport VM
            ProjectReportVM model = new ProjectReportVM
            {
                Projects                = _projectRepo.ReadAll().ToList(),
                Person                  = _personRepo.ReadAll().ToList(),
                Roles                   = _roleRepo.ReadAll().ToList(),
                ProjectRoles            = _projectRoleRepo.ReadAll().ToList(),
                HourlyTotal             = new Dictionary <Project, decimal>(),
                Test                    = 0,
                ListOfProjectsAndPeople = new Dictionary <Project, Dictionary <string, Dictionary <Role, decimal> > >()
            };


            //Loop through each project
            foreach (var pro in model.Projects)
            {
                List <int> persons = new List <int>();
                persons = _projectRoleRepo.SelectPeopleOnProject(pro.Id);
                Dictionary <string, Dictionary <Role, decimal> > personAndRole = new Dictionary <string, Dictionary <Role, decimal> >();

                //Loop through each person
                foreach (var p in persons)
                {
                    //Get a person
                    var personAssigned = _personRepo.Read(p);

                    //Use string interpulation to create the name
                    var name = $"{personAssigned.FirstName} {personAssigned.LastName}";
                    //List<string> peopleOnProject = _personRepo.SelectAllPeopleById(p);

                    //Get all the project role by user id and project id
                    List <int> roleIds = _projectRoleRepo.SelectRoleOnProjectByPersonId(pro.Id, p);

                    //Create a list to store roles and hourly rate relationships
                    Dictionary <Role, decimal> assignedRoles = new Dictionary <Role, decimal>();


                    //Loop through each role
                    foreach (var role in roleIds)
                    {
                        //Get each hourly rate for each project, person, and role. Then add it to a dictionary.
                        var readRoles = _roleRepo.Read(role);
                        var hourly    = _projectRoleRepo.HourlyRate(p, pro.Id, role);

                        //If the role isn't null, add it to the list.
                        if (readRoles != null)
                        {
                            assignedRoles.Add(readRoles, hourly);
                        }
                    }


                    //Check to see if the user has been added
                    if (!personAndRole.ContainsKey(name))
                    {
                        //Add the user and roles if they have not been added
                        personAndRole.Add(name, assignedRoles);
                    }
                }

                //Put all the dictionaries together.
                model.ListOfProjectsAndPeople.Add(pro, personAndRole);
            }

            return(View(model));
        }