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 UserModel GetByName(string username)
{
using (var context = new MdoDbContext())
{
var user = context.Users.FirstOrDefault(x => x.Username == username);
return new UserAdapter(user).UserModel;
}
}
public UserModel GetUser(int id)
{
using (var context = new MdoDbContext())
{
var user = context.Users.Find(id);
return new UserAdapter(user).UserModel;
}
}
public void UpdateUser(UserModel user)
{
using (var context = new MdoDbContext())
{
context.Users.AddOrUpdate(new UserAdapter(user).UserEntity);
context.SaveChanges();
}
}
public UserModel GetByEmail(string email)
{
using (var context = new MdoDbContext())
{
var user = context.Users.FirstOrDefault(x => x.Email == email);
return new UserAdapter(user).UserModel;
}
}
public IEnumerable<CardEntity> GetCards()
{
using (var context = new MdoDbContext())
{
var cards = context.Cards;
return cards.ToList();
}
}
public void ProcessImageLabel(string cardName, string existingImageUri, string destinationLabelUri, int yoffset)
{
using (var context = new MdoDbContext())
{
var card = context.Cards.First(x => x.Name == cardName);
if (!string.IsNullOrEmpty(card.ImagePath))
{
CardImaging.ExtractLabel(existingImageUri, destinationLabelUri, yoffset);
}
}
}
public IEnumerable<ExpansionModel> GetExpansions()
{
using (var context = new MdoDbContext())
{
var expansions = context.Expansions;
var list = new List<ExpansionModel>();
foreach (var expansion in expansions)
{
list.Add(new ExpansionAdapter(expansion).ExpansionModel);
}
return list;
}
}
public CardEntity GetCard(string name)
{
using (var context = new MdoDbContext())
{
var card = context.Cards
.Include(ex => ex.Expansion)
.Include(ta => ta.Tags)
.Include(ty => ty.Types)
.First(x => x.Name == name);
return card;
}
}
public IEnumerable<CardDto> GetCardsToDisplay()
{
using (var context = new MdoDbContext())
{
var viewCards = context.Cards.Select(x => new CardDto
{
Name = x.Name,
Types = x.Types.Select(t => t.Name),
ImagePath = x.ImagePath,
LabelPath = x.LabelPath
});
return viewCards.ToList();
}
}
private void AddRolesToUsers(MdoDbContext context)
{
var std = context.Roles.First(x => x.Name == RoleNames.Std);
var admin = context.Roles.First(x => x.Name == RoleNames.Admin);
var mod = context.Roles.First(x => x.Name == RoleNames.Mod);
var wes = context.Users.First(x => x.Username == "wes");
var zxx = context.Users.First(x => x.Username == "zxx");
var zcc = context.Users.First(x => x.Username == "zcc");
wes.Roles = new List<RoleEntity> { std, admin, mod };
zxx.Roles = new List<RoleEntity> { std };
zcc.Roles = new List<RoleEntity> { admin };
}
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();
}
}
}
private void AddRolesToUsers(MdoDbContext context)
{
var std = context.Roles.First(x => x.Name == RoleNames.Std);
var admin = context.Roles.First(x => x.Name == RoleNames.Admin);
var mod = context.Roles.First(x => x.Name == RoleNames.Mod);
var wes = context.Users.First(x => x.Username == "wes");
var zxx = context.Users.First(x => x.Username == "zxx");
var zcc = context.Users.First(x => x.Username == "zcc");
wes.Roles = new List <RoleEntity> {
std, admin, mod
};
zxx.Roles = new List <RoleEntity> {
std
};
zcc.Roles = new List <RoleEntity> {
admin
};
}
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();
}
private void AddExpansionsToCards(MdoDbContext context)
{
}
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();
}
}
}
private void AddExpansionsToCards(MdoDbContext context)
{
}
