//Update Question in DB
private void QuestionEditButton_Click(object sender, EventArgs e)
{
AccessConnection.Open();
OleDbDataReader AccessReader = null;
OleDbCommand command = new OleDbCommand("UPDATE Questions SET Question=@Question WHERE Id_ques=@Id_ques", AccessConnection);
command.Parameters.AddWithValue("Question", QuestionTextBoxEdit.Text);
command.Parameters.AddWithValue("Id_ques", QuestionComboBoxID.Text);
{
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
QuestionComboBoxID.Items.Clear();
QuestionTextBoxEdit.Clear();
OleDbCommand NewCommand = new OleDbCommand("SELECT Id_ques FROM Questions", AccessConnection);
try
{
AccessReader = NewCommand.ExecuteReader();
while (AccessReader.Read())
{
QuestionComboBoxID.Items.Add(Convert.ToString(AccessReader["Id_ques"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
AccessConnection.Close();
}
//Update form
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
{
AccessConnection.Open();
DBConnectionStatus.Text = "Обновление";
OleDbDataReader AccessReader = null;
while (GeneralDGV.Rows.Count > 1)
{
for (int i = 0; i < GeneralDGV.Rows.Count - 1; i++)
{
GeneralDGV.Rows.Remove(GeneralDGV.Rows[i]);
}
}
DeleteTeacherComboBox.Items.Clear();
EditTeacherComboBox.Items.Clear();
DeleteGroupComboBox.Items.Clear();
EditGroupComboBox.Items.Clear();
QuestionComboBoxID.Items.Clear();
QuestionTextBoxEdit.Clear();
AvgListBoxTeacherQuestion.Items.Clear();
AvgListBoxTeacher.Items.Clear();
AvgListBoxTeacherGroup.Items.Clear();
AvgTextBox.Clear();
//GeneralDGV filling
{
this.resultTableAdapter1.Fill(this.databaseTIDataSet1.Result);
this.resultTableAdapter.Fill(this.databaseTIDataSet.Result);
}
//TeacherTab filling
{
OleDbCommand command = new OleDbCommand("SELECT Teacher FROM Teachers GROUP BY Teacher", AccessConnection);
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
EditTeacherComboBox.Items.Add(Convert.ToString(AccessReader["Teacher"]));
DeleteTeacherComboBox.Items.Add(Convert.ToString(AccessReader["Teacher"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
//QuestionTab Filling
{
OleDbCommand command = new OleDbCommand("SELECT Id_ques FROM Questions", AccessConnection);
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
QuestionComboBoxID.Items.Add(Convert.ToString(AccessReader["Id_ques"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
//GroupTab Filling
{
OleDbCommand command = new OleDbCommand("SELECT GroupName FROM Groups GROUP BY GroupName", AccessConnection);
{
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
EditGroupComboBox.Items.Add(Convert.ToString(AccessReader["GroupName"]));
DeleteGroupComboBox.Items.Add(Convert.ToString(AccessReader["GroupName"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
}
//AVG Filling
{
//GeneralAvg
{
OleDbCommand command = new OleDbCommand("SELECT ROUND(AVG(Mark),2) AS MarkAVG FROM Result", AccessConnection);
{
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
AvgTextBox.Text = Convert.ToString(AccessReader["MarkAVG"]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
}
//TeacherAvg
{
OleDbCommand command = new OleDbCommand("SELECT Teacher, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY Teacher", AccessConnection);
{
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
AvgListBoxTeacher.Items.Add(Convert.ToString(AccessReader["Teacher"]) + ": " + Convert.ToString(AccessReader["MarkAVG"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
}
//TeacherGroupAvg
{
OleDbCommand command = new OleDbCommand("SELECT Teacher, GroupName, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY GroupName, Teacher", AccessConnection);
{
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
AvgListBoxTeacherGroup.Items.Add(Convert.ToString(AccessReader["Teacher"]) + " - " + Convert.ToString(AccessReader["GroupName"]) + ": " + Convert.ToString(AccessReader["MarkAVG"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
}
//QuestionAvg
{
OleDbCommand command = new OleDbCommand("SELECT Teacher, Id_ques, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY Teacher, Id_ques", AccessConnection);
{
try
{
AccessReader = command.ExecuteReader();
while (AccessReader.Read())
{
AvgListBoxTeacherQuestion.Items.Add(Convert.ToString(AccessReader["Teacher"]) + " - Вопрос #" + Convert.ToString(AccessReader["Id_ques"]) + ": " + Convert.ToString(AccessReader["MarkAVG"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (AccessReader != null)
{
AccessReader.Close();
}
}
}
}
}
AccessConnection.Close();
DBConnectionStatus.Text = "Подключено";
}
