public void GetTodayEvents()
{
var result = (from dbEvent in context.EventDetails
join dbSubscribedBy in context.SubscribedEvents
on dbEvent.NotificationTypeId equals dbSubscribedBy.NotificationTypeId
into dbEventSubscriptionTemp
from dbEventSubscription in dbEventSubscriptionTemp
where (dbEvent.EventDate.Year == DateTime.Now.Year &&
dbEvent.EventDate.Month == DateTime.Now.Month &&
dbEvent.EventDate.Day == DateTime.Now.Day)
select new
{
dbEvent,
dbEventSubscription
}).ToList();
var users = result.Select(e => e.dbEventSubscription).Distinct();
var eventList = result.Where(e => e.dbEventSubscription.NotifyInApp == true).Select(e => e.dbEvent).Distinct();
foreach (var u in users)
{
foreach (var e in eventList)
{
EmployeeEventMap employeeEventMap = new EmployeeEventMap()
{
EmployeeId = u.EmployeeId,
EventId = e.EventId
};
eventConcrete.AddEventMap(employeeEventMap);
}
}
}
public int AddEventMap(EmployeeEventMap employeeEventMap)
{
context.employeeEvents.Add(employeeEventMap);
return(context.SaveChanges());
}
