private static CanadianLocatorResult BuildDealerItem(SqlDataReader rdr)
{
var d = new CanadianLocatorResult(DealerType.Dealer)
{
Id = rdr.IsDBNull(rdr.GetOrdinal("id")) ? -1 : (int)rdr.GetDecimal(rdr.GetOrdinal("id"))
};
PopulateStandardFields(rdr, d);
return(d);
}
internal static void PopulateStandardFields(SqlDataReader rdr, CanadianLocatorResult d)
{
d.Name = rdr.IsDBNull(rdr.GetOrdinal("company")) ? "" : rdr.GetString(rdr.GetOrdinal("company"));
d.Address = rdr.IsDBNull(rdr.GetOrdinal("address")) ? "" : rdr.GetString(rdr.GetOrdinal("address"));
d.City = rdr.IsDBNull(rdr.GetOrdinal("city")) ? "" : rdr.GetString(rdr.GetOrdinal("city"));
d.Province = rdr.IsDBNull(rdr.GetOrdinal("province")) ? "" : rdr.GetString(rdr.GetOrdinal("province"));
d.PostalCode = rdr.IsDBNull(rdr.GetOrdinal("postal_code")) ? "" : rdr.GetString(rdr.GetOrdinal("postal_code"));
var phone = rdr.IsDBNull(rdr.GetOrdinal("phone")) ? "" : rdr.GetString(rdr.GetOrdinal("phone"));
d.Phone = FormatPhoneNumber(phone);
d.Distance = (Decimal)(rdr.IsDBNull(rdr.GetOrdinal("distanceKilometers")) ? 0.0 : rdr.GetDouble(rdr.GetOrdinal("distanceKilometers")));
d.Website = rdr.IsDBNull(rdr.GetOrdinal("website")) ? "" : rdr.GetString(rdr.GetOrdinal("website"));
}
