public List <EventDataModel> GetInvites(InviteDataModel invitesData) { using (var context = new BookReadingEventsDBEntities()) { context.Database.Log = Logger.Log; List <EventDataModel> listOfInvites = null; Event eventModel = new Event(); Invite inviteModel = new Invite(); var invitesEntityList = context.Invites.Where(i => i.UserId == invitesData.UserId). GroupJoin(context.Events, i => i.EventId, e => e.Id, (i, eve) => new { eventDetail = eve }); if (invitesEntityList != null) { listOfInvites = new List <EventDataModel>(); foreach (var invite in invitesEntityList) { EventDataModel eventDataModel = new EventDataModel(); eventDataModel.Date = invite.eventDetail.ElementAt(0).Date; eventDataModel.Description = invite.eventDetail.ElementAt(0).Description; eventDataModel.DurationInHours = (int)invite.eventDetail.ElementAt(0).DurationInHours; eventDataModel.Id = invite.eventDetail.ElementAt(0).Id; eventDataModel.InviteEmails = invite.eventDetail.ElementAt(0).InviteEmails; eventDataModel.Location = invite.eventDetail.ElementAt(0).Location; eventDataModel.OtherDetails = invite.eventDetail.ElementAt(0).OtherDetails; eventDataModel.StartTime = (DateTime)invite.eventDetail.ElementAt(0).StartTime; eventDataModel.Title = invite.eventDetail.ElementAt(0).Title; eventDataModel.TotalInvites = (int)invite.eventDetail.ElementAt(0).TotalInvites; eventDataModel.Type = invite.eventDetail.ElementAt(0).Type; eventDataModel.UserId = invite.eventDetail.ElementAt(0).UserId; listOfInvites.Add(eventDataModel); } } return(listOfInvites); } }
public ActionResult EventsInviteTo() { InviteDataModel inviteDataModel = new InviteDataModel(); string user = GetUserDetail(); inviteDataModel.UserId = Convert.ToInt32(user.Split('|')[1]); InvitesService invitesService = new InvitesService(); var result = invitesService.GetInvites(inviteDataModel); List <EventViewModel> eventsModel = null; if (result != null && result.Count != 0) { eventsModel = new List <EventViewModel>(); foreach (EventDataModel levent in result) { EventViewModel eventViewModel = new EventViewModel(); eventViewModel.Date = levent.Date; eventViewModel.Description = levent.Description; eventViewModel.DurationInHours = (int)levent.DurationInHours; eventViewModel.Id = levent.Id; eventViewModel.InviteEmails = levent.InviteEmails; eventViewModel.Location = levent.Location; eventViewModel.OtherDetails = levent.OtherDetails; eventViewModel.StartTime = (DateTime)levent.StartTime; eventViewModel.Title = levent.Title; eventViewModel.TotalInvites = (int)levent.TotalInvites; eventViewModel.Type = levent.Type; eventViewModel.UserId = levent.UserId; eventsModel.Add(eventViewModel); } return(View(eventsModel)); } return(View()); }