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;
}