private void SetComboBoxes()
{
try
{
NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "nationality");
while (dataReader.Read())
{
cbNationality.Items.Add(dataReader[0].ToString());
}
dataReader = PgSql.SelectFrom("color", "Eyecolor");
while (dataReader.Read())
{
cbEyeColor.Items.Add(dataReader[0].ToString());
}
dataReader = PgSql.SelectFrom("color", "Haircolor");
while (dataReader.Read())
{
cbHairColor.Items.Add(dataReader[0].ToString());
}
foreach (Control c in pnlControls.Controls)
{
if (c.GetType().Equals(cbEyeColor.GetType()))
{
((ComboBox)(c)).SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
}
private void SetComboBoxes()
{
try
{
NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "placetype");
cbPlaceTheme.Items.Clear();
cbPlaceType.Items.Clear();
while (dataReader.Read())
{
String s = dataReader[0].ToString();
cbPlaceType.Items.Add(s);
//MessageBox.Show(dataReader[0].ToString());
}
dataReader.Close();
dataReader = PgSql.SelectFrom("name", "placetheme");
while (dataReader.Read())
{
this.cbPlaceTheme.Items.Add(dataReader[0].ToString());
//MessageBox.Show(dataReader[0].ToString());
}
dataReader.Close();
foreach (Control c in this.Controls.OfType <ComboBox>())
{
((ComboBox)(c)).SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
}
private void SetComboBoxes()
{
try
{
NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "nationality");
while (dataReader.Read())
{
cbNationality.Items.Add(dataReader[0].ToString());
}
dataReader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.DialogResult = DialogResult.Cancel;
this.Close();
}
}
private void SetComboBoxes()
{
try
{
NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "WorkPosition");
while (dataReader.Read())
{
cbPosition.Items.Add(dataReader[0].ToString());
}
dataReader.Close();
cbPosition.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
}
private void ShowAllUsers()
{
y = 10;
ClearUserButtons();
try
{
PgSql.ConnectToUsersDB(role, role_pass);
NpgsqlDataReader dataReader = PgSql.SelectFrom("login,role", "users");
while (dataReader.Read())
{
CreateUsersButtons(dataReader[0].ToString(), dataReader[1].ToString());
}
dataReader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
lblNoUsers.Visible = true;
btnRegistrate.Enabled = false;
}
}
