public bool TryGetCity(string city, string state, string postalCode, string country, out City match)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.TryGetCity");
db.AddInputParameter("@City", DbType.String, city);
db.AddInputParameter("@State", DbType.String, state);
db.AddInputParameter("@PostalCode", DbType.String, postalCode);
db.AddInputParameter("@Country", DbType.String, country);
db.AddReturnParameter();
try
{
db.ReadInto(match = new City());
return Convert.ToBoolean(db.GetReturnValue());
}
catch (Exception ex)
{
Logger.Error("Error while getting country.", ex);
}
}
match = default(City);
return false;
}