void confirm_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text))
{
MessageBox.Show("Name of the book is required");
txtName.Focus();
}
else if (String.IsNullOrEmpty(txtAuthor.Text))
{
MessageBox.Show("Name of the Author is required");
txtAuthor.Focus();
}
else
{
using (BooksDatacontext context = new BooksDatacontext(App.booksconnectionString))
{
try
{
//Add the details to the Tables
TblBooks st = new TblBooks()
{
name = txtName.Text, author = txtAuthor.Text, description = txtDesc.Text, version = txtVersion.Text
};
context.TblBooks.InsertOnSubmit(st);
context.SubmitChanges();
MessageBox.Show("Book has been Added Successfully");
}
catch (Exception)
{
MessageBox.Show("Unable to add book");
}
}
}
}
protected override void OnTap(System.Windows.Input.GestureEventArgs e)
{
//enable onTap on the list items
TblBooks tb = (TblBooks)bookList.SelectedItem;
if (bookList.SelectedIndex != -1)
{
NavigationService.Navigate(new Uri("/ViewBook.xaml?id=" + tb.id, UriKind.RelativeOrAbsolute));
}
}
//delete book by id
public void DeleteUser(String id)
{
using (BooksDatacontext context = new BooksDatacontext(App.booksconnectionString))
{
IQueryable <TblBooks> entityQuery = from c in context.TblBooks where c.id.Equals(id) select c;
TblBooks entityToDelete = entityQuery.FirstOrDefault();
context.TblBooks.DeleteOnSubmit(entityToDelete);
context.SubmitChanges();
}
}