/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
var filterRequest = (AppAnnouncementMaintenanceListRequest)request;
var filterQuery = (IQueryable <AppAnnouncement>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.Subject))
{
filterQuery = filterQuery.Where(p => p.Subject.Contains(filterRequest.Subject));
}
if (!String.IsNullOrEmpty(filterRequest.AnnouncementText))
{
filterQuery = filterQuery.Where(p => p.AnnouncementText.Contains(filterRequest.AnnouncementText));
}
if (filterRequest.EffectiveDateStart != null)
{
filterQuery = filterQuery.Where(p => p.EffectiveDate >= filterRequest.EffectiveDateStart);
}
if (filterRequest.EffectiveDateEnd != null)
{
//Add 1 day to the end date and subtract a millisecond so we get all users who logged in on the end date
var endDate = filterRequest.EffectiveDateEnd.Value.EndDateTime();
filterQuery = filterQuery.Where(p => p.EffectiveDate <= endDate);
}
return((IQueryable <T>)filterQuery);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as AppCodeDetailMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "CodeGroup ASC, Sort ASC, CodeValue ASC";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as AppAnnouncementMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "ForceToTopOfList DESC, EffectiveDate ASC, Sort ASC";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as SecurityRoleMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "Name ASC, Description ASC, ADGroupName ASC";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest<T, R>(BaseServiceListRequest request)
{
var listRequest = request as AppMenuItemMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "Name ASC";
}
return null;
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as AppVariableMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "VariableGroup ASC, VariableName ASC, VariableValue ASC";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as SecurityActionMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "SecurityActionId ASC";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
SecurityUserMaintenanceListRequest listRequest = request as SecurityUserMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "UserName";
}
return(null);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <typeparam name="R">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override R OnValidateListRequest <T, R>(BaseServiceListRequest request)
{
var listRequest = request as AppEmailTemplateMaintenanceListRequest;
if (string.IsNullOrEmpty(listRequest.OrderBy) == true)
{
listRequest.OrderBy = "TemplateCode ASC";
}
return(null);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
var filterRequest = (SecurityQuestionMaintenanceListRequest)request;
var filterQuery = (IQueryable <SecurityQuestion>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.Question))
{
filterQuery = filterQuery.Where(p => p.Question.Contains(filterRequest.Question));
}
return((IQueryable <T>)filterQuery);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <TEntity> ApplyListFilter <TEntity>(BaseServiceListRequest request, IQueryable <TEntity> query)
{
var filterRequest = (WebsiteDataEntityPagedListRequest)request;
var filterQuery = (IQueryable <CStore.Domain.Entities.WebsiteData>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.SearchText))
{
filterQuery = filterQuery.Where(p => p.Title.Contains(filterRequest.SearchText) || p.ImgLink.Contains(filterRequest.SearchText) || p.Description.Contains(filterRequest.SearchText));
}
return((IQueryable <TEntity>)filterQuery);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
SecurityUserMaintenanceListRequest listRequest = request as SecurityUserMaintenanceListRequest;
var listQuery = (IQueryable <VWSecurityUser>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(listRequest.UserName))
{
listQuery = listQuery.Where(p => p.UserName.Contains(listRequest.UserName));
}
if (!String.IsNullOrEmpty(listRequest.LastName))
{
listQuery = listQuery.Where(p => p.LastName.Contains(listRequest.LastName));
}
if (!String.IsNullOrEmpty(listRequest.FirstName))
{
listQuery = listQuery.Where(p => p.FirstName.Contains(listRequest.FirstName));
}
if (listRequest.SecurityRoleIds != null && listRequest.SecurityRoleIds.Any())
{
listQuery = listQuery.Where(p => p.RoleMemberships.Any(s => listRequest.SecurityRoleIds.Contains(s.SecurityRoleId)));
}
if (listRequest.SystemAdmin != null && listRequest.SystemAdmin.Value)
{
listQuery = listQuery.Where(p => p.SystemAdmin == true);
}
if (listRequest.Active != null && listRequest.Active.Value)
{
listQuery = listQuery.Where(p => p.Active == true);
}
if (listRequest.LastLoginDateStart != null)
{
listQuery = listQuery.Where(p => p.LastLoginDate >= listRequest.LastLoginDateStart);
}
if (listRequest.LastLoginDateEnd != null)
{
//Add 1 day to the end date and subtract a millisecond so we get all users who logged in on the end date
var endDate = listRequest.LastLoginDateEnd.Value.AddDays(1).AddMilliseconds(-1);
listQuery = listQuery.Where(p => p.LastLoginDate <= endDate);
}
return((IQueryable <T>)listQuery);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
var filterRequest = (AppVariableMaintenanceListRequest)request;
var filterQuery = (IQueryable <AppVariable>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.VariableGroup))
{
filterQuery = filterQuery.Where(p => p.VariableGroup.Contains(filterRequest.VariableGroup));
}
if (!String.IsNullOrEmpty(filterRequest.VariableName))
{
filterQuery = filterQuery.Where(p => p.VariableName.Contains(filterRequest.VariableName));
}
if (!String.IsNullOrEmpty(filterRequest.VariableValue))
{
filterQuery = filterQuery.Where(p => p.VariableValue.Contains(filterRequest.VariableValue));
}
return((IQueryable <T>)filterQuery);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
var filterRequest = (AppMenuMaintenanceListRequest)request;
var filterQuery = (IQueryable <AppMenu>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.MenuCode))
{
filterQuery = filterQuery.Where(p => p.MenuCode.Contains(filterRequest.MenuCode));
}
if (!String.IsNullOrEmpty(filterRequest.Name))
{
filterQuery = filterQuery.Where(p => p.Name.Contains(filterRequest.Name));
}
if (!String.IsNullOrEmpty(filterRequest.Description))
{
filterQuery = filterQuery.Where(p => p.Description.Contains(filterRequest.Description));
}
return((IQueryable <T>)filterQuery);
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable<T> ApplyListFilter<T>(BaseServiceListRequest request, IQueryable<T> query)
{
var filterRequest = (AppMenuItemMaintenanceListRequest)request;
var filterQuery = (IQueryable<AppMenuItem>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.ParentAppMenuItemId))
{
filterQuery = filterQuery.Where(p => p.AppMenuItemId.ToString() == filterRequest.ParentAppMenuItemId);
}
if (!String.IsNullOrEmpty(filterRequest.AppMenuId))
{
filterQuery = filterQuery.Where(p => p.AppMenuId.ToString().Contains(filterRequest.AppMenuId));
}
if (!String.IsNullOrEmpty(filterRequest.Name))
{
filterQuery = filterQuery.Where(p => p.Name.Contains(filterRequest.Name));
}
if (!String.IsNullOrEmpty(filterRequest.Handler))
{
filterQuery = filterQuery.Where(p => p.Handler.Contains(filterRequest.Handler));
}
if (!String.IsNullOrEmpty(filterRequest.Text))
{
filterQuery = filterQuery.Where(p => p.Text.Contains(filterRequest.Text));
}
if (!String.IsNullOrEmpty(filterRequest.Style))
{
filterQuery = filterQuery.Where(p => p.Style.Contains(filterRequest.Style));
}
if (!String.IsNullOrEmpty(filterRequest.ToolTip))
{
filterQuery = filterQuery.Where(p => p.ToolTip.Contains(filterRequest.ToolTip));
}
return (IQueryable<T>)filterQuery;
}
/// <summary>
/// Apply List Filter - Applies the Filters from the Request to the Query
/// </summary>
/// <typeparam name="T">Entity Type</typeparam>
/// <param name="request">Request Type</param>
/// <param name="query">Query</param>
/// <returns>Updated Query</returns>
public override IQueryable <T> ApplyListFilter <T>(BaseServiceListRequest request, IQueryable <T> query)
{
var filterRequest = (AppCodeDetailMaintenanceListRequest)request;
var filterQuery = (IQueryable <AppCodeDetail>)query;
// apply filters to the IQueryable
if (!String.IsNullOrEmpty(filterRequest.CodeGroup))
{
filterQuery = filterQuery.Where(p => p.CodeGroup.Contains(filterRequest.CodeGroup));
}
if (!String.IsNullOrEmpty(filterRequest.CodeValue))
{
filterQuery = filterQuery.Where(p => p.CodeValue.Contains(filterRequest.CodeValue));
}
if (!String.IsNullOrEmpty(filterRequest.Description))
{
filterQuery = filterQuery.Where(p => p.Description.Contains(filterRequest.Description));
}
if (filterRequest.Active)
{
filterQuery = filterQuery.Where(p => p.Active == true);
}
return((IQueryable <T>)filterQuery);
}
/// <summary>
/// Method To Allow Additional Custom Updates to the response of the List method.
/// </summary>
/// <param name="request">Request</param>
/// <param name="response">Response</param>
/// <returns>Response</returns>
public override TResponse OnListResponse <TEntity, TResponse>(BaseServiceListRequest request, TResponse response)
{
var listRequest = request as WebsiteDataEntityPagedListRequest;
return(response);
}
/// <summary>
/// On Validate List Request / Used for Custom Validation or Tweaking of Parameters
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <typeparam name="TResponse">Request Type</typeparam>
/// <param name="request">Request</param>
/// <returns>Response</returns>
public override TResponse OnValidateListRequest <TEntity, TResponse>(BaseServiceListRequest request)
{
var listRequest = request as WebsiteDataEntityPagedListRequest;
return(null);
}
/// <summary>
/// Create the IQueryable object for the list so we can include additional navigation properties.
/// </summary>
/// <param name="request"></param>
public override IQueryable<TEntity> CreateListIQueryable<TEntity>(BaseServiceListRequest request, IRepository repository)
{
return _repository.GetAll<AppMenuItem>(p => p.AppMenu) as IQueryable<TEntity>;
}
/// <summary>
/// Create the IQueryable object for the list so we can include additional navigation properties.
/// </summary>
/// <param name="request"></param>
public override IQueryable <TEntity> CreateListIQueryable <TEntity>(BaseServiceListRequest request, IRepository repository)
{
return(_repository.GetAll <SecuritySecurable>(p => p.ParentSecuritySecurable) as IQueryable <TEntity>);
}