private void btnNewGroceryList_Click(object sender, RoutedEventArgs e) { AddGroceryList newList = new AddGroceryList(); string newListName = String.Empty; if ((bool)newList.ShowDialog()) { newListName = newList.txtGroceryListName.Text; GroceryList newGroceryList = new GroceryList(newListName, DateTime.Now); m_Manager.AddNewGroceryList(newGroceryList); m_UpdateInfo.Invoke(this, e); } }
public void AddNewGroceryList(GroceryList GroceryList) { using (SqlCeConnection Con = CompactDataSource.EstablishConnection()) { using (SqlCeCommand Cmd = Con.CreateCommand()) { Cmd.CommandText = "INSERT INTO GroceryList(GroceryListName, GroceryListDate) VALUES (@Name,@Date) "; Cmd.Parameters.AddWithValue("@Name", GroceryList.GroceryListName); Cmd.Parameters.AddWithValue("@Date", GroceryList.GroceryListDate); Cmd.ExecuteScalar(); } } }