private static void ClearDbContext(CardHeroDataDbContext context)
{
foreach (var item in context.Card)
{
context.Card.Remove(item);
}
foreach (var item in context.CardCollection)
{
context.CardCollection.Remove(item);
}
foreach (var item in context.CardFavourite)
{
context.CardFavourite.Remove(item);
}
foreach (var item in context.CardPack)
{
context.CardPack.Remove(item);
}
foreach (var item in context.Deck)
{
context.Deck.Remove(item);
}
foreach (var item in context.DeckCardCollection)
{
context.DeckCardCollection.Remove(item);
}
foreach (var item in context.DeckFavourite)
{
context.DeckFavourite.Remove(item);
}
foreach (var item in context.Game)
{
context.Game.Remove(item);
}
foreach (var item in context.GameDeck)
{
context.GameDeck.Remove(item);
}
foreach (var item in context.GameDeckCardCollection)
{
context.GameDeckCardCollection.Remove(item);
}
foreach (var item in context.GameUser)
{
context.GameUser.Remove(item);
}
foreach (var item in context.Move)
{
context.Move.Remove(item);
}
foreach (var item in context.Rarity)
{
context.Rarity.Remove(item);
}
foreach (var item in context.StoreItem)
{
context.StoreItem.Remove(item);
}
foreach (var item in context.Turn)
{
context.Turn.Remove(item);
}
foreach (var item in context.User)
{
context.User.Remove(item);
}
context.SaveChanges();
}
private static void SeedDbContext(CardHeroDataDbContext context)
{
context.Card.Add(new Card
{
CardPackFk = 600,
CardPk = 1,
Name = "First card",
RarityFk = 1,
});
context.Card.Add(new Card
{
CardPackFk = 601,
CardPk = 2,
Name = "Second card",
RarityFk = 2,
});
context.CardCollection.Add(new CardCollection
{
CardCollectionPk = 1,
CardFk = 1,
UserFk = 1,
});
context.CardCollection.Add(new CardCollection
{
CardCollectionPk = 2,
CardFk = 2,
UserFk = 1,
});
context.CardCollection.Add(new CardCollection
{
CardCollectionPk = 3,
CardFk = 1,
UserFk = 2,
});
context.CardPack.Add(new CardPack
{
CardPackPk = 600,
Name = "First pack",
});
context.CardPack.Add(new CardPack
{
CardPackPk = 601,
Name = "Second pack",
});
context.Deck.Add(new Deck
{
DeckPk = 1,
MaxCards = 5,
Name = "First deck",
UserFk = 1,
});
context.Deck.Add(new Deck
{
DeckPk = 2,
MaxCards = 5,
Name = "Second deck",
UserFk = 1,
});
context.Deck.Add(new Deck
{
DeckPk = 3,
MaxCards = 5,
Name = "Third deck",
UserFk = 2
});
context.StoreItem.Add(new StoreItem
{
CardPackFk = 601,
Cost = 100,
ItemCount = 1,
Name = "Valid Bundle",
StoreItemPk = 501,
});
context.StoreItem.Add(new StoreItem
{
Cost = 200,
Expiry = DateTime.UtcNow.AddYears(-1),
ItemCount = 2,
Name = "Expired Bundle",
StoreItemPk = 502,
});
context.StoreItem.Add(new StoreItem
{
Cost = 300,
Expiry = DateTime.UtcNow.AddDays(7),
ItemCount = 3,
Name = "Still Valid Bundle",
StoreItemPk = 503,
});
context.User.Add(new User
{
Coins = 123456,
FullName = "Test user",
Identifier = "abcxyz",
IdPsource = "TestSvr",
UserPk = 1
});
context.User.Add(new User
{
Coins = 0,
FullName = "Inactive user",
Identifier = "_",
IdPsource = "TestSvr",
UserPk = 2
});
context.SaveChanges();
}
