public List <Booking> GetBookingsByOtel(int?otelId) { using (var context = new ResitalContext()) { var bookings = context.Booking.Where(i => i.IsActive).AsQueryable(); if (otelId != null) { bookings = bookings .Include(i => i.Otel) .Where(i => i.OtelId == otelId); } return(bookings.ToList()); } }
public static void Initialize(ResitalContext context) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); // Look for any bookings. if (context.Booking.Any()) { return; // DB has been seeded } List <Room> rooms = new List <Room> { new Room { Description = "A" }, new Room { Description = "B" }, new Room { Description = "C" } }; DateTime date = DateTime.Today.AddDays(4); List <Booking> bookings = new List <Booking> { new Booking { StartDate = date, EndDate = date.AddDays(14), IsActive = true, RoomId = 1 }, new Booking { StartDate = date, EndDate = date.AddDays(14), IsActive = true, RoomId = 2 }, new Booking { StartDate = date, EndDate = date.AddDays(14), IsActive = true, RoomId = 3 } }; context.Room.AddRange(rooms); context.SaveChanges(); context.Booking.AddRange(bookings); context.SaveChanges(); }
public List <Room> GetRoomsByOtel(int otelId) { using (var context = new ResitalContext()) { var rooms = context.Room.AsQueryable(); //if (!string.IsNullOrEmpty(name)) //{ // rooms = rooms // .Include(i => i.Otel) // .Where(i => i.OtelAd.ToLower() == name.ToLower()); //} DateTime now = DateTime.Now.AddDays(-1); rooms = rooms.Include(x => x.Otel).Include(x => x.Bookings).Where(x => x.OtelId == otelId && !x.Bookings .Any(i => i.StartDate <now && i.EndDate> now)); //oda boş ise return(rooms.ToList()); } }
public RoomRepository() { db = new ResitalContext(); }
public BookingRepository() { db = new ResitalContext(); }