public void LoadPrices(IPriceProvider a_PriceProvider, Settings.V2._PriceSettings a_Settings, bool a_Silent) { StopUpdaterThread(); m_ItemsDB.ResetItemPrices(); ItemPrices.PricesDataTable pricesTable = new ItemPrices.PricesDataTable(); string selectSQL = "Select * from " + pricesTable.TableName + " where " + "(" + pricesTable.ProviderIDColumn.ColumnName + " = @ProviderID) AND " + "(" + pricesTable.RegionIDColumn.ColumnName + " = @RegionID) AND " + "(" + pricesTable.SolarIDColumn.ColumnName + " = @SolarID) AND " + "(" + pricesTable.StationIDColumn.ColumnName + " = @StationID) AND" + "(" + pricesTable.PriceTypeColumn.ColumnName + " = @PriceType)"; SQLiteCommand sqlCommand = new SQLiteCommand(selectSQL, m_DbConnection); PriceRecord priceFilter = a_PriceProvider.GetCurrentFilter(); sqlCommand.Parameters.AddWithValue("@ProviderID", (UInt32)priceFilter.Provider); sqlCommand.Parameters.AddWithValue("@RegionID", priceFilter.RegionID); sqlCommand.Parameters.AddWithValue("@SolarID", priceFilter.SolarID); sqlCommand.Parameters.AddWithValue("@StationID", priceFilter.StationID); sqlCommand.Parameters.AddWithValue("@PriceType", (UInt32)priceFilter.PriceType); SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlCommand); adapter.Fill(pricesTable); foreach (ItemPrices.PricesRow currRow in pricesTable.Rows) { DbRecordToItemRecord(currRow); } TestMarketPrices(a_PriceProvider, a_Settings, a_Silent); }
public void DropPrices(IPriceProvider a_PriceProvider) { StopUpdaterThread(); ItemPrices.PricesDataTable pricesTable = new ItemPrices.PricesDataTable(); string selectSQL = "Delete from " + pricesTable.TableName + " where " + "(" + pricesTable.ProviderIDColumn.ColumnName + " = @ProviderID) AND " + "(" + pricesTable.RegionIDColumn.ColumnName + " = @RegionID) AND " + "(" + pricesTable.SolarIDColumn.ColumnName + " = @SolarID) AND " + "(" + pricesTable.StationIDColumn.ColumnName + " = @StationID) AND" + "(" + pricesTable.PriceTypeColumn.ColumnName + " = @PriceType)"; SQLiteCommand sqlCommand = new SQLiteCommand(selectSQL, m_DbConnection); PriceRecord priceFilter = a_PriceProvider.GetCurrentFilter(); sqlCommand.Parameters.AddWithValue("@ProviderID", (UInt32)priceFilter.Provider); sqlCommand.Parameters.AddWithValue("@RegionID", priceFilter.RegionID); sqlCommand.Parameters.AddWithValue("@SolarID", priceFilter.SolarID); sqlCommand.Parameters.AddWithValue("@StationID", priceFilter.StationID); sqlCommand.Parameters.AddWithValue("@PriceType", (UInt32)priceFilter.PriceType); sqlCommand.ExecuteNonQuery(); }
private void BtnLoadMineralPrices_Click(object sender, EventArgs e) { List <UInt32> loadPricesFor = new List <UInt32>(); loadPricesFor.Add((UInt32)EveTypeIDs.Tritanium); loadPricesFor.Add((UInt32)EveTypeIDs.Pyerite); loadPricesFor.Add((UInt32)EveTypeIDs.Mexallon); loadPricesFor.Add((UInt32)EveTypeIDs.Isogen); loadPricesFor.Add((UInt32)EveTypeIDs.Noxcium); loadPricesFor.Add((UInt32)EveTypeIDs.Zydrine); loadPricesFor.Add((UInt32)EveTypeIDs.Megacyte); loadPricesFor.Add((UInt32)EveTypeIDs.Morphite); IPriceProvider provider = PriceProviderAuto.GetPriceProvider(m_Settings.PriceLoad.Minerals); // @@@@ Check for exceptions? List <PriceRecord> prices = provider.GetPrices(loadPricesFor); PriceRecord priceFilter = provider.GetCurrentFilter(); foreach (PriceRecord currRecord in prices) { if (!currRecord.IsMatchesFilter(priceFilter)) { continue; } switch ((EveTypeIDs)currRecord.TypeID) { case EveTypeIDs.Tritanium: TxtTritanium.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Pyerite: TxtPyerite.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Mexallon: TxtMexallon.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Isogen: TxtIsogen.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Noxcium: TxtNoxcium.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Zydrine: TxtZydrine.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Megacyte: TxtMegacyte.Value = (decimal)currRecord.Price; break; case EveTypeIDs.Morphite: TxtMorphite.Value = (decimal)currRecord.Price; break; } } }