public ActionResult TaskList()
{
TaskListDBEntities ORM = new TaskListDBEntities();
ViewBag.Tasks = ORM.Tasks.ToList <Task>();
return(View());
}
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 Index()
{
TaskListDBEntities ORM = new TaskListDBEntities();
ViewBag.TaskList = ORM.TaskList.ToList();
return(View());
}
public ActionResult Welcome()
{
TaskListDBEntities ORM = new TaskListDBEntities();
ViewBag.TaskList = ORM.Tasks.ToList();
return(View());
}
public ActionResult LoginToAccount(string email, string password)
{
TaskListDBEntities ORM = new TaskListDBEntities();
User Account = ORM.Users.Find(email);
if (Account == null)
{
ViewBag.Error = "User does not exist.";
return(View("Index"));
}
else if (Account.password != password)
{
ViewBag.Error = "Incorrect password.";
return(View("Index"));
}
else if (Account.email == email && Account.password == password)
{
ViewBag.Message = "Welcome!";
return(View("Welcome"));
}
else
{
return(View("Index"));
}
}
public ActionResult UserTasks()
{
TaskListDBEntities ORM = new TaskListDBEntities();
ViewBag.TaskList = ORM.TasksTables.ToList();
ViewBag.Message = "added!";
return(View());
}
public ActionResult RegisterNewUser(User newUser)
{
TaskListDBEntities ORM = new TaskListDBEntities();
ORM.Users.Add(newUser);
ORM.SaveChanges();
return(View("Index"));
}
public ActionResult CreateAccount(User newUser)
{
TaskListDBEntities ORM = new TaskListDBEntities();
ORM.Users.Add(newUser);
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 Update(TaskList updateTask)
{
TaskListDBEntities ORM = new TaskListDBEntities();
ORM.Entry(updateTask).State = EntityState.Modified;
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddNewTask(Task newTask)
{
TaskListDBEntities ORM = new TaskListDBEntities();
ORM.Tasks.Add(newTask);
ORM.SaveChanges();
return(RedirectToAction("TaskList"));
}
public ActionResult SaveNewTask(TaskList newTask)
{
TaskListDBEntities ORM = new TaskListDBEntities();
ORM.TaskList.Add(newTask);
ORM.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult TaskList()//User CurrentUser
{
TaskListDBEntities ORM = new TaskListDBEntities();
ViewBag.CurrentUserUserID = currentUser.ID;
ViewBag.Tasks = ORM.Tasks.ToList <Task>();
return(View());
}
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 JsonResult SearchByName(string taskName)
{
//orm
TaskListDBEntities ORM = new TaskListDBEntities();
//search by country
List <Task> Result = ORM.Tasks.Where(c => c.taskName.Contains(taskName)).ToList();
//return data as json
return(Json(Result));
}
public ActionResult TaskList(Users currentUser)
{
TaskListDBEntities ORM = new TaskListDBEntities();
// viewbags to pass to the view
ViewBag.UserName = currentUser.FirstName;
ViewBag.UserID = currentUser.UserID;
ViewBag.TaskList = ORM.TaskList.ToList();
return(View());
}
public ActionResult SignIn(int UserID, string Email_Address, string Password)
{
TaskListDBEntities ORM = new TaskListDBEntities();
Users currentUser = ORM.Users.Find(UserID);
if (currentUser.Email_Address == Email_Address && currentUser.Password == Password)
{
return(RedirectToAction("TaskList", currentUser));
}
ViewBag.AuthError = "Email or password was incorrect. Try again";
return(View("Login"));
}
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 UpdateTaskList(string TaskNumber)
{
TaskListDBEntities ORM = new TaskListDBEntities();
TasksTable Found = ORM.TasksTables.Find(TaskNumber);
if (Found != null)
{
return(View("UpdatedTaskDetails", Found));
}
else
{
ViewBag.ErrorMessage = "Tasks Not Found";
return(View("Error"));
}
}
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 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 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 SignIn(string UserName, string Password)
{
TaskListDBEntities ORM = new TaskListDBEntities();
User currentUser = ORM.Users.Find(UserName);
if (currentUser == null)
{
ViewBag.Error = "Username does not exist. Did you mean to register?";
return(View("Index"));
}
else if (currentUser.Password != Password)
{
ViewBag.Error = "Incorrect password.";
return(View("Index"));
}
return(RedirectToAction("UserTasks"));
}
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 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 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 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 LoginButton(User logUser)
{
TaskListDBEntities ORM = new TaskListDBEntities();
List <User> foundID = ORM.Users.ToList <User>();
foreach (User user in foundID)
{
if (logUser.Email == user.Email)
{
if (currentUser.LogIn == false)
{
currentUser.LogIn = true;
currentUser.ID = user.UserID;
TempData["LoggedIn"] = "You've successfully logged in!";
return(RedirectToAction("TaskList"));//, logUser
}
ViewBag.Error = "You are already logged in!";
return(View("Login"));
}
}
ViewBag.Error = "This is not a valid email address";
return(View("Login"));
}