public void Migrate(DougContext db) { var lines = File.ReadLines("droptables.csv").ToList(); lines.RemoveAt(0); foreach (var line in lines) { var values = Split(line); var existingTable = db.Droptables.Include(t => t.Items).SingleOrDefault(table => table.Id == values[0]); if (existingTable != null) { if (existingTable.Items.Any(itm => itm.Id == values[1])) { continue; } existingTable.Items.Add(new LootItem(values[1], int.Parse(values[2]), double.Parse(values[3]))); } else { var droptable = new DropTable() { Id = values[0] }; droptable.Items.Add(new LootItem(values[1], int.Parse(values[2]), double.Parse(values[3]))); db.Droptables.Add(droptable); } db.SaveChanges(); } }
private static void AddCreditsToRuler(DougContext db) { var government = db.Government.Single(); var ruler = db.Users.Single(usr => usr.Id == government.Ruler); ruler.Credits += 200; }
public void Migrate(DougContext db) { var lines = File.ReadLines("items.csv").ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity); foreach (var item in items) { if (!db.Items.Any(itm => itm.Id == item.Id)) { db.Items.Add(item); } } db.SaveChanges(); }
public void Migrate(DougContext db) { var lines = File.ReadLines("monsters.csv").Where(line => line[0] != ',').ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity); foreach (var item in items) { if (!db.Monsters.Any(itm => itm.Id == item.Id)) { db.Monsters.Add(item); } else { db.Entry(db.Monsters.Find(item.Id)).CurrentValues.SetValues(item); } } db.SaveChanges(); }
public void Migrate(DougContext db, string path) { var lines = File.ReadLines(path).ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity); foreach (var item in items) { if (!db.Items.Any(itm => itm.Id == item.Id)) { db.Items.Add(item); } else { db.Entry(db.Items.Find(item.Id)).CurrentValues.SetValues(item); } } db.SaveChanges(); }
public void Migrate(DougContext db) { var lines = File.ReadLines("shops.csv").ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity).ToList(); var shops = db.Shops.Include(shp => shp.ShopItems).ToList(); foreach (var shop in shops) { var shopItems = items.Where(itm => itm.ShopId == shop.Id).ToList(); if (!shopItems.Any()) { continue; } shop.ShopItems = shopItems; } db.SaveChanges(); }
public CreditsRepository(DougContext db) { _db = db; }
public EquipmentRepository(DougContext dougContext) { _db = dougContext; }
public PartyRepository(DougContext db) { _db = db; }
public ItemRepository(DougContext db) { _db = db; }
public EffectRepository(DougContext db) { _db = db; }
public SpawnedMonsterRepository(DougContext db) { _db = db; }
public SlurRepository(DougContext dougContext) { _db = dougContext; }
public Authentication(DougContext db, ISlackWebApi slack) { _db = db; _slack = slack; }
public EquipmentRepository(DougContext dougContext, IItemFactory itemFactory) { _db = dougContext; _itemFactory = itemFactory; }
public UserRepository(DougContext dougContext) { _db = dougContext; }
public MonsterRepository(DougContext db) { _db = db; }
public MonsterRepository(DougContext db, IMonsterFactory monsterFactory) { _db = db; _monsterFactory = monsterFactory; }
public GovernmentRepository(DougContext db) { _db = db; }
public CoffeeRepository(DougContext dougContext) { _db = dougContext; }
public UserRepository(DougContext dougContext, IItemFactory itemFactory, IEffectFactory effectFactory) { _db = dougContext; _itemFactory = itemFactory; _effectFactory = effectFactory; }
public ShopRepository(DougContext db) { _db = db; }
private static void ResetRecentSlurs(DougContext db) { db.RecentSlurs.RemoveRange(db.RecentSlurs); }
public RecipeRepository(DougContext db) { _db = db; }
public CoffeeRepository(DougContext dougContext, IItemFactory itemFactory) { _db = dougContext; _itemFactory = itemFactory; }
public UserRepository(DougContext dougContext, IEquipmentEffectFactory equipmentEffectFactory, IEffectFactory effectFactory) { _db = dougContext; _equipmentEffectFactory = equipmentEffectFactory; _effectFactory = effectFactory; }
public StatsRepository(DougContext dougContext) { _db = dougContext; }
public InventoryRepository(DougContext dougContext) { _db = dougContext; }
public ChannelRepository(DougContext dougContext) { _db = dougContext; }
public CoffeeRepository(DougContext dougContext, IEquipmentEffectFactory equipmentEffectFactory) { _db = dougContext; _equipmentEffectFactory = equipmentEffectFactory; }