private static AddressInfo CreateAddressInfoInstance(GeoMessageAddressInfo table) { return new AddressInfo() { BuildingFloor = table.BuildingFloor, BuildingName = table.BuildingName, BuildingRoom = table.BuildingRoom, BuildingZone = table.BuildingZone, City = table.City, Country = table.Country, CountryCode = table.CountryCode, County = table.County, Crossing1 = table.Crossing1, Crossing2 = table.Crossing2, District = table.District, Extension = table.Extension, PhoneNumber = table.PhoneNumber, PostalCode = table.PostalCode, State = table.State, Street = table.Street, Url = table.Url }; }
private static GeoMessageAddressInfo GetGeoMessageAddressInfo(Int32 addressInfoID, SqlConnection connection, SqlTransaction transaction) { var addressInfo = new GeoMessageAddressInfo(); SqlCommand cmd = new SqlCommand( "select Extension, Street, PostalCode, City, County, State, Country, CountryCode, District, BuildingName, BuildingFloor, BuildingRoom, BuildingZone, Crossing1, Crossing2, Url, PhoneNumber from GeoMessageAddressInfo where GeoMessageAddressInfoID = @addressInfoID", connection, transaction); cmd.Parameters.AddWithValue("@addressInfoID", addressInfoID); SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { String extension = Convert.ToString(reader[0]); String street = Convert.ToString(reader[1]); String postalCode = Convert.ToString(reader[2]); String city = Convert.ToString(reader[3]); String county = Convert.ToString(reader[4]); String state = Convert.ToString(reader[5]); String country = Convert.ToString(reader[6]); String countryCode = Convert.ToString(reader[7]); String district = Convert.ToString(reader[8]); String buildingName = Convert.ToString(reader[9]); String buildingFloor = Convert.ToString(reader[10]); String buildingRoom = Convert.ToString(reader[11]); String buildingZone = Convert.ToString(reader[12]); String crossing1 = Convert.ToString(reader[13]); String crossing2 = Convert.ToString(reader[14]); String url = Convert.ToString(reader[15]); String phoneNumber = Convert.ToString(reader[16]); addressInfo.BuildingFloor = buildingFloor; addressInfo.BuildingName = buildingName; addressInfo.BuildingRoom = buildingRoom; addressInfo.BuildingZone = buildingZone; addressInfo.City = city; addressInfo.Country = country; addressInfo.CountryCode = countryCode; addressInfo.County = county; addressInfo.Crossing1 = crossing1; addressInfo.Crossing2 = crossing2; addressInfo.District = district; addressInfo.Extension = extension; addressInfo.ID = addressInfoID; addressInfo.PhoneNumber = phoneNumber; addressInfo.PostalCode = postalCode; addressInfo.State = state; addressInfo.Street = street; addressInfo.Url = url; } } finally { if (reader != null) reader.Close(); } return addressInfo; }