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()); }