public void ToInfo(ref KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, DataRow dr)
{
pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID].ToString());
pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien].ToString());
pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo = dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo].ToString();
pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc].ToString());
pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot = bool.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot].ToString());
}
public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));
RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Delete", colParam);
}
public void ToDataRow(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, ref DataRow dr)
{
dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID] = pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID;
dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien] = pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien;
dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo] = pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo;
dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc] = pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc;
dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot] = pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot;
}
public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));
return(RunProcedureGet("sp_KQHT_DanhSachKhongThiTotNghiep_Get", colParam));
}
public frmXetThiTotNghiep()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBSV_SinhVien = new cBSV_SinhVien();
oBKQHT_DanhSachKhongThiTotNghiep = new cBKQHT_DanhSachKhongThiTotNghiep();
pKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo();
}
public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
int ID = 0;
ID = oDKQHT_DanhSachKhongThiTotNghiep.Add(pKQHT_DanhSachKhongThiTotNghiepInfo);
mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber;
return(ID);
}
public void Update(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot));
colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));
RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Update", colParam);
}
public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DanhSachKhongThiTotNghiep_Add", colParam));
}
public List <KQHT_DanhSachKhongThiTotNghiepInfo> GetList(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
List <KQHT_DanhSachKhongThiTotNghiepInfo> oKQHT_DanhSachKhongThiTotNghiepInfoList = new List <KQHT_DanhSachKhongThiTotNghiepInfo>();
DataTable dtb = Get(pKQHT_DanhSachKhongThiTotNghiepInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo();
oKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dtb.Rows[i]["KQHT_DanhSachKhongThiTotNghiepID"].ToString());
oKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DanhSachKhongThiTotNghiepInfo.LyDo = dtb.Rows[i]["LyDo"].ToString();
oKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DanhSachKhongThiTotNghiepInfo.XetVot = bool.Parse(dtb.Rows[i]["XetVot"].ToString());
oKQHT_DanhSachKhongThiTotNghiepInfoList.Add(oKQHT_DanhSachKhongThiTotNghiepInfo);
}
}
return(oKQHT_DanhSachKhongThiTotNghiepInfoList);
}
public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
oDKQHT_DanhSachKhongThiTotNghiep.Delete(pKQHT_DanhSachKhongThiTotNghiepInfo);
mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber;
}
public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
{
return(oDKQHT_DanhSachKhongThiTotNghiep.Get(pKQHT_DanhSachKhongThiTotNghiepInfo));
}