//
// GET: /Show/
public ActionResult Show()
{
List<Task> taskListFalse = new List<Task>();
List<Task> taskListTrue = new List<Task>();
List<Task> taskListDelete = new List<Task>();
MyDBDataContext db = new MyDBDataContext();
taskListFalse = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'false' AND [delete] = 'false'").ToList<Task>();
//taskListFalse = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'false' ").ToList<Task>();
taskListTrue = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'true' AND [delete] = 'false'").ToList<Task>();
taskListDelete = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE [delete] = 'true'").ToList<Task>();
/*
WriteResult(taskListFalse);
WriteResult(taskListTrue);
WriteResult(taskListDelete);
*/
ThreeModel tm = new ThreeModel();
tm.taskListFalse = taskListFalse;
tm.taskListTrue = taskListTrue;
tm.taskListDelete = taskListDelete;
return View(tm);
}
