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"); } } } }
private void confirm_Click(object sender, EventArgs e) { //throw new NotImplementedException(); using (BooksDatacontext context = new BooksDatacontext(App.booksconnectionString)) { var BookLoaded = (from book in context.TblBooks where book.id == Int32.Parse(txtID.Text) select book).FirstOrDefault(); if (BookLoaded != null) { try { //Adding changes into the database String id = NavigationContext.QueryString["id"]; BookLoaded.author = txtAuthor.Text; BookLoaded.description = txtDesc.Text; BookLoaded.name = txtName.Text; BookLoaded.version = txtVersion.Text; context.SubmitChanges(); MessageBox.Show("Book Editted successfully"); //Move back to the view page NavigationService.Navigate(new Uri("/ViewBook.xaml?id=" + id, UriKind.RelativeOrAbsolute)); } catch (Exception) { MessageBox.Show("Unable to Edit the book"); } } } }
//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(); } }
void confirm_Click(object sender, EventArgs e) { //validate the form if (String.IsNullOrEmpty(txtName.Text)) { MessageBox.Show("Name is required"); txtName.Focus(); } else if (String.IsNullOrEmpty(txtUname.Text)) { MessageBox.Show("Username is required"); txtUname.Focus(); } else if (String.IsNullOrEmpty(txtPasswd.Password)) { MessageBox.Show("Password is required"); txtPasswd.Focus(); } else { using (BooksDatacontext context = new BooksDatacontext(App.booksconnectionString)) { try { //Add user information in the database table TblAccounts TblAccounts tb = new TblAccounts(); tb.name = txtName.Text; tb.username = txtUname.Text; tb.passwd = txtPasswd.Password; context.TblAccounts.InsertOnSubmit(tb); context.SubmitChanges(); MessageBox.Show("Account Created Successfully"); } catch (Exception) { MessageBox.Show("unable to Create an Account"); } } } }