private void butSave_Click(object sender, EventArgs e) { if (boxBookTitle.Text == "") { MessageBox.Show("Book Title must be filled !"); } else if (checkCapital() == true) { MessageBox.Show("First letter in each word of Book Title must be capital !"); } else if (boxBookTypeID.SelectedIndex == -1) { MessageBox.Show("Book Type ID must be chosen !"); } else if (boxPrice.Text == "") { MessageBox.Show("Price must be filled !"); } else if (checkNumeric(boxPrice.Text) == false) { MessageBox.Show("Price must be numeric !"); } else if (int.Parse(boxPrice.Text) < 5000 && int.Parse(boxPrice.Text) > 200000) { MessageBox.Show("Price must between 5000 and 200000!"); } else if (boxAuthor.Text == "") { MessageBox.Show("Author must be filled !"); } else if (boxPublisher.Text == "") { MessageBox.Show("Publisher must be filled !"); } else if (!boxPublisher.Text.StartsWith("PT. ")) { MessageBox.Show("Publisher must be started with 'PT. ' !"); } else if (boxISBN.Text == "") { MessageBox.Show("ISBN must be filled !"); } else if (boxISBN.Text.Length - 1 == 13) { MessageBox.Show("ISBN must be 13 characters !"); } else if (checkNumeric(boxISBN.Text) == false) { MessageBox.Show("ISBN must be numeric !"); } else { if (flag == 1) { MsBook book = new MsBook(); book.BookID = boxBookID.Text; book.BookTitle = boxBookTitle.Text; book.BookTypeID = boxBookTypeID.Text; book.Price = int.Parse(boxPrice.Text); book.TotalPage = int.Parse(boxTotalPage.Text); book.Author = boxAuthor.Text; book.Publisher = boxPublisher.Text; book.ISBN = boxISBN.Text; book.Stock = int.Parse(boxStock.Text); dtBS.MsBooks.InsertOnSubmit(book); dtBS.SubmitChanges(); MessageBox.Show("Data succesfuly inserted !"); dataGridBook.Enabled = true; IUDEnabled(); IdentityDisabled(); clear(); refreshTable(); } else if (flag == 2) { var query = (from x in dtBS.MsBooks where x.BookID == boxBookID.Text select x).First(); query.BookID = boxBookID.Text; query.BookTitle = boxBookTitle.Text; query.BookTypeID = boxBookTypeID.Text; query.Price = int.Parse(boxPrice.Text); query.TotalPage = int.Parse(boxTotalPage.Text); query.Author = boxAuthor.Text; query.Publisher = boxPublisher.Text; query.ISBN = boxISBN.Text; query.Stock = int.Parse(boxStock.Text); dtBS.MsBooks.InsertOnSubmit(query); dtBS.SubmitChanges(); MessageBox.Show("Data succesfuly updated !"); dataGridBook.Enabled = true; IUDEnabled(); IdentityDisabled(); clear(); refreshTable(); } } }
partial void DeleteMsBook(MsBook instance);
partial void UpdateMsBook(MsBook instance);
partial void InsertMsBook(MsBook instance);
private void detach_MsBooks(MsBook entity) { this.SendPropertyChanging(); entity.MsBookType = null; }
private void attach_MsBooks(MsBook entity) { this.SendPropertyChanging(); entity.MsBookType = this; }