public void GetListPersonalInfoTest() { var queryParam = new ListPersonalInfoQueryParam { SearchText = "a", Pagination = new Pagination(0, 100) }; var result = _queryService.GetListPersonalInfo(queryParam); }
public void ListPersonsTest() { var queryParam = new ListPersonalInfoQueryParam(); //queryParam.AgeFrom = 25; //queryParam.ThruAge = 26; //queryParam.UserNumber = "sbi"; //queryParam.CategoryTypeIds = new List<string> { "MODELING" }; //queryParam.CategoryTypeIds = new System.Collections.Generic.List<string>() { "FILM", "MODELING" }; queryParam.HeightFrom = 1.56; queryParam.HeightThru = 1.56; queryParam.HeightUom = "METER"; var result = _queryService.ListSearchPersonalInfos(queryParam); Assert.IsNotNull(result); }
public GetPersonalInfoListModel GetListPersonalInfo(ListPersonalInfoQueryParam queryParam) { var searchText = queryParam.SearchText?.Trim(); var personalInfos = _context.PersonalInformations .Where(t => (string.IsNullOrEmpty(searchText) || ( t.FirstName.Contains(searchText) || t.LastName.Contains(searchText) || t.FatherName.Contains(searchText) || t.PersonId_User.UserNumber.Contains(searchText) )) && (string.IsNullOrEmpty(queryParam.Sex) || t.Sex == queryParam.Sex) ); return(new GetPersonalInfoListModel { PersonalInfoList = personalInfos.Paginate(t => t.FirstName, queryParam.Pagination).ToList().AsQueryable().ToList <PersonalInfoListModel>(), TotalCount = personalInfos.Count() }); }
public GetListSearchPersonalInfos ListSearchPersonalInfos(ListPersonalInfoQueryParam queryParam) { var birthDateFromAge = DateTime.Now.AddYears(-queryParam.AgeFrom); var birthDateThruAge = DateTime.Now.AddYears(-(queryParam.ThruAge + 1)); var personalInfos = _context.PersonalInformations.Where(t => t.PersonId_User.StatusId != null && (queryParam.AgeFrom == 0 || (t.DateOfBirth.Value.Year <= birthDateFromAge.Year && ( birthDateFromAge.Year - t.DateOfBirth.Value.Year > 0 || t.DateOfBirth.Value.Month <= birthDateFromAge.Month ) ) ) && (queryParam.ThruAge == 0 || (t.DateOfBirth.Value.Year >= birthDateThruAge.Year && ( t.DateOfBirth.Value.Year - birthDateThruAge.Year > 0 || t.DateOfBirth.Value.Month > birthDateThruAge.Month ) ) ) && (string.IsNullOrEmpty(queryParam.Sex) || t.Sex == queryParam.Sex) && (string.IsNullOrEmpty(queryParam.FirstName) || t.FirstName.ToLower() .Contains(queryParam.FirstName.ToLower())) && (string.IsNullOrEmpty(queryParam.Complexion) || t.PersonId_PhysicalInformation.Complexion == queryParam.Complexion) && (string.IsNullOrEmpty(queryParam.UserNumber) || t.PersonId_User.UserNumber.ToLower() .Contains(queryParam.UserNumber.ToLower())) && (queryParam.CategoryTypeIds.Count == 0 || t.Categories_PersonId .Any(l => queryParam.CategoryTypeIds.Contains( l.CategoryTypeId))) && (queryParam.HeightFrom == null || ( t.PersonId_PhysicalInformation.Height >= queryParam.HeightFrom && t.PersonId_PhysicalInformation.HeightEnumId == queryParam.HeightUom ) ) && (queryParam.HeightThru == null || ( t.PersonId_PhysicalInformation.Height <= queryParam.HeightThru && t.PersonId_PhysicalInformation.HeightEnumId == queryParam.HeightUom) )); return(new GetListSearchPersonalInfos() { PersonalInfos = personalInfos.Paginate(t => t.PersonId_User.UserNumber, queryParam.Pagination.Page, queryParam.Pagination.PageSize).OrderBy(t => t.FirstName).ToList().AsQueryable().ToList <PersonalInformationQueryModel>(), TotalCount = personalInfos.Count() }); }
public GetPersonalInfoListModel GetListPersonalInfo(ListPersonalInfoQueryParam queryParam) { return(_query.GetListPersonalInfo(queryParam)); }
public GetListSearchPersonalInfos ListSearchPersonalInfos(ListPersonalInfoQueryParam queryParam) { return(_query.ListSearchPersonalInfos(queryParam)); }
public GetPersonalInfoListModel GetListPersonalInfo(ListPersonalInfoQueryParam queryParam) { return(_modelManagementQueryServices.GetListPersonalInfo(queryParam)); }
public GetListSearchPersonalInfos ListSearchPersonalInfos(ListPersonalInfoQueryParam queryParam) { return(_modelManagementQueryServices.ListSearchPersonalInfos(queryParam)); }