public ActionResult ChangeStatus(string TaskNumber) { TaskListDBEntities ORM = new TaskListDBEntities(); Task Found = ORM.Tasks.Find(TaskNumber); if (Found != null) { if (Found.Status == "Incomplete") { Found.Status = "Completed"; } else { Found.Status = "Incomplete"; } ORM.Entry(Found).State = System.Data.Entity.EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("Welcome")); } else { ViewBag.Error.Message = "Task not found"; return(View("Error")); } }
public ActionResult DeleteTask(string taskName) { //1. ORM TaskListDBEntities ORM = new TaskListDBEntities(); //2. Find the customer you want to delete Task Found = ORM.Tasks.Find(taskName); if (Found != null) { ORM.Tasks.Remove(Found); ORM.SaveChanges(); return(RedirectToAction("TaskList")); } else { ViewBag.ErrorMessage = "Task not found!"; return(View("Error")); } }
public ActionResult AddNewTask(Task newTask) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.Tasks.Add(newTask); ORM.SaveChanges(); return(RedirectToAction("TaskList")); }
public ActionResult CreateAccount(User newUser) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.Users.Add(newUser); ORM.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult SaveNewTask(TaskList newTask) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.TaskList.Add(newTask); ORM.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Update(TaskList updateTask) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.Entry(updateTask).State = EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult MarkComplete(TaskList TaskID) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.TaskList.Remove(ORM.TaskList.Find(TaskID)); ORM.SaveChanges(); return(View("Index")); }
public ActionResult RegisterNewUser(User newUser) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.Users.Add(newUser); ORM.SaveChanges(); return(View("Index")); }
public ActionResult DeleteTask(int taskID) { TaskListDBEntities ORM = new TaskListDBEntities(); Task found = ORM.Tasks.Find(taskID); ORM.Tasks.Remove(found); ORM.SaveChanges(); return(RedirectToAction("TaskList")); }
public ActionResult AddNewTask(Task newTask) { if (ModelState.IsValid) { TaskListDBEntities ORM = new TaskListDBEntities(); Task oldTask = ORM.Tasks.Add(newTask); ORM.SaveChanges(); return(RedirectToAction("TaskList")); } else { ViewBag.Error = "Error with adding task."; return(View("AddTask")); } }
public ActionResult AddUser(Users newUser) { if (ModelState.IsValid) { TaskListDBEntities ORM = new TaskListDBEntities(); ORM.Users.Add(newUser); ORM.SaveChanges(); // go to task list, passing the new user to the taskList method return(RedirectToAction("TaskList", newUser)); } else { return(View("Error")); } }
public ActionResult DeleteTask(string TaskNumber) { TaskListDBEntities ORM = new TaskListDBEntities(); TasksTable Found = ORM.TasksTables.Find(TaskNumber); if (Found != null) { ORM.TasksTables.Remove(Found); ORM.SaveChanges(); return(RedirectToAction("UserTasks")); } else { ViewBag.ErrorMessage = "Task not found"; return(View("Error")); } }
public ActionResult UpdateComplete(int taskID) { TaskListDBEntities ORM = new TaskListDBEntities(); Task oldTask = ORM.Tasks.Find(taskID); if (oldTask.Complete == false) { oldTask.Complete = true; ORM.Entry(oldTask).State = System.Data.Entity.EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("TaskList")); } else { return(RedirectToAction("TaskList")); } }
public ActionResult RegisterUser(User newUser) { if (ModelState.IsValid) { TaskListDBEntities ORM = new TaskListDBEntities(); User added = ORM.Users.Add(newUser); ORM.SaveChanges(); currentUser.ID = added.UserID; currentUser.LogIn = true; return(RedirectToAction("TaskList"));//, added } else { ViewBag.Error = "Error with adding user."; return(View("Login")); } }
public ActionResult DeleteTask(string TaskNumber) { TaskListDBEntities ORM = new TaskListDBEntities(); Task Found = ORM.Tasks.Find(TaskNumber); if (Found != null) { ORM.Tasks.Remove(Found); ORM.SaveChanges(); return(RedirectToAction("Welcome")); } else { return(View("Error")); } }
public ActionResult DeleteOrder(int TaskID) { // Initialize ORM TaskListDBEntities ORM = new TaskListDBEntities(); // set var "found" to the Order of ID "OrderID" TaskList found = ORM.TaskList.Find(TaskID); // remember which user we're on (work-around until we actually learn how to use identity) Users currentUser = ORM.Users.Find(found.UserID); // remove that order from the database ORM.TaskList.Remove(found); // Always Be Saving ORM.SaveChanges(); return(RedirectToAction("TaskList", currentUser)); }
public ActionResult SaveTaskUpdates(TasksTable UpdateTaskList) { TaskListDBEntities ORM = new TaskListDBEntities(); TasksTable OldTaskRecord = ORM.TasksTables.Find(UpdateTaskList.TaskNumber); if (OldTaskRecord != null && ModelState.IsValid) { OldTaskRecord.Description = UpdateTaskList.Description; OldTaskRecord.DueDate = UpdateTaskList.DueDate; OldTaskRecord.Status = UpdateTaskList.Status; OldTaskRecord.TaskNumber = UpdateTaskList.TaskNumber; ORM.Entry(OldTaskRecord).State = System.Data.Entity.EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("UserTasks")); } else { ViewBag.ErrorMessage = "Task not Found"; return(View("Error")); } }
public ActionResult AddNewTask(TasksTable NewTask) { if (ModelState.IsValid) { TaskListDBEntities ORM = new TaskListDBEntities(); if (ORM.TasksTables.ToList().Count == 0) { NewTask.TaskNumber = "1"; } else { NewTask.TaskNumber = (int.Parse(ORM.TasksTables.ToList().Last().TaskNumber) + 1).ToString(); } ORM.TasksTables.Add(NewTask); ORM.SaveChanges(); return(RedirectToAction("UserTasks")); } else { return(View("Error")); } }
public ActionResult ChangeStatus(string taskName) { TaskListDBEntities ORM = new TaskListDBEntities(); Task Found = ORM.Tasks.Find(taskName); if (Found != null) { if (Found.taskStatus == "Incomplete") { Found.taskStatus = "Complete"; } else { Found.taskStatus = "Incomplete"; } ORM.Entry(Found).State = System.Data.Entity.EntityState.Modified; ORM.SaveChanges(); return(RedirectToAction("TaskList")); } else { return(View("Error")); } }