Exemplo n.º 1
0
        [HttpGet]       //Get Projects Page
        public ActionResult projectsPage()
        {
            ITProject1Entities IT = new ITProject1Entities();

            //create projects
            var vmUE        = new ViewModelProjectsUnassignedEmp();
            var showProject = new List <Projects>();  //yet now not it vm but this doesn't error out

            foreach (var item in IT.Projects)
            {
                showProject.Add(new Projects
                {
                    ProjectID = item.ProjectID,
                    Name      = item.Name,
                    Descrip   = item.Descrip,
                    CatID     = item.CatID,
                    Category  = item.Category
                });
            }
            vmUE.allProjects = showProject;


            var showEmployees = new List <Employees>();
            var query         = IT.Employees;

            //create employees
            foreach (var item in query)
            {
                if (item.ProjectsAssigned == 0)
                {
                    showEmployees.Add(new Employees
                    {
                        EmployeeID = item.EmployeeID,
                        FName      = item.FName,
                        LName      = item.LName,
                        Specialty  = item.Specialty,
                    });
                }
            }
            vmUE.allEmployees = showEmployees;

            return(View(vmUE));


            //return View(IT.Projects.ToList());
        }
        public ActionResult projectsPage()
        {
            ITProject1Entities IT = new ITProject1Entities();

            //create projects
            var vmUE = new ViewModelProjectsUnassignedEmp();
            var showProject = new List<Projects>();  //yet now not it vm but this doesn't error out

            foreach(var item in IT.Projects)
            {
                showProject.Add(new Projects
                {
                    ProjectID = item.ProjectID,
                    Name = item.Name,
                    Descrip = item.Descrip,
                    CatID = item.CatID,
                    Category = item.Category

                });
            }
            vmUE.allProjects = showProject;

            var showEmployees = new List<Employees>();
            var query = IT.Employees;

            //create employees
            foreach (var item in query)
            {
                if(item.ProjectsAssigned==0)
                {
                    showEmployees.Add(new Employees
                    {
                        EmployeeID = item.EmployeeID,
                        FName = item.FName,
                        LName = item.LName,
                        Specialty = item.Specialty,
                    });
                }
            }
            vmUE.allEmployees = showEmployees;

            return View(vmUE);

            //return View(IT.Projects.ToList());
        }