public static EveDataSet.mapSolarSystemsRow GetSystem(long systemID) { EveDataSet.mapSolarSystemsDataTable table = new EveDataSet.mapSolarSystemsDataTable(); EveDataSet.mapSolarSystemsRow retVal; table = GetSystems(systemID.ToString()); retVal = table.FindBysolarSystemID((int)systemID); return retVal; }
public static EveDataSet.mapSolarSystemsRow GetSystem(string systemName) { EveDataSet.mapSolarSystemsDataTable table = new EveDataSet.mapSolarSystemsDataTable(); EveDataSet.mapSolarSystemsRow retVal = null; lock (systemsTableAdapter) { systemsTableAdapter.FillByName(table, systemName); } if (table.Count == 0) { lock (systemsTableAdapter) { systemsTableAdapter.FillByName(table, "%" + systemName + "%"); } if (table.Count < 1) { throw new EMMADataException(ExceptionSeverity.Error, "No system found matching '" + systemName + "'"); } else if (table.Count > 1) { SortedList<object, string> options = new SortedList<object, string>(); foreach (EveDataSet.mapSolarSystemsRow system in table) { options.Add(system.solarSystemID, system.solarSystemName); } OptionPicker picker = new OptionPicker("Select System", "Choose the specific system you " + "want from those listed below.", options); if (picker.ShowDialog() != System.Windows.Forms.DialogResult.Cancel) { retVal = table.FindBysolarSystemID((int)picker.SelectedItem); } } else { retVal = table[0]; } } else { retVal = table[0]; } return retVal; }