public IQueryable <Booking> GetActiveBookings(Booking booking) { var bookings = _unitOfWork.Query <Booking>() .Where( b => b.Id != booking.Id && b.Status != "Cancelled"); return(bookings); }
public IQueryable <Booking> GetBookings() { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>(); return(bookings); }
public IQueryable <Booking> GetActiveBookings(int?excludeBookingId = null) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where(b => b.Status != "Cancelled" && (excludeBookingId == null || excludeBookingId != b.Id)); return(bookings); }
public static void SendStatementEmails(DateTime statementDate) { var housekeepers = UnitOfWork.Query <Housekeeper>(); foreach (var housekeeper in housekeepers) { SendStatementEmail(statementDate, housekeeper); } }
public IQueryable <Booking> GetActiveBookings(int?excludedBookingId = null) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork .Query <Booking>() .Where(b => (!excludedBookingId.HasValue || b.Id != excludedBookingId.Value) && b.Status != "Cancelled"); return(bookings); }
public IQueryable <Booking> GetActiveBookings(int excludedBooking) { var unitOfWork = new UnitOfWork(); return (unitOfWork.Query <Booking>() .Where( b => b.Id != excludedBooking && b.Status != "Cancelled")); }
public IQueryable <Booking> FindActiveBookings(int excludedBookingId) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where( b => b.Id != excludedBookingId && b.Status != "Cancelled"); return(bookings); }
public IQueryable <Booking> getBookings(Booking booking) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where( b => b.Id != booking.Id && b.Status != "Cancelled"); return(bookings); }
public IQueryable <Booking> GetActiveBookings(int?exculdeBookingId = null) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where( b => b.Status != "Cancelled"); return(exculdeBookingId.HasValue ? bookings.Where(b => b.Id != exculdeBookingId) : bookings); }
public IQueryable <Booking> GetBookings(int?id = null) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>().Where(b => b.Status != "Cancelled"); if (id.HasValue) { bookings = bookings.Where(b => b.Id != id.Value); } return(bookings); }
public IQueryable <Booking> getActiveBookings(int?excludedBookingId) { var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where( b => b.Id != excludedBookingId && b.Status != "Cancelled"); if (excludedBookingId.HasValue) { bookings = bookings.Where(b => b.Id != excludedBookingId.Value); } return(bookings); }
public IQueryable <Booking> GetActiveBookings(int?excludedBookingId = null) { var bookings = _unitOfWork.Query <Booking>() .Where( b => b.Status != "Cancelled"); if (excludedBookingId.HasValue) { bookings = bookings.Where(b => b.Id == excludedBookingId.Value); } return(bookings); }
public IQueryable <Booking> GetActiveBookings(int?excludedBookingId = null) // we wanted this to be optional { var unitOfWork = new UnitOfWork(); // External Database, so, External resource used... var bookings = unitOfWork.Query <Booking>() .Where( b => b.Status != "Cancelled"); if (excludedBookingId.HasValue) { bookings = bookings.Where(b => b.Id != excludedBookingId.Value); } return(bookings); }
public string OverlappingBookingsExist(Booking booking) { if (booking.Status == "Cancelled") { return(string.Empty); } var otherNotCancelledBookings = _unitOfWork .Query <Booking>() .Where(b => b.Id != booking.Id && b.Status != "Cancelled"); var overlappingBooking = otherNotCancelledBookings .FirstOrDefault(b => IsBookingsOverlapped(booking, b)); return(overlappingBooking == null ? string.Empty : overlappingBooking.Reference); }
public IQueryable <Booking> GetActiveBookings(int?excludedBookingId = null) { var unitOfWork = new UnitOfWork(); //Refactorizamos esta dependencia externa en una clase a parte var bookings = unitOfWork.Query <Booking>() .Where( b => b.Status != "Cancelled"); if (excludedBookingId.HasValue) { bookings = bookings.Where(b => b.Id != excludedBookingId.Value); } return(bookings); }
public static string OverlappingBookingsExist(Booking booking) { if (booking.Status == "Cancelled") { return(string.Empty); } var unitOfWork = new UnitOfWork(); var bookings = unitOfWork.Query <Booking>() .Where(b => b.Id != booking.Id && b.Status != "Cancelled"); var overlappingBooking = bookings.FirstOrDefault( b => booking.ArrivalDate >= b.ArrivalDate && booking.ArrivalDate <b.DepartureDate || booking.DepartureDate> b.ArrivalDate && booking.DepartureDate <= b.DepartureDate); return(overlappingBooking == null ? string.Empty : overlappingBooking.Reference); }
public IQueryable <Housekeeper> GetHouseKeepers() { return(_unitOfWork.Query <Housekeeper>()); }
public IQueryable <Housekeeper> GetHouseKeepers() { var housekeepers = _unitOfWork.Query <Housekeeper>(); return(housekeepers); }
public IQueryable <Booking> GetAllBookingsWithActiveStatusAndDifferentByGivenId(int id) => _unitOfWork.Query <Booking>() .Where( b => b.Id != id && b.Status != "Cancelled");
public IQueryable <Housekeeper> GetHousekeepers() { UnitOfWork UnitOfWork = new UnitOfWork(); return(UnitOfWork.Query <Housekeeper>()); }