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