private void SeedComments(ApartmentReservationDbContext context) { var comments = new[] { new Comment() { Apartment = Apartments[0], Guest = Guests[0], Approved = true, Rating = 4, Text = "Had fun, enjoyable experience. Neighbours were kinda anoying tho." }, new Comment() { Apartment = Apartments[0], Guest = Guests[1], Approved = false, Rating = 1, Text = "Bad experience! Would not recommend to anybody!" } }; context.Comments.AddRange(comments); context.SaveChanges(); }
private void SeedGuests(ApartmentReservationDbContext context) { this.Guests = new[] { new Guest() { User = new User() { Username = "******", Password = "******", FirstName = "Dio", LastName = "Brando", Gender = Genders.Other, RoleName = RoleNames.Guest } }, new Guest() { User = new User() { Username = "******", Password = "******", FirstName = "Joseph", LastName = "Joester", Gender = Genders.Male, RoleName = RoleNames.Guest } } }; context.Guests.AddRange(this.Guests); context.SaveChanges(); }
private void SeedHosts(ApartmentReservationDbContext context) { this.Host = context.Add(new Host() { User = new User() { Username = "******", Password = "******", FirstName = "Enyaba", LastName = "Geil", Gender = Genders.Female, RoleName = RoleNames.Host } }).Entity; context.SaveChanges(); }
private void SeedAdministrators(ApartmentReservationDbContext context) { this.Admin = context.Add(new Administrator() { User = new User() { Username = "******", Password = "******", FirstName = "Jotaro", LastName = "Kujo", Gender = Genders.Male, RoleName = RoleNames.Administrator } }).Entity; context.SaveChanges(); }
private void SeedForRentalDates(ApartmentReservationDbContext context) { var days = DateTimeHelpers.GetDateDayRange(this.MinDate, this.MaxDate); context.ForRentalDates.AddRange(days.Select(d => new ForRentalDate() { Apartment = this.Apartments[0], Date = d }).ToArray()); context.ForRentalDates.AddRange(days.Select(d => new ForRentalDate() { Apartment = this.Apartments[1], Date = d }).ToArray()); context.ForRentalDates.AddRange(days.Select(d => new ForRentalDate() { Apartment = this.Apartments[2], Date = d }).ToArray()); context.SaveChanges(); }
private void SeedImages(ApartmentReservationDbContext context) { string[] imgUris = new[] { "https://www.onni.com/wp-content/uploads/2016/11/Rental-Apartment-Page-new-min.jpg", "https://arystudios.files.wordpress.com/2015/08/3dcontemperoryapartmentrenderingarchitecturalduskviewrealisticarystudios.jpg", "https://www.travelonline.com/melbourne/city-cbd/accommodation/adina-apartment-hotel-melbourne-flinders-street/penthouse-76880.jpg", "./images/apartment_1_pond_chair_stunning.JPG", "./images/apartment_1_pond_flowers.JPG", "./images/apartment_1_pond_view_from_bed.JPG" }; this.Images = new[] { new Image() { Apartment = this.Apartments[0], ImageUri = imgUris[0] }, new Image() { Apartment = this.Apartments[0], ImageUri = imgUris[1] }, new Image() { Apartment = this.Apartments[2], ImageUri = imgUris[2] }, new Image() { Apartment = this.Apartments[1], ImageUri = imgUris[3] }, new Image() { Apartment = this.Apartments[1], ImageUri = imgUris[4] }, new Image() { Apartment = this.Apartments[1], ImageUri = imgUris[5] } }; context.Images.AddRange(this.Images); context.SaveChanges(); }
protected void SeedEverything(ApartmentReservationDbContext context) { context.Database.Migrate(); if (context.Administrators.Any()) { return; } this.SeedAdministrators(context); this.SeedHosts(context); this.SeedGuests(context); this.SeedAmenities(context); this.SeedApartments(context); this.SeedApartmentAmenities(context); this.SeedImages(context); this.SeedForRentalDates(context); this.SeedReservations(context); this.SeedComments(context); }
private void SeedApartmentAmenities(ApartmentReservationDbContext context) { var apartmentAmenities = new[] { new ApartmentAmenity() { Apartment = Apartments[0], Amenity = Amenities[0] }, new ApartmentAmenity() { Apartment = Apartments[0], Amenity = Amenities[1] }, new ApartmentAmenity() { Apartment = Apartments[0], Amenity = Amenities[2] }, new ApartmentAmenity() { Apartment = Apartments[0], Amenity = Amenities[3] }, new ApartmentAmenity() { Apartment = Apartments[0], Amenity = Amenities[4] }, new ApartmentAmenity() { Apartment = Apartments[1], Amenity = Amenities[2] }, new ApartmentAmenity() { Apartment = Apartments[1], Amenity = Amenities[3] }, new ApartmentAmenity() { Apartment = Apartments[1], Amenity = Amenities[4] } }; context.ApartmentAmenities.AddRange(apartmentAmenities); context.SaveChanges(); }
private void SeedAmenities(ApartmentReservationDbContext context) { this.Amenities = new[] { new Amenity() { Name = "TV" }, new Amenity() { Name = "Kitchen" }, new Amenity() { Name = "High chair" }, new Amenity() { Name = "Air conditioning" }, new Amenity() { Name = "Heating" }, new Amenity() { Name = "Wifi" }, new Amenity() { Name = "Refrigerator" }, new Amenity() { Name = "Microwave" } }; context.Amenities.AddRange(this.Amenities); context.SaveChanges(); }
public static void Initialize(ApartmentReservationDbContext context) { var initializer = new ApartmentReservationInitializer(); initializer.SeedEverything(context); }
private void SeedReservations(ApartmentReservationDbContext context) { this.Reservations = new[] { new Reservation() { Apartment = this.Apartments[0], Guest = this.Guests[0], ReservationStartDate = MinDate, NumberOfNightsRented = 3, ReservationState = ReservationStates.Accepted, TotalCost = 3 * this.Apartments[0].PricePerNight }, new Reservation() { Apartment = this.Apartments[0], Guest = this.Guests[0], ReservationStartDate = this.MinDate.AddDays(4), NumberOfNightsRented = 1, ReservationState = ReservationStates.Completed, TotalCost = 1 * this.Apartments[0].PricePerNight }, new Reservation() { Apartment = this.Apartments[0], Guest = this.Guests[0], ReservationStartDate = MinDate, NumberOfNightsRented = 2, ReservationState = ReservationStates.Withdrawn, TotalCost = 2 * this.Apartments[0].PricePerNight }, new Reservation() { Apartment = this.Apartments[0], Guest = this.Guests[1], ReservationStartDate = this.MinDate.AddDays(8), NumberOfNightsRented = 2, ReservationState = ReservationStates.Created, TotalCost = 2 * this.Apartments[0].PricePerNight }, new Reservation() { Apartment = this.Apartments[1], Guest = this.Guests[0], ReservationStartDate = MinDate, NumberOfNightsRented = 3, ReservationState = ReservationStates.Denied, TotalCost = 3 * this.Apartments[1].PricePerNight }, new Reservation() { Apartment = this.Apartments[0], Guest = this.Guests[1], ReservationStartDate = MinDate, NumberOfNightsRented = 3, ReservationState = ReservationStates.Denied, TotalCost = 3 * this.Apartments[0].PricePerNight } }; context.Reservations.AddRange(this.Reservations); context.SaveChanges(); }
private void SeedApartments(ApartmentReservationDbContext context) { this.Apartments = new[] { new Apartment() { Host = this.Host, ActivityState = ActivityStates.Active, ApartmentType = ApartmentTypes.Full, CheckInTime = "14:00:00", CheckOutTime = "10:00:00", NumberOfGuests = 3, NumberOfRooms = 4, PricePerNight = 83, Title = "Great apartment, affordable", Location = new Location() { Latitude = 45.2615316, Longitude = 19.8347492, Address = new Address() { CityName = "Нови Сад", CountryName = "RS", PostalCode = "21101", StreetName = "Булевар краља Петра I", StreetNumber = "12" } } }, new Apartment() { Host = this.Host, ActivityState = ActivityStates.Active, ApartmentType = ApartmentTypes.SingleRoom, CheckInTime = "14:00:00", CheckOutTime = "10:00:00", NumberOfGuests = 1, NumberOfRooms = 1, PricePerNight = 37, Title = "The Pondhouse - A Magical Place", Location = new Location() { Latitude = 48.865425, Longitude = 2.3800042, Address = new Address() { CityName = "Париз", CountryName = "FR", PostalCode = "75011", StreetName = "Rue Dranem", StreetNumber = "2" } } }, new Apartment() { Host = this.Host, ActivityState = ActivityStates.Inactive, ApartmentType = ApartmentTypes.Full, CheckInTime = "14:00:00", CheckOutTime = "10:00:00", NumberOfGuests = 4, NumberOfRooms = 3, PricePerNight = 54, Title = "Good location, nice view.", Location = new Location() { Latitude = 45.2517311, Longitude = 19.8362212, Address = new Address() { CityName = "Нови Сад", CountryName = "RS", PostalCode = "21101", StreetName = "Футошка", StreetNumber = "8a" } } }, }; context.Apartments.AddRange(this.Apartments); context.SaveChanges(); }