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; } } }
private void AddBooks_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "")//validation part { MessageBox.Show("Please, insert all values"); } else { int r = EmC.InsertBook(id, textBox1.Text, textBox4.Text, textBox3.Text, Convert.ToInt32(textBox6.Text), Convert.ToInt32(textBox5.Text), textBox2.Text, 0, Convert.ToInt32(textBox7.Text), Convert.ToInt32(textBox8.Text)); if (r == 0) { MessageBox.Show("Your Request is Invalid"); } else { MessageBox.Show("New Book is Added!"); } } }