public void fillComboProfileType()
{
String selectProfileType_SQL = "SELECT * FROM user_profile_type";
MySqlConnection mySqlConnection = DataConnection.getDBConnection();
mySqlConnection.Open();
MySqlCommand cmd_ProfileType = new MySqlCommand(selectProfileType_SQL, mySqlConnection);
MySqlDataReader DataReaderBookType;
DataReaderBookType = cmd_ProfileType.ExecuteReader();
while (DataReaderBookType.Read())
{
String profileType = DataReaderBookType.GetString("name");
comboBoxProfileType.Items.Add(profileType);
}
if (LoginDetails.userRole.Equals("Librarian"))
{
comboBoxProfileType.Items.Remove("Librarian");
}
mySqlConnection.Close();
}
void fillComboType()
{
try
{
String selectBookType_SQL = "SELECT * FROM book_type";
MySqlConnection mySqlConnection = DataConnection.getDBConnection();
mySqlConnection.Open();
MySqlCommand cmd_bookType = new MySqlCommand(selectBookType_SQL, mySqlConnection);
MySqlDataReader DataReaderBookType;
DataReaderBookType = cmd_bookType.ExecuteReader();
while (DataReaderBookType.Read())
{
String bookType = DataReaderBookType.GetString("name");
comboBoxBookType.Items.Add(bookType);
}
mySqlConnection.Close();
}
catch (MySqlException e) {
Console.WriteLine(e);
MessageBox.Show("Please check the connection", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
