public static void SaveDeck(int deckId, string deckName, string deckDesc, List<Models.CardItem> cards)
{
DeckDataModel deck = new DeckDataModel()
{
Id = deckId,
DeckName = deckName,
DeckDescription = deckDesc
};
string sqlDeck = @"update dbo.Deck set DeckName = @DeckName, DeckDescription = @DeckDescription where Id = @DeckId;";
int r = SaveData(sqlDeck, deck);
foreach (var card in cards)
{
DeckCardDataModel deckCard = new DeckCardDataModel()
{
DeckId = deckId,
CardId = card.CardID,
CardQuantity = card.Quantity,
CardName = card.Name
};
string sqlCard = @"insert into dbo.DeckCard (DeckId, CardId, CardQuantity, CardName) output INSERTED.Id values (@DeckId, @CardId, @CardQuantity, @CardName);";
int deckCardId = SaveData(sqlCard, deckCard);
}
return;
}
public static int CreateDeck(string deckName, string deckDesc, List<Models.CardItem> cards)
{
DeckDataModel deck = new DeckDataModel()
{
DeckName = deckName,
DeckDescription = deckDesc
};
string sqlDeck = @"insert into dbo.Deck (DeckName, DeckDescription) output INSERTED.Id values (@DeckName, @DeckDescription);";
int deckId = SaveData(sqlDeck, deck, true);
foreach (var card in cards)
{
DeckCardDataModel deckCard = new DeckCardDataModel()
{
DeckId = deckId,
CardId = card.CardID,
CardQuantity = card.Quantity,
CardName = card.Name
};
string sqlCard = @"insert into dbo.DeckCard (DeckId, CardId, CardQuantity, CardName) output INSERTED.Id values (@DeckId, @CardId, @CardQuantity, @CardName);";
int deckCardId = SaveData(sqlCard, deckCard);
}
return deckId;
}
