override public SqlResults AnalyzeResults()
{
SqlResults RetValues = new SqlResults();
foreach (SqlParameter Param in OutputParameters)
{
RetValues.Add(Param.ParameterName, Param.Value);
}
return(RetValues);
}
public SqlResults Execute()
{
this.Build();
ConnectionManager.OpenConnection();
object QueryResults = OutputMode.Execute(StoredCommand);
SqlResults RetValues = AnalyzeResults();
if (QueryResults != null)
{
RetValues.Add("ReturnedValues", QueryResults);
}
return(RetValues);
}
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 override IStoreResults DoGlobalPostLocalExecute(IStoreTransactionScope ts)
{
SqlResults results = new SqlResults();
return results;
}
public override IStoreResults DoLocalTargetExecute(IStoreTransactionScope ts)
{
SqlResults results = new SqlResults();
return results;
}
