public static DataSet filteredSearch(String name, int? stars, String city, String country) { SqlFunction func = new SqlFunction("[BOBBY_TABLES].SP_FILTER_HOTELS") .WithParam("@Name").As(SqlDbType.VarChar).Value(name) .WithParam("@City").As(SqlDbType.VarChar).Value(city) .WithParam("@Country").As(SqlDbType.VarChar).Value(country); if (stars == null) {func.WithParam("@Stars").As(SqlDbType.Int).Value(DBNull.Value);} else { func.WithParam("@Stars").As(SqlDbType.Int).Value(stars); } SqlResults results = func.Execute(); return (DataSet)results["ReturnedValues"]; }
/*public DataTable filters(String name, String lastname, String docType, Decimal? docNumber, String mail) { SqlResults results = new SqlQuery() }*/ public DataTable filteredSearch(String name, String lastname, String docType, Decimal? docNumber, String mail) { if (docNumber == -1) { SqlResults results = new SqlFunction("[BOBBY_TABLES].SP_FILTER_PERSONS_NULLDOC") .WithParam("@Name").As(SqlDbType.VarChar).Value(name) .WithParam("@Lastname").As(SqlDbType.VarChar).Value(lastname) .WithParam("@DocType").As(SqlDbType.VarChar).Value(docType) .WithParam("@Mail").As(SqlDbType.VarChar).Value(mail) .Execute(); return (DataTable)results["ReturnedValues"]; } else { SqlResults results = new SqlFunction("[BOBBY_TABLES].SP_FILTER_PERSONS") .WithParam("@Name").As(SqlDbType.VarChar).Value(name) .WithParam("@Lastname").As(SqlDbType.VarChar).Value(lastname) .WithParam("@DocType").As(SqlDbType.VarChar).Value(docType) .WithParam("@DocNumber").As(SqlDbType.Decimal).Value(docNumber) .WithParam("@Mail").As(SqlDbType.VarChar).Value(mail) .Execute(); return (DataTable)results["ReturnedValues"]; } }
public DataTable getGuestInformation(Int32 id) { SqlResults results = new SqlFunction("[BOBBY_TABLES].FUNCT_GET_INFO") .WithParam("@IdPerson").As(SqlDbType.Int).Value(id) .Execute(); return (DataTable)results["ReturnedValues"]; }
public DataSet filteredSearch(Int32 idHotel, Int32? roomNum, Int32? floor, Int32 location, Int32 type, String descrip) { SqlResults results = new SqlFunction("[BOBBY_TABLES].SP_FILTER_ROOMS") .WithParam("@IdHotel").As(SqlDbType.Int).Value(idHotel) .WithParam("@RoomNum").As(SqlDbType.Int).Value(roomNum) .WithParam("@Floor").As(SqlDbType.Int).Value(floor) .WithParam("@TypeDesc").As(SqlDbType.Int).Value(type) .WithParam("@LocationDesc").As(SqlDbType.Int).Value(location) .WithParam("@Descr").As(SqlDbType.VarChar).Value(descrip) .Execute(); return (DataSet)results["ReturnedValues"]; }