// Add New 'To Do Item' to 'To Do Item List' named 'ToDoListItem'.
        public ToDoListItem AddItem(string description)
        {
            ToDoListItem itemToAdd = new ToDoListItem();

            itemToAdd.Description = description;

            Items.Add(itemToAdd);

            var connectionString = ConfigurationManager.ConnectionStrings["TodoList"];
            using (SqlConnection connection = new SqlConnection(connectionString.ConnectionString))
            {
                connection.Open();
                using (SqlCommand command = connection.CreateCommand())
                {
                    string insertStatement = "insert dbo.ToDoListItem(description) values(@desc2); select scope_identity()";

                    command.CommandText = insertStatement;
                    command.Parameters.Add("@desc2", SqlDbType.NVarChar);
                    command.Parameters["@desc2"].Value = description;
                    var result = command.ExecuteScalar();
                    itemToAdd.Id = Convert.ToInt32((decimal) result);
                }

            }

            return itemToAdd;
        }
        public TodoListViewModel()
        {
            Items = new ObservableCollection<ToDoListItem>
            {

            };
             // Add Current Items in Database to 'To Do Items List' named 'ToDoListItem'.
            var connectionString = ConfigurationManager.ConnectionStrings["TodoList"];
            using (SqlConnection connection = new SqlConnection(connectionString.ConnectionString))
            {
                connection.Open();
                using (SqlCommand command = connection.CreateCommand())
                {
                    string query = "select * from dbo.ToDoListItem";
                    command.CommandText = query;
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string description = reader.GetString(1);
                            ToDoListItem item = new ToDoListItem();
                            item.Description = description;
                            Items.Add(item);
                        }
                    }
                }
            }
        }
 public void DeleteItem(ToDoListItem itemToDelete)
 {
     Items.Remove(itemToDelete);
 }