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);
}
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 DataTable getCAP_CHUNGCHI_HV_SearchLastName(string lastName)
{
HOCVIEN searchLastName = new HOCVIEN();
searchLastName.HOV_LastName = lastName;
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.getCAP_CHUNGCHI_HV_SearchLastName(searchLastName));
}
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 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 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 int insert(CAP_CHUNGCHI vDto)
{
vDao = new DAL_CAP_CHUNGCHI();
return(vDao.insert(vDto));
}
public void vUpdateDoiID(int vDoiID, int CccID)
{
DAL_CAP_CHUNGCHI da = new DAL_CAP_CHUNGCHI();
da.vUpdateDoiID(vDoiID, CccID);
}
public DataTable vLoadIdDoi(int vCcID)
{
DAL_CAP_CHUNGCHI da = new DAL_CAP_CHUNGCHI();
return(da.vLoadIdDoi(vCcID));
}
public void updateChungChiDoiIDToCapChungChi(int DoiID)
{
DAL_CAP_CHUNGCHI da = new DAL_CAP_CHUNGCHI();
da.updateChungChiDoiIDToCapChungChi(DoiID);
}
public DataTable ExportExcel_Phat_Doi_CHUNGCHI(int cCIds, int status, string SoHieuDoi)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.ExportExcel_Phat_Doi_CHUNGCHI(cCIds, status, SoHieuDoi));
}
public DataTable ExportExcel_DsHV_DuocCapCC(int cCIds, int lopID)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.ExportExcel_DsHV_DuocCapCC(cCIds, lopID));
}
public DataTable getHocVienCapCC_ByLopID(int vLopID)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.getHovienCapCC_byLopID(vLopID));
}
public DataTable vLoadCapChungChi_Next(int vLopId, int vHocVienId)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.vLoadCapChungChi_Next(vLopId, vHocVienId));
}
public DataTable get_Print_CcDoi(int CcID, int Status, string soHieu)
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.get_Print_CccDoi(CcID, Status, soHieu));
}
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);
}
public DataTable get_SoHieuDoi_Cc(int CcID, int Status)
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.get_SoHieuDoi_Cc(CcID, Status));
}
public void update(CAP_CHUNGCHI vDto)//, int CCC_DOIID)
{
vDao = new DAL_CAP_CHUNGCHI();
vDao.update(vDto);
}
public DataTable Search_CCC_Status(int lopID, int Status)
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.Search_CCC_Status(lopID, Status));
}
public DataTable getAll()
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.getAll_CAP_CHUNGCHI());
}
public DataTable getCAP_CHUNGCHI_WithName()
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.getCAP_CHUNGCHI_WithName());
}
public DataTable ExportExcel_Phat_CHUNGCHI(int cCIds, int lopID)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.ExportExcel_Phat_CHUNGCHI(cCIds, lopID));
}
public DataTable searchCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC_NAME_CONTAIN(int KHOAHOC_ID, int LOP_ID, string lastName)
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.searchCAP_CHUNG_CHI_FILTER_BY_KHOAHOC_LOPHOC_NAME_CONTAIN(KHOAHOC_ID, LOP_ID, lastName));
}
public DataTable getLast_SoCc(int ccID)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.getLast_SoCc(ccID));
}
public DataTable ListForUpdate()
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.loadListForUpdate());
}
public DataTable ExportExcel_DsHV_DuocCapCC_Doi(int cCIds, int Status, string soHieu)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.ExportExcel_DsHV_DuocCapCC_Doi(cCIds, Status, soHieu));
}
public DataTable GetData_For_CAP_CHUNGCHI_ByLopID(int sLOP_ID)
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.GetData_For_CAP_CHUNGCHI_ByLopID(sLOP_ID));
}
public DataTable vCheckLopDaCapCcByLopMonID(int vLopId, int vMonId, int vLanThi)
{
DAL_CAP_CHUNGCHI ccc_dal = new DAL_CAP_CHUNGCHI();
return(ccc_dal.vCheckLopDaCapCcByLopMonID(vLopId, vMonId, vLanThi));
}
public DataTable searchHocVien_In_CCC_ByBirthday(int lopID, string lastName) //(int lopID,
{
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.searchHocVien_In_CCC_ByBirthday(lopID, lastName));
}
