protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (HomepageCategoryIdList != null && HomepageCategoryIdList.Count > 0)
{
JoinableList list = new JoinableList(HomepageCategoryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", HomepageCategory.Columns.HomepageCategoryId));
}
if (HomepageCategoryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@homepageCategoryId", HomepageCategory.Columns.HomepageCategoryId));
sb.AddDataParameter("@homepageCategoryId", HomepageCategoryId.Value);
}
if (HomepageId != 0)
{
sb.Criteria.Add(string.Format("{0}=@homepageId", HomepageCategory.Columns.HomepageId));
sb.AddDataParameter("@homepageId", HomepageId);
}
if (CategoryId != 0)
{
sb.Criteria.Add(string.Format("{0}=@categoryId", HomepageCategory.Columns.CategoryId));
sb.AddDataParameter("@categoryId", CategoryId);
}
if (OrderBy != 0)
{
sb.Criteria.Add(string.Format("{0}=@orderBy", HomepageCategory.Columns.OrderBy));
sb.AddDataParameter("@orderBy", OrderBy);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetLinkIdList != null && AssetLinkIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetLinkIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetLink.Columns.AssetLinkId));
}
if (AssetLinkId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetLinkId", AssetLink.Columns.AssetLinkId));
sb.AddDataParameter("@assetLinkId", AssetLinkId.Value);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", AssetLink.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (LinkedAssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@linkedAssetId", AssetLink.Columns.LinkedAssetId));
sb.AddDataParameter("@linkedAssetId", LinkedAssetId);
}
if (LinkedAssetTitle != String.Empty)
{
sb.Criteria.Add("LinkedAssetTitle=@linkedAssetTitle");
sb.AddDataParameter("@linkedAssetTitle", LinkedAssetTitle);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (CompanyBrandIdList != null && CompanyBrandIdList.Count > 0)
{
JoinableList list = new JoinableList(CompanyBrandIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", CompanyBrand.Columns.CompanyBrandId));
}
if (CompanyBrandId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@companyBrandId", CompanyBrand.Columns.CompanyBrandId));
sb.AddDataParameter("@companyBrandId", CompanyBrandId.Value);
}
if (CompanyId != 0)
{
sb.Criteria.Add(string.Format("{0}=@companyId", CompanyBrand.Columns.CompanyId));
sb.AddDataParameter("@companyId", CompanyId);
}
if (BrandId != 0)
{
sb.Criteria.Add(string.Format("{0}=@brandId", CompanyBrand.Columns.BrandId));
sb.AddDataParameter("@brandId", BrandId);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (CountryIdList != null && CountryIdList.Count > 0)
{
JoinableList list = new JoinableList(CountryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Country.Columns.CountryId));
}
if (CountryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@countryId", Country.Columns.CountryId));
sb.AddDataParameter("@countryId", CountryId.Value);
}
if (Code != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@code", Country.Columns.Code));
sb.AddDataParameter("@code", Code);
}
if (Name != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@name", Country.Columns.Name));
sb.AddDataParameter("@name", Name);
}
if (Rank != 0)
{
sb.Criteria.Add(string.Format("{0}=@rank", Country.Columns.Rank));
sb.AddDataParameter("@rank", Rank);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (UserPasswordHistoryIdList != null && UserPasswordHistoryIdList.Count > 0)
{
JoinableList list = new JoinableList(UserPasswordHistoryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", UserPasswordHistory.Columns.UserPasswordHistoryId));
}
if (UserPasswordHistoryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@userPasswordHistoryId", UserPasswordHistory.Columns.UserPasswordHistoryId));
sb.AddDataParameter("@userPasswordHistoryId", UserPasswordHistoryId.Value);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", UserPasswordHistory.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (Password != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@password", UserPasswordHistory.Columns.Password));
sb.AddDataParameter("@password", Password);
}
if (Date != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@date", UserPasswordHistory.Columns.Date));
sb.AddDataParameter("@date", Date);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (HomepageTypeIdList != null && HomepageTypeIdList.Count > 0)
{
JoinableList list = new JoinableList(HomepageTypeIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", HomepageType.Columns.HomepageTypeId));
}
if (HomepageTypeId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@homepageTypeId", HomepageType.Columns.HomepageTypeId));
sb.AddDataParameter("@homepageTypeId", HomepageTypeId.Value);
}
if (Description != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@description", HomepageType.Columns.Description));
sb.AddDataParameter("@description", Description);
}
if (ShortName != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@shortName", HomepageType.Columns.ShortName));
sb.AddDataParameter("@shortName", ShortName);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AuditAssetSearchKeywordIdList != null && AuditAssetSearchKeywordIdList.Count > 0)
{
JoinableList list = new JoinableList(AuditAssetSearchKeywordIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AuditAssetSearchKeyword.Columns.AuditAssetSearchKeywordId));
}
if (AuditAssetSearchKeywordId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@auditAssetSearchKeywordId", AuditAssetSearchKeyword.Columns.AuditAssetSearchKeywordId));
sb.AddDataParameter("@auditAssetSearchKeywordId", AuditAssetSearchKeywordId.Value);
}
if (AuditAssetSearchId != 0)
{
sb.Criteria.Add(string.Format("{0}=@auditAssetSearchId", AuditAssetSearchKeyword.Columns.AuditAssetSearchId));
sb.AddDataParameter("@auditAssetSearchId", AuditAssetSearchId);
}
if (SearchKeyword != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@searchKeyword", AuditAssetSearchKeyword.Columns.SearchKeyword));
sb.AddDataParameter("@searchKeyword", SearchKeyword);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AuditAssetSearchResultIdList != null && AuditAssetSearchResultIdList.Count > 0)
{
JoinableList list = new JoinableList(AuditAssetSearchResultIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AuditAssetSearchResult.Columns.AuditAssetSearchResultId));
}
if (AuditAssetSearchResultId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@auditAssetSearchResultId", AuditAssetSearchResult.Columns.AuditAssetSearchResultId));
sb.AddDataParameter("@auditAssetSearchResultId", AuditAssetSearchResultId.Value);
}
if (AuditAssetSearchId != 0)
{
sb.Criteria.Add(string.Format("{0}=@auditAssetSearchId", AuditAssetSearchResult.Columns.AuditAssetSearchId));
sb.AddDataParameter("@auditAssetSearchId", AuditAssetSearchId);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", AuditAssetSearchResult.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (Date != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@date", AuditAssetSearchResult.Columns.Date));
sb.AddDataParameter("@date", Date);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetFilePathIdList != null && AssetFilePathIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetFilePathIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetFilePath.Columns.AssetFilePathId));
}
if (AssetFilePathId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetFilePathId", AssetFilePath.Columns.AssetFilePathId));
sb.AddDataParameter("@assetFilePathId", AssetFilePathId.Value);
}
if (Path != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@path", AssetFilePath.Columns.Path));
sb.AddDataParameter("@path", Path);
}
if (IsDefault.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isDefault", AssetFilePath.Columns.IsDefault));
sb.AddDataParameter("@isDefault", SqlUtils.BitValue(IsDefault.Value));
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (LightboxIdList != null && LightboxIdList.Count > 0)
{
JoinableList list = new JoinableList(LightboxIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Lightbox.Columns.LightboxId));
}
if (LightboxId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@lightboxId", Lightbox.Columns.LightboxId));
sb.AddDataParameter("@lightboxId", LightboxId.Value);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", Lightbox.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (Name != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@name", Lightbox.Columns.Name));
sb.AddDataParameter("@name", Name);
}
if (Summary != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@summary", Lightbox.Columns.Summary));
sb.AddDataParameter("@summary", Summary);
}
if (Notes != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@notes", Lightbox.Columns.Notes));
sb.AddDataParameter("@notes", Notes);
}
if (IsPublic.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isPublic", Lightbox.Columns.IsPublic));
sb.AddDataParameter("@isPublic", SqlUtils.BitValue(IsPublic.Value));
}
if (IsDefault.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isDefault", Lightbox.Columns.IsDefault));
sb.AddDataParameter("@isDefault", SqlUtils.BitValue(IsDefault.Value));
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", Lightbox.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetWorkflowIdList != null && AssetWorkflowIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetWorkflowIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetWorkflow.Columns.AssetWorkflowId));
}
if (AssetWorkflowId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetWorkflowId", AssetWorkflow.Columns.AssetWorkflowId));
sb.AddDataParameter("@assetWorkflowId", AssetWorkflowId.Value);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", AssetWorkflow.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (SubmittedByUserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@submittedByUserId", AssetWorkflow.Columns.SubmittedByUserId));
sb.AddDataParameter("@submittedByUserId", SubmittedByUserId);
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", AssetWorkflow.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
if (IsComplete.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isComplete", AssetWorkflow.Columns.IsComplete));
sb.AddDataParameter("@isComplete", SqlUtils.BitValue(IsComplete.Value));
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (IpAddressIdList != null && IpAddressIdList.Count > 0)
{
JoinableList list = new JoinableList(IpAddressIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", IpAddress.Columns.IpAddressId));
}
if (IpAddressId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@ipAddressId", IpAddress.Columns.IpAddressId));
sb.AddDataParameter("@ipAddressId", IpAddressId.Value);
}
if (IpAddressValue != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@ipAddressValue", IpAddress.Columns.IpAddressValue));
sb.AddDataParameter("@ipAddressValue", IpAddressValue);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (CompanyIdList != null && CompanyIdList.Count > 0)
{
JoinableList list = new JoinableList(CompanyIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Company.Columns.CompanyId));
}
if (CompanyId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@companyId", Company.Columns.CompanyId));
sb.AddDataParameter("@companyId", CompanyId.Value);
}
if (Name != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@name", Company.Columns.Name));
sb.AddDataParameter("@name", Name);
}
if (Brands != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@brands", Company.Columns.Brands));
sb.AddDataParameter("@brands", Brands);
}
if (Domain != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@domain", Company.Columns.Domain));
sb.AddDataParameter("@domain", Domain);
}
if (IsInternal.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isInternal", Company.Columns.IsInternal));
sb.AddDataParameter("@isInternal", SqlUtils.BitValue(IsInternal.Value));
}
if (CreatedByUserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@createdByUserId", Company.Columns.CreatedByUserId));
sb.AddDataParameter("@createdByUserId", CreatedByUserId);
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", Company.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetFileIdList != null && AssetFileIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetFileIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetFile.Columns.AssetFileId));
}
if (AssetFileId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetFileId", AssetFile.Columns.AssetFileId));
sb.AddDataParameter("@assetFileId", AssetFileId.Value);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", AssetFile.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (FileContent != null)
{
sb.Criteria.Add(string.Format("{0}=@fileContent", AssetFile.Columns.FileContent));
sb.AddDataParameter("@fileContent", FileContent);
}
if (Filename != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@filename", AssetFile.Columns.Filename));
sb.AddDataParameter("@filename", Filename);
}
if (FileExtension != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@fileExtension", AssetFile.Columns.FileExtension));
sb.AddDataParameter("@fileExtension", FileExtension);
}
if (AssetFileTypeId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetFileTypeId", AssetFile.Columns.AssetFileTypeId));
sb.AddDataParameter("@assetFileTypeId", AssetFileTypeId);
}
if (LastUpdate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@lastUpdate", AssetFile.Columns.LastUpdate));
sb.AddDataParameter("@lastUpdate", LastUpdate);
}
SetCustomSearchCriteria(ref sb);
}
protected void SetCustomSearchCriteria(ref SearchBuilder sb)
{
if (OnlyDistinctAssetIds)
{
sb.TableAlias = "AAH";
sb.Fields.Add("DISTINCT AssetId");
}
if (IncludeActionsList.Count > 0)
{
JoinableList jList = new JoinableList(" OR ");
foreach (AuditAssetAction auditAssetAction in IncludeActionsList)
{
string criteria = string.Format("{0}={1}", AuditAssetHistory.Columns.AuditAssetActionId, Convert.ToInt32(auditAssetAction));
jList.Add(criteria);
}
sb.Criteria.Add(jList.ToString());
}
if (!StringUtils.IsBlank(UserEmail))
{
sb.Criteria.Add("[UserEmail] = @userEmail");
sb.AddDataParameter("@userEmail", UserEmail);
}
if (BrandId != 0)
{
sb.Criteria.Add(string.Format("AssetBrandId={0}", BrandId));
}
if (StartDate.HasValue)
{
string criteria = string.Format("[Date] >= '{0}'", StartDate.Value.ToString("yyyy-MM-dd"));
sb.Criteria.Add(criteria);
}
if (EndDate.HasValue)
{
string criteria = string.Format("[Date] <= '{0}'", EndDate.Value.ToString("yyyy-MM-dd"));
sb.Criteria.Add(criteria);
}
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (CartIdList != null && CartIdList.Count > 0)
{
JoinableList list = new JoinableList(CartIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Cart.Columns.CartId));
}
if (CartId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@cartId", Cart.Columns.CartId));
sb.AddDataParameter("@cartId", CartId.Value);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", Cart.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", Cart.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (Notes != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@notes", Cart.Columns.Notes));
sb.AddDataParameter("@notes", Notes);
}
if (RequiredByDate != null)
{
sb.Criteria.Add(string.Format("{0}=@requiredByDate", Cart.Columns.RequiredByDate));
sb.AddDataParameter("@requiredByDate", RequiredByDate.Value);
}
if (DateAdded != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@dateAdded", Cart.Columns.DateAdded));
sb.AddDataParameter("@dateAdded", DateAdded);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetImageSizeIdList != null && AssetImageSizeIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetImageSizeIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetImageSize.Columns.AssetImageSizeId));
}
if (AssetImageSizeId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetImageSizeId", AssetImageSize.Columns.AssetImageSizeId));
sb.AddDataParameter("@assetImageSizeId", AssetImageSizeId.Value);
}
if (Description != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@description", AssetImageSize.Columns.Description));
sb.AddDataParameter("@description", Description);
}
if (Height != 0)
{
sb.Criteria.Add(string.Format("{0}=@height", AssetImageSize.Columns.Height));
sb.AddDataParameter("@height", Height);
}
if (Width != 0)
{
sb.Criteria.Add(string.Format("{0}=@width", AssetImageSize.Columns.Width));
sb.AddDataParameter("@width", Width);
}
if (DotsPerInch != 0)
{
sb.Criteria.Add(string.Format("{0}=@dotsPerInch", AssetImageSize.Columns.DotsPerInch));
sb.AddDataParameter("@dotsPerInch", DotsPerInch);
}
if (FileSuffix != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@fileSuffix", AssetImageSize.Columns.FileSuffix));
sb.AddDataParameter("@fileSuffix", FileSuffix);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (OrderItemCommentIdList != null && OrderItemCommentIdList.Count > 0)
{
JoinableList list = new JoinableList(OrderItemCommentIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", OrderItemComment.Columns.OrderItemCommentId));
}
if (OrderItemCommentId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@orderItemCommentId", OrderItemComment.Columns.OrderItemCommentId));
sb.AddDataParameter("@orderItemCommentId", OrderItemCommentId.Value);
}
if (OrderItemId != 0)
{
sb.Criteria.Add(string.Format("{0}=@orderItemId", OrderItemComment.Columns.OrderItemId));
sb.AddDataParameter("@orderItemId", OrderItemId);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", OrderItemComment.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (CommentText != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@commentText", OrderItemComment.Columns.CommentText));
sb.AddDataParameter("@commentText", CommentText);
}
if (CommentDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@commentDate", OrderItemComment.Columns.CommentDate));
sb.AddDataParameter("@commentDate", CommentDate);
}
if (UserFullName != String.Empty)
{
sb.Criteria.Add("UserFullName=@userFullName");
sb.AddDataParameter("@userFullName", UserFullName);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AuditUserHistoryIdList != null && AuditUserHistoryIdList.Count > 0)
{
JoinableList list = new JoinableList(AuditUserHistoryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AuditUserHistory.Columns.AuditUserHistoryId));
}
if (AuditUserHistoryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@auditUserHistoryId", AuditUserHistory.Columns.AuditUserHistoryId));
sb.AddDataParameter("@auditUserHistoryId", AuditUserHistoryId.Value);
}
if (SessionId != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@sessionId", AuditUserHistory.Columns.SessionId));
sb.AddDataParameter("@sessionId", SessionId);
}
if (IpAddress != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@ipAddress", AuditUserHistory.Columns.IpAddress));
sb.AddDataParameter("@ipAddress", IpAddress);
}
if (AuditUserActionId != 0)
{
sb.Criteria.Add(string.Format("{0}=@auditUserActionId", AuditUserHistory.Columns.AuditUserActionId));
sb.AddDataParameter("@auditUserActionId", AuditUserActionId);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", AuditUserHistory.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (Notes != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@notes", AuditUserHistory.Columns.Notes));
sb.AddDataParameter("@notes", Notes);
}
if (Date != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@date", AuditUserHistory.Columns.Date));
sb.AddDataParameter("@date", Date);
}
if (Description != String.Empty)
{
sb.Criteria.Add("Description=@description");
sb.AddDataParameter("@description", Description);
}
if (UserName != String.Empty)
{
sb.Criteria.Add("UserName=@userName");
sb.AddDataParameter("@userName", UserName);
}
if (UserEmail != String.Empty)
{
sb.Criteria.Add("UserEmail=@userEmail");
sb.AddDataParameter("@userEmail", UserEmail);
}
if (PrimaryBrandId.HasValue)
{
if (PrimaryBrandId.Value == 0)
{
sb.Criteria.Add("PrimaryBrandId IS NULL");
}
else
{
sb.Criteria.Add("PrimaryBrandId=@primaryBrandId");
sb.AddDataParameter("@primaryBrandId", PrimaryBrandId.Value);
}
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (CategoryIdList != null && CategoryIdList.Count > 0)
{
JoinableList list = new JoinableList(CategoryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Category.Columns.CategoryId));
}
if (CategoryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@categoryId", Category.Columns.CategoryId));
sb.AddDataParameter("@categoryId", CategoryId.Value);
}
if (ParentCategoryId != null)
{
sb.Criteria.Add(string.Format("{0}=@parentCategoryId", Category.Columns.ParentCategoryId));
sb.AddDataParameter("@parentCategoryId", ParentCategoryId.Value);
}
if (BrandId != 0)
{
sb.Criteria.Add(string.Format("{0}=@brandId", Category.Columns.BrandId));
sb.AddDataParameter("@brandId", BrandId);
}
if (Name != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@name", Category.Columns.Name));
sb.AddDataParameter("@name", Name);
}
if (ExternalRef != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@externalRef", Category.Columns.ExternalRef));
sb.AddDataParameter("@externalRef", ExternalRef);
}
if (Message != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@message", Category.Columns.Message));
sb.AddDataParameter("@message", Message);
}
if (Synonyms != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@synonyms", Category.Columns.Synonyms));
sb.AddDataParameter("@synonyms", Synonyms);
}
if (OwnerUserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@ownerUserId", Category.Columns.OwnerUserId));
sb.AddDataParameter("@ownerUserId", OwnerUserId);
}
if (CategoryOrder != 0)
{
sb.Criteria.Add(string.Format("{0}=@categoryOrder", Category.Columns.CategoryOrder));
sb.AddDataParameter("@categoryOrder", CategoryOrder);
}
if (FullAssetCount != 0)
{
sb.Criteria.Add(string.Format("{0}=@fullAssetCount", Category.Columns.FullAssetCount));
sb.AddDataParameter("@fullAssetCount", FullAssetCount);
}
if (AvailableAssetCount != 0)
{
sb.Criteria.Add(string.Format("{0}=@availableAssetCount", Category.Columns.AvailableAssetCount));
sb.AddDataParameter("@availableAssetCount", AvailableAssetCount);
}
if (OwnerEmail != String.Empty)
{
sb.Criteria.Add("OwnerEmail=@ownerEmail");
sb.AddDataParameter("@ownerEmail", OwnerEmail);
}
if (OwnerName != String.Empty)
{
sb.Criteria.Add("OwnerName=@ownerName");
sb.AddDataParameter("@ownerName", OwnerName);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetCategoryIdList != null && AssetCategoryIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetCategoryIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetCategory.Columns.AssetCategoryId));
}
if (AssetCategoryId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetCategoryId", AssetCategory.Columns.AssetCategoryId));
sb.AddDataParameter("@assetCategoryId", AssetCategoryId.Value);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", AssetCategory.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (CategoryId != 0)
{
sb.Criteria.Add(string.Format("{0}=@categoryId", AssetCategory.Columns.CategoryId));
sb.AddDataParameter("@categoryId", CategoryId);
}
if (IsPrimary.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isPrimary", AssetCategory.Columns.IsPrimary));
sb.AddDataParameter("@isPrimary", SqlUtils.BitValue(IsPrimary.Value));
}
if (Name != String.Empty)
{
sb.Criteria.Add("Name=@name");
sb.AddDataParameter("@name", Name);
}
if (ParentCategoryId.HasValue)
{
if (ParentCategoryId.Value == 0)
{
sb.Criteria.Add("ParentCategoryId IS NULL");
}
else
{
sb.Criteria.Add("ParentCategoryId=@parentCategoryId");
sb.AddDataParameter("@parentCategoryId", ParentCategoryId.Value);
}
}
if (Synonyms != String.Empty)
{
sb.Criteria.Add("Synonyms=@synonyms");
sb.AddDataParameter("@synonyms", Synonyms);
}
if (CategoryOrder.HasValue)
{
if (CategoryOrder.Value == 0)
{
sb.Criteria.Add("CategoryOrder IS NULL");
}
else
{
sb.Criteria.Add("CategoryOrder=@categoryOrder");
sb.AddDataParameter("@categoryOrder", CategoryOrder.Value);
}
}
if (NameAndSynonyms != String.Empty)
{
sb.Criteria.Add("NameAndSynonyms=@nameAndSynonyms");
sb.AddDataParameter("@nameAndSynonyms", NameAndSynonyms);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AuditAssetSearchIdList != null && AuditAssetSearchIdList.Count > 0)
{
JoinableList list = new JoinableList(AuditAssetSearchIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AuditAssetSearch.Columns.AuditAssetSearchId));
}
if (AuditAssetSearchId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@auditAssetSearchId", AuditAssetSearch.Columns.AuditAssetSearchId));
sb.AddDataParameter("@auditAssetSearchId", AuditAssetSearchId.Value);
}
if (SessionId != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@sessionId", AuditAssetSearch.Columns.SessionId));
sb.AddDataParameter("@sessionId", SessionId);
}
if (IpAddress != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@ipAddress", AuditAssetSearch.Columns.IpAddress));
sb.AddDataParameter("@ipAddress", IpAddress);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", AuditAssetSearch.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (Date != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@date", AuditAssetSearch.Columns.Date));
sb.AddDataParameter("@date", Date);
}
if (SearchKeyword != String.Empty)
{
sb.Criteria.Add("SearchKeyword=@searchKeyword");
sb.AddDataParameter("@searchKeyword", SearchKeyword);
}
if (AssetId.HasValue)
{
if (AssetId.Value == 0)
{
sb.Criteria.Add("AssetId IS NULL");
}
else
{
sb.Criteria.Add("AssetId=@assetId");
sb.AddDataParameter("@assetId", AssetId.Value);
}
}
if (UserName != String.Empty)
{
sb.Criteria.Add("UserName=@userName");
sb.AddDataParameter("@userName", UserName);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (OrderIdList != null && OrderIdList.Count > 0)
{
JoinableList list = new JoinableList(OrderIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Order.Columns.OrderId));
}
if (OrderId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@orderId", Order.Columns.OrderId));
sb.AddDataParameter("@orderId", OrderId.Value);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", Order.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (OrderDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@orderDate", Order.Columns.OrderDate));
sb.AddDataParameter("@orderDate", OrderDate);
}
if (CompletionDate != null)
{
sb.Criteria.Add(string.Format("{0}=@completionDate", Order.Columns.CompletionDate));
sb.AddDataParameter("@completionDate", CompletionDate.Value);
}
if (UserName != String.Empty)
{
sb.Criteria.Add("UserName=@userName");
sb.AddDataParameter("@userName", UserName);
}
if (UserEmail != String.Empty)
{
sb.Criteria.Add("UserEmail=@userEmail");
sb.AddDataParameter("@userEmail", UserEmail);
}
if (UserPrimaryBrandId.HasValue)
{
if (UserPrimaryBrandId.Value == 0)
{
sb.Criteria.Add("UserPrimaryBrandId IS NULL");
}
else
{
sb.Criteria.Add("UserPrimaryBrandId=@userPrimaryBrandId");
sb.AddDataParameter("@userPrimaryBrandId", UserPrimaryBrandId.Value);
}
}
if (UserPrimaryBrandName != String.Empty)
{
sb.Criteria.Add("UserPrimaryBrandName=@userPrimaryBrandName");
sb.AddDataParameter("@userPrimaryBrandName", UserPrimaryBrandName);
}
if (AssetCount.HasValue)
{
if (AssetCount.Value == 0)
{
sb.Criteria.Add("AssetCount IS NULL");
}
else
{
sb.Criteria.Add("AssetCount=@assetCount");
sb.AddDataParameter("@assetCount", AssetCount.Value);
}
}
if (IsPending.HasValue)
{
sb.Criteria.Add("IsPending=@isPending");
sb.AddDataParameter("@isPending", SqlUtils.BitValue(IsPending.Value));
}
if (DeadlineDate != null)
{
sb.Criteria.Add("DeadlineDate=@deadlineDate");
sb.AddDataParameter("@deadlineDate", DeadlineDate.Value);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetWorkflowCommenterIdList != null && AssetWorkflowCommenterIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetWorkflowCommenterIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetWorkflowCommenter.Columns.AssetWorkflowCommenterId));
}
if (AssetWorkflowCommenterId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetWorkflowCommenterId", AssetWorkflowCommenter.Columns.AssetWorkflowCommenterId));
sb.AddDataParameter("@assetWorkflowCommenterId", AssetWorkflowCommenterId.Value);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", AssetWorkflowCommenter.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (InvitingAssetWorkflowUserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@invitingAssetWorkflowUserId", AssetWorkflowCommenter.Columns.InvitingAssetWorkflowUserId));
sb.AddDataParameter("@invitingAssetWorkflowUserId", InvitingAssetWorkflowUserId);
}
if (InvitingUserMessage != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@invitingUserMessage", AssetWorkflowCommenter.Columns.InvitingUserMessage));
sb.AddDataParameter("@invitingUserMessage", InvitingUserMessage);
}
if (Comments != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@comments", AssetWorkflowCommenter.Columns.Comments));
sb.AddDataParameter("@comments", Comments);
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", AssetWorkflowCommenter.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
if (LastUpdate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@lastUpdate", AssetWorkflowCommenter.Columns.LastUpdate));
sb.AddDataParameter("@lastUpdate", LastUpdate);
}
if (InvitingUserId.HasValue)
{
if (InvitingUserId.Value == 0)
{
sb.Criteria.Add("InvitingUserId IS NULL");
}
else
{
sb.Criteria.Add("InvitingUserId=@invitingUserId");
sb.AddDataParameter("@invitingUserId", InvitingUserId.Value);
}
}
if (AssetWorkflowId.HasValue)
{
if (AssetWorkflowId.Value == 0)
{
sb.Criteria.Add("AssetWorkflowId IS NULL");
}
else
{
sb.Criteria.Add("AssetWorkflowId=@assetWorkflowId");
sb.AddDataParameter("@assetWorkflowId", AssetWorkflowId.Value);
}
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetWorkflowUserIdList != null && AssetWorkflowUserIdList.Count > 0)
{
JoinableList list = new JoinableList(AssetWorkflowUserIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", AssetWorkflowUser.Columns.AssetWorkflowUserId));
}
if (AssetWorkflowUserId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@assetWorkflowUserId", AssetWorkflowUser.Columns.AssetWorkflowUserId));
sb.AddDataParameter("@assetWorkflowUserId", AssetWorkflowUserId.Value);
}
if (AssetWorkflowId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetWorkflowId", AssetWorkflowUser.Columns.AssetWorkflowId));
sb.AddDataParameter("@assetWorkflowId", AssetWorkflowId);
}
if (UserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@userId", AssetWorkflowUser.Columns.UserId));
sb.AddDataParameter("@userId", UserId);
}
if (Position != 0)
{
sb.Criteria.Add(string.Format("{0}=@position", AssetWorkflowUser.Columns.Position));
sb.AddDataParameter("@position", Position);
}
if (Comments != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@comments", AssetWorkflowUser.Columns.Comments));
sb.AddDataParameter("@comments", Comments);
}
if (AssetWorkflowUserStatusId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetWorkflowUserStatusId", AssetWorkflowUser.Columns.AssetWorkflowUserStatusId));
sb.AddDataParameter("@assetWorkflowUserStatusId", AssetWorkflowUserStatusId);
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", AssetWorkflowUser.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
if (LastUpdate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@lastUpdate", AssetWorkflowUser.Columns.LastUpdate));
sb.AddDataParameter("@lastUpdate", LastUpdate);
}
if (IsDeleted.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isDeleted", AssetWorkflowUser.Columns.IsDeleted));
sb.AddDataParameter("@isDeleted", SqlUtils.BitValue(IsDeleted.Value));
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (AssetOrderHistoryId.HasValue)
{
sb.Criteria.Add("AssetOrderHistoryId=@auditAssetHistoryId");
sb.AddDataParameter("@auditAssetHistoryId", AssetOrderHistoryId.Value);
}
if (AssetId.HasValue)
{
sb.Criteria.Add("AssetId=@assetId");
sb.AddDataParameter("@assetId", AssetId.Value);
}
if (OrderId.HasValue)
{
sb.Criteria.Add("OrderId=@orderId");
sb.AddDataParameter("@orderId", OrderId.Value);
}
if (OrderDate.HasValue)
{
sb.Criteria.Add("OrderDate=@orderDate");
sb.AddDataParameter("@orderDate", OrderDate.Value);
}
if (DeadlineDate.HasValue)
{
sb.Criteria.Add("DeadlineDate=@deadlineDate");
sb.AddDataParameter("@deadlineDate", DeadlineDate.Value);
}
if (UserEmail != String.Empty)
{
sb.Criteria.Add("UserEmail=@userEmail");
sb.AddDataParameter("@userEmail", UserEmail);
}
if (UserId.HasValue)
{
sb.Criteria.Add("UserId=@userId");
sb.AddDataParameter("@userId", UserId.Value);
}
if (UserName != String.Empty)
{
sb.Criteria.Add("UserName=@userName");
sb.AddDataParameter("@userName", UserName);
}
if (Notes != String.Empty)
{
sb.Criteria.Add("Notes=@notes");
sb.AddDataParameter("@notes", Notes);
}
if (OrderItemStatusDate.HasValue)
{
sb.Criteria.Add("OrderItemStatusDate=@orderItemStatusDate");
sb.AddDataParameter("@orderItemStatusDate", OrderItemStatusDate.Value);
}
if (OrderItemStatusId.HasValue)
{
sb.Criteria.Add("OrderItemStatusId=@orderItemStatusId");
sb.AddDataParameter("@orderItemStatusId", OrderItemStatusId);
}
SetCustomSearchCriteria(ref sb);
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (HomepageIdList != null && HomepageIdList.Count > 0)
{
JoinableList list = new JoinableList(HomepageIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", Homepage.Columns.HomepageId));
}
if (HomepageId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@homepageId", Homepage.Columns.HomepageId));
sb.AddDataParameter("@homepageId", HomepageId.Value);
}
if (BrandId != 0)
{
sb.Criteria.Add(string.Format("{0}=@brandId", Homepage.Columns.BrandId));
sb.AddDataParameter("@brandId", BrandId);
}
if (IntroText != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@introText", Homepage.Columns.IntroText));
sb.AddDataParameter("@introText", IntroText);
}
if (Url1 != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@url1", Homepage.Columns.Url1));
sb.AddDataParameter("@url1", Url1);
}
if (Url2 != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@url2", Homepage.Columns.Url2));
sb.AddDataParameter("@url2", Url2);
}
if (Url3 != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@url3", Homepage.Columns.Url3));
sb.AddDataParameter("@url3", Url3);
}
if (Url4 != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@url4", Homepage.Columns.Url4));
sb.AddDataParameter("@url4", Url4);
}
if (BumperPageHtml != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@bumperPageHtml", Homepage.Columns.BumperPageHtml));
sb.AddDataParameter("@bumperPageHtml", BumperPageHtml);
}
if (BumperPageSkip.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@bumperPageSkip", Homepage.Columns.BumperPageSkip));
sb.AddDataParameter("@bumperPageSkip", SqlUtils.BitValue(BumperPageSkip.Value));
}
if (CustomHtml != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@customHtml", Homepage.Columns.CustomHtml));
sb.AddDataParameter("@customHtml", CustomHtml);
}
if (HomepageTypeId != 0)
{
sb.Criteria.Add(string.Format("{0}=@homepageTypeId", Homepage.Columns.HomepageTypeId));
sb.AddDataParameter("@homepageTypeId", HomepageTypeId);
}
if (IsPublished.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@isPublished", Homepage.Columns.IsPublished));
sb.AddDataParameter("@isPublished", SqlUtils.BitValue(IsPublished.Value));
}
if (LastModifiedByUserId != 0)
{
sb.Criteria.Add(string.Format("{0}=@lastModifiedByUserId", Homepage.Columns.LastModifiedByUserId));
sb.AddDataParameter("@lastModifiedByUserId", LastModifiedByUserId);
}
if (LastModifiedDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@lastModifiedDate", Homepage.Columns.LastModifiedDate));
sb.AddDataParameter("@lastModifiedDate", LastModifiedDate);
}
if (BrandName != String.Empty)
{
sb.Criteria.Add("BrandName=@brandName");
sb.AddDataParameter("@brandName", BrandName);
}
SetCustomSearchCriteria(ref sb);
}
private void SetCustomSearchCriteria(ref SearchBuilder sb)
{
sb.Table = "[v_Asset]";
if (AuditAssetHistoryFinder != null)
{
AuditAssetHistoryFinder.OnlyDistinctAssetIds = true;
sb.Criteria.Add(sb.TableAlias + ".AssetId IN (" + AuditAssetHistoryFinder.FindQuery + ")");
}
if (Orientation != Orientation.All)
{
string sql = string.Empty;
switch (Orientation)
{
case (Orientation.Portrait):
sql = string.Format("[Height] > [Width]");
break;
case (Orientation.Landscape):
sql = string.Format("[Height] < [Width]");
break;
case (Orientation.Square):
sql = string.Format("[Height] = [Width]");
break;
}
if (sql != string.Empty)
{
sb.Criteria.Add(string.Format("({0})", sql));
}
}
if (GeneralKeyword != string.Empty)
{
if (FullTextSearchedEnabled)
{
UserQueryParser uq = new UserQueryParser();
bool isValid = uq.ParseTokens(GeneralKeyword);
if (isValid)
{
string query = uq.GetSqlQuery();
SetFullTextSearchCriteria(sb, query);
}
else
{
string error = string.Format("Error parsing user query: \"{0}\" - {1}", GeneralKeyword, uq.Error);
Debug.WriteLine(error);
}
}
else
{
JoinableList jList = GetStandardSectorSearchSql();
sb.Criteria.Add(string.Format("({0})", jList));
}
}
if (IsBeforePublicationDate)
{
sb.Criteria.Add(string.Format("({0} > getdate())", Asset.Columns.PublishDate));
}
if (IsExpired.HasValue)
{
sb.Criteria.Add("dbo.IsExpired(" + sb.TableAlias + ".ExpiryDate) = @isExpired");
sb.AddDataParameter("@isExpired", SqlUtils.BitValue(IsExpired.GetValueOrDefault()));
}
if (!ExpiryDateRange.IsNull)
{
const string dateFormat = "dd MMMM yyyy HH:mm:ss";
if (ExpiryDateRange.StartDate.HasValue && ExpiryDateRange.EndDate.HasValue)
{
sb.Criteria.Add(string.Format("({0} BETWEEN '{1}' AND '{2}')", Asset.Columns.ExpiryDate, ExpiryDateRange.StartDate.Value.ToString(dateFormat), ExpiryDateRange.EndDate.Value.ToString(dateFormat)));
}
else
{
if (ExpiryDateRange.StartDate.HasValue)
{
sb.Criteria.Add(string.Format("({0} >= '{1}')", Asset.Columns.ExpiryDate, ExpiryDateRange.StartDate.Value.ToString(dateFormat)));
}
if (ExpiryDateRange.EndDate.HasValue)
{
sb.Criteria.Add(string.Format("({0} <= '{1}')", Asset.Columns.ExpiryDate, ExpiryDateRange.EndDate.Value.ToString(dateFormat)));
}
}
}
foreach (ComplexCriteria cc in m_ComplexCriteria)
{
string operand;
switch (cc.CompareType)
{
case (CompareType.LessThan):
operand = "<";
break;
case (CompareType.MoreThan):
operand = ">";
break;
default:
operand = "=";
break;
}
sb.Criteria.Add(string.Format("({0} {1} {2})", cc.Field, operand, cc.Value));
}
if (IsCompletelyPublished)
{
// Entire clause
JoinableList jList1 = new JoinableList(" OR ");
// Currently published
JoinableList jList2 = new JoinableList(" AND ");
jList2.Add(string.Format("{0} = {1}", Asset.Columns.AssetPublishStatusId, Convert.ToInt32(AssetPublishStatus.Published)));
jList2.Add(string.Format("{0} < getdate()", Asset.Columns.PublishDate));
jList2.Add(string.Format("{0} > getdate()", Asset.Columns.ExpiryDate));
// Add to entire clause
jList1.Add(jList2);
// If unpublished and expired assets need to be displayed too, we need to expand this criteria as follows:
// 1. All admin users should see their own assets
// 2. Brand admins should see assets in their primary brand
// 3. Super admins should see all assets
if (IncludeUnpublishedExpiredAssets)
{
JoinableList jList3 = new JoinableList(" OR ");
if (IncludeUnpublishedExpiredAssets_UserId > 0)
{
jList3.Add(string.Format("({0}={1})", Asset.Columns.UploadedByUserId, IncludeUnpublishedExpiredAssets_UserId));
}
if (IncludeUnpublishedExpiredAssets_BrandId > 0)
{
jList3.Add(string.Format("({0}={1})", Asset.Columns.BrandId, IncludeUnpublishedExpiredAssets_BrandId));
}
if (jList3.Count > 0)
{
jList1.Add(jList3);
}
}
string criteria = jList1.ToString();
if (!StringUtils.IsBlank(criteria))
{
sb.Criteria.Add(string.Format("({0})", criteria));
}
}
if (IsPublished.HasValue)
{
string op = (IsPublished.Value) ? " = " : " <> ";
sb.Criteria.Add(string.Concat(Asset.Columns.AssetPublishStatusId, op, Convert.ToInt32(AssetPublishStatus.Published)));
}
if (BrandIdList.Count > 0)
{
JoinableList jList = new JoinableList(BrandIdList);
sb.Criteria.Add(string.Format("BrandId IN ({0})", jList));
}
// Production date filter
SetProductionMonthDayCriteria(sb);
// Metadata filters
AddMetadataCriteria(sb);
// Category filters
AddManyToManyCriteria(sb, "AssetCategory", "CategoryId", CategoryIdList);
// Setup results ordering
AddOrderByClause();
Debug.WriteLine(string.Format("AssetFinder: {0}", sb.GetFullQuery()));
}
protected override void SetSearchCriteria(ref SearchBuilder sb)
{
if (OrderItemIdList != null && OrderItemIdList.Count > 0)
{
JoinableList list = new JoinableList(OrderItemIdList);
sb.Criteria.Add(string.Format("{0} IN (" + list + ")", OrderItem.Columns.OrderItemId));
}
if (OrderItemId.HasValue)
{
sb.Criteria.Add(string.Format("{0}=@orderItemId", OrderItem.Columns.OrderItemId));
sb.AddDataParameter("@orderItemId", OrderItemId.Value);
}
if (OrderId != 0)
{
sb.Criteria.Add(string.Format("{0}=@orderId", OrderItem.Columns.OrderId));
sb.AddDataParameter("@orderId", OrderId);
}
if (AssetId != 0)
{
sb.Criteria.Add(string.Format("{0}=@assetId", OrderItem.Columns.AssetId));
sb.AddDataParameter("@assetId", AssetId);
}
if (Notes != String.Empty)
{
sb.Criteria.Add(string.Format("{0}=@notes", OrderItem.Columns.Notes));
sb.AddDataParameter("@notes", Notes);
}
if (RequiredByDate != null)
{
sb.Criteria.Add(string.Format("{0}=@requiredByDate", OrderItem.Columns.RequiredByDate));
sb.AddDataParameter("@requiredByDate", RequiredByDate.Value);
}
if (OrderItemStatusId != 0)
{
sb.Criteria.Add(string.Format("{0}=@orderItemStatusId", OrderItem.Columns.OrderItemStatusId));
sb.AddDataParameter("@orderItemStatusId", OrderItemStatusId);
}
if (OrderItemStatusDate != null)
{
sb.Criteria.Add(string.Format("{0}=@orderItemStatusDate", OrderItem.Columns.OrderItemStatusDate));
sb.AddDataParameter("@orderItemStatusDate", OrderItemStatusDate.Value);
}
if (OrderItemStatusUserId != null)
{
sb.Criteria.Add(string.Format("{0}=@orderItemStatusUserId", OrderItem.Columns.OrderItemStatusUserId));
sb.AddDataParameter("@orderItemStatusUserId", OrderItemStatusUserId.Value);
}
if (AssignedToUserId != null)
{
sb.Criteria.Add(string.Format("{0}=@assignedToUserId", OrderItem.Columns.AssignedToUserId));
sb.AddDataParameter("@assignedToUserId", AssignedToUserId.Value);
}
if (CreateDate != DateTime.MinValue)
{
sb.Criteria.Add(string.Format("{0}=@createDate", OrderItem.Columns.CreateDate));
sb.AddDataParameter("@createDate", CreateDate);
}
if (UserId.HasValue)
{
if (UserId.Value == 0)
{
sb.Criteria.Add("UserId IS NULL");
}
else
{
sb.Criteria.Add("UserId=@userId");
sb.AddDataParameter("@userId", UserId.Value);
}
}
if (AssetUploadUserId.HasValue)
{
if (AssetUploadUserId.Value == 0)
{
sb.Criteria.Add("AssetUploadUserId IS NULL");
}
else
{
sb.Criteria.Add("AssetUploadUserId=@assetUploadUserId");
sb.AddDataParameter("@assetUploadUserId", AssetUploadUserId.Value);
}
}
if (AssetBrandId.HasValue)
{
if (AssetBrandId.Value == 0)
{
sb.Criteria.Add("AssetBrandId IS NULL");
}
else
{
sb.Criteria.Add("AssetBrandId=@assetBrandId");
sb.AddDataParameter("@assetBrandId", AssetBrandId.Value);
}
}
SetCustomSearchCriteria(ref sb);
}
protected void SetCustomSearchCriteria(ref SearchBuilder sb)
{
sb.Table = "[v_User]";
if (CompanyName.ToLower() == "all")
{
sb.Criteria.Remove(string.Format("{0}=@companyName", User.Columns.CompanyName));
}
if (MinimumUserRoleId > 0)
{
string sql = string.Format("{0} >= {1}", User.Columns.UserRoleId, MinimumUserRoleId);
sb.Criteria.Add(sql);
}
if (MaximumUserRoleId > 0)
{
string sql = string.Format("{0} <= {1}", User.Columns.UserRoleId, MaximumUserRoleId);
sb.Criteria.Add(sql);
}
if (FuzzyEmail != string.Empty)
{
string sql = string.Format("{0} LIKE '%{1}%'", User.Columns.Email, FuzzyEmail.Replace("'", "''"));
sb.Criteria.Add(sql);
}
if (ExpiredAndSuspendedAccountsOnly)
{
sb.Criteria.Add("((IsAccountExpired = 1) OR (IsSuspended = 1))");
}
if (PrimaryBrandId == Int32.MinValue)
{
// -------------------------------------------------------------
// Criteria checks
// -------------------------------------------------------------
// null = ignore (automatic)
// int = int (automatic)
// Int32.MinValue = IS NULL (handled below)
// -------------------------------------------------------------
sb.Criteria.Remove(string.Format("{0}=@primaryBrandId", User.Columns.PrimaryBrandId));
sb.Criteria.Add(string.Format("{0} IS NULL", User.Columns.PrimaryBrandId));
}
if (!RegisterDateRange.IsNull)
{
if (RegisterDateRange.StartDate.HasValue)
{
string criteria = string.Format("{0} >= @RegisterDateRangeStartDate", User.Columns.RegisterDate);
sb.Criteria.Add(criteria);
sb.AddDataParameter("@RegisterDateRangeStartDate", RegisterDateRange.StartDate);
}
if (RegisterDateRange.EndDate.HasValue)
{
string criteria = string.Format("{0} <= @RegisterDateRangeEndDate", User.Columns.RegisterDate);
sb.Criteria.Add(criteria);
sb.AddDataParameter("@RegisterDateRangeEndDate", RegisterDateRange.EndDate);
}
}
//--------------------------------------------------------------------
// Brand Admins are restricted to seeing users in their own BU
// or from companies they have created, so we modify the where clause
// accordingly to reflect this.
//--------------------------------------------------------------------
if (BrandAdministratorId != 0)
{
// Ensure that the primary brand ID is specified
if (!sb.Criteria.Contains(string.Format("{0}=@primaryBrandId", User.Columns.PrimaryBrandId)))
{
throw new SystemException("PrimaryBrandId must be specified when BrandAdministratorId is specified");
}
// Create list to hold criteria
JoinableList jList = new JoinableList(" AND ");
// Remove primary brand ID from SQL
sb.Criteria.Remove(string.Format("{0}=@primaryBrandId", User.Columns.PrimaryBrandId));
// Update with correct syntax
jList.Add(PrimaryBrandId == 0 ? string.Format("{0} IS NULL", User.Columns.PrimaryBrandId) : string.Format("{0}={1}", User.Columns.PrimaryBrandId, PrimaryBrandId));
// Add the criteria
sb.Criteria.Add(jList.ToString());
}
}
