private void borrowToolStripMenuItem_Click(object sender, EventArgs e)
{
if (id != null)
{
Borrow borrowPage = new Borrow(id);
borrowPage.MdiParent = this;
borrowPage.Show();
}
else
{
MessageBox.Show("Please login first.");
}
}
// insert data of borrower for admin to monitor the borrowe return the book or not
private void InsertBorrowerInfoToDatabase()
{
borrowD = borrowDate.Value.ToString("dd-mm-yyyy");
returnD = returnDate.Value.ToString("dd-mm-yyyy");
libraryDataContext borrowBook = new libraryDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30");
Borrow borrowInfo = new Borrow
{
name = getNameLbl.Text,
userId = getUserIdLbl.Text,
bookId = BookIdTF.Text,
borrowDate = borrowD,
returnDate = returnD,
totalDays = dateDiffTF.Text
};
//borrowInfo.BookBorrowInfos.InsertOnSubmit();
borrowBook.Borrows.InsertOnSubmit(borrowInfo);
borrowBook.SubmitChanges();
}
partial void DeleteBorrow(Borrow instance);
partial void UpdateBorrow(Borrow instance);
partial void InsertBorrow(Borrow instance);