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 = "";
}
