public int insert(CAP_CHUNGCHI vDto)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_Code", SqlDbType.NVarChar, 50, vDto.CCC_Code),
MakeInParam("@CCC_HOVID", SqlDbType.Int, 4, vDto.CCC_HOVID),
MakeInParam("@CCC_LOPID", SqlDbType.Int, 4, vDto.CCC_LOPID),
MakeInParam("@CCC_SoCC", SqlDbType.NVarChar, 50, vDto.CCC_SoCC),
MakeInParam("@CCC_NgayCap", SqlDbType.Date, 4, vDto.CCC_NgayCap),
MakeInParam("@CCC_NgayHetHan", SqlDbType.Date, 4, vDto.CCC_NgayHetHan),
MakeInParam("@CCC_NgayCapLai", SqlDbType.Date, 4, vDto.CCC_NgayCapLai),
MakeInParam("@CCC_CHCID", SqlDbType.Int, 4, vDto.CCC_CHCID),
MakeInParam("@CCC_Status", SqlDbType.Int, 4, vDto.CCC_Status),
MakeInParam("@CCC_SoHieuDoi", SqlDbType.NVarChar, 50, vDto.CCC_SoHieuDoi),
MakeInParam("@CCC_DOIID", SqlDbType.NVarChar, 50, vDto.CCC_DOIID),
MakeOutParam("@CCC_ID", SqlDbType.Int, 4)
};
errorcode = RunProc("usp_InsertCAP_CHUNGCHI", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
else
{
return(gID = (int)prams[11].Value);
}
}
public void delete(int CCC_ID)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
CAP_CHUNGCHI ccc = new CAP_CHUNGCHI();
ccc.CCC_ID = CCC_ID;
ccc_dal.delete(ccc);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
CAP_CHUNGCHI obj = new CAP_CHUNGCHI();
obj.CCC_ID = int.Parse(dt.Rows[i]["CCC_ID"].ToString());
//some column
return((object)obj);
}
public DataTable getCAP_CHUNG_CHI_By_HocVienID(int hocvienID)
{
CAP_CHUNGCHI chungchi_hocvien = new CAP_CHUNGCHI();
chungchi_hocvien.CCC_HOVID = hocvienID;
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.getCAP_CHUNGCHI_By_HocVien_ID(chungchi_hocvien));
}
public DataTable getByID(int cap_chungchi_ID)
{
CAP_CHUNGCHI ccc = new CAP_CHUNGCHI();
ccc.CCC_ID = cap_chungchi_ID;
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.getByID_CAP_CHUNGCHI(ccc));
}
public void update_SoCc_ToNull(int?CCC_HOVID, int?CCC_LOPID) //string CCC_SoCC,
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
CAP_CHUNGCHI ccc = new CAP_CHUNGCHI();
ccc.CCC_HOVID = CCC_HOVID;
//ccc.CCC_SoCC = CCC_SoCC;
ccc.CCC_LOPID = CCC_LOPID;
ccc_dal.update_SoCC_ToNull(ccc);
}
public void CapLaiChungChi(int?CCC_HOVID, int?CCC_LOPID, DateTime?CCC_NgayCapLai, DateTime?CCC_NgayHetHan, int?CCC_Status)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
CAP_CHUNGCHI ccc = new CAP_CHUNGCHI();
ccc.CCC_HOVID = CCC_HOVID;
ccc.CCC_LOPID = CCC_LOPID;
ccc.CCC_NgayCap = CCC_NgayCapLai;
ccc.CCC_NgayHetHan = CCC_NgayHetHan;
ccc.CCC_Status = CCC_Status;
ccc_dal.CapLaiChungChi(ccc);
}
public void delete(CAP_CHUNGCHI Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_ID", SqlDbType.Int, 4, Certificate.CCC_ID)
};
int errorcode = RunProc("usp_DeleteCAP_CHUNGCHI", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void DeleteHocVienCapChungChiDoiByDoiID(CAP_CHUNGCHI vDto)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_ID", SqlDbType.Int, 4, vDto.CCC_ID)
};
int errorcode = RunProc("DeleteHocVienCapChungChiDoiByID", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void update_SoCC_ToNull(CAP_CHUNGCHI Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_HOVID", SqlDbType.Int, 4, Certificate.CCC_HOVID),
//MakeInParam("@CCC_SoCC",SqlDbType.NVarChar,50,Certificate.CCC_SoCC),
MakeInParam("@CCC_LOPID", SqlDbType.Int, 4, Certificate.CCC_LOPID)
};
int errorcode = RunProc("usp_UpdateCAP_CHUNGCHI_SoCC_ToNull", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void CapLaiChungChi(CAP_CHUNGCHI Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_HOVID", SqlDbType.Int, 4, Certificate.CCC_HOVID),
MakeInParam("@CCC_LOPID", SqlDbType.Int, 4, Certificate.CCC_LOPID),
MakeInParam("@CCC_NgayCap", SqlDbType.Date, 4, Certificate.CCC_NgayCap),
MakeInParam("@CCC_NgayHetHan", SqlDbType.Date, 4, Certificate.CCC_NgayHetHan),
MakeInParam("@CCC_Status", SqlDbType.Int, 4, Certificate.CCC_Status)
};
int errorcode = RunProc("CapLai_ChungChi", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void update_CapChungChi(CAP_CHUNGCHI vDto)
{
SqlParameter[] prams =
{
//MakeInParam("@CCC_HOVID",SqlDbType.Int,4,vDto.CCC_HOVID),
//MakeInParam("@CCC_LOPID",SqlDbType.Int,4,vDto.CCC_LOPID),
MakeInParam("@CCC_ID", SqlDbType.Int, 4, vDto.CCC_ID),
MakeInParam("@CCC_SoCC", SqlDbType.NVarChar, 20, vDto.CCC_SoCC),
MakeInParam("@CCC_NgayCap", SqlDbType.Date, 4, vDto.CCC_NgayCap),
MakeInParam("@CCC_NgayHetHan", SqlDbType.Date, 4, vDto.CCC_NgayHetHan)
};
int errorcode = RunProc("Update_SoCC_New", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void update_SoCC(CAP_CHUNGCHI Certificate)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_ID", SqlDbType.Int, 4, Certificate.CCC_ID),
//MakeInParam("@CCC_HOVID",SqlDbType.Int,4,Certificate.CCC_HOVID),
//MakeInParam("@CCC_LOPID",SqlDbType.Int,4,Certificate.CCC_LOPID),
MakeInParam("@CCC_SoCC", SqlDbType.NVarChar, 20, Certificate.CCC_SoCC),
MakeInParam("@CCC_NgayCap", SqlDbType.Date, 4, Certificate.CCC_NgayCap),
MakeInParam("@CCC_NgayHetHan", SqlDbType.Date, 4, Certificate.CCC_NgayHetHan)
};
int errorcode = RunProc("Update_SoCC_ToNull", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public DataTable getCAP_CHUNGCHI_By_HocVien_ID(CAP_CHUNGCHI cccSearch)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@HocVien_ID", SqlDbType.Int, 4, cccSearch.CCC_HOVID)
};
int errorcode = RunProcDS("usp_SelectCAP_CHUNGCHI_ByHocVienID", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable getByID_CAP_CHUNGCHI(CAP_CHUNGCHI Certificate)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@CCC_ID", SqlDbType.Int, 4, Certificate.CCC_ID)
};
int errorcode = RunProcDS("usp_SelectCAP_CHUNGCHI", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public void update(CAP_CHUNGCHI vDto)
{
SqlParameter[] prams =
{
MakeInParam("@CCC_ID", SqlDbType.Int, 4, vDto.CCC_ID),
//MakeInParam("@CCC_Code",SqlDbType.NVarChar,50,vDto.CCC_Code),
//MakeInParam("@CCC_HOVID",SqlDbType.Int,4,vDto.CCC_HOVID),
//MakeInParam("@CCC_LOPID",SqlDbType.Int ,4,vDto.CCC_LOPID),
//MakeInParam("@CCC_SoCC",SqlDbType.NVarChar,50,vDto.CCC_SoCC),
MakeInParam("@CCC_NgayCap", SqlDbType.Date, 4, vDto.CCC_NgayCap),
MakeInParam("@CCC_NgayHetHan", SqlDbType.Date, 4, vDto.CCC_NgayHetHan),
MakeInParam("@CCC_NgayCapLai", SqlDbType.Date, 4, vDto.CCC_NgayCapLai),
MakeInParam("@CCC_CHCID", SqlDbType.Int, 4, vDto.CCC_CHCID),
MakeInParam("@CCC_Status", SqlDbType.Int, 4, vDto.CCC_Status),
MakeInParam("@CCC_SoHieuDoi", SqlDbType.NVarChar, 50, vDto.CCC_SoHieuDoi)
//MakeInParam("@CCC_DOIID",SqlDbType.NVarChar,50,Certificate.CCC_DOIID)
};
int errorcode = RunProc("usp_UpdateCAP_CHUNGCHI", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
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();
}
public void DeleteHocVienCapChungChiDoiByID(CAP_CHUNGCHI vDto)
{
DAL_DOI_CHUNGCHI DalDoiCc = new DAL_DOI_CHUNGCHI();
DalDoiCc.DeleteHocVienCapChungChiDoiByDoiID(vDto);
}
public int insert(CAP_CHUNGCHI vDto)
{
vDao = new DAL_CAP_CHUNGCHI();
return(vDao.insert(vDto));
}
public void update(CAP_CHUNGCHI vDto)//, int CCC_DOIID)
{
vDao = new DAL_CAP_CHUNGCHI();
vDao.update(vDto);
}
public void update_CapChungChi(CAP_CHUNGCHI vDto)
{
//int? CCC_HOVID, int? CCC_LOPID, string SoCC, DateTime? NgayCap, DateTime? NgayHetHan
vDao = new DAL_CAP_CHUNGCHI();
vDao.update_CapChungChi(vDto);
}
