public static int GetSequenceNumberMax(int copyBookNumber)
{
string cmd = "select * from Copy where bookNumber=" + copyBookNumber.ToString();
DataTable dt = DAO.GetDataTable(cmd);
if (dt.Rows.Count == 0)
{
return(0);
}
else
{
return((int)(dt.Compute("max(sequenceNumber)", "")));
}
}
public static DataTable GetDataTable()
{
string cmd = "select * from Borrower";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetReservation(int borrowerNumber)
{
string cmd = "select * from Reservation where status='R' AND borrowerNumber=" + borrowerNumber.ToString();
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from Reservation";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetBorrowedCopies(int borrowerNumber)
{
string cmd = "select * from CirculatedCopy where returnedDate IS NULL AND borrowerNumber=" + borrowerNumber.ToString();
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from CirculatedCopy";
return(DAO.GetDataTable(cmd));
}
