Пример #1
0
        public DataSet getRooms()
        {
            SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].ROOMS;").Execute();

            return (DataSet)results["ReturnedValues"];

        }
Пример #2
0
        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);
        }
Пример #3
0
        public DataSet getStays(Int32 id_booking) {
            SqlResults results = new SqlQuery("SELECT * FROM BOBBY_TABLES.STAYS").Execute();
            return (DataSet)results["ReturnedValues"];
 
        }
Пример #4
0
        public DataSet getHolderBooking(){
            SqlResults results = new SqlQuery("SELECT * from BOBBY_TABLES.GUEST_BOOKINGS")
                                .Execute();
            return (DataSet)results["ReturnedValues"];

        }
Пример #5
0
 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"];
 }
Пример #6
0
 public DataSet getExtras() {
     SqlResults results = new SqlQuery("SELECT DISTINCT * FROM BOBBY_TABLES.EXTRAS")
                          .Execute();
     return (DataSet)results["ReturnedValues"];
 }
Пример #7
0
 public DataSet getDocTypes() {
     SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].DOC_TYPE").Execute();
     return (DataSet)results["ReturnedValues"];
 }
Пример #8
0
 public DataSet getPersons() {
     SqlResults results = new SqlQuery("SELECT * FROM [BOBBY_TABLES].PERSONS").Execute();
     return (DataSet)results["ReturnedValues"];
 }
Пример #9
0
 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"];
 }
Пример #10
0
 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"];
 }
Пример #11
0
 public DataSet getRegimenIdFromDescr(String descr)
 {
     SqlResults results = new SqlQuery("SELECT id_regimen FROM BOBBY_TABLES.REGIMENS WHERE descr="+descr).Execute();
     return (DataSet) results["ReturnedValues"];
 }
Пример #12
0
        public DataSet getRegimensForHotels()
        {
            SqlResults results = new SqlQuery("SELECT DISTINCT * FROM BOBBY_TABLES.REGIMENS").Execute();
            return (DataSet)results["ReturnedValues"];

        }
Пример #13
0
 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"];
 }
Пример #14
0
 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"];
 }