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