public async Task <BasicGeoposition> GetGeoposition(uint parentId, CoordinatesParentType parentType) { BasicGeoposition geoposition = null; using (var conn = GetConnection()) { conn.Open(); var cmd = new MySqlCommand(@"SELECT * FROM BasicGeoposition WHERE ParentId = @parentId AND ParentType = @parentType", conn); cmd.Parameters.AddWithValue("@parentId", parentId); cmd.Parameters.AddWithValue("@parentType", parentType); using (var reader = await cmd.ExecuteReaderAsync()) { while (reader.Read()) { geoposition = new BasicGeoposition() { ParentId = Convert.ToUInt32(reader["ParentId"]), ParentType = (CoordinatesParentType)Convert.ToUInt32(reader["ParentType"]), Latitude = ConversionHelpers.SafeGetDouble(reader, reader.GetOrdinal("Latitude")), Longitude = ConversionHelpers.SafeGetDouble(reader, reader.GetOrdinal("Longitude")), Altitude = ConversionHelpers.SafeGetDouble(reader, reader.GetOrdinal("Altitude")), Description = ConversionHelpers.SafeGetString(reader, reader.GetOrdinal("Description")) }; } } } return(geoposition); }
public BasicGeoposition(uint parentId, CoordinatesParentType parentType, double latitude, double longitude, double altitude, string description = "") { ParentId = parentId; ParentType = parentType; Latitude = latitude; Longitude = longitude; Altitude = altitude; Description = description; }