private void btnCheckCondition_Click(object sender, EventArgs e)
{
if (txtCopyNumber.Text != "")
{
if (CopyDAO.CheckCondition(int.Parse(txtCopyNumber.Text)) == 0)
{
MessageBox.Show("This book is available.");
btnBorrow.Enabled = true;
}
else if (CopyDAO.CheckCondition(int.Parse(txtCopyNumber.Text)) == 2)
{
if (ReservationDAO.GetFirstReservation(CopyDAO.GetCopy(int.Parse(txtCopyNumber.Text)).BookNumber).MemberNumber
== int.Parse(txtMemberCode.Text))
{
check = 1;
MessageBox.Show("This copy is available.");
btnBorrow.Enabled = true;
}
else
{
MessageBox.Show("This copy is not available.");
}
}
else
{
display(2);
MessageBox.Show("Copy Number is invalid or This book is not available.");
}
}
else
{
MessageBox.Show("Copy Code can not be blank.");
}
}
private errorBorrow checkCondition(int borrowerNumber, int copyNumber, out Copy c, out Reservation r)
{
c = null;
r = null;
c = CopyDAO.GetCopy(copyNumber);
if (c == null)
{
return(errorBorrow.CopyNotExist);
}
if (c.Type == 'A')
{
return(errorBorrow.CopyReferenced);
}
if (c.Type == 'B')
{
return(errorBorrow.CopyBorrowed);
}
// Check if this book is reserved by others and you are not at the first of the reservation list
int bookNumber = c.BookNumber;
r = ReserveDAO.GetFirstReservation(bookNumber);
if (r != null && r.BorrowerNumber != borrowerNumber)
{
return(errorBorrow.CopyReserved);
}
return(errorBorrow.OK);
}
private void btnReturn_Click(object sender, EventArgs e)
{
CirculatedCopy cc = new CirculatedCopy();
cc.CirculatedCopyId = Convert.ToInt32(dgvBorrowedBooks.Rows[rowIndex].Cells["circulatedCopyId"].Value);
cc.ReturnedDate = dtpReturnedDate.Value;
cc.FineAmount = double.Parse(txtFineAmount.Text);
CirculatedCopyDAO.Update(cc);
Copy c = CopyDAO.GetCopy(Convert.ToInt32(dgvBorrowedBooks.Rows[rowIndex].Cells["copyNumber"].Value));
if (ReservationDAO.GetFirstReservation(c.BookNumber) != null)
{
c.Type = 2;
}
else
{
c.Type = 0;
}
CopyDAO.UpdateType(c);
view(int.Parse(txtMemberCode.Text));
MessageBox.Show("Return Successful.");
btnReturn.Enabled = false;
txtFineAmount.Text = "";
btnConfirmFine.Enabled = false;
}
private void Return(CirculatedCopy cc)
{
CirculatedCopyDAO.Update(cc);
Copy c = CopyDAO.GetCopy(cc.CopyNumber);
// update type = 'A' in copy
c.Type = 'A';
CopyDAO.Update(c);
}
private void dgvCopies_CellClick(object sender, DataGridViewCellEventArgs e)
{
display(4);
Copy c = CopyDAO.GetCopy(Convert.ToInt32(dgvCopies.Rows[e.RowIndex].Cells["copyNumber"].Value));
txtCopyNumber.Text = c.CopyNumber.ToString();
txtSequenceNumber.Text = c.SequenceNumber.ToString();
txtType.Text = c.Type.ToString();
txtPrice.Text = c.Price.ToString();
}
private void Return(CirculatedCopy cc)
{
CirculatedCopyDAO.Update(cc);
Copy c = CopyDAO.GetCopy(cc.CopyNumber);
// if copy is reference
if (c.Type == 'R')
{
return;
}
// update type = 'A' in copy
c.Type = 'A';
CopyDAO.Update(c);
}
protected void btnBorrow_Click(object sender, EventArgs e)
{
DateTime receiveDate = Calendar1.SelectedDate;
DateTime dueDate = Calendar1.SelectedDate.AddDays(14);
CirculatedCopy cc = new CirculatedCopy(int.Parse(txtCopyNumber.Text), int.Parse(txtBorrowerNumber.Text),
receiveDate, dueDate);
c = CopyDAO.GetCopy(int.Parse(txtCopyNumber.Text));
r = r = ReserveDAO.GetFirstReservation(c.BookNumber);
borrow(cc, c, r);
showData();
displayButtons(1);
}
private void Return(CirculatedCopy cc)
{
if (CirculatedCopyDAO.Update(cc))
{
showMessageError("Return completed <3");
Copy c = CopyDAO.GetCopy(cc.CopyNumber);
// update type = 'A' in copy
c.Type = 'A';
CopyDAO.Update(c);
}
else
{
showMessageError("Return Fail :<");
}
}
private void btnBorrow_Click(object sender, EventArgs e)
{
if (dtpBorrowed.Value < dtpDue.Value)
{
CirculatedCopy cc = new CirculatedCopy();
cc.CopyNumber = int.Parse(txtCopyNumber.Text);
cc.MemberNumber = int.Parse(txtMemberCode.Text);
cc.BorrowedDate = dtpBorrowed.Value;
cc.DueDate = dtpDue.Value;
if (CirculatedCopyDAO.Add(cc))
{
Copy c = CopyDAO.GetCopy(int.Parse(txtCopyNumber.Text));
c.Type = 1;
CopyDAO.UpdateType(c);
display(2);
view(int.Parse(txtMemberCode.Text));
MessageBox.Show("Add Successful.");
if (check == 1)
{
Reservation r = ReservationDAO.GetFirstReservation(c.BookNumber);
r.Status = true;
ReservationDAO.UpdateStatus(r);
}
if (dgvBorrowedBooks.Rows.Count >= 5)
{
display(0);
MessageBox.Show("The number of borrowed books is 5. You can not borrow anymore book.");
}
}
else
{
MessageBox.Show("Error.");
}
}
else
{
MessageBox.Show("Borrowed date has to be smaller than Due date.");
}
}
private void borrow(CirculatedCopy cc, Copy c, Reservation r)
{
// Insert borrow record
if (cc == null)
{
return;
}
CirculatedCopyDAO.Insert(cc);
// update type = 'B' at Copy
c = CopyDAO.GetCopy(Int32.Parse(txtCopyNumber.Text));
c.Type = 'B';
CopyDAO.Update(c);
// update status = 'A' at Reservation
if (r == null)
{
return;
}
r.Status = 'A';
ReserveDAO.Update(r);
}
