public ActionResult EditTask(Task taskEdit) { var taskUpdate = db.Tasks.SingleOrDefault(t => t.taskID == taskEdit.taskID); var userInfo = (from r in db.Users where r.username == User.Identity.Name select r).FirstOrDefault(); if (!ModelState.IsValid) { return(View(taskEdit)); } if (taskUpdate != null) { taskUpdate.progress = taskEdit.progress; taskUpdate.deadline = taskEdit.deadline; taskUpdate.description = taskEdit.description; taskUpdate.status = taskEdit.status; if (userInfo.roleID == 3) { taskUpdate.assignee = userInfo.userID; } else { taskUpdate.assignee = taskEdit.assignee; } db.SaveChanges(); UpdateProjectProgress(taskEdit, "edit"); } return(RedirectToAction("Tasks")); }
public ActionResult EditTask(Task taskEdit) { var taskUpdate = db.Tasks.SingleOrDefault(t => t.taskID == taskEdit.taskID); var roleId = (from r in db.Users where r.username == User.Identity.Name select r.roleID).FirstOrDefault(); if (!ModelState.IsValid) { return(View(taskEdit)); } if (taskUpdate != null) { //using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) //{ taskUpdate.progress = taskEdit.progress; taskUpdate.deadline = taskEdit.deadline; taskUpdate.description = taskEdit.description; taskUpdate.status = taskEdit.status; if (roleId != 3) { taskUpdate.assignee = taskEdit.assignee; } db.SaveChanges(); //} } return(RedirectToAction("Tasks")); }
public ActionResult DeleteConfirmed(int id) { if (!ModelState.IsValid) { return(View()); } using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { //var projectDelete = (from p in db.Projects // where p.projectID == id // select p).FirstOrDefault(); var projectDelete = db.Projects.Where(p => p.projectID == id).FirstOrDefault(); //delete all tasks of project var listTasks = projectDelete.Tasks.ToList(); listTasks.ForEach(x => db.Tasks.Remove(x)); //delete project db.Projects.Remove(projectDelete); db.SaveChanges(); } return(RedirectToAction("Projects")); }
public ActionResult EditProject(Project projectEdit) { var projectUpdate = db.Projects.SingleOrDefault(p => p.projectID == projectEdit.projectID); if (!ModelState.IsValid) { return(View(projectEdit)); } if (projectUpdate != null) { //using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) //{ var userInfo = db.Users.SingleOrDefault(u => u.username == User.Identity.Name); projectUpdate.project_code = projectEdit.project_code; projectUpdate.project_name = projectEdit.project_name; if (userInfo.roleID == 2) { projectUpdate.manage = userInfo.userID; } else { projectUpdate.manage = projectEdit.manage; } db.SaveChanges(); //} } return(RedirectToAction("Projects")); }
public ActionResult EditProject(Project projectEdit) { var projectUpdate = db.Projects.SingleOrDefault(p => p.projectID == projectEdit.projectID); if (!ModelState.IsValid) { return(View(projectEdit)); } if (projectUpdate != null) { //using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) //{ projectUpdate.project_code = projectEdit.project_code; projectUpdate.project_name = projectEdit.project_name; projectUpdate.manage = projectEdit.manage; db.SaveChanges(); //} } return(RedirectToAction("Projects")); }
public ActionResult DeleteTaskConfirmed(int id) { if (!ModelState.IsValid) { return(View()); } using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { var taskDelete = db.Tasks.Where(t => t.taskID == id).FirstOrDefault(); //remove Task from Project list of Tasks var project = db.Projects.SingleOrDefault(p => p.projectID == taskDelete.projectID); project.Tasks.Remove(taskDelete); //delete task db.Tasks.Remove(taskDelete); db.SaveChanges(); UpdateProjectProgress(taskDelete, "delete"); } return(RedirectToAction("Tasks")); }
public ActionResult Registration(User user) { bool status = false; string message = ""; //Model Validation if (ModelState.IsValid) { #region//Email already exist var isEmailExist = IsEmailExist(user.email); if (isEmailExist) { ModelState.AddModelError("EmailExist", "Email already exist"); return(View(user)); } #endregion #region //Username already exist var isUsernameExist = IsUsernameExist(user.username); if (isUsernameExist) { ModelState.AddModelError("UsernameExist", "Username already exist"); return(View(user)); } #endregion #region //Passwor Hashing user.password = Crypto.Hash(user.password); user.confirmPassword = Crypto.Hash(user.confirmPassword); //we will compare this two values #endregion user.roleID = 3; #region //Save data to db using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { db.Users.Add(user); db.SaveChanges(); message = "Registration successful."; status = true; } #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = status; return(View(user)); }
public ActionResult CreateProject(Project newProject) { if (!ModelState.IsValid) { return(View(newProject)); } using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { db.Projects.Add(newProject); db.SaveChanges(); } return(RedirectToAction("Projects")); }
public ActionResult CreateTask(int id, Task newTask) { if (!ModelState.IsValid) { return(View(newTask)); } newTask.projectID = id; using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { db.Tasks.Add(newTask); db.SaveChanges(); } //add Task to list Tasks in Project var project = db.Projects.Find(id); project.Tasks.Add(newTask); return(RedirectToAction("Tasks")); }
public ActionResult CreateProject(Project newProject) { if (!ModelState.IsValid) { return(View(newProject)); } using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { var userInfo = db.Users.SingleOrDefault(u => u.username == User.Identity.Name); if (userInfo.roleID == 2) { newProject.manage = userInfo.userID; } db.Projects.Add(newProject); db.SaveChanges(); } return(RedirectToAction("Projects")); }
public ActionResult CreateTask(int id, Task newTask) { if (!ModelState.IsValid) { return(View(newTask)); } using (PrMngSystemDBEntities db = new PrMngSystemDBEntities()) { newTask.projectID = id; db.Tasks.Add(newTask); db.SaveChanges(); var project = db.Projects.Find(id); project.Tasks.Add(newTask); } UpdateProjectProgress(newTask, "create"); return(RedirectToAction("Tasks")); }