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;
}
public static EveDataSet.mapSolarSystemsDataTable GetAssetSystems(
List<AssetAccessParams> accessParams, int itemID, long regionID)
{
StringBuilder systemIDs = new StringBuilder("");
EMMADataSet.IDTableDataTable idTable = Assets.GetInvolvedSystemIDs(accessParams, itemID, regionID);
foreach (EMMADataSet.IDTableRow id in idTable)
{
systemIDs.Append(" ");
systemIDs.Append(id.ID);
}
EveDataSet.mapSolarSystemsDataTable retVal = new EveDataSet.mapSolarSystemsDataTable();
lock (systemsTableAdapter)
{
systemsTableAdapter.FillByIDs(retVal, systemIDs.ToString());
}
return retVal;
}
public static EveDataSet.mapSolarSystemsDataTable GetAllSystems()
{
EveDataSet.mapSolarSystemsDataTable table = new EveDataSet.mapSolarSystemsDataTable();
systemsTableAdapter.Fill(table);
return table;
}
/// <summary>
/// Get a data table containing all the items specified in the supplied list of IDs
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
private static EveDataSet.mapSolarSystemsDataTable GetSystems(string ids)
{
EveDataSet.mapSolarSystemsDataTable systems = new EveDataSet.mapSolarSystemsDataTable();
lock (systemsTableAdapter)
{
systemsTableAdapter.FillByIDs(systems, ids);
}
return systems;
}
