/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
// For better performance is necessary to add in
// method FillPortalDS from PortalSearch.ascx.cs the
// next case:
// case "875254B7-2471-491F-BAF8-4AFC261CC224": //EnhancedHtml
// strLink = HttpUrlBuilder.BuildUrl("~/DesktopDefault.aspx", Convert.ToInt32(strTabID), strLocate);
// break;
string dbTable = "rb_EnhancedHtml";
if (Version == WorkFlowVersion.Staging)
{
dbTable += "_st";
}
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition(dbTable, "Title", "DesktopHtml", "CreatedByUser", "CreatedDate", searchField);
string retorno = s.SearchSqlSelect(portalID, userID, searchString);
if (HttpContext.Current != null && HttpContext.Current.Items["PortalSettings"] != null)
{
PortalSettings pS = (PortalSettings)HttpContext.Current.Items["PortalSettings"];
retorno += " AND ((itm.CultureCode = '" + pS.PortalUILanguage.LCID.ToString() + "') OR (itm.CultureCode = '" + System.Globalization.CultureInfo.InvariantCulture.LCID.ToString() + "'))";
}
return(retorno);
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_Blogs", "Title", "Excerpt", "CreatedByUser", "CreatedDate", searchField);
//Add extra search fields here, this way
s.ArrSearchFields.Add("itm.Description");
return(s.SearchSqlSelect(portalID, userID, searchString));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_EnhancedLinks", "Title", "Description", "CreatedByUser", "CreatedDate", searchField);
s.ArrSearchFields.Add("itm.Url");
s.ArrSearchFields.Add("itm.ImageUrl");
return(s.SearchSqlSelect(portalID, userID, searchString, true));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_Documents", "FileFriendlyName", "FileNameUrl", "CreatedByUser", "CreatedDate", searchField);
//Add extra search fields here, this way
s.ArrSearchFields.Add("itm.Category");
return(s.SearchSqlSelect(portalID, userID, searchString));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
// Parameters:
// Table Name: the table that holds the data
// Title field: the field that contains the title for result, must be a field in the table
// Abstract field: the field that contains the text for result, must be a field in the table
// Search field: pass the searchField parameter you recieve.
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_ComponentModule", "Title", "Component", "CreatedByUser", "CreatedDate", searchField);
//Add here extra search fields, this way
//s.ArrSearchFields.Add("itm.ExtraFieldToSearch");
// Builds and returns the SELECT query
return(s.SearchSqlSelect(portalID, userID, searchString, false));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
// Parameters:
// Table Name: the table that holds the data
// Title field: the field that contains the title for result, must be a field in the table
// Abstract field: the field that contains the text for result, must be a field in the table
// Search field: pass the searchField parameter you recieve.
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_Pictures", "ShortDescription", "Keywords", "CreatedByUser", "CreatedDate", "Keywords");
//Add here extra search fields, this way
s.ArrSearchFields.Add("itm.ShortDescription");
// Builds and returns the SELECT query
return(s.SearchSqlSelect(portalID, userID, searchString));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_Discussion", "Title", "Body", "CreatedByUser", "CreatedDate", searchField);
return(s.SearchSqlSelect(portalID, userID, searchString));
}
/// <summary>
/// Searchable module implementation
/// </summary>
/// <param name="portalID">The portal ID</param>
/// <param name="userID">ID of the user is searching</param>
/// <param name="searchString">The text to search</param>
/// <param name="searchField">The fields where perfoming the search</param>
/// <returns>The SELECT sql to perform a search on the current module</returns>
public override string SearchSqlSelect(int portalID, int userID, string searchString, string searchField)
{
Rainbow.Helpers.SearchDefinition s = new Rainbow.Helpers.SearchDefinition("rb_HtmlText", "DesktopHtml", "DesktopHtml", searchField);
return(s.SearchSqlSelect(portalID, userID, searchString, false));
}
