public async Task <ActionResult> ShortlistedParticipants(Guid?Eventid, Guid?Userid) { if (Userid != null) { ViewBag.UserId = Userid; } ParticipantsDetailModel model = new ParticipantsDetailModel(); model.Participantregistration = new List <ParticipationRegistrationModel>(); var data1 = new BasicFunctionalityofentireappService(); var result = data1.GetTotalVoteperPost(SessionToken).Entity; model.voterslist = new List <VotesModel>(); model.voterslist = result; Random rnd = new Random(); OrganiserBasicDetailsServices service = new OrganiserBasicDetailsServices(); var participantRegistration = await service.GetParticipantRegistration(SessionToken); var data = participantRegistration.Where(x => x.ContentType != null && x.EventId == Eventid && x.ParticipantStatus == 3).Select(x => x).OrderBy(x => Guid.NewGuid()).ToList(); var ImageorVideo1 = await service.GetEventRegistrationImageVideo(SessionToken); var ImageorVideo = ImageorVideo1.Where(x => x.Imagevideo.EventIdImageorVideo == Eventid).Select(x => x.Imagevideo.imageorvideo).FirstOrDefault(); try { foreach (var item in data) { model.Participantregistration.Add(new ParticipationRegistrationModel() { OrganizerId = item.OrganizerId, EventId = item.EventId, CollegeorSchool = item.CollegeorSchool, ContentType = item.ContentType, About_Self = item.About_Self, DateOfBirthh = item.DateOfBirthh, Data = ImageorVideo == 2 ? item.Data : null, Images = ImageorVideo == 1 ? Imageget(item.Data) : null, ContactNumber = item.ContactNumber, FileName = item.FileName, Modeofcompitetion = (modeofcompetation)item.Modeofcompitetion, VideoId = item.VideoId, Name = item.Name, Qualification = item.Qualification, }); } return(View(model)); } catch (Exception ex) { return(View("~/Views/Errorpage/Errorpage.cshtml")); } }
public async Task <ActionResult> RegisteredParticipantsfortheevent(Guid EventId) { ParticipantsDetailModel model = new ParticipantsDetailModel(); model.Participantregistration = new List <ParticipationRegistrationModel>(); OrganiserBasicDetailsServices obj = new OrganiserBasicDetailsServices(); var Eventdetails1 = await obj.GetEventRegistrationImageVideo(SessionToken); var Eventdetails = Eventdetails1.Where(x => x.Imagevideo.EventIdImageorVideo == EventId).Select(x => x).FirstOrDefault(); ViewBag.EventMode = Eventdetails.Imagevideo.EventMode; var data1 = await obj.GetParticipantRegistration(SessionToken); var data = data1.Where(x => x.EventId == EventId).Select(x => x).ToList(); try { foreach (var item in data) { model.Participantregistration.Add(new ParticipationRegistrationModel() { ParticipantId = item.ParticipantId, OrganizerId = item.OrganizerId, EventId = item.EventId, CollegeorSchool = item.CollegeorSchool, ContentType = item.ContentType, About_Self = item.About_Self, Data = Eventdetails.Imagevideo.imageorvideo == 2 && item.Data != null ? item.Data : null, Images = Eventdetails.Imagevideo.imageorvideo == 1 && item.Data != null ? Imageget(item.Data) : null, ContactNumber = item.ContactNumber, FileName = item.FileName, Modeofcompitetion = (modeofcompetation)item.Modeofcompitetion, VideoId = item.VideoId, Name = item.Name, Qualification = item.Qualification, }); } return(View(model)); } catch (Exception ex) { return(View("~/Views/Errorpage/Errorpage.cshtml")); } }
public ActionResult HallofFame(Guid?Userid) { if (Userid != null) { ViewBag.UserId = Userid; } try { ParticipantsDetailModel model = new ParticipantsDetailModel(); model.Participantregistration = new List <ParticipationRegistrationModel>(); var data1 = new BasicFunctionalityofentireappService(); var result = data1.GetTotalVoteperPost(SessionToken).Entity; model.voterslist = new List <VotesModel>(); model.voterslist = result; using (var db = new ConquerorHubEntities()) { Dictionary <int, Guid?> dict = new Dictionary <int, Guid?>(); var data4 = db.CH_ParticipantRegistration.Where(f => f.ParticipantId == Userid.ToString()).Select(f => f).ToList(); foreach (var item in data4) { var count = db.CH_VoteTable.GroupBy(a => a.EventId == item.EventId && a.PostId == item.ParticipantsPostId && a.VoteStatus == true).Select(a => a).Count(); if (count != 0) { dict.Add(count, item.ParticipantsPostId); dict.OrderByDescending(x => x.Key); } } if (dict.Count != 0) { var values = dict.Take(3).ToDictionary(x => x.Value).Values; var data01 = new List <ParticipationRegistrationModel>(); var data0 = new List <CH_ParticipantRegistration>(); foreach (var item in values) { data0 = db.CH_ParticipantRegistration.Where(d => d.ParticipantsPostId == item.Value.Value).Select(d => d).ToList(); } foreach (var item in data0) { model.Participantregistration = new List <ParticipationRegistrationModel>(); model.Participantregistration.Add(new ParticipationRegistrationModel() { Data = item.Data, OrganizerId = item.OrganizerId, ParticipantId = item.ParticipantId, EventId = item.EventId, VideoId = item.ParticipantsPostId, Name = item.Name, Qualification = item.Qualification, CollegeorSchool = item.CollegeorSchool, }); } } model.aboutEventlist = new List <AboutEvent>(); model.aboutParticipantslist = new List <AboutParticipants>(); model.importantDateslist = new List <ImportantDates>(); model.awardRewardlist = new List <AwardsAndRewards>(); EventsServices serviceObj = new EventsServices(); var Aboutevent = serviceObj.GetRegistrationAboutEvent(SessionToken, Userid).Entity.ToList(); var Aboutparticipant = serviceObj.GetORegistrtionAboutParticipant(SessionToken, Userid).Entity.ToList(); var AwardReward = serviceObj.GetAwardAndReward(SessionToken, Userid).Entity.ToList(); var impdates = serviceObj.GetImportantDateAndTime(SessionToken, Userid).Entity.ToList(); model.aboutEventlist.AddRange(Aboutevent); model.aboutParticipantslist.AddRange(Aboutparticipant); model.importantDateslist.AddRange(impdates); model.awardRewardlist.AddRange(AwardReward); return(View(model)); } } catch (Exception ex) { return(View("~/Views/Errorpage/Errorpage.cshtml")); } }
public async Task <ActionResult> PastEventsPerformance(Guid?Userid, Guid?EventId) { if (Userid != null) { ViewBag.UserId = Userid; } else { Userid = Guid.Parse(User.Identity.GetUserId()); } ParticipantsDetailModel model = new ParticipantsDetailModel(); model.Participantregistration = new List <ParticipationRegistrationModel>(); var data1 = new BasicFunctionalityofentireappService(); var result = data1.GetTotalVoteperPost(SessionToken).Entity; model.voterslist = new List <VotesModel>(); model.aboutEventlist = new List <AboutEvent>(); model.aboutParticipantslist = new List <AboutParticipants>(); model.importantDateslist = new List <ImportantDates>(); model.awardRewardlist = new List <AwardsAndRewards>(); EventsServices serviceObj = new EventsServices(); try { var Aboutevent = serviceObj.GetRegistrationAboutEvent(SessionToken, Userid).Entity.Where(x => x.EventStatus == 5).ToList(); var Aboutparticipant = serviceObj.GetORegistrtionAboutParticipant(SessionToken, Userid).Entity.Where(x => x.EventStatus == 5).ToList(); var AwardReward = serviceObj.GetAwardAndReward(SessionToken, Userid).Entity.Where(x => x.EventStatus == 5).ToList(); var impdates = serviceObj.GetImportantDateAndTime(SessionToken, Userid).Entity.Where(x => x.EventStatus == 5).ToList(); model.aboutEventlist.AddRange(Aboutevent); model.aboutParticipantslist.AddRange(Aboutparticipant); model.importantDateslist.AddRange(impdates); model.awardRewardlist.AddRange(AwardReward); var eventid = Aboutevent.Select(x => x.EventId); OrganiserBasicDetailsServices obj1 = new OrganiserBasicDetailsServices(); var data = new List <ParticipationRegistrationModel>(); var data2 = await obj1.GetParticipantRegistration(SessionToken); data.AddRange(data2.Where(x => x.OrganizerId == Userid.ToString() && x.EventId == EventId).Select(x => x).ToList()); var ImageorVideo1 = await obj1.GetEventRegistrationImageVideo(SessionToken); var ImageorVideo = ImageorVideo1.Where(x => x.Imagevideo.EventIdImageorVideo == EventId).Select(x => x.Imagevideo.imageorvideo).FirstOrDefault(); model.Participantregistration = new List <ParticipationRegistrationModel>(); if (data.Count() != 0) { foreach (var item in data) { model.Participantregistration.Add(new ParticipationRegistrationModel() { Data = ImageorVideo == 2 ? item.Data : null, Images = ImageorVideo == 1 ? Imageget(item.Data) : null, OrganizerId = item.OrganizerId, ParticipantId = item.ParticipantId, EventId = item.EventId, VideoId = item.VideoId, Name = item.Name, Qualification = item.Qualification, CollegeorSchool = item.CollegeorSchool, ContentType = item.ContentType, }); } } return(View(model)); } catch (Exception ex) { return(View("~/Views/Errorpage/Errorpage.cshtml")); } }