public ViewResult Details(int?Id) { ToDoListDetailsViewModel todoList = new ToDoListDetailsViewModel(); ToDoList _tmpToDo = toDoListRepository.Details((int)Id); if (_tmpToDo == null) { Response.StatusCode = 404; return(View("NotFound", Id)); } todoList.Tasks = taskRepository.ActiveTasks(); todoList.ToDoList = _tmpToDo; todoList.PageTitle = "ToDo List Details"; return(View("~/Views/ToDoList/Details.cshtml", todoList)); }
public ActionResult Details(int id) { ToDoList currentToDoList = listOfToDoLists.Single(t => t.ID == id); using (IDbConnection connection = new SqlConnection("Data Source=5SSDHH2;Initial Catalog=JMProjectDB;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework")) { using (connection) { DynamicParameters p = new DynamicParameters(); p.Add("@ListID", currentToDoList.ID); var listOfAvailableToDos = (List <ToDo>)connection.Query <ToDo>("EXEC GetListOfAvailableToDos @ListID", new { ListID = currentToDoList.ID }); ToDoListDetailsViewModel toDoListDetailsViewModel = new ToDoListDetailsViewModel(currentToDoList, listOfAvailableToDos); return(View(toDoListDetailsViewModel)); } } }