private void Load_Uspevaemost()
{
DataTable dt = null;
if (dateTimePicker2.Value.Month < 10)
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Predmety, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + '0' + dateTimePicker2.Value.Month.ToString());
}
else
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Predmety, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString());
}
if (dt.Rows.Count > 0)
{
if (dateTimePicker2.Value.Month < 10)
{
dataGridView8.Rows.Add(dt.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView8.Rows[i].Cells[0].Value = dt.Rows[i][0];
}
for (int i = 1; i <= 31; i++)
{
if (i < 10)
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Daily, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + '0' + dateTimePicker2.Value.Month.ToString(), "0" + i.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[i].Value = dt.Rows[j][0];
}
}
else
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Daily, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + '0' + dateTimePicker2.Value.Month.ToString(), i.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[i].Value = dt.Rows[j][0];
}
}
}
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_SrBal, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + '0' + dateTimePicker2.Value.Month.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[32].Value = dt.Rows[j][0];
}
label6.Text = MySqlOperations.Select_Text(MySqlQueries.Select_SrBal_Uchenika, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + '0' + dateTimePicker2.Value.Month.ToString());
}
else
{
dataGridView8.Rows.Add(dt.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView8.Rows[i].Cells[0].Value = dt.Rows[i][0];
}
for (int i = 1; i <= 31; i++)
{
if (i < 10)
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Daily, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString(), "0" + i.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[i].Value = dt.Rows[j][0];
}
}
else
{
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_Daily, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString(), i.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[i].Value = dt.Rows[j][0];
}
}
}
dt = MySqlOperations.Select_DataTable(MySqlQueries.Select_Uspevaemost_SrBal, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
dataGridView8.Rows[j].Cells[32].Value = dt.Rows[j][0];
}
label6.Text = MySqlOperations.Select_Text(MySqlQueries.Select_SrBal_Uchenika, ID_Uchenika, dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString());
}
for (int i = 0; i < dataGridView8.Rows.Count; i++)
{
for (int j = 1; j < dataGridView8.Columns.Count - 1; j++)
{
if (dataGridView8.Rows[i].Cells[j].Value != null)
{
if (int.Parse(dataGridView8.Rows[i].Cells[j].Value.ToString()) < 4)
{
dataGridView8.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
break;
}
}
}
}
dataGridView8.ClearSelection();
}
else
{
dataGridView8.Rows.Clear();
label6.Text = "";
}
}
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)));
}
}
}
