public async Task <Card> Add(Card newCard)
{
_context.Card.Add(newCard);
await _context.SaveChangesAsync();
return(newCard);
}
public async Task <Archetype> Add(Archetype archetype)
{
await _dbContext.Archetype.AddAsync(archetype);
await _dbContext.SaveChangesAsync();
return(archetype);
}
public async Task <Banlist> Add(Banlist banlist)
{
banlist.Created =
banlist.Updated = DateTime.UtcNow;
_context.Banlist.Add(banlist);
await _context.SaveChangesAsync();
return(banlist);
}
public async Task <IEnumerable <ArchetypeCard> > Update(long archetypeId, IEnumerable <string> cards)
{
var archetypeCards = await _dbContext.ArchetypeCard.Where(ac => ac.ArchetypeId == archetypeId).ToArrayAsync();
if (archetypeCards.Any())
{
_dbContext.ArchetypeCard.RemoveRange(archetypeCards);
await _dbContext.SaveChangesAsync();
}
var tvp = new TableValuedParameterBuilder
(
"tvp_ArchetypeCardsByCardName",
new SqlMetaData("ArchetypeId", SqlDbType.BigInt), new SqlMetaData("CardName", SqlDbType.NVarChar, 255)
);
foreach (var card in cards)
{
tvp.AddRow(archetypeId, card);
}
var cardsParameter = tvp.CreateParameter("@TvpArchetypeCards");
return(await _dbContext
.ArchetypeCard
.FromSql("EXECUTE usp_AddCardsToArchetype @TvpArchetypeCards", cardsParameter)
.ToListAsync());
}
public async Task <ICollection <BanlistCard> > Update(long banlistId, IList <BanlistCard> banlistCards)
{
var existingBanlistCards = _context.BanlistCard.Select(bl => bl).Where(bl => bl.BanlistId == banlistId).ToList();
if (existingBanlistCards.Any())
{
_context.BanlistCard.RemoveRange(existingBanlistCards);
await _context.SaveChangesAsync();
}
await _context.BanlistCard.AddRangeAsync(banlistCards);
await _context.SaveChangesAsync();
return(banlistCards);
}
public async Task DeleteByCardId(long cardId)
{
var rulingSections = await _context
.RulingSection
.Include(t => t.Card)
.Include(t => t.Ruling)
.Where(ts => ts.CardId == cardId)
.ToListAsync();
if (rulingSections.Any())
{
_context.Ruling.RemoveRange(rulingSections.SelectMany(t => t.Ruling));
_context.RulingSection.RemoveRange(rulingSections);
await _context.SaveChangesAsync();
}
}
public async Task <Category> Add(Category category)
{
await _dbContext.Category.AddAsync(category);
await _dbContext.SaveChangesAsync();
return(category);
}
