/// <summary> /// Gets a list of Engage: Publish articles in the given portal that match the search string /// </summary> /// <param name="searchValue">The search string.</param> /// <param name="portalId">The portal id.</param> /// <returns>A list of Engage: Publish articles in the given portal that match the search string</returns> public override IDataReader GetPublishLinks(string searchValue, int portalId) { StringBuilder sql = new StringBuilder(128); sql.Append("SELECT va.name, va.ItemId, va.articletext, va.displaytabid, t.TabName "); sql.AppendFormat("FROM {0}publish_vwarticles va ", this.DnnPrefix); sql.AppendFormat(" JOIN {0}Tabs t on t.TabID = va.displaytabid ", this.DnnPrefix); sql.Append("WHERE va.articletext collate SQL_Latin1_General_CP1_CS_AS LIKE @searchValue "); sql.Append(" and va.IsCurrentVersion = 1 and va.PortalId = @portalId"); return(SqlHelper.ExecuteReader( this.ConnectionString, CommandType.Text, sql.ToString(), Utility.CreateIntegerParam("@portalId", portalId), Utility.CreateVarcharParam("@searchValue", "%" + searchValue + "%"))); }
/// <summary> /// Gets a list of the Text/HTML modules with content matching the search string. /// </summary> /// <param name="searchValue">The search string.</param> /// <returns>The Text/HTML modules with content matching the search string</returns> public override IDataReader GetMatchingHtmlTextModules(string searchValue) { StringBuilder sql = new StringBuilder(128); sql.Append("SELECT ht.ModuleID, tm.TabID, ht.DesktopHtml, ht.DesktopSummary, m.ModuleTitle, t.TabName "); sql.AppendFormat("FROM {0}HtmlText ht ", this.DnnPrefix); sql.AppendFormat(" JOIN {0}TabModules tm ON (tm.ModuleID = ht.ModuleID)", this.DnnPrefix); sql.AppendFormat(" JOIN {0}Modules m ON (m.ModuleID = tm.ModuleID)", this.DnnPrefix); sql.AppendFormat(" JOIN {0}Tabs t ON (t.TabID = tm.TabID)", this.DnnPrefix); sql.Append("WHERE ht.DesktopHtml collate SQL_Latin1_General_CP1_CS_AS LIKE @searchValue"); return(SqlHelper.ExecuteReader( this.ConnectionString, CommandType.Text, sql.ToString(), Utility.CreateVarcharParam("@searchValue", "%" + searchValue + "%"))); }