public ActionResult Delete(sifProjectUserRole userRole) { try { var userRoleToDelete = db.sifProjectUserRoles.Where(p => p.idUserRole == userRole.idUserRole).First(); Project activeProject = Session["project"] as Project; var existsUserWithRole = from n in db.sif_ProjectUsers join s in db.sifProjectUserRoles on n.idUserRole equals s.idUserRole where s.idProject == activeProject.idProject && s.idUserRole == userRoleToDelete.idUserRole select n; if (existsUserWithRole.Count() == 0) { // ne postoji netko to ima tu user rolu db.sifProjectUserRoles.DeleteOnSubmit(userRoleToDelete); db.SubmitChanges(); return RedirectToAction("Index"); } else { return Redirect("../ErrorOnDelete"); } } catch { return View(); } }
public ActionResult Create(sifProjectUserRole userRole) { try { var activeProject = Session["project"] as Project; sifProjectUserRole newUserRole = new sifProjectUserRole(); newUserRole.idProject = activeProject.idProject; newUserRole.idUserRole = userRole.idUserRole; newUserRole.userRoleDescription = userRole.userRoleDescription; db.sifProjectUserRoles.InsertOnSubmit(newUserRole); db.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(); } }
partial void DeletesifProjectUserRole(sifProjectUserRole instance);
partial void UpdatesifProjectUserRole(sifProjectUserRole instance);
partial void InsertsifProjectUserRole(sifProjectUserRole instance);
public ActionResult Edit(sifProjectUserRole userRole) { try { var userRoleToEdit = db.sifProjectUserRoles.Where(p => p.idUserRole == userRole.idUserRole).First(); userRoleToEdit.userRoleDescription = userRole.userRoleDescription; db.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(); } }