private void button1_Click(object sender, EventArgs e)
{
Database2Entities content = new Database2Entities();
Category Category = new Category();
Category.Title = cattxt.Text;
content.Categories.Add(Category);
content.SaveChanges();
MessageBox.Show("New category added");
}
private void button2_Click(object sender, EventArgs e)
{
Database2Entities content = new Database2Entities();
var book = content.Books.Where(x => x.ISBN == risbntxt.Text).FirstOrDefault();
var bookqty = book.Quantity - Convert.ToInt32(rqtytxt.Text);
book.Quantity = bookqty;
content.SaveChanges();
MessageBox.Show($"Book{rqtytxt.Text} removed");
}
private void button2_Click(object sender, EventArgs e)
{
IssueBook book = new IssueBook();
book.Enrollment = studentetxt.Text;
book.ISBN = ISBNTxt.Text;
//book.IssueReturn = true;
var singlebook = context.Books.Where(x => x.ISBN == ISBNTxt.Text);
context.IssueBooks.Add(book);
context.SaveChanges();
}
private void button1_Click(object sender, EventArgs e)
{
Database2Entities context = new Database2Entities();
Book book = new Book();
book.ISBN = isbntxt.Text;
book.Title = titletxt.Text;
book.Category = cateCombo.SelectedText;
book.Quantity = Convert.ToInt32(Qtytxt.Text);
context.Books.Add(book);
context.SaveChanges();
}
