/// <summary>
/// Get the specified item.
/// </summary>
/// <param name="itemID"></param>
/// <returns></returns>
/// <exception cref="EMMADataMissingException"></exception>
public static EveDataSet.invTypesRow GetItem(int itemID)
{
EveDataSet.invTypesDataTable table = new EveDataSet.invTypesDataTable();
table = GetItems(itemID.ToString());
EveDataSet.invTypesRow data = table.FindBytypeID(itemID);
return data;
}
public EveDataSet.invTypesDataTable GetAllItems()
{
EveDataSet.invTypesDataTable retVal = new EveDataSet.invTypesDataTable();
foreach (EMMADataSet.TradedItemsRow item in table)
{
EveDataSet.invTypesRow existing = retVal.FindBytypeID((short)item.ItemID);
if (existing == null)
{
retVal.ImportRow(Items.GetItem(item.ItemID));
}
}
return retVal;
}
/// <summary>
/// Add a new item to the items table with the specified ID and name.
/// </summary>
/// <param name="itemID"></param>
/// <param name="itemName"></param>
public static void AddItem(int itemID, string itemName)
{
try
{
// First make sure this item is not already in the database.
lock (tableAdapter)
{
EveDataSet.invTypesDataTable items = new EveDataSet.invTypesDataTable();
items = GetItems(itemID.ToString());
EveDataSet.invTypesRow data = items.FindBytypeID(itemID);
if (data == null)
{
EveDataSet.invTypesRow newRow = items.NewinvTypesRow();
newRow.typeID = itemID;
newRow.typeName = itemName;
/// Just adding a placeholder row until an offical datadump arrives.
/// Can't expect the user to enter other details so just leave other rows
/// to default value (i.e. null)...
items.AddinvTypesRow(newRow);
tableAdapter.Update(items);
}
else
{
/*throw new EMMADataException(ExceptionSeverity.Error, "Item with ID " + itemID +
" already exists in database.");*/
}
}
}
catch (Exception ex)
{
throw new EMMADataException(ExceptionSeverity.Error, "Problem adding item to database.", ex);
}
}
/// <summary>
/// Get the specified item. itemName can be the whole name or just part of a name.
/// </summary>
/// <param name="itemName"></param>
/// <returns></returns>
public static EveDataSet.invTypesRow GetItem(string itemName)
{
EveDataSet.invTypesDataTable table = new EveDataSet.invTypesDataTable();
EveDataSet.invTypesRow retVal = null;
lock (tableAdapter)
{
tableAdapter.FillByName(table, itemName);
}
if (table.Count == 1)
{
retVal = table[0];
}
else
{
lock (tableAdapter)
{
tableAdapter.FillByName(table, "%" + itemName + "%");
}
if (table.Count < 1)
{
throw new EMMADataException(ExceptionSeverity.Error, "No item found matching '" + itemName + "'");
}
else if (table.Count > 1)
{
SortedList<object, string> options = new SortedList<object, string>();
foreach (EveDataSet.invTypesRow item in table)
{
options.Add(item.typeID, item.typeName);
}
OptionPicker picker = new OptionPicker("Select Item", "Choose the specific item you want from " +
"those listed below.", options);
if (picker.ShowDialog() != System.Windows.Forms.DialogResult.Cancel)
{
retVal = table.FindBytypeID((int)picker.SelectedItem);
}
}
else
{
retVal = table[0];
}
}
return retVal;
}
/// <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.invTypesDataTable GetItems(string ids)
{
EveDataSet.invTypesDataTable items = new EveDataSet.invTypesDataTable();
lock (tableAdapter)
{
tableAdapter.FillByIDs(items, ids);
}
return items;
}
public static EveDataSet.invTypesDataTable GetMarketItems()
{
EveDataSet.invTypesDataTable retVal = new EveDataSet.invTypesDataTable();
lock (tableAdapter)
{
tableAdapter.FillByMarketItems(retVal, false);
}
return retVal;
}
public static EveDataSet.invTypesDataTable GetItemsTraded(List<FinanceAccessParams> accessList, int minTrans,
int minBuy, int minSell, List<long> buyStations, List<long> sellStations, DateTime startDate)
{
StringBuilder itemIDs = new StringBuilder("");
DateTime endData = DateTime.UtcNow.Add(new TimeSpan(1, 0, 0, 0));
EMMADataSet.IDTableDataTable idTable = Transactions.GetInvolvedItemIDs(accessList,
minTrans, startDate, DateTime.UtcNow, minBuy, minSell, buyStations, sellStations);
foreach (EMMADataSet.IDTableRow id in idTable)
{
itemIDs.Append(" ");
itemIDs.Append(id.ID);
}
EveDataSet.invTypesDataTable retVal = new EveDataSet.invTypesDataTable();
retVal = GetItems(itemIDs.ToString());
return retVal;
}
public static EveDataSet.invTypesDataTable GetItemsThatAreAssets(List<AssetAccessParams> accessList)
{
StringBuilder itemIDs = new StringBuilder("");
EMMADataSet.IDTableDataTable idTable = Assets.GetInvolvedItemIDs(accessList);
foreach (EMMADataSet.IDTableRow id in idTable)
{
itemIDs.Append(" ");
itemIDs.Append(id.ID);
}
EveDataSet.invTypesDataTable retVal = new EveDataSet.invTypesDataTable();
retVal = GetItems(itemIDs.ToString());
return retVal;
}
private void SelectItemsTraded_Load(object sender, EventArgs e)
{
txtItemSellPrice.Enabled = false;
txtDefaultBuyPrice.Enabled = false;
cmbStation.Enabled = false;
chkUseReprocessVal.Enabled = false;
chkForceDefaultBuyPrice.Enabled = false;
chkForceDefaultSellPrice.Enabled = false;
EveDataSet.mapRegionsDataTable regions = Regions.GetAllRegions();
EveDataSet.mapRegionsRow newRow = regions.NewmapRegionsRow();
newRow.regionID = -1;
newRow.regionName = "All Regions";
regions.AddmapRegionsRow(newRow);
cmbStation.ValueMember = "regionID";
cmbStation.DisplayMember = "regionName";
cmbStation.DataSource = regions;
cmbStation.SelectedValue = -1;
cmbStation.AutoCompleteSource = AutoCompleteSource.ListItems;
cmbStation.AutoCompleteMode = AutoCompleteMode.Suggest;
itemValues = UserAccount.CurrentGroup.ItemValues;
itemsList = itemValues.GetAllItems();
lstItems.DisplayMember = "typeName";
lstItems.ValueMember = "typeID";
lstItems.DataSource = itemsList;
chkEveMarketPrices.Checked = (UserAccount.CurrentGroup.Settings.UseEveCentral || UserAccount.CurrentGroup.Settings.UseEveMetrics);
ReportGroupSettings.EveMarketValueToUse value = UserAccount.CurrentGroup.Settings.EveMarketType;
rdbMaxBuy.Checked = false;
rdbMedianBuy.Checked = false;
switch (value)
{
case ReportGroupSettings.EveMarketValueToUse.medianBuy:
rdbMedianBuy.Checked = true;
break;
case ReportGroupSettings.EveMarketValueToUse.maxBuy:
rdbMaxBuy.Checked = true;
break;
default:
break;
}
rdbEveCentral.Checked = UserAccount.CurrentGroup.Settings.UseEveCentral;
rdbEveMetrics.Checked = UserAccount.CurrentGroup.Settings.UseEveMetrics;
txtDaysBetweenUpdates.Text = UserAccount.CurrentGroup.Settings.ItemValueWebExpiryDays.ToString();
//RefreshList();
}
private void TradedItemsManager_Load(object sender, EventArgs e)
{
_tradedItems = UserAccount.CurrentGroup.TradedItems;
_itemsList = _tradedItems.GetAllItems();
lstItems.DisplayMember = "typeName";
lstItems.ValueMember = "typeID";
lstItems.DataSource = _itemsList;
}
