public QueryResult ListStatusItem(string statusTypeId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.StatusItems.Where(t => string.IsNullOrEmpty(statusTypeId) || t.StatusTypeId == statusTypeId)
.QueryResultList <KeyDescription>(queryParamArg));
}
public QueryResult ListSkill(string personId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.Skills.Where(t => t.PersonId == personId)
.QueryResultList <SkillListModel>(queryParamArg));
}
public QueryResult LookupEnumByType(string enumTypeId, QueryParamArg queryParamArg)
{
queryParamArg.SetDefaultSortColumn("SequenceId");
var enums =
ModelManagementContext()
.Enumerations.Where(t => string.IsNullOrEmpty(enumTypeId) || t.EnumerationTypeId == enumTypeId);
return(enums.QueryResultList <KeyDescription>(queryParamArg));
}
public QueryResult ListEnum(string enumTypeId, List <string> enumTypeIds, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.Enumerations.Where(t =>
(string.IsNullOrEmpty(enumTypeId) || t.EnumerationTypeId == enumTypeId) &&
(enumTypeIds.Count == 0 || enumTypeIds.Contains(t.EnumerationTypeId))
).QueryResultList <EnumerationListModel>(queryParamArg));
}
private static IQueryable GetResult(IQueryable source, QueryParamArg queryParamArg)
{
if (queryParamArg?.Pagination != null && !string.IsNullOrEmpty(queryParamArg.SortingColumnName) && !string.IsNullOrEmpty(queryParamArg.SortDirection))
{
return(source.OrderBy(queryParamArg.SortingColumnName + " " + queryParamArg.SortDirection)
.Skip(queryParamArg.Pagination.Page * queryParamArg.Pagination.PageSize)
.Take(queryParamArg.Pagination.PageSize));
}
return(string.IsNullOrEmpty(queryParamArg?.SortDirection) ? source : source.OrderBy(queryParamArg.SortingColumnName + " " + queryParamArg.SortDirection));
}
public QueryResult ListJobOffer(string jobPostId, string statusId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobOffers.Where(
t =>
(string.IsNullOrEmpty(jobPostId) || t.JobPostId == jobPostId) &&
(string.IsNullOrEmpty(statusId) || t.StatusId == statusId))
.QueryResultList <JobOfferListModel>(queryParamArg));
}
public QueryResult ListUserJobApplications(string userId, string jobPostId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobApplications.Where(
t =>
(string.IsNullOrEmpty(userId) || t.ApplyingUserId == userId) &&
(string.IsNullOrEmpty(jobPostId) || t.JobPostId == jobPostId))
.QueryResultList <JobApplicationListModel>(queryParamArg));
}
private static IQueryable Paginate(IQueryable source, QueryParamArg queryParamArg)
{
if (queryParamArg?.Pagination == null)
{
return(source);
}
return(source.OrderBy(queryParamArg.SortingColumnName + " " + queryParamArg.SortDirection)
.Skip(queryParamArg.Pagination.Page * queryParamArg.Pagination.PageSize)
.Take(queryParamArg.Pagination.PageSize));
}
public static void SetDefaultSortColumn(this QueryParamArg queryParamArg, string defaultSortColumn = null)
{
if (!IsNullOrEmpty(queryParamArg.SortingColumnName))
{
return;
}
{
queryParamArg.SortDirection = "ASC";
queryParamArg.SortingColumnName = IsNullOrEmpty(defaultSortColumn) ? "Description" : defaultSortColumn;
}
}
public QueryResult ListOfferType(QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.OfferTypes.Where(
t =>
string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.Description.Contains(queryParamArg.SearchText) ||
t.Sequence.Contains(queryParamArg.SearchText) ||
t.LongDescription.Contains(queryParamArg.SearchText))
.QueryResultList <OfferTypeListModel>(queryParamArg));
}
public static QueryResult QueryResultList <T>(this IQueryable queryResult, QueryParamArg queryParamArg = null)
{
ValidateQueryParamArg(queryParamArg);
var result = GetResult(queryResult, queryParamArg);
return(new QueryResult
{
Data = result.ProjectTo <T>().ToList(),
EntityCount = queryParamArg == null ? 0 : queryParamArg.ShowEntityCount ? queryResult.Count() : 0,
IsSuccess = true
});
}
public QueryResult LookupCategoryType(QueryParamArg queryParamArg)
{
var categoryTypes = ModelManagementContext()
.CategoryTypes.Where(t => t.IsActive == "Y")
.GroupBy(g => g.ParentTypeId).ToList()
.Select(s => new CategoryTypeLookupModel
{
CategoryTypeParent = s.FirstOrDefault(t => t.CategoryTypeId == s.Key)?.Description,
CategoryTypes = s.AsQueryable().Where(t => t.CategoryTypeId != s.Key).ToLookUp()
}).ToList();
return(Utility.QuerySuccessResult(categoryTypes));
}
public QueryResult ListOfferItemType(string offertypeId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.OfferItemTypes.Where(
t =>
(string.IsNullOrEmpty(offertypeId) ||
t.OfferItemTypeId_OfferType.Any(l => l.OfferTypeId == offertypeId)) &&
(string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.Description.Contains(queryParamArg.SearchText) ||
t.Sequence.Contains(queryParamArg.SearchText)))
.QueryResultList <OfferItemTypeListModel>(queryParamArg));
}
public static void ValidateQueryParamArg(QueryParamArg queryParamArg)
{
if (queryParamArg == null)
{
return;
}
if (queryParamArg.Pagination != null && IsNullOrEmpty(queryParamArg.SortDirection))
{
throw new InvalidOperationException("Sorting direction missing");
}
if (queryParamArg.Pagination != null && IsNullOrEmpty(queryParamArg.SortingColumnName))
{
throw new InvalidOperationException("Sorting column direction missing");
}
}
public QueryResult ListUserContent(string userId, QueryParamArg queryParamArg)
{
//var queryContext = ModelManagementContext();
//var userContents = queryContext.Contents.Where(t => t.ContentUserId == userId).OrderBy(o => o.LastUpdatedStamp).ToList<ContentListModel>();
//var contentIds = userContents.Select(s => s.ContentId);
//var contentData = queryContext.ContentDatas.Where(t => contentIds.Contains(t.ContentId)).ToList();
//foreach (var content in userContents)
//{
// content.Data = contentData.FirstOrDefault(t => t.ContentId == content.ContentId)?.Data;
//}
return
(ModelManagementContext()
.Contents.Where(t => t.ContentUserId == userId)
.OrderBy(o => o.LastUpdatedStamp)
.QueryResultList <ContentListModel>());
//return Utility.QuerySuccessResult(userContents);
}
public QueryResult ListPersonContactInfo(string personId, QueryParamArg queryParamArg)
{
var result =
ModelManagementContext()
.ContactMechTypes.Where(t => t.IsActive == "Y")
.GroupBy(g => g.ContactMechTypeId)
.ToList()
.Select(s => new ContactInformationListModel
{
PersonId = personId,
ContactMechTypeId = s.Key,
ContactMechType = s.FirstOrDefault()?.Description,
ContactUrl =
s.FirstOrDefault()?
.ContactInformations.FirstOrDefault(t => t.PersonId == personId)?
.ContactUrl
}).ToList();
return(Utility.QuerySuccessResult(result));
}
public QueryResult ListJobApplication(string jobPostId, string applyingUserId, string statusId, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobApplications.Where(
t =>
(string.IsNullOrEmpty(jobPostId) || t.JobPostId == jobPostId) &&
(string.IsNullOrEmpty(applyingUserId) || t.ApplyingUserId == applyingUserId) &&
string.IsNullOrEmpty(statusId) || t.StatusId == statusId)
.QueryResultList <JobApplicationListModel>(queryParamArg));
}
public QueryResult ListModels(ListModelsQueryParamArg listModelsQueryParamArg, QueryParamArg queryParamArg)
{
var birthDateFromAge = DateTime.Now.AddYears(-listModelsQueryParamArg.AgeFrom);
var birthDateThruAge = DateTime.Now.AddYears(-(listModelsQueryParamArg.ThruAge + 1));
var result =
ModelManagementContext()
.Users.Where(
t =>
t.IsUserActivated == "Y" && t.StatusId == Utility.StatusEnabled &&
t.UserRoleId_UserRoles.Any(l => l.RoleTypeId == Utility.RoleTypeModel) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.Sex) ||
t.PersonId_PersonalInformation.Sex == listModelsQueryParamArg.Sex) &&
(listModelsQueryParamArg.CategoryTypeIds.Count == 0 ||
t.PersonId_PersonalInformation.Categories_PersonId.Any(
c => listModelsQueryParamArg.CategoryTypeIds.Contains(c.CategoryTypeId))
) &&
(listModelsQueryParamArg.HeightFrom == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.Height >=
listModelsQueryParamArg.HeightFrom) &&
(listModelsQueryParamArg.HeightThru == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.Height <=
listModelsQueryParamArg.HeightThru) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.CategoryTypeId) ||
t.PersonId_PersonalInformation.Categories_PersonId
.Any(c => c.CategoryTypeId == listModelsQueryParamArg.CategoryTypeId)
) &&
(listModelsQueryParamArg.AgeFrom == 0 ||
(t.PersonId_PersonalInformation.DateOfBirth.Value.Year <= birthDateFromAge.Year &&
(birthDateFromAge.Year - t.PersonId_PersonalInformation.DateOfBirth.Value.Year > 0 ||
t.PersonId_PersonalInformation.DateOfBirth.Value.Month <= birthDateFromAge.Month)
)) &&
(listModelsQueryParamArg.ThruAge == 0 ||
(t.PersonId_PersonalInformation.DateOfBirth.Value.Year >= birthDateThruAge.Year &&
(t.PersonId_PersonalInformation.DateOfBirth.Value.Year - birthDateThruAge.Year > 0 ||
t.PersonId_PersonalInformation.DateOfBirth.Value.Month > birthDateThruAge.Month)
)) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.Complexion) ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.Complexion ==
listModelsQueryParamArg.Complexion) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.CountryGeoId) ||
t.PersonId_PersonalInformation.CountryGeoId == listModelsQueryParamArg.CountryGeoId) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.CityGeoId) ||
t.PersonId_PersonalInformation.CityGeoId == listModelsQueryParamArg.CityGeoId) &&
(listModelsQueryParamArg.BmiFrom == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.BmI >=
listModelsQueryParamArg.BmiFrom) &&
(listModelsQueryParamArg.BmiThru == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.BmI <=
listModelsQueryParamArg.BmiThru) &&
(listModelsQueryParamArg.WeightFrom == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.Weight >=
listModelsQueryParamArg.WeightFrom) &&
(listModelsQueryParamArg.WeightThru == null ||
t.PersonId_PersonalInformation.PersonId_PhysicalInformation.Weight <=
listModelsQueryParamArg.WeightThru) &&
(listModelsQueryParamArg.SelectedCities.Count == 0 ||
listModelsQueryParamArg.SelectedCities.Contains(t.PersonId_PersonalInformation.CityGeoId)) &&
(string.IsNullOrEmpty(listModelsQueryParamArg.ExperienceId) ||
t.PersonId_PersonalInformation.ExperienceEnumId == listModelsQueryParamArg.ExperienceId)
);
return(result.QueryResultList <ModelListModel>(queryParamArg));
}
public QueryResult Execute()
{
QueryParamArg.SetDefaultSortColumn("SequenceId");
return(new CommonDataQueryAppService().ListStatusItem(StatusTypeId, QueryParamArg));
}
public QueryResult ListPersonalInfo(PersonalInfoQueryParamArg personalInfoQueryParam, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.Users.Where(
t =>
string.IsNullOrEmpty(personalInfoQueryParam.RoleTypeId) ||
t.UserRoleId_UserRoles.Any(
r => r.RoleTypeId == personalInfoQueryParam.RoleTypeId) &&
(string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.Description.Contains(queryParamArg.SearchText) ||
t.PersonId_PersonalInformation.FirstName.Contains(queryParamArg.SearchText) ||
t.PersonId_PersonalInformation.FatherName.Contains(queryParamArg.SearchText) ||
t.TaxId.Contains(queryParamArg.SearchText)))
.QueryResultList <ModelListModel>(queryParamArg));
}
public QueryResult ListJobPost(string userId, string statusId, string isActive, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobPosts.Where(
t =>
t.UserId == userId && (string.IsNullOrEmpty(statusId) || t.StatusId == statusId) &&
(string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.JobTitle.Contains(queryParamArg.SearchText) ||
t.JobDescription.Contains(queryParamArg.SearchText)) &&
(string.IsNullOrEmpty(isActive) || t.IsActive == isActive)
)
.QueryResultList <JobPostListModel>(queryParamArg));
}
public QueryResult ListOpenJobPost(JobPostQueryParamArg jobPostQueryParamArg, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobPosts.Where(
t =>
t.IsActive == "Y" &&
(string.IsNullOrEmpty(jobPostQueryParamArg.Sex) || t.Sex == jobPostQueryParamArg.Sex) &&
(string.IsNullOrEmpty(jobPostQueryParamArg.JobLocation) ||
t.JobLocation == jobPostQueryParamArg.JobLocation) &&
(jobPostQueryParamArg.AgeFrom == null || t.AgeFrom >= jobPostQueryParamArg.AgeFrom) &&
(jobPostQueryParamArg.AgeThru == null || t.AgeThru <= jobPostQueryParamArg.AgeThru) &&
(jobPostQueryParamArg.HeightFrom == null || t.HeightFrom >= jobPostQueryParamArg.HeightFrom) &&
(jobPostQueryParamArg.HeightThru == null || t.HeightThru <= jobPostQueryParamArg.HeightThru) &&
(jobPostQueryParamArg.JobLocations.Count == 0 ||
jobPostQueryParamArg.JobLocations.Contains(t.JobLocationGeoId)) &&
(string.IsNullOrEmpty(jobPostQueryParamArg.StatusId) ||
jobPostQueryParamArg.StatusId == t.StatusId) &&
(string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.JobTitle.Contains(queryParamArg.SearchText) ||
t.JobDescription.Contains(queryParamArg.SearchText)))
.QueryResultList <JobPostListModel>(queryParamArg));
}
public QueryResult LookupContactMechType(QueryParamArg queryParamArg)
{
return(ModelManagementContext().ContactMechTypes.Where(t => t.IsActive == "Y").QueryResultList <KeyDescription>(queryParamArg));
}
public QueryResult Execute()
{
QueryParamArg.SetDefaultSortColumn();
return(new CommonDataQueryAppService().ListOfferItemType(OfferTypeId, QueryParamArg));
}
