public static List <Theart_Room> getAllRapPhong() { List <Theart_Room> list = new List <Theart_Room>(); string sql = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong "; DataTable dt = DataAccess.ReadDataBySQL(sql); foreach (DataRow dr in dt.Rows) { Theart_Room tr = new Theart_Room(); tr.Theartx = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString())); tr.Roomx = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString())); tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString()); tr.Note = dr["note"].ToString(); tr.SeatTypes = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID); list.Add(tr); } return(list); }
public static Theart_Room getAllRapPhongByID(int idRap, int idPhong) { string sql = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong AS rp" + " WHERE rp.idRap = @idRap AND rp.idPhong = @idPhong"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@idRap", SqlDbType.Int), new SqlParameter("@idPhong", SqlDbType.Int) }; param[0].Value = idRap; param[1].Value = idPhong; DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, param); Theart_Room tr = new Theart_Room(); foreach (DataRow dr in dt.Rows) { tr.Theartx = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString())); tr.Roomx = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString())); tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString()); tr.Note = dr["note"].ToString(); tr.SeatTypes = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID); } return(tr); }