public static bool checkInItem(int studentId, int itemId) { bool returnVal = false; DateTime checkInTime = DateTime.Now; if (sDBHandler == null) { sDBHandler = new DatabaseHandler(); } try { sDBHandler.open(); // If item id is invalid, display error alert if (!verifyItemId(itemId)) { displayInvalidItemId(); } // If item is not checked out by student, display error else if (!isItemCheckedOut(itemId, studentId)) { displayItemNotCheckedOut(); } else { // If item is overdue, we need to update the fees if (isOverDue(itemId, checkInTime)) { updateLateFees(itemId, studentId, checkInTime); } // If item is book, we need to update the quanitity if (isBook(itemId)) { updateBookQuantity(itemId, true); } // Display that item was checked in displayItemCheckedIn(); // Update the item to being checked in in the database returnVal = markItemAsCheckedIn(itemId, studentId); } } catch (Exception exception) { System.Diagnostics.Debug.WriteLine("ItemHelper CheckInItem" + exception.StackTrace); } sDBHandler.close(); return returnVal; }
public static bool checkOutItem(int studentId, int itemId) { bool returnVal = false; if (sDBHandler == null) { sDBHandler = new DatabaseHandler(); } try { sDBHandler.open(); // If item id is not found in db, display error alert if (!verifyItemId(itemId)) { displayInvalidItemId(); } // If item is alreeady checked out by student display error alert else if (isItemCheckedOut(itemId, studentId)) { displayItemAlreadyCheckedOut(); } //If item is a magazine, display error alert else if (!verifyItemNotMagazine(itemId)) { displayItemIsMagazine(); } // If item is not avialable display an error elert else if (!isItemAvailable(itemId)) { displayItemNotAvailable(); } else { // Else display that the item was checked out displayItemCheckedOut(); // Update the item as checked out in the database returnVal = markItemAsCheckedOut(itemId, studentId, DateTime.Now); } } catch (Exception exception) { System.Diagnostics.Debug.WriteLine("ItemHelper CheckOutItem" + exception.StackTrace); } sDBHandler.close(); return returnVal; }
public static DataTable performItemSearch(string searchCategory, string searchString) { searchCategory = "'" + searchCategory + "'"; searchString = "'%" + searchString + "%'"; DatabaseHandler db = new DatabaseHandler(); DataTable dataTable = new DataTable(); try { db.open(); string sql = "SELECT * FROM " + sItemTable + " WHERE (`Category`=" + searchCategory + " && (`Title` LIKE " + searchString + " OR `Year` LIKE " + searchString + " OR `Genre` LIKE " + searchString + " OR `Author` LIKE " + searchString + " OR `Publisher` LIKE " + searchString + "));"; MySqlCommand cmd = new MySqlCommand(sql, db.getDB()); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); adapter.Fill(dataTable); } catch (Exception exception) { System.Diagnostics.Debug.WriteLine("ItemHelper PerformItemSearch" + exception.StackTrace); } db.close(); return dataTable; }
public static bool reserveItem(int studentId, int itemId) { bool returnVal = false; if (sDBHandler == null) { sDBHandler = new DatabaseHandler(); } try { sDBHandler.open(); // If item id is not found in database, show an error alert if (!verifyItemId(itemId)) { displayInvalidItemId(); } // If item is already checked out by the student, display an error message else if (isItemCheckedOut(itemId, studentId)) { displayItemAlreadyCheckedOut(); } // Check to make sure the item is not a magazine else if (!verifyItemNotMagazine(itemId)) { displayItemIsMagazine(); } // Check to make sure the item is available else if (!isItemAvailable(itemId)) { displayItemNotAvailable(); } else { // Display that the item was reserved displayItemReserved(); // Update the item to reserved by student in the database returnVal = markItemAsReserved(itemId, studentId, DateTime.Now); } } catch (Exception exception) { System.Diagnostics.Debug.WriteLine("ItemHelper ReserveItem" + exception.StackTrace); } sDBHandler.close(); return returnVal; }
public bool verifyID() { DatabaseHandler db = new DatabaseHandler(); try { // Get ID from database and check to see if it matches one setup with Librarian Object db.open(); // Query to select all columns from database where LibrarianID == mId string sql = "SELECT * FROM " + sLibrarianTable + " WHERE `LibrarianID`=" + mId + ";"; // Create a command MySqlCommand cmd = new MySqlCommand(sql, db.getDB()); // Execute command and store results in reader MySqlDataReader reader = cmd.ExecuteReader(); // We found a matching record in the database if (reader.Read()) { // Get the Librarian ID and name from records and set isLoggedIn to true mId = int.Parse(reader["LibrarianID"].ToString()); mName = reader["Name"].ToString(); mIsLoggedIn = true; } // Close reader reader.Close(); } catch (FormatException formException) { System.Diagnostics.Debug.WriteLine("LibrarianVerifyId" + formException.StackTrace); } catch (Exception exception) { System.Diagnostics.Debug.WriteLine("LibrarianVerifyId" + exception.StackTrace); } // Close db db.close(); return mIsLoggedIn; }