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!");
}
}
}
