public void Delete(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_LoaiPhongID", SqlDbType.Int, pDM_LoaiPhongInfo.DM_LoaiPhongID));
RunProcedure("sp_DM_LoaiPhong_Delete", colParam);
}
public DataTable Get(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_LoaiPhongID", SqlDbType.Int, pDM_LoaiPhongInfo.DM_LoaiPhongID));
return(RunProcedureGet("sp_DM_LoaiPhong_Get", colParam));
}
public int Add(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
int ID = 0;
ID = oDDM_LoaiPhong.Add(pDM_LoaiPhongInfo);
mErrorMessage = oDDM_LoaiPhong.ErrorMessages;
mErrorNumber = oDDM_LoaiPhong.ErrorNumber;
return(ID);
}
public void Update(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaLoaiPhong", SqlDbType.NVarChar, pDM_LoaiPhongInfo.MaLoaiPhong));
colParam.Add(CreateParam("@TenLoaiPhong", SqlDbType.NVarChar, pDM_LoaiPhongInfo.TenLoaiPhong));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Bit, pDM_LoaiPhongInfo.LyThuyet));
colParam.Add(CreateParam("@DM_LoaiPhongID", SqlDbType.Int, pDM_LoaiPhongInfo.DM_LoaiPhongID));
RunProcedure("sp_DM_LoaiPhong_Update", colParam);
}
public int Add(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaLoaiPhong", SqlDbType.NVarChar, pDM_LoaiPhongInfo.MaLoaiPhong));
colParam.Add(CreateParam("@TenLoaiPhong", SqlDbType.NVarChar, pDM_LoaiPhongInfo.TenLoaiPhong));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Bit, pDM_LoaiPhongInfo.LyThuyet));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_LoaiPhong_Add", colParam));
}
public List <DM_LoaiPhongInfo> GetList(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
List <DM_LoaiPhongInfo> oDM_LoaiPhongInfoList = new List <DM_LoaiPhongInfo>();
DataTable dtb = Get(pDM_LoaiPhongInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_LoaiPhongInfo = new DM_LoaiPhongInfo();
oDM_LoaiPhongInfo.DM_LoaiPhongID = int.Parse(dtb.Rows[i]["DM_LoaiPhongID"].ToString());
oDM_LoaiPhongInfo.MaLoaiPhong = dtb.Rows[i]["MaLoaiPhong"].ToString();
oDM_LoaiPhongInfo.TenLoaiPhong = dtb.Rows[i]["TenLoaiPhong"].ToString();
oDM_LoaiPhongInfoList.Add(oDM_LoaiPhongInfo);
}
}
return(oDM_LoaiPhongInfoList);
}
public void Delete(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
oDDM_LoaiPhong.Delete(pDM_LoaiPhongInfo);
mErrorMessage = oDDM_LoaiPhong.ErrorMessages;
mErrorNumber = oDDM_LoaiPhong.ErrorNumber;
}
public DataTable Get(DM_LoaiPhongInfo pDM_LoaiPhongInfo)
{
return(oDDM_LoaiPhong.Get(pDM_LoaiPhongInfo));
}