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 Reservation"; 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 Copy"; 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)); }