public ActionResult TaskList()
{
Capstone6Entities ORM = new Capstone6Entities();
ViewBag.TaskList = ORM.Tasks.ToList();
return(View());
}
public ActionResult DeleteTask(string TaskID)
{
Capstone6Entities orm = new Capstone6Entities();
Task Found = orm.Tasks.Find(TaskID);
orm.Tasks.Remove(Found);
orm.SaveChanges();
return(RedirectToAction("TaskList"));
}
public ActionResult SaveNewTask(Task newTask)
{
Capstone6Entities orm = new Capstone6Entities();
orm.Tasks.Add(newTask);
orm.SaveChanges();
return(RedirectToAction("TaskList"));
}
public ActionResult RegisterNewUser(User newUser)
{
Capstone6Entities ORM = new Capstone6Entities();
ORM.Users.Add(newUser);
ORM.SaveChanges();
return(View("Index"));
}
public ActionResult Index()
{
Capstone6Entities ORMuser = new Capstone6Entities();
var userList = ORMuser.Users.ToList();
//put user db list into select list for dropdown list
ViewBag.allUsers = new SelectList(userList, "userID", "name");
return(View());
}
//for testing purposes
public ActionResult AllUserTasksView()
{
//1. get database
Capstone6Entities ormListTask = new Capstone6Entities();
//3.load items into viewbag matching userid
ViewBag.AllTasks = ormListTask.Tasks.ToList();
//ViewBag.theUsersTasks = ormList.Tasks.Where(u => u.userID == getTasks.userID).ToString();
//3.return view
return(View());
}
public ActionResult UserTasksView()
{
//1. get database
Capstone6Entities ormList = new Capstone6Entities();
//2. Get user id
User selectUser = ormList.Users.Find(1);
//3.load items into viewbag matching userid
ViewBag.theUserTasks = ormList.Tasks.Where(x => x.userID == selectUser.userID).ToList();
//3.return view
return(View());
}
public ActionResult UserTaskDelete(Task deleteItem)
{
//1. create ORM
Capstone6Entities ORMtask = new Capstone6Entities();
//2. get old item
Task getItem = ORMtask.Tasks.Find(deleteItem.taskID); // use edit item name to find old item
//4. push to DB
ORMtask.Entry(getItem).State = System.Data.Entity.EntityState.Deleted;
ORMtask.SaveChanges();
//5. return to the list of item
return(RedirectToAction("UserTasksView")); // action to action instead of action to view
}
public ActionResult UserTaskComplete(int whichTasks, int currentUser)
{
int numberToReturn = currentUser;
//1. create ORM
Capstone6Entities ORMtask = new Capstone6Entities();
//2. find item
Task getItem = ORMtask.Tasks.Find(whichTasks); // use edit item name to find old item
//3. change item
getItem.isComplete = true;
//4. push to DB
ORMtask.Entry(getItem).State = System.Data.Entity.EntityState.Modified;
ORMtask.SaveChanges();
//5. return to the list of item
return(RedirectToAction("UserTasksView", new { currentUser = numberToReturn })); // action to action instead of action to view
}
public ActionResult ChangeStatus(string TaskID)
{
Capstone6Entities ORM = new Capstone6Entities();
Task Found = ORM.Tasks.Find(TaskID);
if (Found.Status == "incomplete")
{
Found.Status = "complete";
}
else
{
Found.Status = "incomplete";
}
ORM.Entry(Found).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
return(RedirectToAction("TaskList"));
}
public ActionResult SignIn(User user)
{
Capstone6Entities ORM = new Capstone6Entities();
List <User> users = ORM.Users.ToList();
if (users.Where(X => X.UserName == user.UserName).ToList().Count() == 0)
{
ViewBag.Error = "Username does not exist";
return(View("Error"));
}
User thisUser = ORM.Users.Find(user.UserName);
if (thisUser.Password != user.Password)
{
ViewBag.Error = "Incorrect Password";
}
ViewBag.Message = $"Welcome {user.UserName}!";
return(View("Welcome"));
}
public ActionResult AddNew(Task newTask)
{
try
{
if (ModelState.IsValid)
{
Capstone6Entities ORMtask = new Capstone6Entities();
var searchDup = ORMtask.Tasks.Where(x => x.taskID == newTask.taskID).SingleOrDefault();
if (searchDup == null)
{
ORMtask.Entry(newTask).State = System.Data.Entity.EntityState.Added;
ORMtask.SaveChanges();
ViewBag.AllItems = ORMtask.Tasks.ToList <Task>();
return(RedirectToAction("UserTasksView"));
}
else
{
ViewBag.WhereError = "Task ID Already in database";
return(View("Error"));
}
}
else
{
ViewBag.WhereError = "Model State Not Vaild";
return(View("Error"));
}
}
catch (Exception)
{
ViewBag.WhereError = "Exception Error in Add Item";
return(View("Error"));
}
}