private void button1_Click(object sender, EventArgs e)
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Klassy, null, numericUpDown1.Value.ToString(), comboBox1.Text) == "0")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Klassy, null, numericUpDown1.Value.ToString(), comboBox1.Text, numericUpDown2.Value.ToString());
this.Close();
}
else
{
MessageBox.Show("Класс " + numericUpDown1.Value.ToString() + comboBox1.Text + " уже присутствует в базе.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void PrepodWin_Load(object sender, EventArgs e)
{
MySqlOperations.OpenConnection();
DateTime dateTime = DateTime.Now;
while (dateTime.DayOfWeek != System.DayOfWeek.Monday)
{
dateTime = dateTime.AddDays(-1);
}
dateTimePicker1.Value = dateTime;
MessageBox.Show("Добро пожаловать, " + MySqlOperations.Select_Text(MySqlQueries.Select_FIO_Ucheniki, ID_Uchenika) + '.', "Приветствие", MessageBoxButtons.OK, MessageBoxIcon.Information);
Load_Raspisanie(MySqlOperations.Select_Text(MySqlQueries.Select_ID_Klassa_Ucheniki, ID_Uchenika));
Load_Uspevaemost();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Auditorii, null, textBox1.Text) == "0")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Auditorii, null, textBox1.Text);
this.Close();
}
else
{
MessageBox.Show("Аудитория №" + textBox1.Text + " уже присутствует в базе.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Поля не заполнены", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "")
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Prepod, null, textBox4.Text, textBox5.Text) != "1")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Prepod, null, textBox1.Text, textBox2.Text, textBox3.Text, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Predmety_ComboBox, null, comboBox1.Text), textBox4.Text, textBox5.Text);
this.Close();
}
else
{
MessageBox.Show("Введенный вами Логин и(или) Пароль уже заняты.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Поля не заполнены.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox3.Text != "admin" && textBox4.Text != "1234")
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Prepod, null, textBox3.Text, textBox4.Text) == "1")
{
ID = MySqlOperations.Select_Text(MySqlQueries.Select_ID_Prepod, null, textBox3.Text, textBox4.Text);
this.DialogResult = DialogResult.Yes;
this.Close();
}
else
{
MessageBox.Show("Неверный логин или пароль.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public Zanyatiya(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD, string iD2)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID_Zanyatiya = iD;
ID_Homework = iD2;
MySqlOperations.Select_DataGridView(MySqlQueries.Select_Otmetki_Zanyatiya, dataGridView1, ID_Zanyatiya);
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].ReadOnly = true;
richTextBox1.Text = MySqlOperations.Select_Text(MySqlQueries.Select_Homework, ID_Homework);
}
private void button4_Click(object sender, EventArgs e)
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Raspisanie, null, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Klassy_ComboBox, null, comboBox1.Text), comboBox2.Text) == "0")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Raspisanie, null, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Klassy_ComboBox, null, comboBox1.Text), comboBox2.Text);
ID = MySqlOperations.Select_Text(MySqlQueries.Select_Last_ID);
button4.Enabled = false;
button3.Text = "Закрыть";
groupBox1.Visible = true;
MySqlOperations.Select_DataGridView(MySqlQueries.Select_Uroki_Raspisaniya, dataGridView1);
dataGridView1.Columns[0].Visible = false;
}
else
{
MessageBox.Show("Для " + comboBox1.Text + " класса уже присутствует расписание на " + comboBox2.Text + ".", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (dateTimePicker2.Value < dateTimePicker3.Value)
{
string date = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString();
string time1 = dateTimePicker2.Value.Hour.ToString() + ':' + dateTimePicker2.Value.Minute.ToString();
string time2 = dateTimePicker3.Value.Hour.ToString() + ':' + dateTimePicker3.Value.Minute.ToString();
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Fakultativy, null, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Predmety_ComboBox, null, comboBox1.Text), MySqlOperations.Select_Text(MySqlQueries.Select_ID_Prepod_ComboBox, null, comboBox3.Text), date, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Auditorii_ComboBox, null, comboBox2.Text), time1, time2);
this.Close();
}
else
{
MessageBox.Show("Факультатив не может начаться позже времени его окончания.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
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;
}
}
