private void btnDelete_Click(object sender, EventArgs e) { boDkHoc = new BO_DANG_KI_HOC(); boDiem = new BO_DIEM(); DataRow selectedRow = grvRegisterContent.GetDataRow(grvRegisterContent.FocusedRowHandle); if (selectedRow != null) { if (MessageBox.Show("Bạn có chắc chắn xóa học viên này không?", "DELETE", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int lopId = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); int hvId = int.Parse(selectedRow["HOV_ID"].ToString()); int vDkhID = int.Parse(selectedRow["DKH_ID"].ToString()); selectedRow.Delete(); boDkHoc.vDeletedHvInDangKiHoc(vDkhID); boDiem.delete_DIEM_By_HVID(lopId, hvId); //Call Delete in table CAP_CHUNGCHI boDkHoc.DeleteCAP_CHUNGCHI_By_HovID(lopId, hvId); clearInputData(1); loadDataToGrid(); lookUpLop.ClosePopup(); lookUpBirthPlace.ClosePopup(); lookUpDonvi.ClosePopup(); lookUpBirthPlace.EditValue = null; lookUpDonvi.EditValue = null; sResultSearchByFirstName(); sCounter(); } } }
private void vSaveRegisterCoures(int vCheck) { dtoDkHoc = new DANG_KI_HOC(); boDangKiHoc = new BO_DANG_KI_HOC(); dtoDiem = new DIEM(); boDiem = new BO_DIEM(); dtoDkHoc.DKH_Code = txtDKHCode.Text; dtoDkHoc.DKH_BienLai = txtSoBienLai.Text; dtoDkHoc.DKH_Diem = null; dtoDkHoc.DKH_LanThi = null; dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); dtoDkHoc.DKH_HOVID = gHocVienID; if (vCheck == 1) { //Lưu vào bảng đăng kí học boDangKiHoc.insert(dtoDkHoc); dtoDiem.DIE_CHCID = int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString()); dtoDiem.DIE_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); dtoDiem.DIE_HOVID = gHocVienID; dtoDiem.DIE_Diem = null; dtoDiem.DIE_LanThi = 1; dtoDiem.DIE_NgayNhapDiem = null; for (int ii = 0; ii < listSubject.ItemCount; ii++) { if (listSubject.GetItemChecked(ii)) { // Luu vao table Diem dtoDiem.DIE_MONID = int.Parse(listSubject.GetItemValue(ii).ToString()); boDiem.insert(dtoDiem); } } } }
private int sLoadLanThi() { boDiem = new BO_DIEM(); lookLanThi.Properties.DataSource = boDiem.lanThi(int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()), int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString())); lookLanThi.Properties.ValueMember = "DIE_LanThi"; lookLanThi.Properties.DisplayMember = "DIE_LanThi"; lookLanThi.ItemIndex = 0; //int sLanthi = sLoadLanThi(); //DataTable vtbl = new DataTable(); //sLanthi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString()); //int sLopID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); //int sMonID = int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString()); //vtbl = boDiem.select_Diem_by_LanThi(sLopID, sMonID, sLanthi); //if (sLanthi > 1) //{ // DataTable vtbl1 = new DataTable(); // vtbl1 = boDiem.select_Diem_by_LanThi(sLopID, sMonID, 1); // if (vtbl1.Rows.Count <= 0 || vtbl1.Columns["DIE_Diem"].ToString() == null) // { // MessageBox.Show("Lớp này chưa nhập điểm thi lần 1", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning); // loadDataToGrid(); // //return; // } //} return(lookLanThi.ItemIndex); }
private void initComboboxLanThi(int vLopID, int vMonID) { boDiem = new BO_DIEM(); lookLanThi.Properties.DataSource = boDiem.lanThi(vLopID, vMonID); lookLanThi.Properties.ValueMember = "DIE_LanThi"; lookLanThi.Properties.DisplayMember = "DIE_LanThi"; lookLanThi.ItemIndex = 0; }
private void sSaveRegisterCoures(int sCheck) { dtoDkHoc = new DANG_KI_HOC(); boDkHoc = new BO_DANG_KI_HOC(); dtoDiem = new DIEM(); boDiem = new BO_DIEM(); dtoDkHoc.DKH_Code = txtDKHCode.Text; dtoDkHoc.DKH_BienLai = txtSoBienLai.Text; dtoDkHoc.DKH_Diem = null; dtoDkHoc.DKH_LanThi = null; dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); dtoDkHoc.DKH_HOVID = gIDHocVien; if (sCheck == 1) { // Lay lai ID hoc vien o day de insert vao bang diem. boDkHoc.insert(dtoDkHoc); dtoDiem.DIE_CHCID = int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString()); dtoDiem.DIE_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); dtoDiem.DIE_HOVID = gIDHocVien; dtoDiem.DIE_Diem = null; dtoDiem.DIE_LanThi = 1; dtoDiem.DIE_NgayNhapDiem = null; for (int ii = 0; ii < listSubject.ItemCount; ii++) { if (listSubject.GetItemChecked(ii)) { // Luu vao table Diem dtoDiem.DIE_MONID = int.Parse(listSubject.GetItemValue(ii).ToString()); boDiem.insert(dtoDiem); } } } else if (sCheck == 2) { dtoDkHoc.DKH_ID = mDkhId; boDkHoc.update(dtoDkHoc); MessageBox.Show("Cập nhập thông tin thành công", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void saveStudentIntoNewClass() { dtoDkHoc = new DANG_KI_HOC(); dtoDiem = new DIEM(); boDiem = new BO_DIEM(); boDkh = new BO_DANG_KI_HOC(); //int sCcId = -1; //int sIdMon = -1; //int sClassId = -1; //int sStudenstId = -1; dtoDkHoc.DKH_BienLai = string.Empty; dtoDiem.DIE_LOPID = dtoDkHoc.DKH_LOPID = int.Parse(lookLopNew.GetColumnValue("LOP_ID").ToString()); dtoDkHoc.DKH_Diem = null; dtoDkHoc.DKH_LanThi = null; dtoDiem.DIE_CHCID = int.Parse(lookChungChiNew.GetColumnValue("CHC_ID").ToString()); for (int i = 0; i < grvNewClass.RowCount; i++) { dtoDkHoc.DKH_Code = sGeneralCodeDangKiHocVien().ToString(); // ID hoc vien o day moi chi lay la ID cuoi, nen khong dam bao insert dung hoc vien vao bang diem dtoDiem.DIE_HOVID = dtoDkHoc.DKH_HOVID = int.Parse(grvNewClass.GetRowCellValue(i, "HOV_ID").ToString()); boDkh.insert(dtoDkHoc); dtoDiem.DIE_Diem = null; dtoDiem.DIE_LanThi = 1; dtoDiem.DIE_NgayNhapDiem = null; for (int ii = 0; ii < listSubject.ItemCount; ii++) { if (listSubject.GetItemChecked(ii)) { // Luu vao table Diem dtoDiem.DIE_MONID = int.Parse(listSubject.GetItemValue(ii).ToString()); boDiem.insert(dtoDiem); } } } }
private void btnSave_Click(object sender, EventArgs e) { boCapcc = new BO_CAP_CHUNGCHI(); dtoCapCc = new CAP_CHUNGCHI(); boDiem = new BO_DIEM(); dtoDiem = new DIEM(); DataTable tb = new DataTable(); tb = (DataTable)gridEntryCoures.DataSource; for (int i = 0; i < tb.Rows.Count; i++) { dtoDiem.DIE_ID = int.Parse(tb.Rows[i]["DIE_ID"].ToString()); // De phong khi chua nhap diem ma bam luu. if (tb.Rows[i]["DIE_Diem"].ToString() == "") { dtoDiem.DIE_Diem = 0; } else { dtoDiem.DIE_Diem = int.Parse(tb.Rows[i]["DIE_Diem"].ToString()); } dtoDiem.DIE_LanThi = int.Parse(lookLanThi.Text.ToString()); dtoDiem.DIE_NgayNhapDiem = dateEntryScores.DateTime; if (dtoDiem.DIE_LanThi == 1) { if (dtoDiem.DIE_Diem > 4) { // Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1 boDiem.update_DiemThi_Into_DIEM(dtoDiem); } else { // Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien dtoDiem.DIE_LanThi++; boDiem.update_DiemThi_Into_DIEM(dtoDiem); } } else { //Update diem lan thi thu n if (dtoDiem.DIE_Diem > 4) { // Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1 boDiem.update_DiemThi_Into_DIEM(dtoDiem); } else { // Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien dtoDiem.DIE_LanThi++; boDiem.update_DiemThi_Into_DIEM(dtoDiem); } } if (vCheckLopDaCapCC()) { if (dtoDiem.DIE_Diem > 4) { // Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1 boDiem.update_DiemThi_Into_DIEM(dtoDiem); } else { // Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien dtoDiem.DIE_LanThi++; boDiem.update_DiemThi_Into_DIEM(dtoDiem); //Trong truong hop da cap chung chi roi ma sua lai diem nho hon 5 cập nhật số chứng chỉ về null // Sau khi nhap lai diem >5 thi cap lai so chung chi dtoCapCc.CCC_ID = int.Parse(tb.Rows[i]["CCC_ID"].ToString()); dtoCapCc.CCC_HOVID = int.Parse(tb.Rows[i]["HOV_ID"].ToString()); dtoCapCc.CCC_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); dtoCapCc.CCC_SoCC = string.Empty; dtoCapCc.CCC_NgayCap = null; dtoCapCc.CCC_NgayHetHan = null; boCapcc.update_SoCc(dtoCapCc); } } } MessageBox.Show("Nhập điểm thành công", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information); sLoadLanThi(); }