public void Init() { Cleanup(); using (var dataContext = new HotelContext()) { var amsterdam = new City {Name = Amsterdam}; var h1 = new Hotel { City = amsterdam, Name = "F1 Hotels" }; var h2 = new Hotel { City = amsterdam, Name = "Dam Hotel" }; dataContext.Hotels.Add(h1); dataContext.Hotels.Add(h2); dataContext.SaveChanges(); } }
public void SearchForHotelsInAmsterdam() { using (var dataContext = new HotelContext()) { var hotelRepository = new Repository<Hotel>(dataContext); IEnumerable<Hotel> hotels = hotelRepository .SearchFor(h => h.City.Name == Amsterdam); foreach (Hotel hotel in hotels) { Assert.AreEqual(Amsterdam, hotel.City.Name); Debug.WriteLine(hotel.Name); } } }
public void Cleanup() { using (var dataContext = new HotelContext()) { IQueryable<Hotel> hotels = dataContext.Hotels.Select(h => h); IQueryable<City> cities = dataContext.Cities.Select(c => c); foreach (City city in cities) { dataContext.Cities.Remove(city); } foreach (Hotel hotel in hotels) { dataContext.Hotels.Remove(hotel); } dataContext.SaveChanges(); } }
public BookingsController(HotelContext context) { hotelContext = context; }
public FacturaController(HotelContext context) { _context = context; }
public RoomRepository(HotelContext db) { this.db = db; }
public FacilityRepository(HotelContext context) { Database = context; }
public BookingController(HotelContext context) { _context = context; }
public EmployerRepository(HotelContext context) : base(context) { }
public HotelRepository(HotelContext context) { _context = context; }
public AddClientCommand(HotelContext context) => Context = context;
public ServicesController(HotelContext context) { _context = context; }
public RoomDAO(HotelContext db) : base(db) { }
public BookingRepository(HotelContext context) { Database = context; }
public UserController(HotelContext context) { db = context; }
public VisitorService(HotelContext hotelContext) { _hotelContext = hotelContext; }
public UserRepository(HotelContext context) { this.context = context; }
static void Main() { HotelContext context = new HotelContext(); }
public HotelRepository(HotelContext context) : base(context) { }
public HeartbeatsController(HotelContext hotelContext, Parser parser) { _parser = parser; _heartbeatDbManager = new HeartbeatDbManager(hotelContext); }
public ServiceRepository(HotelContext context) : base(context) { }
public GuestController(HotelContext context) { _context = context; }
public ContractRepository(HotelContext context) : base(context) { }
public BookingRepository(HotelContext ctx) : base(ctx) { }
public ReserveController(HotelContext context) { _context = context; }
public PaymentController(HotelContext context) { _context = context; }
public TestRepository(HotelContext context) { _context = context; }
public BookingRepository(HotelContext db) { this.db = db; }
public UserRepository(HotelContext hotelContext) : base(hotelContext) { }
public SeederService(HotelContext db) { _db = db; }
public RoomRepository(HotelContext context) { _context = context; }
public static void SeedData(HotelContext context) { var guests = new List <Guest>(); var reservations = new List <Reservation>(); guests.AddRange(new List <Guest> { new Guest { FirstName = "Jacek", LastName = "Tarda", Email = "*****@*****.**", PostalCode = "10-234", BirthDate = new DateTime(1978, 3, 9), Address = "Puszkina 9/1", City = "Olsztyn", Telephone = "501144135" }, new Guest { FirstName = "Piotr", LastName = "Bukowiński", Email = "*****@*****.**", PostalCode = "11-400", City = "Wrocław", Address = "Warszawska 33", Telephone = "601001001" }, new Guest { FirstName = "Piotr", LastName = "Gajko", Email = "*****@*****.**", PostalCode = "10-900", City = "Wrocław", Address = "Gdańska 13", Telephone = "666345456", BirthDate = new DateTime(1967, 6, 19) }, new Guest { FirstName = "Patryk", LastName = "Wiśniewski", Email = "*****@*****.**", PostalCode = "22-789", BirthDate = new DateTime(1995, 10, 11), City = "Warszawa", Address = "Olszrtńska 34", Telephone = "223456789" }, new Guest { FirstName = "Krzysztof", LastName = "Malinowski", Email = "*****@*****.**", PostalCode = "12-222", BirthDate = new DateTime(2000, 1, 22), City = "Gdańsk", Address = "Płoskiego 6", Telephone = "514141414" }, new Guest { FirstName = "Marta", LastName = "Glinska", Email = "*****@*****.**", PostalCode = "11-400", BirthDate = new DateTime(1985, 10, 7), City = "Suwałki", Address = "Mechaników 3", Telephone = "84678456" }, new Guest { FirstName = "Marek", LastName = "Kapłon", Email = "*****@*****.**", PostalCode = "80-678", BirthDate = new DateTime(1940, 3, 30) }, new Guest { FirstName = "Tomek", LastName = "Wiśniewski", Email = "*****@*****.**", PostalCode = "10-700", BirthDate = new DateTime(1985, 10, 9) }, new Guest { FirstName = "Jan", LastName = "Malinowski", Email = "*****@*****.**", PostalCode = "15-240", BirthDate = new DateTime(1986, 11, 1) }, new Guest { FirstName = "Piotr", LastName = "Wiśniewski", Email = "*****@*****.**", PostalCode = "12-670", BirthDate = new DateTime(1990, 5, 19), City = "Warszawa", Address = "Poniatowskiego 16" }, new Guest { FirstName = "Marian", LastName = "Kolasiński", Email = "*****@*****.**", PostalCode = "13-700", BirthDate = new DateTime(1960, 4, 29) } }); if (!context.Guests.Any()) { context.Guests.AddRange(guests); } context.SaveChanges(); reservations.AddRange(new List <Reservation> { new Reservation { BookInDate = new DateTime(2020, 2, 24), BookOutDate = new DateTime(2020, 2, 26), CreationDate = DateTime.Now, Currency = "PLN", Price = 160, ReservationCode = "9876545554", Source = "Gotówka", Commission = 21 }, new Reservation { BookInDate = new DateTime(2020, 3, 12), BookOutDate = new DateTime(2020, 3, 16), CreationDate = DateTime.Now, Currency = "PLN", Price = 240, ReservationCode = "147852369", Source = "Gotówka", Commission = 30 }, new Reservation { BookInDate = new DateTime(2020, 4, 17), BookOutDate = new DateTime(2020, 4, 24), CreationDate = DateTime.Now, Currency = "PLN", Price = 560, ReservationCode = "741258963", Source = "Gotówka", Commission = 25 }, new Reservation { BookInDate = new DateTime(2020, 5, 23), BookOutDate = new DateTime(2020, 5, 30), CreationDate = DateTime.Now, Currency = "PLN", Price = 640, ReservationCode = "9876543210", Source = "Przelew", Commission = 28 }, new Reservation { BookInDate = new DateTime(2020, 6, 10), BookOutDate = new DateTime(2020, 6, 14), CreationDate = DateTime.Now, Currency = "PLN", Price = 320, ReservationCode = "789654123", Source = "Przelew", Commission = 10 }, new Reservation { BookInDate = new DateTime(2020, 7, 15), BookOutDate = new DateTime(2020, 7, 20), CreationDate = DateTime.Now, Currency = "PLN", Price = 400, ReservationCode = "159847263", Source = "Przelew", Commission = 11 }, new Reservation { BookInDate = new DateTime(2020, 8, 6), BookOutDate = new DateTime(2020, 8, 12), CreationDate = DateTime.Now, Currency = "PLN", Price = 480, ReservationCode = "357421689", Source = "Przelew", Commission = 16 }, new Reservation { BookInDate = new DateTime(2020, 9, 17), BookOutDate = new DateTime(2020, 9, 22), CreationDate = DateTime.Now, Currency = "PLN", Price = 400, ReservationCode = "0002659000", Source = "Karta płatnicza", Commission = 10 }, new Reservation { BookInDate = new DateTime(2020, 10, 19), BookOutDate = new DateTime(2020, 10, 21), CreationDate = DateTime.Now, Currency = "PLN", Price = 160, ReservationCode = "7411596235", Source = "Karta płatnicza", Commission = 18 }, new Reservation { BookInDate = new DateTime(2020, 11, 18), BookOutDate = new DateTime(2020, 11, 22), CreationDate = DateTime.Now, Currency = "PLN", Price = 360, ReservationCode = "9871598472", Source = "Karta płatnicza", Commission = 14 }, new Reservation { BookInDate = new DateTime(2020, 12, 20), BookOutDate = new DateTime(2020, 12, 24), CreationDate = DateTime.Now, Currency = "PLN", Price = 360, ReservationCode = "1112223330", Source = "Karta płatnicza", Commission = 10 }, new Reservation { BookInDate = new DateTime(2020, 3, 30), BookOutDate = new DateTime(2020, 4, 6), CreationDate = DateTime.Now, Currency = "PLN", Price = 640, ReservationCode = "4488775219", Source = "Karta płatnicza", Commission = 20 } } ); if (!context.Reservations.Any()) { context.Reservations.AddRange(reservations); } context.SaveChanges(); var random = new Random(); foreach (var reservation in reservations) { var guestNum = random.Next(1, 3); var indexes = new List <int>(); for (var i = 0; i <= guestNum; i++) { var index = random.Next(guests.Count); if (!indexes.Contains(index)) { indexes.Add(index); var guest = guests[index]; guest.GuestReservations.Add(new ReservationGuest { GuestId = guest.Id, ReservationId = reservation.Id }); } } } context.SaveChanges(); }
public RoomsController(HotelContext context) { _context = context; }
public RoomRepository(HotelContext context) : base(context) { }