/// <summary> /// recursively add the parent groups of the specified group id to the given table. /// </summary> /// <param name="table"></param> /// <param name="groupID"></param> private static void AddGroupParents(EveDataSet.invMarketGroupsDataTable table, int groupID) { EveDataSet.invMarketGroupsRow group = table.FindBymarketGroupID(groupID); if (group == null) { EveDataSet.invMarketGroupsDataTable resultTable = new EveDataSet.invMarketGroupsDataTable(); tableAdapter.FillByID(resultTable, groupID); table.ImportRow(resultTable[0]); group = table.FindBymarketGroupID(groupID); } if (!group.IsparentGroupIDNull()) { AddGroupParents(table, group.parentGroupID); } }
/// <summary> /// Load the data for the specified route into the specified data table /// </summary> /// <param name="startSystem"></param> /// <param name="endSystem"></param> /// <param name="distances"></param> private static void LoadDistanceData(int startSystem, int endSystem, EveDataSet.SolarSystemDistancesDataTable distances) { lock (tableAdapter) { try { tableAdapter.FillByIDs(distances, startSystem, endSystem); } catch (Exception ex) { throw new EMMADataException(ExceptionSeverity.Critical, "Problem loading distance " + "data from the EMMA database. (" + SolarSystems.GetSystemName(startSystem) + " -> " + SolarSystems.GetSystemName(endSystem) + ")", ex); } } }
private static void SetWormholeRegionNames(ref EveDataSet.mapRegionsDataTable table) { foreach (EveDataSet.mapRegionsRow region in table) { // Add region ID to wormhole regions if (region.regionName.Trim().ToUpper().Equals("UNKNOWN")) { region.regionName = "Unknown (" + region.regionID + ")"; } } }