예제 #1
0
        public async Task <FrontPersonAdvancedSearchGet> FrontPersonAdvancedSearchGet(string UserId)
        {
            var AdvancedPersonSearch = new FrontPersonAdvancedSearchGet();

            string GenderUsp = "usp_GenderList @UserId";

            AdvancedPersonSearch.Genders = await _sqlDataAccess.LoadData <GenderList, dynamic>(GenderUsp, new { UserId = UserId });

            AdvancedPersonSearch.Genders.Insert(0, new GenderList {
                GenderId = 0, Name = "Select a gender"
            });

            string OrganizationUsp = "usp_OrganizationList @UserId";

            AdvancedPersonSearch.Organizations = await _sqlDataAccess.LoadData <OrganizationList, dynamic>(OrganizationUsp, new { UserId = UserId });

            AdvancedPersonSearch.Organizations.Insert(0, new OrganizationList {
                OrganizationId = 0, Name = "Select an organization"
            });


            string ProjectUsp = "usp_ProjectListCheckSecurityLevel @UserId";

            AdvancedPersonSearch.Projects = await _sqlDataAccess.LoadData <ProjectList, dynamic>(ProjectUsp, new { UserId = UserId });

            AdvancedPersonSearch.Projects.Insert(0, new ProjectList {
                ProjectId = 0, Name = "Select an project"
            });

            string CountriesUsp = "usp_CountryList @UserId";

            AdvancedPersonSearch.Countries = await _sqlDataAccess.LoadData <CountryList, dynamic>(CountriesUsp, new { UserId = UserId });

            AdvancedPersonSearch.Countries.Insert(0, new CountryList {
                CountryId = 0, Name = "Select an organization type"
            });


            string RelationWithPersonsUsp = "usp_PersonListWithRelations";

            AdvancedPersonSearch.RelationWithPersons = await _sqlDataAccess.LoadData <PersonList>(RelationWithPersonsUsp);

            AdvancedPersonSearch.RelationWithPersons.Insert(0, new PersonList {
                PersonId = 0, Name = "Select person"
            });

            return(AdvancedPersonSearch);
        }
예제 #2
0
        public async Task <IActionResult> QuickSearch([FromQuery(Name = "Search")] string Search)
        {
            var SearchData = new FrontPersonAdvancedSearchGet
            {
                FirstName = Search,
                ToAge     = 120
            };
            var token = HttpContext.Session.GetString("Token"); if (token == null)
            {
                return(RedirectToAction("Login", "FrontAuth"));
            }
            var result = await _client.PostProtectedAsync <FrontPersonAdvancedSearchGet>($"{_configuration["APIUrl"]}api/FrontPerson/AdvancedSearch", SearchData, token);

            ViewBag.AllStuff = await _loadViewBagModel.ViewBagLoad(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), token, _hostingEnv.EnvironmentName, _configuration, false, 0, "");

            //ViewBag.UITerms = await _client.GetProtectedAsync<List<UITermLanguageCustomizationList>>($"{_configuration["APIUrl"]}api/MVC/FrontPerson/SearchResult", token);
            //ViewBag.Favorites = await _client.GetProtectedAsync<List<MVCFavoriteMenu>>($"{_configuration["APIUrl"]}api/MVCFavorite/Menu", token);
            //ViewBag.FavoriteGroupList = await _client.GetProtectedAsync<List<MVCFavoriteGroupList>>($"{_configuration["APIUrl"]}api/MVCFavorite/GroupList", token);
            //ViewBag.Env = _hostingEnv.EnvironmentName;

            return(View("SearchResult", result));
        }
예제 #3
0
        public async Task <List <FrontPersonSearchResult> > FrontPersonAdvancedSearchPost(FrontPersonAdvancedSearchGet SearchData)
        {
            string usp = "usp_FrontPersonAdvancedSearchPost @UserId, @Contains, @Age, @Birthdate, @MainOrganizationId, @IsUser, @RoleId, @OrganizationId, @ProjectId, @CountryId, @ProvinceState , @County , @City, @ClassificationId, @ClassificationValueId ";
            var    x   = await _sqlDataAccess.LoadData <FrontPersonSearchResult, dynamic>(usp, SearchData);

            return(x);
        }