Rezervace

// BEFORE
            DateTime dateToFindMinusOneDay = dateToFind.AddDays(-1);
            DateTime dateToFindPlusOneDay = dateToFind.AddDays(1);

            // FIND RESERVATIONS
            List<HallReservation> list = appcontext.HallReservations.Where(p =>
           (
            // Den pred
            ((p.fromDate.Day == dateToFindMinusOneDay.Day && p.fromDate.Month == dateToFindMinusOneDay.Month && p.fromDate.Year == dateToFindMinusOneDay.Year // PREDCHOZI DEN
            && p.fromDate.Day != p.toDate.Day // KONCI AZ VE VYBRANY DEN
            && (p.toDate.Day == dateToFind.Day && p.toDate.Month == dateToFind.Month && p.toDate.Year == dateToFind.Year //
            && ((p.toDate.Hour == 0 && p.toDate.Minute != 0) || (p.toDate.Hour != 0))))
            // Aktualni dne
            || (p.fromDate.Day == dateToFind.Day && p.fromDate.Month == dateToFind.Month && p.fromDate.Year == dateToFind.Year)
            // Den pote
            || ((p.fromDate.Day == dateToFindPlusOneDay.Day && p.fromDate.Month == dateToFindPlusOneDay.Month && p.fromDate.Year == dateToFindPlusOneDay.Year)
               && ((p.toDate.Day == dateToFindPlusOneDay.Day && p.toDate.Hour < 2 || (p.toDate.Hour == 2 && p.toDate.Minute == 0)) || p.fromDate.Day == dateToFindPlusOneDay.Day && p.fromDate.Hour < 2)))

            && p.deleted == null)).ToList();

            list = list.OrderBy(m => m.fromDate).ToList();

// AFTER
            DateTime dateToFindMinusOneDay = dateToFind.AddDays(-1);
            DateTime dateToFindPlusOneDay = dateToFind.AddDays(1);

            // FIND RESERVATIONS
            List<HallReservation> list = appcontext.HallReservations.Where(p =>
           (
            // Den pred
            ((
            DbFunctions.TruncateTime(p.fromDate) == dateToFindMinusOneDay.Date
            && p.fromDate.Day != p.toDate.Day // KONCI AZ VE VYBRANY DEN
            && (DbFunctions.TruncateTime(p.toDate) == dateToFind.Date
            && ((p.toDate.Hour == 0 && p.toDate.Minute != 0) || (p.toDate.Hour != 0))))
            // Aktualni dne
            || (DbFunctions.TruncateTime(p.fromDate) == dateToFind.Date)
            // Den pote
            || ((DbFunctions.TruncateTime(p.fromDate) == dateToFindPlusOneDay.Date)
               && ((p.toDate.Day == dateToFindPlusOneDay.Day && p.toDate.Hour < 2 || (p.toDate.Hour == 2 && p.toDate.Minute == 0)) || p.fromDate.Day == dateToFindPlusOneDay.Day && p.fromDate.Hour < 2)))

            && p.deleted == null)).ToList();

            list = list.OrderBy(m => m.fromDate).ToList();