public int FlavorTable()
{
int count = 0;
try
{
// read from old db
old_Access.Open();
string strCmd = @"SELECT * from Flavors";
OleDbCommand cmd = new OleDbCommand(strCmd, old_Access);
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
FlavorWPF itm_WPF = new FlavorWPF();
itm_WPF.ID = int.Parse(rdr["ID"].ToString());
itm_WPF.Name = rdr["Flavor_Name"].ToString();
itm_WPF.Description = rdr["Description"].ToString();
new_WCF.AddFlavor(itm_WPF);
count++;
}
rdr.Close();
old_Access.Close();
}
catch (Exception ex)
{
return(-1);
}
return(count);
}
private void btnAdd_Update_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text == "")
{
return;
}
// build and populate flavorWPF object
FlavorWPF flav = new FlavorWPF();
flav.Name = txtName.Text;
flav.Description = txtDescription.Text;
flav.NotAflavor = (bool)chkNotAFlavor.IsChecked;
flav.CakeFlavor = (bool)chkCakeFlavor.IsChecked;
flav.Invisible = (bool)chkInvisible.IsChecked;
if (btnAdd_Update.Content.ToString() == "Add")
{
lck_comm.AddFlavor(flav);
}
else if (btnAdd_Update.Content.ToString() == "Update")
{
if (lvwFlavors.SelectedItem == null)
{
return;
}
flav.ID = (lvwFlavors.SelectedItem as FlavorWPF).ID;
lck_comm.UpdateFlavor(flav.ID, flav);
}
ClearUI();
RefreshFlavors();
}
