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 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; }