protected override void Seed(Photographers.Data.PhotographerContext context) { Photographer teo = new Photographer { Username = "******", Password = "******", Email = "*****@*****.**", BirthDate = DateTime.Now, RegisterDate = DateTime.Now.AddDays(-20) }; context.Photographers .AddOrUpdate(p => p.Username, teo); context.SaveChanges(); Picture demoPicture = new Picture() { Title = "Demo", Caption = "Demo", FileSystemPath = "/public/imags/demo.png" }; context.Pictures.AddOrUpdate(i => i.Title, demoPicture); Album vitosha = new Album() { Name = "Vitosha", BackgroundColor = "Blue", IsPublic = true, //OwnerId = teo.Id }; context.Albums.AddOrUpdate(a => a.Name, vitosha); vitosha.Pictures.Add(demoPicture); context.SaveChanges(); PhotographerAlbum ph = new PhotographerAlbum() { Photographer_Id = teo.Id, Album_Id = vitosha.Id, Role = Role.Viewer }; vitosha.Photographers.Add(ph); context.PhotographerAlbums.Add(ph); Tag mountainTag = new Tag() { Label = "mountain" }; context.Tags.AddOrUpdate(t => t.Label, mountainTag); mountainTag.Albums.Add(vitosha); context.SaveChanges(); }
protected override void Seed(Photographers.Context context) { Photographer a = new Photographer() { Username = "******", Password = "******", Email = "*****@*****.**", Birthdate = new DateTime(2004, 9, 6), RegisterDate = new DateTime(2004, 9, 7) }; context.Photographers.AddOrUpdate(p => p.Username, a); context.SaveChanges(); Picture fdobai = new Picture() { Title = "TukaSamFDobai", Caption = "f Dobai", PathInFileSystem = "asdasd" }; context.Pictures.AddOrUpdate(d => d.Title, fdobai); Album asd = new Album() { Name = "Za Auschwitz", BackgroundColor = "#Ffff", IsPublic = true, }; context.Albums.AddOrUpdate(w => w.Name, asd); context.SaveChanges(); asd.Pictures.Add(fdobai); context.SaveChanges(); PhotographerAlbum ph = new PhotographerAlbum() { Photographer_Id = a.Id, Album_Id = asd.Id, Role = Role.Viewer }; asd.Photographers.Add(ph); context.PhotographerAlbums.Add(ph); Tag ftag = new Tag() { Label = "#asd" }; context.Tags.AddOrUpdate(e => e.Label, ftag); ftag.Albums.Add(asd); context.SaveChanges(); }
public static void Seed(PhotoContext db) { Photographer photographer = new Photographer() { Username = "******", Email = "*****@*****.**", Password = "******", BirthDate = new DateTime(1990, 10, 02), RegisteredDate = new DateTime(2017, 10, 10) }; Photographer photographerTwo = new Photographer() { Username = "******", Email = "*****@*****.**", Password = "******", BirthDate = new DateTime(1989, 09, 02), RegisteredDate = new DateTime(2016, 10, 10) }; Photographer photographerThree = new Photographer() { Username = "******", Email = "*****@*****.**", Password = "******", BirthDate = new DateTime(1977, 09, 02), RegisteredDate = new DateTime(2016, 01, 10) }; Album album = new Album() { BackgroundColor = "Black", IsPublic = true }; Album albumTwo = new Album() { BackgroundColor = "White", IsPublic = false }; PhotographerAlbum photographerAlbum = new PhotographerAlbum() { Album = album, Photographer = photographer }; PhotographerAlbum photographerAlbumTwo = new PhotographerAlbum() { Album = album, Photographer = photographerTwo }; PhotographerAlbum photographerAlbumThree = new PhotographerAlbum() { Album = albumTwo, Photographer = photographerTwo }; PhotographerAlbum photographerAlbumFour = new PhotographerAlbum() { Album = albumTwo, Photographer = photographerThree }; Picture picture = new Picture() { Caption = "Nature", Path = @"C:\Users\Admin\Desktop\Pictures", Title = "SummerView" }; Picture pictureOne = new Picture() { Caption = "Animals", Path = @"C:\Users\Admin\Desktop\Pictures", Title = "Zoo" }; Picture pictureTwo = new Picture() { Caption = "Forest", Path = @"C:\Users\Admin\Desktop\Pictures", Title = "Tree" }; db.PictureAlbums.Add(new PictureAlbum() { Album = album, Picture = picture }); db.PictureAlbums.Add(new PictureAlbum() { Album = album, Picture = pictureOne }); db.PictureAlbums.Add(new PictureAlbum() { Album = albumTwo, Picture = pictureTwo }); db.SaveChanges(); }
protected override void Seed(_5.Photographers.Data.PhotographerContext context) { Photographer teo = new Photographer { Username = "******", Password = "******", Email = "*****@*****.**", BirthDate = DateTime.Now, RegistereDate = DateTime.Now.AddDays(-20) }; Photographer jim = new Photographer { Username = "******", Password = "******", Email = "*****@*****.**", BirthDate = DateTime.Now, RegistereDate = DateTime.Now.AddDays(-20) }; context.Photographers.AddOrUpdate(p => p.Username, teo, jim); var demoPicture = new Picture() { Title = "Demo", Caption = "Demo", FileSystemPath = "../images/demo.png" }; context.Pictures.AddOrUpdate(p => p.Title, demoPicture); var vitosha = new Album() { Name = "Vitosha", BackgroundColor = "Black", IsPublic = true, }; context.Albums.AddOrUpdate(a => a.Name, vitosha); vitosha.Pictures.Add(demoPicture); context.SaveChanges(); PhotographerAlbum ph = new PhotographerAlbum() { Photographer_Id = teo.Id, Album_Id = vitosha.Id, Role = Role.Viewer }; vitosha.Photographers.Add(ph); context.PhotographerAlbums.Add(ph); var mountainTag = new Tag() { Label = "#mountain" }; context.Tags.AddOrUpdate(t => t.Label, mountainTag); mountainTag.Albums.Add(vitosha); context.SaveChanges(); }
protected override void Seed(PhotographersDB.PhotographersDBContext context) { var ph1 = new Photographer() { Username = "******", Password = "******", RegisterDate = new DateTime(2000, 3, 23), BirthDate = new DateTime(1991, 12, 20), Email = "*****@*****.**" }; var ph2 = new Photographer() { Username = "******", Password = "******", RegisterDate = new DateTime(2001, 1, 21), BirthDate = new DateTime(1991, 12, 13), Email = "*****@*****.**" }; var ph3 = new Photographer() { Username = "******", Password = "******", RegisterDate = new DateTime(1989, 11, 25), BirthDate = new DateTime(1991, 12, 23), Email = "*****@*****.**" }; context.Photographers.AddOrUpdate(x => x.Username, ph1); context.SaveChanges(); context.Photographers.AddOrUpdate(x => x.Username, ph2); context.SaveChanges(); context.Photographers.AddOrUpdate(x => x.Username, ph3); context.SaveChanges(); var album1 = new Album() { Name = "Album1", BackgroundColor = "red", IsPublic = true }; var album2 = new Album() { Name = "Album2", BackgroundColor = "blue", IsPublic = true }; var album3 = new Album() { Name = "Album3", BackgroundColor = "orange", IsPublic = true }; var album4 = new Album() { Name = "Album4", BackgroundColor = "green", IsPublic = true }; context.Albums.AddOrUpdate(x => x.Name, album1); context.SaveChanges(); context.Albums.AddOrUpdate(x => x.Name, album2); context.SaveChanges(); context.Albums.AddOrUpdate(x => x.Name, album3); context.SaveChanges(); context.Albums.AddOrUpdate(x => x.Name, album4); context.SaveChanges(); PhotographerAlbum pa1 = new PhotographerAlbum() { Photographer_Id = ph1.Id, Album_Id = album1.Id, Role = Role.Owner }; album1.Photographers.Add(pa1); PhotographerAlbum pa2 = new PhotographerAlbum() { Photographer_Id = ph1.Id, Album_Id = album2.Id, Role = Role.Owner }; album2.Photographers.Add(pa2); PhotographerAlbum pa3 = new PhotographerAlbum() { Photographer_Id = ph2.Id, Album_Id = album3.Id, Role = Role.Owner }; album3.Photographers.Add(pa3); PhotographerAlbum pa4 = new PhotographerAlbum() { Photographer_Id = ph3.Id, Album_Id = album4.Id, Role = Role.Viewer }; album4.Photographers.Add(pa4); var picture1 = new Picture() { Caption = "someCaption1", FilePath = "c:\\Albums1", Title = "BestTitle1" }; var picture2 = new Picture() { Caption = "someCaption2", FilePath = "c:\\Albums2", Title = "BestTitle2" }; var picture3 = new Picture() { Caption = "someCaption3", FilePath = "c:\\Albums3", Title = "BestTitle3" }; context.PhotographerAlbums.Add(pa1); context.PhotographerAlbums.Add(pa2); context.PhotographerAlbums.Add(pa3); context.PhotographerAlbums.Add(pa4); context.Pictures.AddOrUpdate(x => x.Caption, picture1); context.SaveChanges(); context.Pictures.AddOrUpdate(x => x.Caption, picture2); context.SaveChanges(); context.Pictures.AddOrUpdate(x => x.Caption, picture3); context.SaveChanges(); var tag1 = new Tag() { Label = "#blessed" }; context.Tags.AddOrUpdate(x => x.Label, tag1); context.SaveChanges(); var tag2 = new Tag() { Label = "#nofiler" }; context.Tags.AddOrUpdate(x => x.Label, tag2); context.SaveChanges(); var tag3 = new Tag() { Label = "#wokeuplikethis" }; context.Tags.AddOrUpdate(x => x.Label, tag3); context.SaveChanges(); album1.Tags.Add(tag1); album1.Tags.Add(tag2); album2.Tags.Add(tag3); album2.Tags.Add(tag2); album3.Tags.Add(tag1); album4.Tags.Add(tag3); album1.Pictures.Add(picture1); album1.Pictures.Add(picture2); album2.Pictures.Add(picture1); album2.Pictures.Add(picture3); album3.Pictures.Add(picture3); album3.Pictures.Add(picture2); album4.Pictures.Add(picture1); context.SaveChanges(); }
protected override void Seed(PhotographyContext context) { Photographer dragan = new Photographer() { Username = "******", Password = "******", Email = "*****@*****.**", BirthDate = new DateTime(1992, 01, 08), RegisterDate = new DateTime(2010, 10, 10) }; Photographer stamen = new Photographer() { Username = "******", Password = "******", Email = "*****@*****.**", BirthDate = new DateTime(1992, 01, 08), RegisterDate = new DateTime(2010, 10, 10) }; context.Photographers.AddOrUpdate(p => p.Username, dragan, stamen); context.SaveChanges(); Picture picture = new Picture() { Title = "Mountain", Caption = "Peak", PathOnFileSystem = "../pictures/mountains" }; Picture picture2 = new Picture() { Title = "River", Caption = "Water", PathOnFileSystem = "../pictures/rivers" }; context.Pictures.AddOrUpdate(pic => pic.Title, picture, picture2); context.SaveChanges(); Tag tag = new Tag() { Name = "rocks" // Tag name doesn't start with '#' but it's transformed to valid tag with the 'TagTansformer' class; }; Tag tag2 = new Tag() { Name = "# fishes" //Tag name contains white spaces but it's transformed to valid tag with the 'TagTansformer' class; }; List <Tag> tags = new List <Tag>(); tags.Add(tag); tags.Add(tag2); foreach (var currentTag in tags) { currentTag.Name = TagTansformer.Transform(currentTag.Name); } foreach (var currentTag in tags) { context.Tags.AddOrUpdate(t => t.Name, currentTag); } context.SaveChanges(); Album album = new Album() { Name = "Mountains", BackgroundColor = "Green and Brown", IsPublic = true }; Album album2 = new Album() { Name = "Rivers", BackgroundColor = "Green and Blue", IsPublic = true }; context.Albums.AddOrUpdate(a => a.Name, album, album2); context.SaveChanges(); PhotographerAlbum photographerAlbumDragan = new PhotographerAlbum() { Album_Id = album.Id, Photographer_Id = dragan.Id, Role = Role.Owner }; PhotographerAlbum photographerAlbumStamen = new PhotographerAlbum() { Album_Id = album2.Id, Photographer_Id = stamen.Id, Role = Role.Owner }; PhotographerAlbum photographerAlbumDragan2 = new PhotographerAlbum() { Album_Id = album2.Id, Photographer_Id = dragan.Id, Role = Role.Viewer }; PhotographerAlbum photographerAlbumStamen2 = new PhotographerAlbum() { Album_Id = album.Id, Photographer_Id = stamen.Id, Role = Role.Viewer }; // After executing the Seed method: // In the first album Dragan is an owner and Stamen is a viewer; // In the second album Stamen is an owner and Dragan is a viewer; context.PhotographerAlbums.AddOrUpdate(pa => new { pa.Photographer_Id, pa.Album_Id }, photographerAlbumDragan, photographerAlbumStamen, photographerAlbumDragan2, photographerAlbumStamen2); // Album-Pictures many-to-many relationship it's working - table [dbo].[PictureAlbums] it's filling with data; album.Pictures.Add(picture); album2.Pictures.Add(picture2); // Album-Tags many-to-many relationship it's working - table [dbo].[TagAlbums] it's filling with data; album.Tags.Add(tag); album2.Tags.Add(tag2); context.SaveChanges(); }