public frmNhapHocLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_NhapHocLai = new cBSV_NhapHocLai();
pSV_NhapHocLaiInfo = new SV_NhapHocLaiInfo();
oBSV_SinhVien = new cBSV_SinhVien();
}
public void Delete(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_NhapHocLaiID", SqlDbType.Int, pSV_NhapHocLaiInfo.SV_NhapHocLaiID));
RunProcedure("sp_SV_NhapHocLai_Delete", colParam);
}
public DataTable Get(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_NhapHocLaiID", SqlDbType.Int, pSV_NhapHocLaiInfo.SV_NhapHocLaiID));
return(RunProcedureGet("sp_SV_NhapHocLai_Get", colParam));
}
public void ToInfo(ref SV_NhapHocLaiInfo pSV_NhapHocLaiInfo, DataRow dr)
{
pSV_NhapHocLaiInfo.SV_NhapHocLaiID = int.Parse(dr[pSV_NhapHocLaiInfo.strSV_NhapHocLaiID].ToString());
pSV_NhapHocLaiInfo.IDSV_SinhVien = int.Parse(dr[pSV_NhapHocLaiInfo.strIDSV_SinhVien].ToString());
pSV_NhapHocLaiInfo.IDDM_LopCu = int.Parse(dr[pSV_NhapHocLaiInfo.strIDDM_LopCu].ToString());
pSV_NhapHocLaiInfo.IDDM_LopMoi = int.Parse(dr[pSV_NhapHocLaiInfo.strIDDM_LopMoi].ToString());
pSV_NhapHocLaiInfo.IDDM_NamHoc = int.Parse(dr[pSV_NhapHocLaiInfo.strIDDM_NamHoc].ToString());
pSV_NhapHocLaiInfo.HocKy = int.Parse(dr[pSV_NhapHocLaiInfo.strHocKy].ToString());
}
public void ToDataRow(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo, ref DataRow dr)
{
dr[pSV_NhapHocLaiInfo.strSV_NhapHocLaiID] = pSV_NhapHocLaiInfo.SV_NhapHocLaiID;
dr[pSV_NhapHocLaiInfo.strIDSV_SinhVien] = pSV_NhapHocLaiInfo.IDSV_SinhVien;
dr[pSV_NhapHocLaiInfo.strIDDM_LopCu] = pSV_NhapHocLaiInfo.IDDM_LopCu;
dr[pSV_NhapHocLaiInfo.strIDDM_LopMoi] = pSV_NhapHocLaiInfo.IDDM_LopMoi;
dr[pSV_NhapHocLaiInfo.strIDDM_NamHoc] = pSV_NhapHocLaiInfo.IDDM_NamHoc;
dr[pSV_NhapHocLaiInfo.strHocKy] = pSV_NhapHocLaiInfo.HocKy;
}
public int Add(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
int ID = 0;
ID = oDSV_NhapHocLai.Add(pSV_NhapHocLaiInfo);
mErrorMessage = oDSV_NhapHocLai.ErrorMessages;
mErrorNumber = oDSV_NhapHocLai.ErrorNumber;
return(ID);
}
public void Update(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_NhapHocLaiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_LopCu", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_LopCu));
colParam.Add(CreateParam("@IDDM_LopMoi", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_LopMoi));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_NhapHocLaiInfo.HocKy));
colParam.Add(CreateParam("@SV_NhapHocLaiID", SqlDbType.Int, pSV_NhapHocLaiInfo.SV_NhapHocLaiID));
RunProcedure("sp_SV_NhapHocLai_Update", colParam);
}
public int Add(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_NhapHocLaiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_LopCu", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_LopCu));
colParam.Add(CreateParam("@IDDM_LopMoi", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_LopMoi));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_NhapHocLaiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_NhapHocLaiInfo.HocKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_SV_NhapHocLai_Add", colParam));
}
public List <SV_NhapHocLaiInfo> GetList(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
List <SV_NhapHocLaiInfo> oSV_NhapHocLaiInfoList = new List <SV_NhapHocLaiInfo>();
DataTable dtb = Get(pSV_NhapHocLaiInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oSV_NhapHocLaiInfo = new SV_NhapHocLaiInfo();
oSV_NhapHocLaiInfo.SV_NhapHocLaiID = int.Parse(dtb.Rows[i]["SV_NhapHocLaiID"].ToString());
oSV_NhapHocLaiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oSV_NhapHocLaiInfo.IDDM_LopCu = int.Parse(dtb.Rows[i]["IDDM_LopCu"].ToString());
oSV_NhapHocLaiInfo.IDDM_LopMoi = int.Parse(dtb.Rows[i]["IDDM_LopMoi"].ToString());
oSV_NhapHocLaiInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oSV_NhapHocLaiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oSV_NhapHocLaiInfoList.Add(oSV_NhapHocLaiInfo);
}
}
return(oSV_NhapHocLaiInfoList);
}
public void Delete(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
oDSV_NhapHocLai.Delete(pSV_NhapHocLaiInfo);
mErrorMessage = oDSV_NhapHocLai.ErrorMessages;
mErrorNumber = oDSV_NhapHocLai.ErrorNumber;
}
public DataTable Get(SV_NhapHocLaiInfo pSV_NhapHocLaiInfo)
{
return(oDSV_NhapHocLai.Get(pSV_NhapHocLaiInfo));
}