private void button1_Click(object sender, EventArgs e)
{
int a = 0;
bool finish = true;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (int.TryParse(row.Cells[2].Value.ToString(), out a) == true || row.Cells[2].Value.ToString() == "")
{
if (a < 10)
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Update_Otmetki, row.Cells[0].Value.ToString(), row.Cells[2].Value.ToString());
}
else
{
MessageBox.Show("В качестве отметки для " + row.Cells[1].Value.ToString() + " было выставлено число, превышающее 10.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
finish = false;
}
}
else
{
MessageBox.Show("В качестве отметки для " + row.Cells[1].Value.ToString() + " было выставлено не число.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
finish = false;
}
}
MySqlOperations.Insert_Update_Delete(MySqlQueries.Update_Homework, ID_Homework, richTextBox1.Text);
if (finish)
{
this.Close();
}
}
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 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 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 Delete_String()
{
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
if (identify == "auditorii")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Auditorii, row.Cells[0].Value.ToString());
}
if (identify == "predmety")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Predmety, row.Cells[0].Value.ToString());
}
if (identify == "fakultativy")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Fakultativy, row.Cells[0].Value.ToString());
}
if (identify == "klassy")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Klassy, row.Cells[0].Value.ToString());
}
if (identify == "prepod")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Prepod, row.Cells[0].Value.ToString());
}
if (identify == "ucheniki")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Ucheniki, row.Cells[0].Value.ToString());
}
if (identify == "raspisanie")
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Delete_Raspisanie, row.Cells[0].Value.ToString());
}
}
}
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 Insert_Zanyatiya(DataGridView dataGridView)
{
DateTime Now = DateTime.Now;
string date = Now.Year.ToString() + '-' + Now.Month.ToString() + '-' + Now.Day.ToString();
if (Exists == true)
{
if (MySqlOperations.Select_Text(MySqlQueries.Exists_Zanyatiya, null, dataGridView.SelectedRows[0].Cells[0].Value.ToString(), date, ID_Prepoda) == "0")
{
if (MessageBox.Show("Хотите заполнить занятие?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Zanyatiya, null, dataGridView.SelectedRows[0].Cells[0].Value.ToString(), date, ID_Prepoda);
string ID_Zanyatiya = MySqlOperations.Select_Text(MySqlQueries.Select_Last_ID);
DataTable dataTable = MySqlOperations.Select_DataTable(MySqlQueries.Select_ID_Ucheniki_Klassa, null, dataGridView.SelectedRows[0].Cells[1].Value.ToString());
foreach (DataRow row in dataTable.Rows)
{
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Otmetki, null, row[0].ToString(), ID_Zanyatiya, "");
}
do
{
Now = Now.AddDays(1);
}while (MySqlOperations.Select_Text(MySqlQueries.Exists_Zanyatiya_Today, ID_Prepoda, Now.ToString("dddd", new CultureInfo("ru-RU")).Substring(0, 1).ToUpper() + Now.ToString("dddd", new CultureInfo("ru-RU")).Remove(0, 1).ToLower()) != "1");
MySqlOperations.Insert_Update_Delete(MySqlQueries.Insert_Homework, null, ID_Zanyatiya, Now.Year.ToString() + '-' + Now.Month.ToString() + '-' + Now.Day.ToString(),
MySqlOperations.Select_Text(MySqlQueries.Select_Urok_Homework, ID_Prepoda, Now.ToString("dddd", new CultureInfo("ru-RU")).Substring(0, 1).ToUpper() + Now.ToString("dddd", new CultureInfo("ru-RU")).Remove(0, 1).ToLower(),
MySqlOperations.Select_Text(MySqlQueries.Select_ID_Klassy_ComboBox, null, dataGridView.SelectedRows[0].Cells[1].Value.ToString())));
string ID_Homework = MySqlOperations.Select_Text(MySqlQueries.Select_Last_ID);
Zanyatiya zanyatiya = new Zanyatiya(MySqlQueries, MySqlOperations, ID_Zanyatiya, ID_Homework);
zanyatiya.Text += ID_Zanyatiya;
zanyatiya.Zanyatiya_Closed += Load_Zanyatiya;
zanyatiya.Show();
}
}
else if (MessageBox.Show("Хотите отредактровать занятие?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Open_Zanyatiya(MySqlOperations.Select_Text(MySqlQueries.Select_ID_Zanyatiya, null, dataGridView.SelectedRows[0].Cells[0].Value.ToString(), date, ID_Prepoda),
MySqlOperations.Select_Text(MySqlQueries.Select_ID_Homework, MySqlOperations.Select_Text(MySqlQueries.Select_ID_Zanyatiya, null, dataGridView.SelectedRows[0].Cells[0].Value.ToString(), date, ID_Prepoda)));
}
}
}
