public ProjectAndResources GetProject(int id, string userid)
{
ProjectAndResources model = new ProjectAndResources();
using (ApplicationDbContext db = new ApplicationDbContext())
{
model.Project = db.Projects.Include("Tasks").Where(x => x.ProjectId == id && x.UserId == userid).FirstOrDefault();
model.Resources = db.Resources.Include("Tasks").Include("Contacts").Where(x => x.UserId == userid).ToList();
}
model.taskVM = new AddTaskVM() { Task = PrepNewTask(id) };
model.taskVM.GetResourcesDropDownList(userid);
return model;
}
public ActionResult Index()
{
ProjectAndResources model = new ProjectAndResources();
using (ApplicationDbContext db = new ApplicationDbContext())
{
model.Resources = db.Resources.Include("Contacts").Include("Tasks").Where(p => p.UserId == UserId).OrderBy(x => x.CompanyName).ToList();
model.Projects = db.Projects.Include("Tasks").Where(p => p.UserId == UserId).OrderByDescending(x => x.StartDate).ToList();
}
return View(model);
}
public ActionResult UpdateOptions()
{
ProjectAndResources model = new ProjectAndResources();
model.Contacts = db.Contacts.OrderBy(x => x.Name).ToList();
model.Projects = db.Projects.Include("Tasks").Where(p => p.UserId == UserId).ToList();
List<int> pIDS = new List<int>();
model.Projects.ForEach(p => pIDS.Add(p.ProjectId));
model.Resources = db.Resources.Include("Tasks").Include("Contacts").OrderBy(x => x.CompanyName).ToList();
model.Tasks = db.Tasks.Where(t => pIDS.Contains(t.ProjectId)).OrderBy(x => x.StartDate).ToList();
return View(model);
}
public ActionResult AddTask(ProjectAndResources model)
{
try
{
_adapter.AddTask(model.taskVM.Task);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
TempData["Exception"] += string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
return RedirectToAction("Index");
}
return RedirectToAction("ProjectDetails", new { id = model.taskVM.Task.ProjectId });
}