private void ShowSystemName_Load(object sender, EventArgs e) { var systemcollection = new AutoCompleteStringCollection(); var stationcollection = new AutoCompleteStringCollection(); using (var elite = new elite_testingEntities()) { var systemlist = elite.Systems.ToList(); var stationlist = elite.Stations.ToList(); foreach (var x in systemlist) { systemcollection.Add(x.name); } foreach (var x in stationlist) { stationcollection.Add(x.name); } } textBox2.AutoCompleteCustomSource = systemcollection; textBox1.AutoCompleteCustomSource = stationcollection; textBox2.Text = OCRThingee.Systemname; textBox1.Text = OCRThingee.Stationname; }
private void tabControl2_SelectedIndexChanged(object sender, EventArgs e) { if (tabControl2.SelectedTab != tabControl2.TabPages["TabPage1"]) { return; } _source.Clear(); _systemcollectionstrings.Clear(); var systemvalues = new Dictionary <int, string>(); using (var elite = new elite_testingEntities()) { var systemcollection = from p in elite.Systems select p; _systemcollectionstrings.AddRange(systemcollection.Select(x => x.name)); foreach (var v in systemcollection.ToList()) { systemvalues.Add(v.sysId, v.name); } } _source.AddRange(_systemcollectionstrings.ToArray()); comboBox1.DataSource = new BindingSource(systemvalues, null); comboBox1.DisplayMember = "Value"; comboBox1.ValueMember = "Key"; comboBox1.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox1.AutoCompleteCustomSource = _source; comboBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox4.DataSource = new BindingSource(systemvalues, null); comboBox4.DisplayMember = "Value"; comboBox4.ValueMember = "Key"; comboBox4.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox4.AutoCompleteCustomSource = _source; comboBox4.AutoCompleteSource = AutoCompleteSource.CustomSource; }
private async void btn_AddRowToDatabase_Click(object sender, EventArgs e) { using (var elite = new elite_testingEntities()) { try { var cloned = new DataGridView(); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns.Add(new DataGridViewTextBoxColumn()); cloned.Columns[0].Name = "SystemName"; cloned.Columns[1].Name = "StationName"; cloned.Columns[2].Name = "GoodsName"; cloned.Columns[3].Name = "SellPrice"; cloned.Columns[4].Name = "BuyPrice"; cloned.Columns[5].Name = "NumSupply"; cloned.Columns[6].Name = "GalacticAverage"; foreach (var y in dg_OCRRows.Rows.Cast <DataGridViewRow>().Where(y => y.Cells[2].Value.ToString() != "")) { cloned.Rows.Add(CloneWithValues(y)); } var task = UpdateDatabaseAsync(elite, cloned); await task; tradeitemsTableAdapter.Fill(eliteDataSet.tradeitems); stationsTableAdapter.Fill(eliteDataSet.stations); systemsTableAdapter.Fill(eliteDataSet.systems); itemsTableAdapter.Fill(eliteDataSet.items); dataGridView2.Refresh(); dataGridView3.Refresh(); dataGridView4.Refresh(); dataGridView5.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(CultureInfo.InvariantCulture)); } } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { var cmb = (ComboBox)sender; if (cmb.SelectedItem == null) { return; } var x = (KeyValuePair <int, string>)cmb.SelectedItem; _stationcollectionstrings.Clear(); var stationvalues = new Dictionary <int, string>(); using (var elite = new elite_testingEntities()) { var stationcollection = from p in elite.Systems where p.sysId == x.Key join u in elite.Stations on p.sysId equals u.sysid select u; var list = stationcollection.ToList(); if (list.Count > 0) { _stationcollectionstrings.AddRange(stationcollection.Select(station => station.name)); _stationsource.AddRange(_stationcollectionstrings.ToArray()); foreach (var station in list) { stationvalues.Add(station.stationId, station.name); } } else { _stationsource.Add(""); stationvalues.Add(0, "NO STATION"); } } comboBox2.DisplayMember = "Value"; comboBox2.ValueMember = "Key"; comboBox2.DataSource = new BindingSource(stationvalues, null); comboBox2.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox2.AutoCompleteCustomSource = _stationsource; comboBox2.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox2.AutoCompleteMode = AutoCompleteMode.Suggest; }
public ConsumerItemsList() { var elite = new elite_testingEntities(); _items = (from item in elite.Items select item.name).ToArray(); }
private void button6_Click(object sender, EventArgs e) { if (txtCargo.Text == "") { MessageBox.Show(@"Enter the number of cargo spaces in the ship."); return; } if (CreditsTextBox.Text == "") { MessageBox.Show(@"Enter the amount of credits you have."); } int num; if (!int.TryParse(txtCargo.Text, out num)) { return; } int credits; if (!int.TryParse(CreditsTextBox.Text, out credits)) { return; } using (var elite = new elite_testingEntities()) { var originatingstationKvp = (KeyValuePair <int, string>)comboBox2.SelectedItem; if (originatingstationKvp.Key == 0) { return; } var destinationsystemKey = (KeyValuePair <int, string>)comboBox4.SelectedItem; var destinationstation = from system in elite.Systems join station in elite.Stations on system.sysId equals station.sysid join tradeitem in elite.Tradeitems on station.stationId equals tradeitem.stationid join item in elite.Items on tradeitem.itemid equals item.itemId where tradeitem.sellprice > 0 where system.sysId == destinationsystemKey.Key select new { TradeitemId = tradeitem.itemid, SystemName = system.name, StationID = station.stationId, StationName = station.name, TradeItemName = item.name, Supply = tradeitem.supply, BuyPrice = tradeitem.buyprice, SellPrice = tradeitem.sellprice }; var originatingstation = from station in elite.Stations join tradeitem in elite.Tradeitems on station.stationId equals tradeitem.stationid join item in elite.Items on tradeitem.itemid equals item.itemId join system in elite.Systems on station.sysid equals system.sysId where tradeitem.supply > 0 where tradeitem.buyprice > 0 where station.stationId == originatingstationKvp.Key select new { TradeitemId = tradeitem.itemid, SystemName = system.name, StationID = station.stationId, StationName = station.name, TradeItemName = item.name, Supply = tradeitem.supply, BuyPrice = tradeitem.buyprice, SellPrice = tradeitem.sellprice }; var profit = from t in originatingstation join f in destinationstation on t.TradeitemId equals f.TradeitemId where t.BuyPrice <f.SellPrice && (credits / t.BuyPrice > 0) let numberBought = (credits / t.BuyPrice)> num ? num : (credits / t.BuyPrice) select new { TradeitemID = f.TradeitemId, f.SystemName, f.StationID, f.StationName, f.TradeItemName, t.Supply, t.BuyPrice, f.SellPrice, NumberBought = numberBought, Profit = (f.SellPrice - t.BuyPrice) * numberBought }; var y = profit.ToList(); y = y.OrderByDescending(v => v.Profit).GroupBy(v => v.StationID).SelectMany(g => g).ToList(); var bindingSource1 = new BindingSource { DataSource = y }; dataGridView1.DataSource = bindingSource1; } }
private static void UpdateDatabase(elite_testingEntities elite, DataGridView thegrid) { var thissystem = elite.Systems.ToList(); for (int index = 0; index < thegrid.Rows.Count; index++) { DataGridViewRow y = thegrid.Rows[index]; if (y.Cells[0].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[0].FormattedValue.ToString())) { continue; } if (y.Cells[1].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[1].FormattedValue.ToString())) { continue; } if (y.Cells[2].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[2].FormattedValue.ToString())) { continue; } if (y.Cells[3].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[3].FormattedValue.ToString())) { continue; } if (y.Cells[4].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[4].FormattedValue.ToString())) { continue; } if (y.Cells[5].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[5].FormattedValue.ToString())) { continue; } if (y.Cells[6].FormattedValue == null) { continue; } if (string.IsNullOrEmpty(y.Cells[6].FormattedValue.ToString())) { continue; } var system = y.Cells[0].FormattedValue.ToString(); var station = y.Cells[1].FormattedValue.ToString(); station = station.RemoveChars('\n'); var goodsname = y.Cells[2].FormattedValue.ToString(); var sellprice = y.Cells[3].FormattedValue.ToString(); var buyprice = y.Cells[4].FormattedValue.ToString(); var numsupply = y.Cells[5].FormattedValue.ToString(); var thesystem = thissystem.Find(s => s.name == system); if (thesystem == null) { elite.Systems.Add(new system { name = system }); elite.SaveChanges(); thissystem = elite.Systems.ToList(); thesystem = thissystem.Find(s => s.name == system); } var count = elite.Stations.Count(s => s.sysid == thesystem.sysId); station thestation; List <station> systemstationlist; if (count < 1) { thestation = null; } else { systemstationlist = elite.Stations.Where(s => s.sysid == thesystem.sysId).ToList(); thestation = systemstationlist.Find(s => s.name == station); } if (thestation == null) { elite.Stations.Add(new station { name = station, sysid = thesystem.sysId }); elite.SaveChanges(); systemstationlist = elite.Stations.Where(s => s.sysid == thesystem.sysId).ToList(); thestation = systemstationlist.Find(s => s.name == station); } var goodslist = elite.Items.ToList(); var thisgood = goodslist.Find(s => s.name == goodsname); if (thisgood == null) { elite.Items.Add(new item { name = goodsname }); elite.SaveChanges(); goodslist = elite.Items.ToList(); thisgood = goodslist.Find(s => s.name == goodsname); } var tradeitemlist = elite.Tradeitems.Where(s => s.stationid == thestation.stationId).ToList(); var thistradeitem = tradeitemlist.Find(s => s.itemid == thisgood.itemId); if (buyprice == "") { buyprice = "0"; } if (sellprice == "") { sellprice = "0"; } if (numsupply == "") { numsupply = "0"; } var decbuyprice = int.Parse(buyprice); var decsellprice = int.Parse(sellprice); var intsupply = int.Parse(numsupply); if (thistradeitem != null) { thistradeitem.lastupdate = DateTime.Now; thistradeitem.buyprice = decbuyprice; thistradeitem.sellprice = decsellprice; thistradeitem.supply = intsupply; elite.SaveChanges(); } else { elite.Tradeitems.Add(new tradeitem { lastupdate = DateTime.Now, stationid = thestation.stationId, itemid = thisgood.itemId, buyprice = decbuyprice, sellprice = decsellprice, supply = intsupply }); elite.SaveChanges(); } } }
public Task UpdateDatabaseAsync(elite_testingEntities elite, DataGridView thegrid) { return(Task.Run(() => UpdateDatabase(elite, thegrid))); }