private void showImage(object sender, MouseEventArgs e) { Label label = sender as Label; Card_listing card = label.DataContext as Card_listing; if (card.MultiverseId != null) { string fullFilePath = @"http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=" + card.MultiverseId + @"&type=card"; BitmapImage bi = new BitmapImage(); bi.BeginInit(); bi.UriSource = new Uri(fullFilePath, UriKind.RelativeOrAbsolute); bi.EndInit(); image.Source = bi; } }
private void removeButton_MouseUp(object sender, MouseButtonEventArgs e) { Viewbox button = sender as Viewbox; Card_listing card = button.DataContext as Card_listing; string cs = ConfigurationManager.ConnectionStrings["magicConnect"].ConnectionString; using (SqlConnection conn = new SqlConnection(@cs)) using (SqlCommand cmd = new SqlCommand("usp_addCardToDeck", conn)) { cmd.CommandType = CommandType.StoredProcedure; conn.Open(); // set up the parameters cmd.Parameters.Add("@deck", SqlDbType.Int); cmd.Parameters.Add("@cardId", SqlDbType.Int); cmd.Parameters.Add("@amount", SqlDbType.Int); cmd.Parameters.Add("@sideboard", SqlDbType.Int); // set parameter values cmd.Parameters["@deck"].Value = card.Deck; cmd.Parameters["@cardId"].Value = card.Id; cmd.Parameters["@amount"].Value = -1; cmd.Parameters["@sideboard"].Value = card.IsSideDeck ? "0" : "1"; try { cmd.ExecuteNonQuery(); } catch (SqlException sqle) { MessageBox.Show(sqle.Message.Split('.')[2], "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } conn.Close(); } showDeck(); }