private void setWinsOrLossesLists()
{
ObservableCollection <DeckListing> winsList = new ObservableCollection <DeckListing>();
ObservableCollection <DeckListing> lossesList = new ObservableCollection <DeckListing>();
ObservableCollection <DeckListing> decksL = new ObservableCollection <DeckListing>();
SqlDataReader dr = DatabaseControl.getDataReader("EXEC usp_getWins " + this.deck_id);
while (dr.Read())
{
winsList.Add(new DeckListing {
DeckID = int.Parse(dr["ID"].ToString()), DeckName = dr["Name"].ToString(), WinsOrLosses = int.Parse(dr["Amount"].ToString())
});
}
dr = DatabaseControl.getDataReader("EXEC usp_getLosses " + this.deck_id);
while (dr.Read())
{
lossesList.Add(new DeckListing {
DeckID = int.Parse(dr["ID"].ToString()), DeckName = dr["Name"].ToString(), WinsOrLosses = int.Parse(dr["Amount"].ToString())
});
}
dr = DatabaseControl.getDataReader("EXEC usp_DeckSelect " + "null");
while (dr.Read())
{
decksL.Add(new DeckListing {
DeckID = int.Parse(dr["ID"].ToString()), DeckName = dr["Name"].ToString()
});
}
wins.ItemsSource = winsList;
losses.ItemsSource = lossesList;
decks.ItemsSource = decksL;
}
private void updateCardsList()
{
//try
//{
if (listBox_myS.SelectedIndex != -1)
{
SqlDataReader dr = DatabaseControl.getDataReader("SELECT * FROM udf_cardInListing(" + ((Listing)listBox_myS.SelectedItem).Id + ")");
ObservableCollection <CardInListing> cardsInListing = new ObservableCollection <CardInListing>();
while (dr.Read())
{
cardsInListing.Add(new CardInListing {
Id = int.Parse(dr["ID"].ToString()), Listingid = int.Parse(dr["Listing"].ToString()), Card = int.Parse(dr["cardID"].ToString()), Cardname = dr["name"].ToString(), Priceperunit = double.Parse(dr["Price_Per_Unit"].ToString()), Condition = dr["Condition"].ToString(), Units = int.Parse(dr["Units"].ToString())
});
}
listBox_cardsInListingSelling.ItemsSource = cardsInListing;
dr = DatabaseControl.getDataReader("SELECT * FROM udf_cardInListingHistory(" + ((Listing)listBox_myS.SelectedItem).Id + ")");
ObservableCollection <CardInListing> cardsInListingBought = new ObservableCollection <CardInListing>();
while (dr.Read())
{
cardsInListingBought.Add(new CardInListing {
Id = int.Parse(dr["ID"].ToString()), Listingid = int.Parse(dr["Listing"].ToString()), Card = int.Parse(dr["cardID"].ToString()), Cardname = dr["name"].ToString(), Priceperunit = double.Parse(dr["Price_Per_Unit"].ToString()), Condition = dr["Condition"].ToString(), Units = int.Parse(dr["Units"].ToString())
});
}
listBox_cardsInListingSold.ItemsSource = cardsInListingBought;
}
if (listBox_myB.SelectedIndex != -1)
{
SqlDataReader dr = DatabaseControl.getDataReader("SELECT * FROM udf_cardInListing(" + ((Listing)listBox_myB.SelectedItem).Id + ")");
ObservableCollection <CardInListing> cardsInListing = new ObservableCollection <CardInListing>();
while (dr.Read())
{
cardsInListing.Add(new CardInListing {
Id = int.Parse(dr["ID"].ToString()), Listingid = int.Parse(dr["Listing"].ToString()), Card = int.Parse(dr["cardID"].ToString()), Cardname = dr["name"].ToString(), Priceperunit = double.Parse(dr["Price_Per_Unit"].ToString()), Condition = dr["Condition"].ToString(), Units = int.Parse(dr["Units"].ToString())
});
}
listBox_cardsInListingBuy.ItemsSource = cardsInListing;
dr = DatabaseControl.getDataReader("SELECT * FROM udf_cardInListingHistory(" + ((Listing)listBox_myB.SelectedItem).Id + ")");
ObservableCollection <CardInListing> cardsInListingBought = new ObservableCollection <CardInListing>();
while (dr.Read())
{
cardsInListingBought.Add(new CardInListing {
Id = int.Parse(dr["ID"].ToString()), Listingid = int.Parse(dr["Listing"].ToString()), Card = int.Parse(dr["cardID"].ToString()), Cardname = dr["name"].ToString(), Priceperunit = double.Parse(dr["Price_Per_Unit"].ToString()), Condition = dr["Condition"].ToString(), Units = int.Parse(dr["Units"].ToString())
});
}
listBox_cardsInListingBuySold.ItemsSource = cardsInListingBought;
}
//}
//catch (SqlException sql) {
// Console.WriteLine(sql);
//}
}