/// <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 + "%")));
}
