private void editExam_Click(object sender, EventArgs e) { if (gvExams.SelectedRows.Count == 1) { frmTaoKyThi frm = new frmTaoKyThi(); Examination oldTest = (Examination)gvExams.SelectedRows[0].DataBoundItem; frm.loadValue(oldTest); frm.ShowDialog(); if (frm.subEdit) { var newTest = frm.getValue(); using (var db = new dbQLThiTracNghiemDataContext()) { Examination t = db.Examinations.Where(p => p.idExamination == oldTest.idExamination).Select(p => p).Single(); t.nameExamination = newTest.nameExamination; t.grade = newTest.grade; t.startTime = newTest.startTime; t.time = newTest.time; t.countStudent = newTest.countStudent; t.type = newTest.type; db.SubmitChanges(); //int index = bs.IndexOf(oldTest); //bs.Remove(oldTest); //bs.Insert(index, t); bs.DataSource = db.Examinations.ToList(); } refreshExam(); } } else { MessageBox.Show("Chọn 1 dòng để chỉnh sửa!"); } }
private void addExam_Click(object sender, EventArgs e) { frmTaoKyThi frm = new frmTaoKyThi(); using (var db = new dbQLThiTracNghiemDataContext()) { var t = new Examination(); db.Examinations.InsertOnSubmit(t); //bs.Add(t); db.SubmitChanges(); frm.idExam = t.idExamination; frm.ShowDialog(); if (frm.subEdit) { frm.setValue(ref t); } else { //db.Examinations.Attach(t); db.Examinations.DeleteOnSubmit(t); //bs.Remove(t); } db.SubmitChanges(); } refreshExam(); }