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 loseButton(object sender, RoutedEventArgs e)
{
if (decks.SelectedIndex == -1)
{
return;
}
DatabaseControl.ExecuteNonQuerryCommand("Exec usp_addWin " + ((DeckListing)decks.SelectedItem).DeckID + ", " + this.deck_id);
setWinsOrLossesLists();
}
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);
//}
}
private void star_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
int ratingToGive = int.Parse(((Image)sender).Name.Substring(4)) + 1;
string cs = ConfigurationManager.ConnectionStrings["magicConnect"].ConnectionString;
using (SqlConnection conn = new SqlConnection(@cs))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("usp_RatedBySelect", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
// set up the parameters
cmd.Parameters.Add("@deck", SqlDbType.Int);
cmd.Parameters.Add("@user", SqlDbType.VarChar, 255);
// set parameter values
cmd.Parameters["@deck"].Value = deck_id;
cmd.Parameters["@user"].Value = App.User;
try
{
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
string userRating = dr["rating"].ToString();
if (int.Parse(userRating) != ratingToGive)
{
MessageBoxResult result = MessageBox.Show("Previously you rated this deck with " + int.Parse(userRating) + " stars. Are you sure you wanna rate this deck with " + ratingToGive + " stars?", "Rating", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
DatabaseControl.ExecuteNonQuerryCommand("EXEC usp_rate '" + App.User + "', " + deck_id + ", " + ratingToGive);
}
}
dr.Close();
}
catch (InvalidOperationException io)
{
Console.WriteLine(io);
DatabaseControl.ExecuteNonQuerryCommand("EXEC usp_rate '" + App.User + "', " + deck_id + ", " + ratingToGive);
MessageBox.Show("You gave this deck " + ratingToGive + " stars.", "Rating", MessageBoxButton.OK, MessageBoxImage.Information);
}
setCurrentRating();
}
}
}
private void removeCardSell(object sender, RoutedEventArgs e)
{
if (listBox_cardsInListingSelling.SelectedIndex == -1)
{
return;
}
try
{
Listing listing = ((Listing)listBox_myS.SelectedItem);
CardInListing cardListing = ((CardInListing)listBox_cardsInListingSelling.SelectedItem);
DatabaseControl.ExecuteNonQuerryCommand("EXEC usp_rmCardToListing " + listing.Id + ", " + cardListing.Card + ", " + cardListing.Priceperunit + ", '" + cardListing.Condition + "'");
}
catch (SqlException sqlE) { Console.Write("" + sqlE); }
updateCardsList();
updateVisual();
}
private void addCardSell(object sender, RoutedEventArgs e)
{
if (listBox_cards.SelectedIndex == -1 || listBox_myS.SelectedIndex == -1)
{
return;
}
int index1 = listBox_cards.SelectedIndex, index2 = listBox_myS.SelectedIndex;
try
{
DatabaseControl.ExecuteNonQuerryCommand("EXEC usp_addCardToListing " + ((Listing)listBox_myS.SelectedItem).Id + ", " + ((Card2)listBox_cards.SelectedItem).Id + ", " + price.Text + ", '" + condition.Text + "'");
}catch (SqlException sqlE) { Console.Write("" + sqlE); }
updateCardsList();
updateVisual();
listBox_cards.SelectedIndex = index1;
listBox_myS.SelectedIndex = index2;
}
public void insertListing(bool sell)
{
DatabaseControl.ExecuteNonQuerryCommand("EXEC usp_ListingInsert '" + App.User + "', null, " + (sell ? 1 : 0));
updateVisual();
}
