Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var overlaps = .Session.QueryOver<DelegateOrderApproval>()
- .Where(x => x.DateFrom > DateTime.Now && delegateOrderApproval.DelegatedUser.UserId == x.DelegatorUser.UserId)
- .And(x => x.DateFrom >= delegateOrderApproval.DateFrom && delegateOrderApproval.DateTo <= x.DateTo
- || (x.DateFrom >= delegateOrderApproval.DateFrom && x.DateTo <= delegateOrderApproval.DateTo)
- || (x.DateFrom <= delegateOrderApproval.DateFrom && x.DateTo >= delegateOrderApproval.DateFrom)
- || (x.DateFrom <= delegateOrderApproval.DateFrom && x.DateTo >= delegateOrderApproval.DateTo))
- .List();
- var doesOverlapExist = Session.QueryOver<DelegateOrderApproval>()
- .Any(x =>
- x.DateFrom > DateTime.Now &&
- delegateOrderApproval.DelegatedUser.UserId == x.DelegatorUser.UserId &&
- x.DateFrom <= delegateOrderApproval.DateTo &&
- x.DateTo >= delegateOrderApproval.DateFrom);
- Where(x=> blabla).Count() >0
Add Comment
Please, Sign In to add comment