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(); } } }