protected override object GetDataFromDataRow(DataTable dt, int i) { LoaiPhongDTO lpDTO = new LoaiPhongDTO(); lpDTO.DonGia = int.Parse(dt.Rows[i]["DonGia"].ToString()); lpDTO.MaLoaiPhong = dt.Rows[i]["MaLoaiPhong"].ToString(); lpDTO.TenLoaiPhong = dt.Rows[i]["TenLoaiPhong"].ToString(); return (object)lpDTO; }
public System.Data.DataTable ConvertLoaiPhongDTOToDataTable(LoaiPhongDTO[] lpDTOArr) { System.Data.DataTable dt = new System.Data.DataTable(); int row = lpDTOArr.Length; dt.Columns.Add("MaLoaiPhong", typeof(string)); dt.Columns.Add("TenLoaiPhong", typeof(string)); dt.Columns.Add("DonGia", typeof(int)); for (int i = 0; i < row; i++) { dt.Rows.Add(lpDTOArr[i].MaLoaiPhong, lpDTOArr[i].TenLoaiPhong, lpDTOArr[i].DonGia); } return dt; }
public LoaiPhongDTO[] getListLoaiPhong() { string strSQL = "SELECT * FROM LOAIPHONG"; DataTable dt = ExecuteQuery(strSQL); LoaiPhongDTO[] lpDTOArr = new LoaiPhongDTO[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { object lpDTO = GetDataFromDataRow(dt, i); lpDTOArr[i] = (LoaiPhongDTO)lpDTO; } return lpDTOArr; }
public int update(LoaiPhongDTO dtoLP) { string sql = "update LOAIPHONG set LOAIPHONG.TenLoaiPhong='" + dtoLP.TenLoaiPhong + "',LOAIPHONG.DonGia='" + dtoLP.DonGia + "' where LOAIPHONG.MaLoaiPhong='" + dtoLP.MaLoaiPhong + "'"; return ExecuteNonQuery(sql,"isReturnInt"); }
public int KiemTra_MaLP(LoaiPhongDTO dtoLP) { string sql = "select * from LOAIPHONG where LOAIPHONG.MaLoaiPhong='" + dtoLP.MaLoaiPhong + "'"; return ExecuteReader(sql,"isReturnInt"); }
public int insertLoaiPhong(LoaiPhongDTO dtoLP) { string sql = "insert into LOAIPHONG(MaLoaiPhong,TenLoaiPhong,DonGia) values('" + dtoLP.MaLoaiPhong + "','" + dtoLP.TenLoaiPhong + "','" + dtoLP.DonGia + "')"; return ExecuteNonQuery(sql,"isReturInt"); }
public int UpdateLoaiPhong(LoaiPhongDTO dtoLP) { return lpDAO.update(dtoLP); }
public int KiemTra_MaLP(LoaiPhongDTO dtoLP) { return lpDAO.KiemTra_MaLP(dtoLP); }
public int insertLoaiPhong(LoaiPhongDTO dtoLP) { return lpDAO.insertLoaiPhong(dtoLP); }