public Fakultativy(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
this.ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Predmety_ComboBox, comboBox1);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Auditorii_ComboBox, comboBox2);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Prepod_ComboBox, comboBox3);
dateTimePicker2.Value = DateTime.Parse("16:00:00");
dateTimePicker2.MinDate = dateTimePicker2.Value;
}
public Raspisanie(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Klassy_ComboBox, comboBox1);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Predmety_ComboBox, comboBox3);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Auditorii_ComboBox, comboBox4);
comboBox2.SelectedItem = comboBox2.Items[0];
comboBox5.SelectedItem = comboBox5.Items[0];
}
public Prepod(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
this.ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Predmety_ComboBox, comboBox1);
}
public Ucheniki(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
this.ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Klassy_ComboBox, comboBox1);
}
private void PrepodWin_Load(object sender, EventArgs e)
{
MySqlOperations.OpenConnection();
MessageBox.Show("Добро пожаловать, " + MySqlOperations.Select_Text(MySqlQueries.Select_FIO_Prepod, ID_Prepoda) + '.', "Приветствие", MessageBoxButtons.OK, MessageBoxIcon.Information);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Klassy_ComboBox, comboBox4);
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Klassy_ComboBox, comboBox1);
Load_Raspisanie(ID_Prepoda);
Load_Fakultativy(this, EventArgs.Empty);
DayOfWeek = DateTime.Now.ToString("dddd", new CultureInfo("ru-RU")).Substring(0, 1).ToUpper() + DateTime.Now.ToString("dddd", new CultureInfo("ru-RU")).Remove(0, 1).ToLower();
LockDown_DataGrids();
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Zanyatiya_Today, ID_Prepoda, DayOfWeek) == "1")
{
Exists = true;
}
else
{
Exists = false;
}
}
