public void Seed(MdoDbContext context)
{
// independent tables
foreach (var role in Roles)
{
context.Roles.AddOrUpdate(role);
}
foreach (var expansion in Expansions)
{
context.Expansions.AddOrUpdate(expansion);
}
context.SaveChanges();
// dependent tables
foreach (var user in Users)
{
context.Users.AddOrUpdate(x => new { x.Username, x.Email }, user);
}
foreach (var card in Cards)
{
context.Cards.AddOrUpdate(card);
}
context.SaveChanges();
// relations
AddRolesToUsers(context);
context.SaveChanges();
}
public void UpdateUser(UserModel user)
{
using (var context = new MdoDbContext())
{
context.Users.AddOrUpdate(new UserAdapter(user).UserEntity);
context.SaveChanges();
}
}
public void Seed(MdoDbContext context)
{
// independent tables
foreach (var role in Roles)
context.Roles.AddOrUpdate(role);
foreach (var expansion in Expansions)
context.Expansions.AddOrUpdate(expansion);
context.SaveChanges();
// dependent tables
foreach (var user in Users)
context.Users.AddOrUpdate(x => new { x.Username, x.Email }, user);
foreach (var card in Cards)
context.Cards.AddOrUpdate(card);
context.SaveChanges();
// relations
AddRolesToUsers(context);
context.SaveChanges();
}
public void FetchCardImage(string cardName, string url)
{
var savePath = CardImaging.FetchImage(url, cardName);
if (string.IsNullOrEmpty(savePath))
{
return;
}
using (var context = new MdoDbContext())
{
var card = context.Cards.First(x => x.Name == cardName);
if (card != null)
{
card.ImagePath = savePath;
context.SaveChanges();
}
}
}
public void SaveScrapedCards(IEnumerable<ScrappedCardModel> scrappedCards)
{
using (var context = new MdoDbContext())
{
foreach (var scrappedCard in scrappedCards)
{
if (context.Cards.Any(x => x.Name == scrappedCard.CardName))
{
continue;
}
// TODO: exp not found do not save
var expansion = context.Expansions.First(x => x.Name.Equals(scrappedCard.Expansion, StringComparison.InvariantCultureIgnoreCase));
var types = new List<TypeEntity>();
var tags = new List<TagEntity>();
foreach (var type in scrappedCard.Types)
{
if (!context.Types.Any(x => x.Name == type))
{
context.Types.Add(new TypeEntity {Name = type});
context.SaveChanges();
}
types.Add(context.Types.First(x => x.Name == type));
}
foreach (var tag in scrappedCard.Tags)
{
if (!context.Tags.Any(x => x.Name == tag))
{
context.Tags.Add(new TagEntity { Name = tag });
context.SaveChanges();
}
tags.Add(context.Tags.First(x => x.Name == tag));
}
context.Cards.Add(new CardEntity
{
Name = scrappedCard.CardName,
Types = types,
Tags = tags,
ImagePath = scrappedCard.ImageUrl,
LabelPath = scrappedCard.ImageLabel,
RedMana = scrappedCard.RedMana,
BlackMana = scrappedCard.BlackMana,
BlueMana = scrappedCard.BlueMana,
Expansion = expansion,
ColorlessMana = scrappedCard.ColorlessMana,
ConvertedManaCost = scrappedCard.ConvertedManaCost,
Loyalty = scrappedCard.Loyalty,
Description = scrappedCard.CardText,
Flavor = scrappedCard.FlavorText,
GreenMana = scrappedCard.GreenMana,
CreaturePower = scrappedCard.Power,
Rarity = scrappedCard.Rarity,
Thoughnes = scrappedCard.Thoughness,
WhiteMana = scrappedCard.WhiteMana
});
context.SaveChanges();
}
}
}
