public void SeedDb(PetShopContext context) { context.Database.EnsureCreated(); string password = "******"; byte[] passwordHashJoe, passwordSaltJoe, passwordHashAnn, passwordSaltAnn; authenticationHelper.CreatePasswordHash(password, out passwordHashJoe, out passwordSaltJoe); authenticationHelper.CreatePasswordHash(password, out passwordHashAnn, out passwordSaltAnn); var user = context.Users.Add(new User() { UserName = "******", PasswordHash = passwordHashJoe, PasswordSalt = passwordSaltJoe, IsAdmin = false }); var user1 = context.Users.Add(new User() { UserName = "******", PasswordHash = passwordHashAnn, PasswordSalt = passwordSaltAnn, IsAdmin = true }); var owner1 = context.Owners.Add(new Owner() { FirstName = "Lady", LastName = "Rainicorn", Address = "Adventure road 104", Email = "*****@*****.**", PhoneNumber = "45634523" }).Entity; var owner2 = context.Owners.Add(new Owner() { FirstName = "Jake", LastName = "Adventure", Address = "Treehouse road 1", Email = "*****@*****.**", PhoneNumber = "44578564" }).Entity; var pet1 = context.Pets.Add(new Pet() { Name = "Finn", PetType = "Human", PreviousOwner = owner2, BirthDate = new DateTime(2000, 5, 23), SoldDate = new DateTime(2002, 9, 2), Price = 100 }).Entity; var pet2 = context.Pets.Add(new Pet() { Name = "Princess Bubblegum", PetType = "cow", PreviousOwner = owner2, BirthDate = new DateTime(2000, 5, 23), SoldDate = new DateTime(2002, 9, 2), Price = 10000 }).Entity; context.SaveChanges(); }
public static void Seed(PetShopContext dbFillContext) { Pet pet1 = new Pet { Birthdate = DateTime.Now, Name = " Trex ", Color = " White ", Price = 10000, Race = "Dog", SoldDate = DateTime.Now, PreviosOwner = " Bente " }; Pet pet2 = new Pet { Birthdate = DateTime.Now, Name = " Rex ", Color = " black ", Price = 5000, Race = "Cat", SoldDate = DateTime.Now, PreviosOwner = " Bodil " }; Pet pet3 = new Pet { Birthdate = DateTime.Now, Name = " Ricko ", Color = " black ", Price = 3000, Race = "Dog", SoldDate = DateTime.Now, PreviosOwner = " Klaus " }; Pet pet4 = new Pet { Birthdate = DateTime.Now, Name = " Teison ", Color = " white ", Price = 7500, Race = " Dog ", SoldDate = DateTime.Now, PreviosOwner = " Camille " }; Pet pet5 = new Pet { Birthdate = DateTime.Now, Name = " Coli ", Color = " White ", Price = 2000, Race = "Goat", SoldDate = DateTime.Now, PreviosOwner = " Bo " }; Pet pet6 = new Pet { Birthdate = DateTime.Now, Name = " Dummi ", Color = " orange ", Price = 1000, Race = " Cat ", SoldDate = DateTime.Now, PreviosOwner = " Katrin " }; dbFillContext.Add(pet1); dbFillContext.Add(pet2); dbFillContext.Add(pet3); dbFillContext.Add(pet4); dbFillContext.Add(pet5); dbFillContext.Add(pet6); Owner owner1 = new Owner { Name = " Karl " }; Owner owner2 = new Owner { Name = " Carg " }; Owner owner3 = new Owner { Name = " Farmand " }; dbFillContext.Add(owner1); dbFillContext.Add(owner2); dbFillContext.Add(owner3); dbFillContext.SaveChanges(); }
public static void Initialize(PetShopContext ctx) { Pet pet1 = new Pet { name = "Felix", type = PetTypes.Cat, birthDate = DateTime.Now, soldDate = DateTime.Now.AddYears(1), color = "Black", price = 275, ownersHistory = new List <PetOwner>() }; Pet pet2 = new Pet { name = "Steggersaurus", type = PetTypes.Dinosaurus, birthDate = DateTime.Now.AddYears(-35), soldDate = DateTime.Now.AddYears(1).AddDays(24), color = "SteggerColor", price = 550, ownersHistory = new List <PetOwner>() }; Pet pet3 = new Pet { name = "Snoopy", type = PetTypes.Dog, birthDate = DateTime.Now.AddYears(-35), soldDate = DateTime.Now.AddYears(1).AddDays(24), color = "White", price = 550, ownersHistory = new List <PetOwner>() }; Owner owner1 = new Owner { firstName = "Post", lastName = "Malone", address = "Melonvej 24", petHistory = new List <PetOwner>() }; Owner owner2 = new Owner { firstName = "Daft", lastName = "Punk", address = "Elektronik Musikvej 1337", petHistory = new List <PetOwner>() }; Owner owner3 = new Owner { firstName = "Chris", lastName = "McDonnel", address = "Tomatvej 40", petHistory = new List <PetOwner>() }; owner1 = ctx.Owners.Add(owner1).Entity; owner2 = ctx.Owners.Add(owner2).Entity; owner3 = ctx.Owners.Add(owner3).Entity; PetOwner PetOwner1 = new PetOwner { Owner = owner1 }; PetOwner PetOwner2 = new PetOwner { Owner = owner2 }; PetOwner PetOwner3 = new PetOwner { Owner = owner1 }; PetOwner PetOwner4 = new PetOwner { Owner = owner3 }; pet1.ownersHistory.Add(PetOwner1); pet1.ownersHistory.Add(PetOwner2); pet2.ownersHistory.Add(PetOwner3); pet3.ownersHistory.Add(PetOwner4); pet1 = ctx.Pets.Add(pet1).Entity; pet2 = ctx.Pets.Add(pet2).Entity; pet3 = ctx.Pets.Add(pet3).Entity; ctx.SaveChanges(); }
public PetSQLRepository(PetShopContext context) { _context = context; }