/// <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; }