public Restaurant GetRestaurantByID(int id)
{
string sql = "Select * From restaurant where RestaurantID = @id";
Dictionary <object, object> parameters = new Dictionary <object, object>();
parameters.Add("id", id.ToString());
DataSet results = GetDataSetSql(sql, parameters);
Restaurant r = null;
if (results != null && results.Tables[0].Rows.Count == 1)
{
r = DataSetParser.DataSetToRestaurant(results, 0);
}
return(r);
}
public Restaurant GetRestaurantByName(string Name)
{
string sql = "Select * From restaurant where Naam like @name";
Dictionary <object, object> parameters = new Dictionary <object, object>();
parameters.Add("name", Name);
DataSet results = GetDataSetSql(sql, parameters);
Restaurant r = null;
if (results != null && results.Tables[0].Rows.Count == 1)
{
r = DataSetParser.DataSetToRestaurant(results, 0);
}
return(r);
}
public List <Restaurant> GetGlobalRestaurants()
{
string sql = "Select * From restaurant";
Dictionary <object, object> parameters = new Dictionary <object, object>();
DataSet results = GetDataSetSql(sql, parameters);
List <Restaurant> restaurants = new List <Restaurant>();
if (results != null && results.Tables[0].Rows.Count > 0)
{
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
Restaurant r = DataSetParser.DataSetToRestaurant(results, x);
restaurants.Add(r);
}
}
return(restaurants);
}