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);
}
}
}
}
