private static void AddMedicEntry(StableContext context)
{
var doc = File.ReadAllBytes("./Resources/dummy.pdf");
var medicEntry = new MedicEntry
{
Report = new MedicReport {
Document = doc
},
HorseID = 1,
IssuedDate = DateTime.Today,
Title = "Very Important Report"
};
context.MedicEntries.Add(medicEntry);
context.SaveChanges();
}
public static void Initialize(StableContext context)
{
context.Database.EnsureCreated();
if (context.Persons.Any())
{
return; // DB has been seeded
}
var roles = new Role[]
{
new Role {
Name = "default"
},
new Role {
Name = "admin"
},
new Role {
Name = "groom"
},
new Role {
Name = "secretary"
},
};
foreach (var role in roles)
{
context.Roles.Add(role);
}
context.SaveChanges();
var persons = new Person[]
{
new Person {
Name = "Martin", Surname = "Pierre"
},
new Person {
Name = "Muller", Surname = "Hans"
},
new Person {
Name = "West", Surname = "Malik"
},
};
foreach (var person in persons)
{
context.Persons.Add(person);
}
context.SaveChanges();
var users = new User[]
{
new User {
Name = "Boss", Surname = "E", UserName = "******", PassHash = "admin", RoleID = 2
},
new User
{
Name = "Secretary", Surname = "F", UserName = "******", PassHash = "secretary", RoleID = 4
},
new User {
Name = "Groom", Surname = "G", UserName = "******", PassHash = "groom", RoleID = 3
},
new User {
Name = "Doe", Surname = "John", UserName = "******", PassHash = "password", RoleID = 1
}
};
foreach (var user in users)
{
context.Users.Add(user);
}
context.SaveChanges();
var stables = new Stable[]
{
new Stable {
BossID = null
},
};
foreach (var stable in stables)
{
context.Stables.Add(stable);
}
context.SaveChanges();
var horses = new Horse[]
{
new Horse {
OwnerID = 1, Name = "Pataclop"
},
new Horse {
Owner = new Person {
Name = "Owner", Surname = "StarPony"
}, Name = "StarPony"
}
};
foreach (var horse in horses)
{
context.Horses.Add(horse);
}
context.SaveChanges();
AddMedicEntry(context);
var stockItems = new StockItem[]
{
new StockItem {
ItemName = "Helmet"
},
new StockItem {
ItemName = "Saddle"
},
new StockItem {
ItemName = "Best Item"
}
};
foreach (var stockItem in stockItems)
{
context.StockItems.Add(stockItem);
}
context.SaveChanges();
var stockEntries = new StockEntry[]
{
new StockEntry {
ItemID = 1, StableID = 1, Quantity = 50
},
new StockEntry {
ItemID = 2, StableID = 1, Quantity = 70
},
};
foreach (var stockEntry in stockEntries)
{
context.StockEntries.Add(stockEntry);
}
context.SaveChanges();
var boxes = new Box[]
{
new Box {
Active = false, StableID = 1
},
new Box {
Active = true, StableID = 1, Occupant = new Horse {
Name = "Clopclopclop", OwnerID = 2
}
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
},
new Box {
Active = false, StableID = 1
}
};
foreach (var box in boxes)
{
context.Boxes.Add(box);
}
context.SaveChanges();
var eventTypes = new EventType[]
{
new EventType {
Label = "Practice"
},
new EventType {
Label = "Race"
},
new EventType {
Label = "Meeting"
},
new EventType {
Label = "Free"
}
};
foreach (var eventType in eventTypes)
{
context.EventTypes.Add(eventType);
}
context.SaveChanges();
var calendars = new Calendar[]
{
new Calendar {
Name = "Staff Planning", StableID = 1
},
new Calendar {
Name = "Public events", StableID = 1
}
};
foreach (var calendar in calendars)
{
context.Calendars.Add(calendar);
}
context.SaveChanges();
}