public statshome()
{
InitializeComponent();
SQL.editComboBoxItems(comboBox1, "SELECT COUNT(*) FROM Clients");
SQL.editComboBoxItems(comboBox4, "SELECT COUNT(*) FROM Instructors");
SQL.editComboBoxItems(comboBox6, "SELECT COUNT(*) FROM Appointments");
SQL.editComboBoxItems(comboBox5, "SELECT COUNT(*) FROM Clients Where clientType = 'experienced' ");
SQL.editComboBoxItems(comboBox2, "SELECT COUNT(*) FROM Clients Where clientType = 'new' ");
SQL.editComboBoxItems(comboBox3, "SELECT COUNT(*) FROM Appointments");
}
public RegisterPage()
{
InitializeComponent();
//It prepares and limites the different text controls
comboBoxUserType.Items.Add("Clients");
comboBoxUserType.Items.Add("Instructors");
comboBoxUserType.Items.Add("Admins");
textBoxUserName.MaxLength = 32;
textBoxPassword.PasswordChar = '*';
textBoxPassword.MaxLength = 16;
textBoxPassword2.PasswordChar = '*';
textBoxPassword2.MaxLength = 16;
textBoxFirst.MaxLength = 24;
textBoxLast.MaxLength = 24;
textBoxEmail.MaxLength = 64;
textBoxPhone.MaxLength = 10;
//It loads the Client Type Combobox
string clientTypeQuery = "SELECT name FROM ClientTypes";
SQL.editComboBoxItems(comboBoxClientType, clientTypeQuery);
}
public DeleteClient()
{
InitializeComponent();
SQL.editComboBoxItems(comboBox1, "SELECT username FROM Clients");
}
public Deleteins()
{
InitializeComponent();
SQL.editComboBoxItems(comboBox1, "SELECT username FROM Instructors");
}
