private void btnXoa_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Bạn có muốn xóa không?", "Xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { maMonHoc = cbbMonHoc.SelectedValue.ToString().Trim(); maSinhVien = cbbSinhVien.SelectedValue.ToString().Trim(); try { MessageBox.Show("Bạn đã xóa thành công"); busDien.XoaKhoa(maSinhVien, maMonHoc); dataGridView1.DataSource = busDien.GetDiem(); Xoa(); } catch (Exception A) { MessageBox.Show(A.Message); } } }
private void GridView_BangDiem_CellEndEdit(object sender, DataGridViewCellEventArgs e) { int row = e.RowIndex; int column = e.ColumnIndex; currentHocSinh = GridView_BangDiem.Rows[row].Cells[0].Value.ToString(); string MaLoaiKT = GridView_BangDiem.Columns[column].DataPropertyName.ToString(); //Console.WriteLine(MaLoaiKT); /* * double? d; * if (GridView_BangDiem.Rows[row].Cells[column].Value == DBNull.Value) * d = null; * else * d = double.Parse(GridView_BangDiem.Rows[row].Cells[column].Value.ToString()); * * // Console.WriteLine(diem.ToString()); * * if (d < listThamSo.DiemToiThieu || d > listThamSo.DiemToiDa) * { * MessageBox.Show("Điểm phải nằm trong khoảng từ " + listThamSo.DiemToiThieu + " đến " + listThamSo.DiemToiDa, "Đã xảy ra lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error); * reverseCurrentCell(); * return; * } * * int? result = null; * * if (d != null) * { * if (diem.GetDiem(currentHocSinh, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT) == null) * { * result = diem.Insert_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT, d); * } * else * { * result = diem.Update_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT, d); * } * } * else * { * if (diem.GetDiem(currentHocSinh, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT) != null) * { * result = diem.Delete_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT); * } * } * * if (result != 1) * { * MessageBox.Show("Không thể cập nhật thông tin", "Đã xảy ra lỗi!", MessageBoxButtons.OK, MessageBoxIcon.Error); * }*/ //int? result = null; string d; if (GridView_BangDiem.Rows[row].Cells[column].Value == DBNull.Value) { d = null; } else { d = GridView_BangDiem.Rows[row].Cells[column].Value.ToString(); } if (d == null) { if (diem.GetDiem(currentHocSinh, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT) != null) { diem.Delete_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT); } } else { List <double> listDiem = getListDiem(d); foreach (double p in listDiem) { if (p == -1) { MessageBox.Show("Không đúng định dạng", "Đã xảy ra lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); LoadBangDiem(); return; } } if (diem.GetDiem(currentHocSinh, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT) == null) { foreach (double p in listDiem) { diem.Insert_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT, p); } } else { diem.Delete_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT); foreach (double p in listDiem) { diem.Insert_Diem(currentHocSinh, currentLop, currentHocKy, currentNamHoc, currentMonHoc, MaLoaiKT, p); } } } LoadBangDiem(); }