public void ToInfo(ref KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo, DataRow dr)
{
pKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID = int.Parse(dr[pKQHT_DangKyMonChonInfo.strKQHT_DangKyMonChonID].ToString());
pKQHT_DangKyMonChonInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DangKyMonChonInfo.strIDSV_SinhVien].ToString());
pKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy = int.Parse(dr[pKQHT_DangKyMonChonInfo.strIDXL_MonHocTrongKy].ToString());
pKQHT_DangKyMonChonInfo.IDHT_User = int.Parse(dr[pKQHT_DangKyMonChonInfo.strIDHT_User].ToString());
}
public void ToDataRow(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo, ref DataRow dr)
{
dr[pKQHT_DangKyMonChonInfo.strKQHT_DangKyMonChonID] = pKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID;
dr[pKQHT_DangKyMonChonInfo.strIDSV_SinhVien] = pKQHT_DangKyMonChonInfo.IDSV_SinhVien;
dr[pKQHT_DangKyMonChonInfo.strIDXL_MonHocTrongKy] = pKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy;
dr[pKQHT_DangKyMonChonInfo.strIDHT_User] = pKQHT_DangKyMonChonInfo.IDHT_User;
}
public void DeleteByMonHoc(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy));
RunProcedure("sp_KQHT_DangKyMonChon_DeleteMonHoc", colParam);
}
public void Delete(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DangKyMonChonID", SqlDbType.Int, pKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID));
RunProcedure("sp_KQHT_DangKyMonChon_Delete", colParam);
}
public DataTable Get(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DangKyMonChonID", SqlDbType.Int, pKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID));
return(RunProcedureGet("sp_KQHT_DangKyMonChon_Get", colParam));
}
public int Add(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
int ID = 0;
ID = oDKQHT_DangKyMonChon.Add(pKQHT_DangKyMonChonInfo);
mErrorMessage = oDKQHT_DangKyMonChon.ErrorMessages;
mErrorNumber = oDKQHT_DangKyMonChon.ErrorNumber;
return(ID);
}
public frmDangKyTuChon()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DangKyMonChonInfo = new KQHT_DangKyMonChonInfo();
oBKQHT_DangKyMonChon = new cBKQHT_DangKyMonChon();
txtHocKy.Text = Program.HocKy.ToString();
txtNamHoc.Text = Program.NamHoc;
}
public void Update(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDHT_User));
colParam.Add(CreateParam("@KQHT_DangKyMonChonID", SqlDbType.Int, pKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID));
RunProcedure("sp_KQHT_DangKyMonChon_Update", colParam);
}
public int Add(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyMonChonInfo.IDHT_User));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DangKyMonChon_Add", colParam));
}
public List <KQHT_DangKyMonChonInfo> GetList(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
List <KQHT_DangKyMonChonInfo> oKQHT_DangKyMonChonInfoList = new List <KQHT_DangKyMonChonInfo>();
DataTable dtb = Get(pKQHT_DangKyMonChonInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DangKyMonChonInfo = new KQHT_DangKyMonChonInfo();
oKQHT_DangKyMonChonInfo.KQHT_DangKyMonChonID = int.Parse(dtb.Rows[i]["KQHT_DangKyMonChonID"].ToString());
oKQHT_DangKyMonChonInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DangKyMonChonInfo.IDXL_MonHocTrongKy = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKy"].ToString());
oKQHT_DangKyMonChonInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString());
oKQHT_DangKyMonChonInfoList.Add(oKQHT_DangKyMonChonInfo);
}
}
return(oKQHT_DangKyMonChonInfoList);
}
public void DeleteByMonHoc(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
oDKQHT_DangKyMonChon.DeleteByMonHoc(pKQHT_DangKyMonChonInfo);
mErrorMessage = oDKQHT_DangKyMonChon.ErrorMessages;
mErrorNumber = oDKQHT_DangKyMonChon.ErrorNumber;
}
public void Update(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
oDKQHT_DangKyMonChon.Update(pKQHT_DangKyMonChonInfo);
mErrorMessage = oDKQHT_DangKyMonChon.ErrorMessages;
mErrorNumber = oDKQHT_DangKyMonChon.ErrorNumber;
}
public DataTable Get(KQHT_DangKyMonChonInfo pKQHT_DangKyMonChonInfo)
{
return(oDKQHT_DangKyMonChon.Get(pKQHT_DangKyMonChonInfo));
}
