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();
}
}
}
