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))); } } }