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;
}
public static Tuple<DeckDataModel, List<DeckCardDataModel>> LoadDeck(int deckId)
{
string sqlDeck = $"SELECT * FROM dbo.Deck WHERE Id = {deckId}";
DeckDataModel deck = LoadData<DeckDataModel>(sqlDeck).FirstOrDefault();
string sqlCards = $"SELECT * FROM dbo.DeckCard WHERE DeckId = {deckId}";
List<DeckCardDataModel> cards = LoadData<DeckCardDataModel>(sqlCards);
return new Tuple<DeckDataModel, List<DeckCardDataModel>>(deck, cards);
}
