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();
}
