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 void sLoadSubject() { boDkHoc = new BO_DANG_KI_HOC(); listSubject.DataSource = boDkHoc.getSubjectName(int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString())); listSubject.ValueMember = "MON_ID"; listSubject.DisplayMember = "MON_Name"; listSubject.CheckAll(); }
private void initComboboxMonHoc() { BO_DANG_KI_HOC dao_dangki_hoc = new BO_DANG_KI_HOC(); lookMonHoc.Properties.DataSource = dao_dangki_hoc.getSubjectName(int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString())); lookMonHoc.Properties.ValueMember = "MON_ID"; lookMonHoc.Properties.DisplayMember = "MON_Name"; }
private void nodeClick(TreeNode node) { if (node.Tag.Equals("CHC")) { lbl_totalHocvien.Text = "Tổng số lớp : " + node.Nodes.Count; } else if (node.Tag.Equals("LOP")) { string LOP_ID = node.Name; BO_DANG_KI_HOC dangkihoc = new BO_DANG_KI_HOC(); DataTable tbl_hocvien = dangkihoc.getHocvienByLopID(Convert.ToInt32(LOP_ID)); gridStudent.DataSource = tbl_hocvien; lbl_totalHocvien.Text = "Tổng số học viên : " + tbl_hocvien.Rows.Count; } }
private void loadDataToGrid() { boDkHoc = new BO_DANG_KI_HOC(); dtoDkHoc = new DANG_KI_HOC(); DataTable vtb = new DataTable(); dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); vtb = boDkHoc.getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(dtoDkHoc); if (vtb.Rows.Count > 0) { gridRegister.DataSource = vtb.DefaultView; } else { gridRegister.DataSource = null; } }
private void vLoadData() { boDangKiHoc = new BO_DANG_KI_HOC(); dtoDkHoc = new DANG_KI_HOC(); dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); DataTable vtb = new DataTable(); vtb = boDangKiHoc.getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(dtoDkHoc); if (vtb.Rows.Count > 0) { gridRegister.DataSource = vtb; lblCounter.Text = " Tổng số học viên trong lớp: " + grvRegisterContent.RowCount + " "; lblCounter.BackColor = Color.White; lblCounter.ForeColor = Color.Red; } }
private void sGeneralCodeDangKiHocVien() { DataTable tb = new DataTable(); boDkHoc = new BO_DANG_KI_HOC(); tb = boDkHoc.getDanKiHoc_LastCode(); string dkhCode = String.Empty; if (tb.Rows.Count == 0) { dkhCode = "000000"; } else if (tb.Rows[0]["DKH_Code"].ToString() != string.Empty) { dkhCode = tb.Rows[0]["DKH_Code"].ToString(); dkhCode = dkhCode.Substring(3, 5); txtDKHCode.Text = ("DKH" + Utilities.quydinh.LaySTT(int.Parse(dkhCode.ToString()) + 1)).ToString(); mDkhStatust = int.Parse(dkhCode.ToString()); } }
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 gridStudentContent_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { //MessageBox.Show(e.RowHandle.ToString()); //int Ma_HocVien = Convert.ToInt32(gridStudentContent.GetRowCellValue(e.RowHandle, "HOV_ID")); if (table_cap_chung_chi.Rows.Count > 0) { int Ma_HocVien = Convert.ToInt32(table_cap_chung_chi.Rows[e.RowHandle]["HOV_ID"]); BO_DANG_KI_HOC bo_dangki_hoc = new BO_DANG_KI_HOC(); gridMarks.DataSource = bo_dangki_hoc.getDANG_KI_HOC_By_HocVien_ID(Ma_HocVien); BO_CAP_CHUNGCHI bo_cap_chungchi = new BO_CAP_CHUNGCHI(); gridTeached.DataSource = bo_cap_chungchi.getCAP_CHUNG_CHI_By_HocVienID(Ma_HocVien); #region left panel info txtStudentName.Text = table_cap_chung_chi.Rows[e.RowHandle]["FirstName"].ToString() + table_cap_chung_chi.Rows[e.RowHandle]["LastName"].ToString(); dateBirthDay.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString()); txtCerNumber.Text = table_cap_chung_chi.Rows[e.RowHandle]["SoCC"].ToString(); //dateAllocate.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString()); //dateExpire.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString()); checkDate(); #endregion } }
private void loadDataToGrid() { grvRegisterContent.OptionsBehavior.ReadOnly = false; if (grvRegisterContent.RowCount > 0) { sselection.CheckMarkColumn.Dispose(); } boDkh = new BO_DANG_KI_HOC(); dtoDkHoc = new DANG_KI_HOC(); //int ChungChi_ID = int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString()); dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); gridRegister.DataSource = boDkh.getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(dtoDkHoc); // new DevExpress.XtraGrid.Design.XViewsPrinting(gridControl1); //grvRegisterContent.Columns["iSCheck"].GroupIndex = 0; //grvRegisterContent.ExpandAllGroups(); sselection = new GridCheckMarksSelection(grvRegisterContent); sselection.CheckMarkColumn.VisibleIndex = 0; sselection.CheckMarkColumn.Width = 8; }
private void txtSearchText_EditValueChanging(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e) { boDkHoc = new BO_DANG_KI_HOC(); //if ( int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString()) <-1 && int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()) < -1) if (int.Parse(lookCcID.ItemIndex.ToString()) < 0 && int.Parse(lookUpLop.ItemIndex.ToString()) < 0) { MessageBox.Show("Chọn khóa học, và lớp học muốn tìm kiếm học viên", "THÔNG BÁO"); return; } else { if (txtSearchText.Text == string.Empty) { // ((DataTable)gridCertificate.DataSource).Rows.Clear(); loadDataToGrid(); } else if (txtSearchText.Text != string.Empty) { gridRegister.DataSource = boDkHoc.search_StudentLastName_In_DKH_New(int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()), txtSearchText.Text); } } }
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); } } } }