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