private static QualifiedCoordinates CreateQualifiedCoordinatesInstance(GeoMessageQualifiedCoordinates table) { return new QualifiedCoordinates() { Altitude = table.Altitude, HorizontalAccuracy = table.HorizontalAccuracy, Latitude = table.Latitude, Longitude = table.Longitude, VerticalAccuracy = table.VerticalAccuracy }; }
private static GeoMessageQualifiedCoordinates GetGeoMessageQualifiedCoordinates(Int32 qualifiedCoordinatesID, SqlConnection connection, SqlTransaction transaction) { var result = new GeoMessageQualifiedCoordinates(); SqlCommand cmd = new SqlCommand( "select Latitude, Longitude, Altitude, HorizontalAccuracy, VerticalAccuracy from GeoMessageQualifiedCoordinates where GeoMessageQualifiedCoordinatesID = @qualifiedCoordinatesID", connection, transaction); cmd.Parameters.AddWithValue("@qualifiedCoordinatesID", qualifiedCoordinatesID); SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { Double latitude = Convert.ToDouble(reader[0]); Double longitude = Convert.ToDouble(reader[1]); Single altitude = Single.NaN; Object altitudeRaw = reader[2]; if (!(altitudeRaw is DBNull)) altitude = Convert.ToSingle(altitudeRaw); Single horizontalAccuracy = Single.NaN; Object horizontalAccuracyRaw = reader[3]; if (!(horizontalAccuracyRaw is DBNull)) horizontalAccuracy = Convert.ToSingle(horizontalAccuracyRaw); Single verticalAccuracy = Single.NaN; Object verticalAccuracyRaw = reader[4]; if (!(verticalAccuracyRaw is DBNull)) verticalAccuracy = Convert.ToSingle(verticalAccuracyRaw); result.Altitude = altitude; result.HorizontalAccuracy = horizontalAccuracy; result.ID = qualifiedCoordinatesID; result.Latitude = latitude; result.Longitude = longitude; result.VerticalAccuracy = verticalAccuracy; } } finally { if (reader != null) reader.Close(); } return result; }