public static List <CalendarItem> SearchCalendarItemForWTR(AjourBTForTestContext context, DateTime fromDate, DateTime toDate) { List <CalendarItem> result = (from item in context.CalendarItems where ((item.From <= fromDate && item.To >= fromDate) || (item.From >= fromDate && item.From <= toDate)) select item).ToList(); return(result); }
public static CalendarItem SearchCalendarItem(int EmployeeID, AjourBTForTestContext context, CalendarItemType type, DateTime fromDate, DateTime toDate) { CalendarItem item; switch (type) { case CalendarItemType.ReclaimedOvertime: { item = ((from calendarItem in context.CalendarItems where calendarItem.EmployeeID == EmployeeID && (calendarItem.Type == CalendarItemType.ReclaimedOvertime || calendarItem.Type == CalendarItemType.PrivateMinus) && ((calendarItem.From <= fromDate && calendarItem.To >= fromDate) || (calendarItem.From >= fromDate && calendarItem.From <= toDate)) select calendarItem).FirstOrDefault()); } break; case CalendarItemType.PaidVacation: { item = ((from calendarItem in context.CalendarItems where calendarItem.EmployeeID == EmployeeID && (calendarItem.Type == CalendarItemType.PaidVacation || calendarItem.Type == CalendarItemType.UnpaidVacation) && ((calendarItem.From <= fromDate && calendarItem.To >= fromDate) || (calendarItem.From >= fromDate && calendarItem.From <= toDate)) select calendarItem).FirstOrDefault()); } break; default: item = (from calendarItem in context.CalendarItems where calendarItem.EmployeeID == EmployeeID && calendarItem.Type == type && ((calendarItem.From <= fromDate && calendarItem.To >= fromDate) || (calendarItem.From >= fromDate && calendarItem.From <= toDate)) select calendarItem).FirstOrDefault(); break; } return(item); }