public void ToDataRow(DM_ToaNhaInfo pDM_ToaNhaInfo, ref DataRow dr)
{
dr[pDM_ToaNhaInfo.strDM_ToaNhaID] = pDM_ToaNhaInfo.DM_ToaNhaID;
dr[pDM_ToaNhaInfo.strIDDM_DiaDiem] = pDM_ToaNhaInfo.IDDM_DiaDiem;
dr[pDM_ToaNhaInfo.strMaToaNha] = pDM_ToaNhaInfo.MaToaNha;
dr[pDM_ToaNhaInfo.strTenToaNha] = pDM_ToaNhaInfo.TenToaNha;
}
public void Delete(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_ToaNhaID", SqlDbType.Int, pDM_ToaNhaInfo.DM_ToaNhaID));
RunProcedure("sp_DM_ToaNha_Delete", colParam);
}
public DataTable Get(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_ToaNhaID", SqlDbType.Int, pDM_ToaNhaInfo.DM_ToaNhaID));
return(RunProcedureGet("sp_DM_ToaNha_Get", colParam));
}
public int Add(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
int ID = 0;
ID = oDDM_ToaNha.Add(pDM_ToaNhaInfo);
mErrorMessage = oDDM_ToaNha.ErrorMessages;
mErrorNumber = oDDM_ToaNha.ErrorNumber;
return(ID);
}
public frmPhongHoc()
{
InitializeComponent();
oBDM_DiaDiem = new cBDM_DiaDiem();
oBDM_ToaNha = new cBDM_ToaNha();
oBDM_PhongHoc = new cBDM_PhongHoc();
pDM_DiaDiemInfo = new DM_DiaDiemInfo();
pDM_ToaNhaInfo = new DM_ToaNhaInfo();
pDM_PhongHocInfo = new DM_PhongHocInfo();
}
public void Update(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_DiaDiem", SqlDbType.Int, pDM_ToaNhaInfo.IDDM_DiaDiem));
colParam.Add(CreateParam("@MaToaNha", SqlDbType.NVarChar, pDM_ToaNhaInfo.MaToaNha));
colParam.Add(CreateParam("@TenToaNha", SqlDbType.NVarChar, pDM_ToaNhaInfo.TenToaNha));
colParam.Add(CreateParam("@DM_ToaNhaID", SqlDbType.Int, pDM_ToaNhaInfo.DM_ToaNhaID));
RunProcedure("sp_DM_ToaNha_Update", colParam);
}
public int Add(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_DiaDiem", SqlDbType.Int, pDM_ToaNhaInfo.IDDM_DiaDiem));
colParam.Add(CreateParam("@MaToaNha", SqlDbType.NVarChar, pDM_ToaNhaInfo.MaToaNha));
colParam.Add(CreateParam("@TenToaNha", SqlDbType.NVarChar, pDM_ToaNhaInfo.TenToaNha));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_ToaNha_Add", colParam));
}
public List <DM_ToaNhaInfo> GetList(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
List <DM_ToaNhaInfo> oDM_ToaNhaInfoList = new List <DM_ToaNhaInfo>();
DataTable dtb = Get(pDM_ToaNhaInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_ToaNhaInfo = new DM_ToaNhaInfo();
oDM_ToaNhaInfo.DM_ToaNhaID = int.Parse(dtb.Rows[i]["DM_ToaNhaID"].ToString());
oDM_ToaNhaInfo.IDDM_DiaDiem = int.Parse(dtb.Rows[i]["IDDM_DiaDiem"].ToString());
oDM_ToaNhaInfo.MaToaNha = dtb.Rows[i]["MaToaNha"].ToString();
oDM_ToaNhaInfo.TenToaNha = dtb.Rows[i]["TenToaNha"].ToString();
oDM_ToaNhaInfoList.Add(oDM_ToaNhaInfo);
}
}
return(oDM_ToaNhaInfoList);
}
public void Delete(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
oDDM_ToaNha.Delete(pDM_ToaNhaInfo);
mErrorMessage = oDDM_ToaNha.ErrorMessages;
mErrorNumber = oDDM_ToaNha.ErrorNumber;
}
public DataTable Get(DM_ToaNhaInfo pDM_ToaNhaInfo)
{
return(oDDM_ToaNha.Get(pDM_ToaNhaInfo));
}
