public DataTable Get(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_NgoaiNguID", SqlDbType.Int, pDM_NgoaiNguInfo.DM_NgoaiNguID));
return(RunProcedureGet("sp_DM_NgoaiNgu_Get", colParam));
}
public void Delete(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_NgoaiNguID", SqlDbType.Int, pDM_NgoaiNguInfo.DM_NgoaiNguID));
RunProcedure("sp_DM_NgoaiNgu_Delete", colParam);
}
public frmDM_NgoaiNgu(frmHoSoGiaoVien _frmHoSoGiaoVien)
{
InitializeComponent();
oBDM_NgoaiNgu = new cBDM_NgoaiNgu();
pDM_NgoaiNguInfo = new DM_NgoaiNguInfo();
SetControl(false);
ofrmHoSoGiaoVien = _frmHoSoGiaoVien;
}
public void Update(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNgoaiNgu", SqlDbType.NVarChar, pDM_NgoaiNguInfo.TenNgoaiNgu));
colParam.Add(CreateParam("@DM_NgoaiNguID", SqlDbType.Int, pDM_NgoaiNguInfo.DM_NgoaiNguID));
RunProcedure("sp_DM_NgoaiNgu_Update", colParam);
}
public int Add(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNgoaiNgu", SqlDbType.NVarChar, pDM_NgoaiNguInfo.TenNgoaiNgu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_NgoaiNgu_Add", colParam));
}
public int Add(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
int ID = 0;
ID = oDDM_NgoaiNgu.Add(pDM_NgoaiNguInfo);
mErrorMessage = oDDM_NgoaiNgu.ErrorMessages;
mErrorNumber = oDDM_NgoaiNgu.ErrorNumber;
return(ID);
}
public List <DM_NgoaiNguInfo> GetList(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
List <DM_NgoaiNguInfo> oDM_NgoaiNguInfoList = new List <DM_NgoaiNguInfo>();
DataTable dtb = Get(pDM_NgoaiNguInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_NgoaiNguInfo = new DM_NgoaiNguInfo();
oDM_NgoaiNguInfo.DM_NgoaiNguID = int.Parse(dtb.Rows[i]["DM_NgoaiNguID"].ToString());
oDM_NgoaiNguInfo.TenNgoaiNgu = dtb.Rows[i]["TenNgoaiNgu"].ToString();
oDM_NgoaiNguInfoList.Add(oDM_NgoaiNguInfo);
}
}
return(oDM_NgoaiNguInfoList);
}
public void ToInfo(ref DM_NgoaiNguInfo pDM_NgoaiNguInfo, DataRow dr)
{
pDM_NgoaiNguInfo.DM_NgoaiNguID = int.Parse(dr[pDM_NgoaiNguInfo.strDM_NgoaiNguID].ToString());
pDM_NgoaiNguInfo.TenNgoaiNgu = dr[pDM_NgoaiNguInfo.strTenNgoaiNgu].ToString();
}
public void ToDataRow(DM_NgoaiNguInfo pDM_NgoaiNguInfo, ref DataRow dr)
{
dr[pDM_NgoaiNguInfo.strDM_NgoaiNguID] = pDM_NgoaiNguInfo.DM_NgoaiNguID;
dr[pDM_NgoaiNguInfo.strTenNgoaiNgu] = pDM_NgoaiNguInfo.TenNgoaiNgu;
}
public void Delete(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
oDDM_NgoaiNgu.Delete(pDM_NgoaiNguInfo);
mErrorMessage = oDDM_NgoaiNgu.ErrorMessages;
mErrorNumber = oDDM_NgoaiNgu.ErrorNumber;
}
public DataTable Get(DM_NgoaiNguInfo pDM_NgoaiNguInfo)
{
return(oDDM_NgoaiNgu.Get(pDM_NgoaiNguInfo));
}
