public ActionResult SearchPorfiles(Search search)
        {
            List <MatrimonyWebsite> allWebSites = new List <MatrimonyWebsite>();
            var dbResult = adaptor.GetAllWebSites(out allWebSites);

            List <MatrimonyWebsite> allFilteredWebSites = new List <MatrimonyWebsite>();
            //Filter result based on search data
            //Filter Data Based on Category
            var specialCategoryWebSites = allWebSites.Where(wb => !string.IsNullOrWhiteSpace(wb.SpecialCategory) && wb.SpecialCategory.ToLower() == search.specialCategory.ToLower()).ToList();

            if (specialCategoryWebSites.Any())
            {
                allFilteredWebSites.AddRange(specialCategoryWebSites);
            }

            //Filter Community WebSites
            var communityWebSites = allWebSites.Where(wb => !string.IsNullOrWhiteSpace(wb.Community) && wb.Community.ToLower() == search.community.ToLower()).ToList();

            if (communityWebSites.Any())
            {
                allFilteredWebSites.AddRange(communityWebSites);
            }

            //Filter Religion and Mothertounge
            var religionandMotherTounge = allWebSites.Where(wb => !string.IsNullOrWhiteSpace(wb.Religion) && !string.IsNullOrWhiteSpace(wb.MotherTounge) && wb.Religion.ToLower() == search.religion.ToLower() && wb.MotherTounge.ToLower() == search.motherTounge.ToLower()).ToList();

            if (religionandMotherTounge.Any())
            {
                allFilteredWebSites.AddRange(religionandMotherTounge);
            }

            //Filter Religion
            if (search.religion != "Hindu")
            {
                var religion = allWebSites.Where(wb => !string.IsNullOrWhiteSpace(wb.Religion) && wb.Religion.ToLower() == search.religion.ToLower()).ToList();
                if (religion.Any())
                {
                    allFilteredWebSites.AddRange(religion);
                }
            }


            var motherTounge = allWebSites.Where(wb => !string.IsNullOrWhiteSpace(wb.MotherTounge) && wb.MotherTounge.ToLower() == search.motherTounge.ToLower()).ToList();

            if (motherTounge.Any())
            {
                allFilteredWebSites.AddRange(motherTounge);
            }

            allFilteredWebSites = allFilteredWebSites.GroupBy(website => website.WebSiteName).Select(web => web.First()).ToList();



            if (allFilteredWebSites.Any())
            {
                matrimony.AllWebSites = allFilteredWebSites;
                foreach (var website in allFilteredWebSites)
                {
                    website.Profiles = GetAllProfiles(website.WebSiteName);
                    if (counter == 107)
                    {
                        counter = 0;
                    }
                    if (search.Gender == Constants.Female && search.community == Constants.Muslim)
                    {
                        website.Profiles.ForEach(profile => profile.ProfilePicPath = "./ProfilePictures_Muslim/" + counter++ + ".jpg");
                    }
                    else if (search.Gender == Constants.Female)
                    {
                        website.Profiles.ForEach(profile => profile.ProfilePicPath = "./ProfilePictures_Bride/" + counter++ + ".jpg");
                    }
                    else if (search.Gender == Constants.Male)
                    {
                        website.Profiles.ForEach(profile => profile.ProfilePicPath = "./ProfilePictures_Groom/" + counter++ + ".jpg");
                    }
                }
            }
            return(Json(new

            {
                redirectTo = Url.Action("ShowAllWebSitesWithProfiles", "Matrimony"),
                returnParam = matrimony
            }));
        }