/// <summary>
/// Called when the cache requires a region name to be read from the database
/// </summary>
/// <param name="myObject"></param>
/// <param name="args"></param>
static void NameCache_DataUpdateNeeded(object myObject, DataUpdateNeededArgs<long, string> args)
{
string name = "";
lock (regionsTableAdapter)
{
EveDataSet.mapRegionsDataTable table = new EveDataSet.mapRegionsDataTable();
regionsTableAdapter.FillByIDs(table, args.Key.ToString());
if (table.Count > 0)
{
name = table[0].regionName;
}
}
if (name.Equals(""))
{
name = "Unknown Region (" + args.Key + ")";
}
// Add region ID to wormhole regions
if (name.Trim().ToUpper().Equals("UNKNOWN"))
{
name = "Unknown (" + args.Key + ")";
}
args.Data = name;
}
public static EveDataSet.mapRegionsDataTable GetAllRegions()
{
EveDataSet.mapRegionsDataTable retVal = new EveDataSet.mapRegionsDataTable();
regionsTableAdapter.Fill(retVal);
Regions.SetWormholeRegionNames(ref retVal);
return retVal;
}
public static EveDataSet.mapRegionsDataTable GetAssetRegions(List<AssetAccessParams> accessList,
int itemID)
{
StringBuilder regionIDs = new StringBuilder("");
EMMADataSet.IDTableDataTable idTable = Assets.GetInvolvedRegionIDs(accessList, itemID);
foreach (EMMADataSet.IDTableRow id in idTable)
{
regionIDs.Append(" ");
regionIDs.Append(id.ID);
}
EveDataSet.mapRegionsDataTable retVal = new EveDataSet.mapRegionsDataTable();
lock (regionsTableAdapter)
{
regionsTableAdapter.FillByIDs(retVal, regionIDs.ToString());
}
Regions.SetWormholeRegionNames(ref retVal);
return retVal;
}