public void DeleteUserToProject(int?id)
{
UserToProjects up = UserToProjectsService.Instance.FindUserWithProjectID(id);
_db.UsersToProjects.Remove(up);
_db.Entry(up).State = EntityState.Deleted;
_db.SaveChanges();
}
public void SaveUserToProject(UserToProjects userProj)
{
Project dbProj = _db.Projects.Where(f => f.id == userProj.id).SingleOrDefault();
dbProj.id = userProj.id;
_db.Entry(dbProj).State = EntityState.Modified;
_db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "id")] UserToProjects userToProject)
{
if (ModelState.IsValid)
{
UserToProjectsService.Instance.SaveUserToProject(userToProject);
return(RedirectToAction("Index"));
}
return(View(userToProject));
}
public UserToProjectsViewModel NewUserToProjectViewModel(UserToProjects up)
{
UserToProjectsViewModel upvm = new UserToProjectsViewModel
{
ide = up.id,
projectId = up.project.id,
userId = null
};
return(upvm);
}
public UserToProjects NewUserToProject(int?id)
{
UserToProjects up = new UserToProjects
{
project = (from p in _db.Projects
where p.id == id.Value
select p).SingleOrDefault(),
user = null
};
return(up);
}
// GET: UserToProjects/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserToProjects userToProject = UserToProjectsService.Instance.FindUserWithProjectID(id);
if (userToProject == null)
{
return(HttpNotFound());
}
return(View(userToProject));
}
// GET: UserToProjects/Create
public ActionResult Create(int?id)
{
ViewBag.ProjectName = ProjectService.Instance.GetProjectByID(id.Value);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserToProjects up = UserToProjectsService.Instance.NewUserToProject(id);
UserToProjectsViewModel upvm = UserToProjectsService.Instance.NewUserToProjectViewModel(up);
return(View(upvm));
}
public UserToProjects UserToProjectList(UserToProjectsViewModel userToProject)
{
var emailId = UserToProjectsService.Instance.CompareUserEmail(userToProject);
UserToProjects upvm = new UserToProjects
{
id = userToProject.ide,
project = (from p in _db.Projects
where p.id == userToProject.projectId
select p).SingleOrDefault(),
user = emailId
};
_db.UsersToProjects.Add(upvm);
_db.SaveChanges();
return(upvm);
}
