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"];
}