private bool checkCopies()
{
string bookNumber = txtBookNumber.Text;
DAL.ReserveDAO reserveDB = new DAL.ReserveDAO();
int countCopy = reserveDB.countCopy(bookNumber);
int countCopyBorrowed = reserveDB.countCopyBorrowed(bookNumber);
if (countCopy == countCopyBorrowed && countCopy > 0)
{
return(true);
}
return(false);
}
private void btnReserve_Click(object sender, EventArgs e)
{
int borrowerNumber = int.Parse(txtMemberCode.Text);
int bookNumber = int.Parse(txtBookNumber.Text);
DateTime dateTime = dtpDate.Value;
Reservation a = new Reservation(borrowerNumber, bookNumber, dateTime);
DAL.ReserveDAO reserveDB = new DAL.ReserveDAO();
reserveDB.Insert(a);
MessageBox.Show("successful reserve");
btnReserve.Enabled = false;
dtpDate.Enabled = false;
txtBookNumber.Text = "";
string memberCode = txtMemberCode.Text;
string name = reserveDB.getNameByID(memberCode);
dataGridView1.DataSource = reserveDB.GetDataTable(memberCode);
}
private void btnCheckMenber_Click(object sender, EventArgs e)
{
string memberCode = txtMemberCode.Text;
txtBookNumber.Text = "";
txtDate.Text = "";
string name = null;
DAL.ReserveDAO reserveDB = new DAL.ReserveDAO();
name = reserveDB.getNameByID(memberCode);
dataGridView1.DataSource = reserveDB.GetDataTable(memberCode);
if (name != null)
{
txtName.Text = name;
txtBookNumber.Enabled = true;
}
else
{
txtName.Text = "";
txtBookNumber.Enabled = false;
}
}
