public List <NS_GiaoVien_NgoaiNguInfo> GetList(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
List <NS_GiaoVien_NgoaiNguInfo> oNS_GiaoVien_NgoaiNguInfoList = new List <NS_GiaoVien_NgoaiNguInfo>();
DataTable dtb = Get(pNS_GiaoVien_NgoaiNguInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_GiaoVien_NgoaiNguInfo = new NS_GiaoVien_NgoaiNguInfo();
oNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID = int.Parse(dtb.Rows[i]["NS_GiaoVien_NgoaiNguID"].ToString());
oNS_GiaoVien_NgoaiNguInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_GiaoVien_NgoaiNguInfo.IDDM_NgoaiNgu = int.Parse(dtb.Rows[i]["IDDM_NgoaiNgu"].ToString());
oNS_GiaoVien_NgoaiNguInfo.TrinhDo = dtb.Rows[i]["TrinhDo"].ToString();
oNS_GiaoVien_NgoaiNguInfo.SoChungChi = dtb.Rows[i]["SoChungChi"].ToString();
oNS_GiaoVien_NgoaiNguInfo.NgayCap = DateTime.Parse(dtb.Rows[i]["NgayCap"].ToString());
oNS_GiaoVien_NgoaiNguInfo.NoiCap = dtb.Rows[i]["NoiCap"].ToString();
oNS_GiaoVien_NgoaiNguInfo.IDDM_TinhHuyenXaNoiCap = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaNoiCap"].ToString());
oNS_GiaoVien_NgoaiNguInfoList.Add(oNS_GiaoVien_NgoaiNguInfo);
}
}
return(oNS_GiaoVien_NgoaiNguInfoList);
}
public void Delete(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_GiaoVien_NgoaiNguID", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID));
RunProcedure("sp_NS_GiaoVien_NgoaiNgu_Delete", colParam);
}
public DataTable Get(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_GiaoVien_NgoaiNguID", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID));
return(RunProcedureGet("sp_NS_GiaoVien_NgoaiNgu_Get", colParam));
}
public int Add(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
int ID = 0;
ID = oDNS_GiaoVien_NgoaiNgu.Add(pNS_GiaoVien_NgoaiNguInfo);
mErrorMessage = oDNS_GiaoVien_NgoaiNgu.ErrorMessages;
mErrorNumber = oDNS_GiaoVien_NgoaiNgu.ErrorNumber;
return(ID);
}
public void ToDataRow(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo, ref DataRow dr)
{
dr[pNS_GiaoVien_NgoaiNguInfo.strNS_GiaoVien_NgoaiNguID] = pNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID;
dr[pNS_GiaoVien_NgoaiNguInfo.strIDNS_GiaoVien] = pNS_GiaoVien_NgoaiNguInfo.IDNS_GiaoVien;
dr[pNS_GiaoVien_NgoaiNguInfo.strIDDM_NgoaiNgu] = pNS_GiaoVien_NgoaiNguInfo.IDDM_NgoaiNgu;
dr[pNS_GiaoVien_NgoaiNguInfo.strIDTrinhDo] = pNS_GiaoVien_NgoaiNguInfo.IDTrinhDo;
dr[pNS_GiaoVien_NgoaiNguInfo.strTrinhDo] = pNS_GiaoVien_NgoaiNguInfo.TrinhDo;
dr[pNS_GiaoVien_NgoaiNguInfo.strSoChungChi] = pNS_GiaoVien_NgoaiNguInfo.SoChungChi;
dr[pNS_GiaoVien_NgoaiNguInfo.strNgayCap] = pNS_GiaoVien_NgoaiNguInfo.NgayCap;
dr[pNS_GiaoVien_NgoaiNguInfo.strNoiCap] = pNS_GiaoVien_NgoaiNguInfo.NoiCap;
dr[pNS_GiaoVien_NgoaiNguInfo.strIDDM_TinhHuyenXaNoiCap] = pNS_GiaoVien_NgoaiNguInfo.IDDM_TinhHuyenXaNoiCap;
}
public void ToInfo(ref NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo, DataRow dr)
{
pNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID = int.Parse(dr[pNS_GiaoVien_NgoaiNguInfo.strNS_GiaoVien_NgoaiNguID].ToString());
pNS_GiaoVien_NgoaiNguInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_GiaoVien_NgoaiNguInfo.strIDNS_GiaoVien]);
pNS_GiaoVien_NgoaiNguInfo.IDDM_NgoaiNgu = int.Parse("0" + dr[pNS_GiaoVien_NgoaiNguInfo.strIDDM_NgoaiNgu]);
pNS_GiaoVien_NgoaiNguInfo.IDTrinhDo = "" + dr[pNS_GiaoVien_NgoaiNguInfo.strIDTrinhDo];
pNS_GiaoVien_NgoaiNguInfo.TrinhDo = dr[pNS_GiaoVien_NgoaiNguInfo.strTrinhDo].ToString();
pNS_GiaoVien_NgoaiNguInfo.SoChungChi = dr[pNS_GiaoVien_NgoaiNguInfo.strSoChungChi].ToString();
if (dr[pNS_GiaoVien_NgoaiNguInfo.strNgayCap].ToString() != "")
{
pNS_GiaoVien_NgoaiNguInfo.NgayCap = DateTime.Parse(dr[pNS_GiaoVien_NgoaiNguInfo.strNgayCap].ToString());
}
pNS_GiaoVien_NgoaiNguInfo.NoiCap = dr[pNS_GiaoVien_NgoaiNguInfo.strNoiCap].ToString();
pNS_GiaoVien_NgoaiNguInfo.IDDM_TinhHuyenXaNoiCap = int.Parse("0" + dr[pNS_GiaoVien_NgoaiNguInfo.strIDDM_TinhHuyenXaNoiCap]);
}
public void Update(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_NgoaiNgu", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDDM_NgoaiNgu));
colParam.Add(CreateParam("@IDTrinhDo", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.IDTrinhDo));
colParam.Add(CreateParam("@TrinhDo", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.TrinhDo));
colParam.Add(CreateParam("@SoChungChi", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.SoChungChi));
colParam.Add(CreateParam("@NgayCap", SqlDbType.DateTime, pNS_GiaoVien_NgoaiNguInfo.NgayCap));
colParam.Add(CreateParam("@NoiCap", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.NoiCap));
colParam.Add(CreateParam("@IDDM_TinhHuyenXaNoiCap", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDDM_TinhHuyenXaNoiCap));
colParam.Add(CreateParam("@NS_GiaoVien_NgoaiNguID", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.NS_GiaoVien_NgoaiNguID));
RunProcedure("sp_NS_GiaoVien_NgoaiNgu_Update", colParam);
}
public int Add(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_NgoaiNgu", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDDM_NgoaiNgu));
colParam.Add(CreateParam("@IDTrinhDo", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.IDTrinhDo));
colParam.Add(CreateParam("@TrinhDo", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.TrinhDo));
colParam.Add(CreateParam("@SoChungChi", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.SoChungChi));
colParam.Add(CreateParam("@NgayCap", SqlDbType.DateTime, pNS_GiaoVien_NgoaiNguInfo.NgayCap));
colParam.Add(CreateParam("@NoiCap", SqlDbType.NVarChar, pNS_GiaoVien_NgoaiNguInfo.NoiCap));
colParam.Add(CreateParam("@IDDM_TinhHuyenXaNoiCap", SqlDbType.Int, pNS_GiaoVien_NgoaiNguInfo.IDDM_TinhHuyenXaNoiCap));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_GiaoVien_NgoaiNgu_Add", colParam));
}
public void Delete(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
oDNS_GiaoVien_NgoaiNgu.Delete(pNS_GiaoVien_NgoaiNguInfo);
mErrorMessage = oDNS_GiaoVien_NgoaiNgu.ErrorMessages;
mErrorNumber = oDNS_GiaoVien_NgoaiNgu.ErrorNumber;
}
public DataTable Get(NS_GiaoVien_NgoaiNguInfo pNS_GiaoVien_NgoaiNguInfo)
{
return(oDNS_GiaoVien_NgoaiNgu.Get(pNS_GiaoVien_NgoaiNguInfo));
}
