private void добавитьЭкзаменToolStripMenuItem_Click(object sender, EventArgs e)
{
var add = new AddExam();
add.DisciplinesCB.DataSource = db.Disciplines.Local.ToBindingList(); // дисциплины
add.DisciplinesCB.DisplayMember = "Name";
if (add.ShowDialog() == DialogResult.OK)
{
ExamSheet examSheet = new ExamSheet();
examSheet.Examiner = add.ExaminerTB.Text;
examSheet.Comment = add.CommentTB.Text;
examSheet.Score = Convert.ToInt32(add.ScoreNumericUpDown.Value);
examSheet.EnrolleeId = currentEnrolleeId;
examSheet.discipline = (Discipline)add.DisciplinesCB.SelectedItem;
db.ExamSheets.Add(examSheet); // добавление абитуриента
db.SaveChanges();
//ExamsDataGV.DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList();
ExamsDataGV.DataSource = new BindingSource
{
DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList().Select(b =>
new { b.Id, b.EnrolleeId, b.Examiner, b.discipline.Name, b.Score, b.Comment }
)
};
ExamsDataGV.Columns[0].HeaderText = "id";
ExamsDataGV.Columns[1].HeaderText = "id абитуриента";
ExamsDataGV.Columns[2].HeaderText = "Экзаменатор";
ExamsDataGV.Columns[3].HeaderText = "Название дисциплины";
ExamsDataGV.Columns[4].HeaderText = "Количество набранных баллов";
ExamsDataGV.Columns[5].HeaderText = "Комментарий";
ExamsDataGV.Refresh();
}
}
private void удалитьИнформациюToolStripMenuItem_Click(object sender, EventArgs e)
{
if (ExamsDataGV.SelectedRows.Count > 0)
{
try
{
foreach (DataGridViewRow i in ExamsDataGV.SelectedRows)
{
bool converted = Int32.TryParse(ExamsDataGV[0, i.Index].Value.ToString(), out int id);
if (converted == false)
{
return;
}
ExamSheet examSheet = db.ExamSheets.Find(id);
db.ExamSheets.Remove(examSheet);
db.SaveChanges();
}
//ExamsDataGV.DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList();
ExamsDataGV.DataSource = new BindingSource
{
DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList().Select(b =>
new { b.Id, b.EnrolleeId, b.Examiner, b.discipline.Name, b.Score, b.Comment }
)
};
ExamsDataGV.Columns[0].HeaderText = "id";
ExamsDataGV.Columns[1].HeaderText = "id абитуриента";
ExamsDataGV.Columns[2].HeaderText = "Экзаменатор";
ExamsDataGV.Columns[3].HeaderText = "Название дисциплины";
ExamsDataGV.Columns[4].HeaderText = "Количество набранных баллов";
ExamsDataGV.Columns[5].HeaderText = "Комментарий";
ExamsDataGV.Refresh();
MessageBox.Show("Удаление прошло успешно!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void изменитьИнформациюToolStripMenuItem_Click(object sender, EventArgs e)
{
if (ExamsDataGV.SelectedRows.Count > 0)
{
foreach (DataGridViewRow i in ExamsDataGV.SelectedRows)
{
try
{
bool converted = Int32.TryParse(ExamsDataGV[0, i.Index].Value.ToString(), out int id);
if (converted == false)
{
return;
}
ExamSheet examSheet = db.ExamSheets.Find(id);
var add = new AddExam(examSheet.Examiner, examSheet.Comment, examSheet.Score);
add.DisciplinesCB.DataSource = db.Disciplines.Local.ToBindingList(); // дисциплины
add.DisciplinesCB.DisplayMember = "Name";
if (add.ShowDialog(this) == DialogResult.OK)
{
try
{
examSheet.Examiner = add.ExaminerTB.Text;
examSheet.Comment = add.CommentTB.Text;
examSheet.Score = Convert.ToInt32(add.ScoreNumericUpDown.Value);
examSheet.discipline = (Discipline)add.DisciplinesCB.SelectedItem;
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
add.Close(); // если нажали кнопку отмены
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//dataGridView1.DataSource = new BindingSource { DataSource = list.Select(b => new { b.prop1, p2 = b.prop2.prop1, b.prop2.prop2 }) };
//ExamsDataGV.DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList();
ExamsDataGV.DataSource = new BindingSource
{
DataSource = db.ExamSheets.Where(idenrollee => idenrollee.EnrolleeId == currentEnrolleeId).ToList().Select(b =>
new { b.Id, b.EnrolleeId, b.Examiner, b.discipline.Name, b.Score, b.Comment }
)
}; // АХТУНГ
ExamsDataGV.Columns[0].HeaderText = "id";
ExamsDataGV.Columns[1].HeaderText = "id абитуриента";
ExamsDataGV.Columns[2].HeaderText = "Экзаменатор";
ExamsDataGV.Columns[3].HeaderText = "Название дисциплины";
ExamsDataGV.Columns[4].HeaderText = "Количество набранных баллов";
ExamsDataGV.Columns[5].HeaderText = "Комментарий";
ExamsDataGV.Refresh();
MessageBox.Show("Информация успешно обновлена!");
}
}