public void FindAddressBy(ClubModel club)
{
string query = "Select * from adres where zipcode=@zipcode";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
parameters.Add(new KeyValuePair <string, string>("zipcode", club.ZipCode));
DataSet results = ExecuteQuery(query, parameters);
AddressModel address = new AddressModel();
if (results != null && results.Tables[0].Rows.Count > 0)
{
address = DataSetParser.DataSetToaddress(results, 0);
}
club.AID = address.AID;
}