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