public List <KQHT_DangKyThiLaiInfo> GetList(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
List <KQHT_DangKyThiLaiInfo> oKQHT_DangKyThiLaiInfoList = new List <KQHT_DangKyThiLaiInfo>();
DataTable dtb = Get(pKQHT_DangKyThiLaiInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DangKyThiLaiInfo = new KQHT_DangKyThiLaiInfo();
oKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID = int.Parse(dtb.Rows[i]["KQHT_DangKyThiLaiID"].ToString());
oKQHT_DangKyThiLaiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DangKyThiLaiInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_DangKyThiLaiInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DangKyThiLaiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi = int.Parse(dtb.Rows[i]["IDKQHT_ToChucThi"].ToString());
oKQHT_DangKyThiLaiInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oKQHT_DangKyThiLaiInfo.TienLePhi = double.Parse(dtb.Rows[i]["TienLePhi"].ToString());
oKQHT_DangKyThiLaiInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString());
oKQHT_DangKyThiLaiInfo.NgayDangKy = DateTime.Parse(dtb.Rows[i]["NgayDangKy"].ToString());
oKQHT_DangKyThiLaiInfoList.Add(oKQHT_DangKyThiLaiInfo);
}
}
return(oKQHT_DangKyThiLaiInfoList);
}
public void Delete(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID));
RunProcedure("sp_KQHT_DangKyThiLai_Delete", colParam);
}
public DataTable Get(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID));
return(RunProcedureGet("sp_KQHT_DangKyThiLai_Get", colParam));
}
public int Add(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
int ID = 0;
ID = oDKQHT_DangKyThiLai.Add(pKQHT_DangKyThiLaiInfo);
mErrorMessage = oDKQHT_DangKyThiLai.ErrorMessages;
mErrorNumber = oDKQHT_DangKyThiLai.ErrorNumber;
return(ID);
}
public frmDangKyThiLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DangKyThiLai = new cBKQHT_DangKyThiLai();
oBKQHT_DanhSachKhongThi = new cBKQHT_DanhSachKhongThi();
pKQHT_DangKyThiLaiInfo = new KQHT_DangKyThiLaiInfo();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
}
public void ToDataRow(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo, ref DataRow dr)
{
dr[pKQHT_DangKyThiLaiInfo.strKQHT_DangKyThiLaiID] = pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID;
dr[pKQHT_DangKyThiLaiInfo.strIDSV_SinhVien] = pKQHT_DangKyThiLaiInfo.IDSV_SinhVien;
dr[pKQHT_DangKyThiLaiInfo.strIDDM_MonHoc] = pKQHT_DangKyThiLaiInfo.IDDM_MonHoc;
dr[pKQHT_DangKyThiLaiInfo.strIDDM_NamHoc] = pKQHT_DangKyThiLaiInfo.IDDM_NamHoc;
dr[pKQHT_DangKyThiLaiInfo.strHocKy] = pKQHT_DangKyThiLaiInfo.HocKy;
dr[pKQHT_DangKyThiLaiInfo.strIDKQHT_ToChucThi] = pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi;
dr[pKQHT_DangKyThiLaiInfo.strGhiChu] = pKQHT_DangKyThiLaiInfo.GhiChu;
dr[pKQHT_DangKyThiLaiInfo.strTienLePhi] = pKQHT_DangKyThiLaiInfo.TienLePhi;
dr[pKQHT_DangKyThiLaiInfo.strIDHT_User] = pKQHT_DangKyThiLaiInfo.IDHT_User;
dr[pKQHT_DangKyThiLaiInfo.strNgayDangKy] = pKQHT_DangKyThiLaiInfo.NgayDangKy;
}
public void ToInfo(ref KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo, DataRow dr)
{
pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strKQHT_DangKyThiLaiID].ToString());
pKQHT_DangKyThiLaiInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDSV_SinhVien].ToString());
pKQHT_DangKyThiLaiInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDDM_MonHoc].ToString());
pKQHT_DangKyThiLaiInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDDM_NamHoc].ToString());
pKQHT_DangKyThiLaiInfo.HocKy = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strHocKy].ToString());
pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDKQHT_ToChucThi].ToString());
pKQHT_DangKyThiLaiInfo.GhiChu = dr[pKQHT_DangKyThiLaiInfo.strGhiChu].ToString();
pKQHT_DangKyThiLaiInfo.TienLePhi = double.Parse(dr[pKQHT_DangKyThiLaiInfo.strTienLePhi].ToString());
pKQHT_DangKyThiLaiInfo.IDHT_User = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDHT_User].ToString());
pKQHT_DangKyThiLaiInfo.NgayDangKy = DateTime.Parse(dr[pKQHT_DangKyThiLaiInfo.strNgayDangKy].ToString());
}
public void Update(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.HocKy));
colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DangKyThiLaiInfo.GhiChu));
colParam.Add(CreateParam("@TienLePhi", SqlDbType.Money, pKQHT_DangKyThiLaiInfo.TienLePhi));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDHT_User));
colParam.Add(CreateParam("@NgayDangKy", SqlDbType.DateTime, pKQHT_DangKyThiLaiInfo.NgayDangKy));
colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID));
RunProcedure("sp_KQHT_DangKyThiLai_Update", colParam);
}
public int Add(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.LanThi));
colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DangKyThiLaiInfo.GhiChu));
colParam.Add(CreateParam("@TienLePhi", SqlDbType.Money, pKQHT_DangKyThiLaiInfo.TienLePhi));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDHT_User));
colParam.Add(CreateParam("@NgayDangKy", SqlDbType.DateTime, pKQHT_DangKyThiLaiInfo.NgayDangKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DangKyThiLai_Add", colParam));
}
public void Delete(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
oDKQHT_DangKyThiLai.Delete(pKQHT_DangKyThiLaiInfo);
mErrorMessage = oDKQHT_DangKyThiLai.ErrorMessages;
mErrorNumber = oDKQHT_DangKyThiLai.ErrorNumber;
}
public DataTable Get(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo)
{
return(oDKQHT_DangKyThiLai.Get(pKQHT_DangKyThiLaiInfo));
}
