private void button2_Click(object sender, EventArgs e)
        {
            BooksSearchList a = new BooksSearchList();
            DialogResult    b = a.ShowDialog();

            if (b == DialogResult.OK)
            {
                Book_NameBox.Text          = a.Book_Name1;
                AuthorBox.Text             = a.Author1;
                publisherBox.Text          = a.Publisher1;
                EditionBox.Text            = a.Edition1;
                CategoryBox.Text           = a.Category1;
                Total_QuantityBox.Text     = a.Total_Quantity1;
                Number_BorrowedBox.Text    = a.Number_Borrowed1;
                Retrieve_BookNumeric.Value = a.Book_ID1;
                if (Total_QuantityBox.Text == Number_BorrowedBox.Text)
                {
                    IssueReturn c = context.IssueReturn.Where(x => x.BookID == Retrieve_BookNumeric.Value).OrderBy(x => x.DateExpiry).First();
                    Can_Borrow_DateBox.Text = c.DateExpiry.ToLongDateString();
                }
                else
                {
                    Can_Borrow_DateBox.Text = "now";
                }
            }
        }
        private void btn_bookid_Click(object sender, EventArgs e)
        {
            BooksSearchList bs = new BooksSearchList();
            DialogResult    r  = bs.ShowDialog();

            if (r == DialogResult.OK)
            {
                txtbookid.Text    = bs.Book_ID1.ToString();
                txtbooktitle.Text = bs.Book_Name1.ToString();
            }
        }