using UserManagement.Data; using UserManagement.Data.Dto; using UserManagement.MediatR.Queries; using UserManagement.Repository; using MediatR; using Microsoft.EntityFrameworkCore; using System; using System.Collections.Generic; using System.Linq; using System.Threading; using System.Threading.Tasks; namespace UserManagement.MediatR.Handlers { public class GetHalfYearlyReminderQueryHandler : IRequestHandler> { private readonly IReminderRepository _reminderRepository; private readonly UserInfoToken _userInfo; public GetHalfYearlyReminderQueryHandler(IReminderRepository reminderRepository, UserInfoToken userInfo) { _reminderRepository = reminderRepository; _userInfo = userInfo; } public async Task> Handle(GetHalfYearlyReminderQuery request, CancellationToken cancellationToken) { var startDate = new DateTime(request.Year, request.Month, 1, 0, 0, 1); var currentQuater = GetCurrentQuater(startDate); var monthEndDate = startDate.AddMonths(1).AddDays(-1); var endDate = new DateTime(monthEndDate.Year, monthEndDate.Month, monthEndDate.Day, 23, 59, 59); var lastDayOfMonth = endDate.Day; var reminders = await _reminderRepository.All .Include(c => c.ReminderUsers) .Include(c => c.HalfYearlyReminders.Where(c => c.Quarter == currentQuater)) .Where(c => c.Frequency == Frequency.HalfYearly && c.HalfYearlyReminders.Any(c => c.Month == request.Month) && c.StartDate <= endDate && (!c.EndDate.HasValue || c.EndDate >= startDate) && (c.CreatedBy == Guid.Parse(_userInfo.Id) || c.ReminderUsers.Any(c => c.UserId == Guid.Parse(_userInfo.Id)))) .ToListAsync(); var reminderDto = reminders.Select(c => { var quater = c.HalfYearlyReminders.FirstOrDefault(); return new CalenderReminderDto { RemiderId = c.Id, Title = c.Subject, Start = new DateTime(startDate.Year, startDate.Month, quater.Day, 0, 0, 10), End = new DateTime(startDate.Year, startDate.Month, quater.Day, 0, 0, 20), }; }).ToList(); return reminderDto; } private QuarterEnum GetCurrentQuater(DateTime date) { if (date >= new DateTime(date.Year, 1, 1) && date <= new DateTime(date.Year, 6, 30)) { return QuarterEnum.Quarter1; } else { return QuarterEnum.Quarter2; } } } }