public DataSet getRooms() { SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].ROOMS;").Execute(); return (DataSet)results["ReturnedValues"]; }
public void ExecutesValidQuery() { SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].USERS;").Execute(); DataSet ReturnedSet = (DataSet) results["ReturnedValues"]; Assert.True(ReturnedSet.Tables[0].Rows.Count > 0); }
public DataSet getStays(Int32 id_booking) { SqlResults results = new SqlQuery("SELECT * FROM BOBBY_TABLES.STAYS").Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getHolderBooking(){ SqlResults results = new SqlQuery("SELECT * from BOBBY_TABLES.GUEST_BOOKINGS") .Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getBookingInformation(Int32 id_booking) { SqlResults results = new SqlQuery(" SELECT * from BOBBY_TABLES.BOOKINGS where id_booking = "+id_booking) .Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getExtras() { SqlResults results = new SqlQuery("SELECT DISTINCT * FROM BOBBY_TABLES.EXTRAS") .Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getDocTypes() { SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].DOC_TYPE").Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getPersons() { SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].PERSONS").Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getRegimensDescrFromId(Int32 id_regimen) { SqlResults results = new SqlQuery("SELECT descr FROM BOBBY_TABLES.REGIMENS WHERE id_regimen = " + id_regimen) .Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getRegimensForHotel(Int32 id_hotel) { SqlResults results = new SqlQuery("SELECT * FROM BOBBY_TABLES.REGIMENS r JOIN BOBBY_TABLES.REGIMEN_HOTEL rh ON r.id_regimen = rh.id_regimen WHERE rh.id_hotel =" + id_hotel).Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getRegimenIdFromDescr(String descr) { SqlResults results = new SqlQuery("SELECT id_regimen FROM BOBBY_TABLES.REGIMENS WHERE descr="+descr).Execute(); return (DataSet) results["ReturnedValues"]; }
public DataSet getRegimensForHotels() { SqlResults results = new SqlQuery("SELECT DISTINCT * FROM BOBBY_TABLES.REGIMENS").Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getRoomTypesForHotel(Int32 id_hotel) { SqlResults results = new SqlQuery("SELECT DISTICT rt.descr FROM [BOBBY_TABLES].ROOM_TYPE rt" + "JOIN [BOBBY_TABLES].ROOMS r ON r.id_roomtype= rt.id_roomtype" + "AND r.id_hotel = " + id_hotel).Execute(); return (DataSet)results["ReturnedValues"]; }
public DataSet getRoomTypeIdFromDescr(String descr){ SqlResults results = new SqlQuery("SELECT id_roomtype FROM [BOBBY_TABLES].ROOM_TYPE WHERE descr =" + descr).Execute(); return (DataSet)results["ReturnedValues"]; }