private AuctionItem ReadDatabase(string _table, int starttimestamp, int endtimestamp) { var results = AuctionItemsTop.Where(x => x.itemName == _table).Where(x => x.TimeStamp > starttimestamp).Where(x => x.TimeStamp < endtimestamp); AuctionItem returnItem = new AuctionItem(); if (results.Count() > 0) { returnItem.TimeStamp = results.ElementAt(0).TimeStamp; returnItem.itemName = results.ElementAt(0).itemName; int bidsum = 0; int buysum = 0; for (int i = 0; i < results.Count(); i++) { bidsum += results.ElementAt(i).BidPrice; buysum += results.ElementAt(i).BuyoutPrice; } returnItem.BuyoutPrice = Convert.ToInt32(buysum / results.Count()); returnItem.BidPrice = Convert.ToInt32(bidsum / results.Count()); } else { returnItem.BuyoutPrice = 0; returnItem.BidPrice = 0; returnItem.TimeStamp = starttimestamp; returnItem.itemName = _table; } return(returnItem); }
private void deletepoint_Click(object sender, EventArgs e) { List <object> itemstodelete = new List <object>(); AuctionItem auctionitem = null; foreach (var item in TimeStampList.CheckedItems) { string[] _string = item.ToString().Split(','); auctionitem = AuctionItemsTop.Where(x => x.Id == Int32.Parse(_string[0])).First(); AuctionItemsTop.Remove(auctionitem); itemstodelete.Add(item); } foreach (var delete in itemstodelete) { TimeStampList.Items.Remove(delete); } }
private void Save_btn_Click(object sender, EventArgs e) { if (ItemName.Text == "" && ItemNameComboBox.Items.Count == 0) { MessageBox.Show("Item Name missing"); return; } int Bid = 0; int Buyout = 0; if (!(int.TryParse(BidInCopper.Text, out Bid)) && !BidInCopper.Text.Contains(',')) { MessageBox.Show("Bid in Copper missing or not a Number"); return; } if (!(int.TryParse(BuyoutinCopper.Text, out Buyout)) && !BuyoutinCopper.Text.Contains(',')) { MessageBox.Show("Buyout in Copper missing or not a Number"); return; } if(BuyoutinCopper.Text.Contains(',')) { int buycount = BuyoutinCopper.Text.Count(f => f == ','); if(buycount == 1) { int silver = 0; int copper = 0; string[] money = BuyoutinCopper.Text.Split(','); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Buyout = silver * 100 + copper; } if(buycount == 2) { int gold = 0; int silver = 0; int copper = 0; string[] money = BuyoutinCopper.Text.Split(','); int.TryParse(money[0], out gold); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Buyout = gold * 100 * 100 + silver * 100 + copper; } } if (BidInCopper.Text.Contains(',')) { int bidcount = BidInCopper.Text.Count(f => f == ','); if (bidcount == 1) { int silver = 0; int copper = 0; string[] money = BidInCopper.Text.Split(','); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Bid = silver * 100 + copper; } if (bidcount == 2) { int gold = 0; int silver = 0; int copper = 0; string[] money = BidInCopper.Text.Split(','); int.TryParse(money[0], out gold); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Bid = gold * 100 * 100 + silver * 100 + copper; } } string name = ""; if (ItemName.Text != "") { name = ItemName.Text; ItemName.Text = ""; } else { name = ItemNameComboBox.SelectedItem.ToString(); } int id = 0; foreach(AuctionItem queryitem in AuctionItemsTop) { if(queryitem.Id > id) { id = queryitem.Id; } } name = name.Replace(" ", "_"); AuctionItem newItemEntry = new AuctionItem(); newItemEntry.Id = id + 1; newItemEntry.itemName = name; newItemEntry.BuyoutPrice = Buyout; newItemEntry.BidPrice = Bid; newItemEntry.setTimeStamp(DateTime.Now); if (!Measurment.Items.Contains(name)) { Measurment.Items.Add(name); ItemNameComboBox.Items.Add(name); MeasurementCorection.Items.Add(name); Conversion_BaseItem.Items.Add(name); Conversion_Result_Item.Items.Add(name); Conversion_Correction_BaseItem.Items.Add(name); Conversion_Correction_ResultITem.Items.Add(name); ItemNameComboBox.SelectedIndex = ItemNameComboBox.Items.Count -1; ItemName.AutoCompleteCustomSource.Add(name); } AuctionItemsTop.Add(newItemEntry); BuyoutinCopper.Text = ""; BidInCopper.Text = ""; }
private AuctionItem ReadDatabase(string _table, int starttimestamp,int endtimestamp) { var results = AuctionItemsTop.Where(x => x.itemName == _table).Where(x => x.TimeStamp > starttimestamp).Where(x => x.TimeStamp < endtimestamp); AuctionItem returnItem = new AuctionItem(); if (results.Count() > 0) { returnItem.TimeStamp = results.ElementAt(0).TimeStamp; returnItem.itemName = results.ElementAt(0).itemName; int bidsum = 0; int buysum = 0; for (int i = 0;i< results.Count();i++) { bidsum += results.ElementAt(i).BidPrice; buysum += results.ElementAt(i).BuyoutPrice; } returnItem.BuyoutPrice = Convert.ToInt32(buysum / results.Count()); returnItem.BidPrice = Convert.ToInt32(bidsum / results.Count()); } else { returnItem.BuyoutPrice = 0; returnItem.BidPrice = 0; returnItem.TimeStamp = starttimestamp; returnItem.itemName = _table; } return returnItem; }
private void Save_btn_Click(object sender, EventArgs e) { if (ItemName.Text == "" && ItemNameComboBox.Items.Count == 0) { MessageBox.Show("Item Name missing"); return; } int Bid = 0; int Buyout = 0; if (!(int.TryParse(BidInCopper.Text, out Bid)) && !BidInCopper.Text.Contains(',')) { MessageBox.Show("Bid in Copper missing or not a Number"); return; } if (!(int.TryParse(BuyoutinCopper.Text, out Buyout)) && !BuyoutinCopper.Text.Contains(',')) { MessageBox.Show("Buyout in Copper missing or not a Number"); return; } if (BuyoutinCopper.Text.Contains(',')) { int buycount = BuyoutinCopper.Text.Count(f => f == ','); if (buycount == 1) { int silver = 0; int copper = 0; string[] money = BuyoutinCopper.Text.Split(','); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Buyout = silver * 100 + copper; } if (buycount == 2) { int gold = 0; int silver = 0; int copper = 0; string[] money = BuyoutinCopper.Text.Split(','); int.TryParse(money[0], out gold); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Buyout = gold * 100 * 100 + silver * 100 + copper; } } if (BidInCopper.Text.Contains(',')) { int bidcount = BidInCopper.Text.Count(f => f == ','); if (bidcount == 1) { int silver = 0; int copper = 0; string[] money = BidInCopper.Text.Split(','); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Bid = silver * 100 + copper; } if (bidcount == 2) { int gold = 0; int silver = 0; int copper = 0; string[] money = BidInCopper.Text.Split(','); int.TryParse(money[0], out gold); int.TryParse(money[1], out silver); int.TryParse(money[2], out copper); Bid = gold * 100 * 100 + silver * 100 + copper; } } string name = ""; if (ItemName.Text != "") { name = ItemName.Text; ItemName.Text = ""; } else { name = ItemNameComboBox.SelectedItem.ToString(); } int id = 0; foreach (AuctionItem queryitem in AuctionItemsTop) { if (queryitem.Id > id) { id = queryitem.Id; } } name = name.Replace(" ", "_"); AuctionItem newItemEntry = new AuctionItem(); newItemEntry.Id = id + 1; newItemEntry.itemName = name; newItemEntry.BuyoutPrice = Buyout; newItemEntry.BidPrice = Bid; newItemEntry.setTimeStamp(DateTime.Now); if (!Measurment.Items.Contains(name)) { Measurment.Items.Add(name); ItemNameComboBox.Items.Add(name); MeasurementCorection.Items.Add(name); Conversion_BaseItem.Items.Add(name); Conversion_Result_Item.Items.Add(name); Conversion_Correction_BaseItem.Items.Add(name); Conversion_Correction_ResultITem.Items.Add(name); ItemNameComboBox.SelectedIndex = ItemNameComboBox.Items.Count - 1; ItemName.AutoCompleteCustomSource.Add(name); } AuctionItemsTop.Add(newItemEntry); BuyoutinCopper.Text = ""; BidInCopper.Text = ""; }