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;
}
}
}
public AddBook()
{
InitializeComponent();
EmC = new EmController();
id = EmC.CountBooks() + 1;
}
