private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "")//validation part { MessageBox.Show("Please, insert all values"); } else { if (Request_ID == -1) { MessageBox.Show("Please, Click a Request!"); } else { EmC.UpdateRequestStatues(Request_ID, "Accept"); EmC = new EmController(); BookID = EmC.CountBooks() + 1; int AuthorID = EmC.GetAuthorID(AuthorName, AuthorLname); if (AuthorID == 0) { AuthorID = EmC.CountAuther() + 1; int x = EmC.AddAuthor(AuthorID, AuthorName, AuthorLname); } int r = EmC.InsertBook(BookID, BookName, Book_langauge, BookGenre, Book_price, Convert.ToInt32(textBox1.Text), BookDesc, 0, AuthorID, Publisher_ID); DataTable dt = EmC.ViewAllRequests(); dataGridView1.DataSource = dt; dataGridView1.Refresh(); Request_ID = -1; } } }