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"));
}
}