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);
}
}
}
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
DANG_KI_HOC obj = new DANG_KI_HOC();
obj.DKH_ID = int.Parse(dt.Rows[i]["DKH_ID"].ToString());
//some column
return((object)obj);
}
public void delete(int dangki_ID)
{
DAL_DANG_KI_HOC dangki_dal = new DAL_DANG_KI_HOC();
DANG_KI_HOC dangki = new DANG_KI_HOC();
dangki.DKH_ID = dangki_ID;
dangki_dal.delete(dangki);
}
public DataTable getByID(int dangki_ID)
{
DAL_DANG_KI_HOC dangki_dal = new DAL_DANG_KI_HOC();
DANG_KI_HOC dangki = new DANG_KI_HOC();
dangki.DKH_ID = dangki_ID;
return(dangki_dal.getByID_DANG_KI_HOC(dangki));
}
public DataTable getDangKiHoc_ByLopID(int lopID)
{
DANG_KI_HOC dkLopID = new DANG_KI_HOC();
dkLopID.DKH_LOPID = lopID;
DAL_DANG_KI_HOC dao = new DAL_DANG_KI_HOC();
return(dao.getDangKiHoc_ByLopID(dkLopID));
}
public DataTable getCAP_CHUNGCHI_HV_ByLastNameContrain(string lastName)
{
DANG_KI_HOC searchLastName = new DANG_KI_HOC();
searchLastName.DKH_LastName = lastName;
DAL_DANG_KI_HOC dao = new DAL_DANG_KI_HOC();
return(dao.getCAP_CHUNGCHI_HV_ByLastNameContrain(searchLastName));
}
public DataTable getDANG_KI_HOC_By_HocVien_ID(int hocvien_ID)
{
DANG_KI_HOC dkhoc = new DANG_KI_HOC();
dkhoc.DKH_HOVID = hocvien_ID;
DAL_DANG_KI_HOC dao = new DAL_DANG_KI_HOC();
return(dao.getDANG_KI_HOC_By_HocVien_ID(dkhoc));
}
public DataTable searchHocVien_In_DKH_ByName(int lopID, string lastName) //(int lopID,
{
DANG_KI_HOC boDkh = new DANG_KI_HOC();
boDkh.DKH_LOPID = lopID;
boDkh.DKH_LastName = lastName;
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.searchHocVien_In_DKH_ByName(boDkh));
}
public void delete(DANG_KI_HOC Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@DKH_ID", SqlDbType.Int, 4, Certificate.DKH_ID)
};
int errorcode = RunProc("usp_DeleteDANG_KI_HOC", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void update_diem(int DKH_ID,
int DKH_Diem,
int DKH_LanThi
)
{
DAL_DANG_KI_HOC dangki_dal = new DAL_DANG_KI_HOC();
DANG_KI_HOC dangki = new DANG_KI_HOC();
dangki.DKH_ID = DKH_ID;
dangki.DKH_Diem = DKH_Diem;
dangki.DKH_LanThi = DKH_LanThi;
dangki_dal.update_diem(dangki);
}
public void update_diem(DANG_KI_HOC Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@DKH_ID", SqlDbType.Int, 4, Certificate.DKH_ID),
MakeInParam("@DKH_Diem", SqlDbType.Int, 4, Certificate.DKH_Diem),
MakeInParam("@DKH_LanThi", SqlDbType.Int, 4, Certificate.DKH_LanThi)
};
int errorcode = RunProc("usp_UpdateDANG_KI_HOC_DIEM", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
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 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;
}
}
public DataTable getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(DANG_KI_HOC dkHoc)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@Lop_ID", SqlDbType.Int, 4, dkHoc.DKH_LOPID)
};
int errorcode = RunProcDS("GetHocVien_DangKiHoc", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public int insert(DANG_KI_HOC dkhoc)
{
SqlParameter[] prams =
{
MakeInParam("@DKH_Code", SqlDbType.NVarChar, 20, dkhoc.DKH_Code),
MakeInParam("@DKH_HOVID", SqlDbType.Int, 4, dkhoc.DKH_HOVID),
MakeInParam("@DKH_LOPID", SqlDbType.Int, 4, dkhoc.DKH_LOPID),
MakeInParam("@DKH_Diem", SqlDbType.Int, 4, dkhoc.DKH_Diem),
MakeInParam("@DKH_LanThi", SqlDbType.Int, 4, dkhoc.DKH_LanThi),
MakeInParam("@DKH_BienLai", SqlDbType.NVarChar, 50, dkhoc.DKH_BienLai),
MakeOutParam("@DKH_ID", SqlDbType.Int, 4)
};
errorcode = RunProc("usp_InsertDANG_KI_HOC", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
return(gID = (int)prams[6].Value);
}
public DataTable getByID_DANG_KI_HOC(DANG_KI_HOC Certificate)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@DKH_ID", SqlDbType.Int, 4, Certificate.DKH_ID)
};
int errorcode = RunProcDS("usp_SelectDANG_KI_HOC", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public void update(DANG_KI_HOC dkhoc)
{
SqlParameter[] prams =
{
MakeInParam("@DKH_ID", SqlDbType.Int, 4, dkhoc.DKH_ID),
//MakeInParam("@DKH_Code",SqlDbType.NVarChar,20,Certificate.DKH_Code),
//MakeInParam("@DKH_HOVID",SqlDbType.Int,4,Certificate.DKH_HOVID),
MakeInParam("@DKH_LOPID", SqlDbType.Int, 4, dkhoc.DKH_LOPID),
MakeInParam("@DKH_Diem", SqlDbType.Int, 4, dkhoc.DKH_Diem),
MakeInParam("@DKH_LanThi", SqlDbType.Int, 4, dkhoc.DKH_LanThi),
MakeInParam("@DKH_BienLai", SqlDbType.NVarChar, 50, dkhoc.DKH_BienLai)
};
int errorcode = RunProc("usp_UpdateDANG_KI_HOC", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public DataTable getCAP_CHUNGCHI_HV_ByLastNameContrain(DANG_KI_HOC dKhocSearch)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@HOV_LastName", SqlDbType.NVarChar, 20, dKhocSearch.DKH_LastName)
};
int errorcode = RunProcDS("usp_SelectCAP_CHUNGCHI_HV_ByLastNameContrain", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable getDANG_KI_HOC_By_HocVien_ID(DANG_KI_HOC dKhoc)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@DKH_HocVienID", SqlDbType.Int, 4, dKhoc.DKH_HOVID)
};
int errorcode = RunProcDS("usp_SelectDANG_KI_HOC_By_HocVien_ID", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable searchHocVien_In_DKH_ByName(DANG_KI_HOC dKhSearch)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@DIE_LOPID", SqlDbType.Int, 4, dKhSearch.DKH_LOPID),
MakeInParam("@StudentName", SqlDbType.NVarChar, 20, dKhSearch.DKH_LastName)
};
int errorcode = RunProcDS("searchHocVien_In_DKH_ByName", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[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 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 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);
}
}
}
}
public void update(DANG_KI_HOC dkhoc)
{
vDao = new DAL_DANG_KI_HOC();
vDao.update(dkhoc);
}
public DataTable getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(DANG_KI_HOC dkHoc)
{
DAL_DANG_KI_HOC dao = new DAL_DANG_KI_HOC();
return(dao.getCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC(dkHoc));
}
public void insert(DANG_KI_HOC dkhoc)
{
vDao = new DAL_DANG_KI_HOC();
vDao.insert(dkhoc);
}
