public ActionResult addEmployees(int id, string Fname, int? ProjectsAssigned)
{
ITProject1Entities IT = new ITProject1Entities();
var addEmp = (from e in IT.Employees where e.EmployeeID == id select e).FirstOrDefault();
addEmp.FName = Fname;
addEmp.ProjectsAssigned = ProjectsAssigned;
IT.SaveChanges();
return RedirectToAction("projectsPage");
}
public ActionResult addEmployees()
{
ITProject1Entities IT = new ITProject1Entities();
int empIdSel = int.Parse(RouteData.Values["id"].ToString());
//int projIdSel = int.Parse(RouteData.Values["pID"].ToString());
var addEmp = (from e in IT.Employees where e.EmployeeID == empIdSel select e).FirstOrDefault();
//addEmp.ProjectsAssigned = new[] { 0, 1, 2, 3, 4, 5, 6 };
// = new SelectList(addEmp.ProjectsAssigned);
if (addEmp != null)
{
return View(addEmp);
}
else
{
return View("projectsPage");
}
}
public ActionResult employeesPage()
{
ITProject1Entities IT = new ITProject1Entities();
//if (User.IsInRole(""))
int projectIdSel = int.Parse(RouteData.Values["id"].ToString());
var displayProject = (from p in IT.Projects where p.ProjectID == projectIdSel select p).FirstOrDefault();
//create projects
var vm = new ViewModelProjectEmployee();
var showProject = new List<Projects>(); //yet now not it vm but this doesn't error out
showProject.Add(new Projects
{
ProjectID = displayProject.ProjectID,
Name = displayProject.Name,
Descrip = displayProject.Descrip,
CatID = displayProject.CatID,
Category = displayProject.Category
});
vm.allProjects = showProject;
var showEmployees = new List<Employees>();
var query = IT.Employees;
//create employees
foreach (var item in query)
{
showEmployees.Add(new Employees
{
EmployeeID = item.EmployeeID,
FName = item.FName,
LName = item.LName,
Specialty = item.Specialty,
});
}
vm.allEmployees = showEmployees;
return View(vm);
}
public ActionResult Tracker()
{
ITProject1Entities IT = new ITProject1Entities();
//if (User.IsInRole(""))
int projectIdSel = int.Parse(RouteData.Values["id"].ToString());
var displayProject = (from p in IT.Projects where p.ProjectID == projectIdSel select p).FirstOrDefault();
var vmT = new ViewModelTrackProjEmpl();
//create projects
var showProject = new List<Projects>();
showProject.Add(new Projects
{
ProjectID = displayProject.ProjectID,
Name = displayProject.Name,
Descrip = displayProject.Descrip,
CatID = displayProject.CatID,
Category = displayProject.Category
});
vmT.allProj = showProject;
//create employees
var showEmployees = new List<Employees>();
//var query = IT.Employees;
var emplOnProj = (from t in IT.Employees where t.ProjectsAssigned == projectIdSel select t).ToList();
foreach (var item in emplOnProj)
{
showEmployees.Add(new Employees
{
EmployeeID = item.EmployeeID,
FName = item.FName,
LName = item.LName,
Specialty = item.Specialty,
});
}
vmT.allEmpl = showEmployees;
//create tracker
var showTracker = new List<Tracker>();
var displayTracker = (from t in IT.Trackers where t.ProjectID_FK == projectIdSel select t).FirstOrDefault();
showTracker.Add(new Models.Tracker
{
ID = displayTracker.ID,
Value = displayTracker.Value,
ProjectID_FK = displayTracker.ProjectID_FK,
});
vmT.track = showTracker;
return View(vmT);
}
public ActionResult projectsPage(string userN, string passW, string passC)
{
ITProject1Entities IT = new ITProject1Entities();
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());
}
public ActionResult progressPage(int id, int value)
{
ITProject1Entities IT = new ITProject1Entities();
var displayTracker = (from t in IT.Trackers where t.ID == id select t).FirstOrDefault();
displayTracker.Value = value;
IT.SaveChanges();
return RedirectToAction("progressPage");
}
public ActionResult progressPage()
{
ITProject1Entities IT = new ITProject1Entities();
int trackIdSel = int.Parse(RouteData.Values["id"].ToString());
var displayTracker = (from t in IT.Trackers where t.ID == trackIdSel select t).FirstOrDefault();
if (displayTracker != null)
{
return View(displayTracker);
}
else
{
return View("projectsPage");
}
}