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