public override List <SueetieWikiPage> GetSueetieWikiPagesToIndex(int contenttypeID, DateTime pubDate)
{
List <SueetieWikiPage> sueetieWikiPages = new List <SueetieWikiPage>();
using (SqlConnection cn = GetSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("Sueetie_Search_WikiPages_Get", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@contenttypeID", SqlDbType.Int, 4).Value = contenttypeID;
cmd.Parameters.Add("@pubDate", SqlDbType.DateTime, 8).Value = pubDate == DateTime.MinValue
? new DateTime(1900, 1, 1)
: pubDate;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
SueetieWikiPage _SueetieWikiPage = null;
while (dr.Read())
{
_SueetieWikiPage = new SueetieWikiPage();
PopulateSueetieWikiPageList(dr, _SueetieWikiPage);
sueetieWikiPages.Add(_SueetieWikiPage);
}
dr.Close();
cn.Close();
}
}
}
return(sueetieWikiPages);
}
private static SueetieSearchDoc ConvertSueetieWikiPageToSearchDoc(SueetieWikiPage sueetieWikiPage)
{
string _body = sueetieWikiPage.PageContent;
string _tags = !string.IsNullOrEmpty(sueetieWikiPage.Tags) ? sueetieWikiPage.Tags.Replace('|', ' ') : string.Empty;
string _displayTags = !string.IsNullOrEmpty(sueetieWikiPage.Tags) ? SueetieTags.TagUrls(sueetieWikiPage.Tags) : string.Empty;
string _keywords = !string.IsNullOrEmpty(sueetieWikiPage.Keywords) ? sueetieWikiPage.Keywords.Replace(',', ' ') : string.Empty;
string _categories = !string.IsNullOrEmpty(sueetieWikiPage.Categories) ? sueetieWikiPage.Categories.Replace('|', ' ') : string.Empty;
SueetieSearchDoc doc = new SueetieSearchDoc()
{
App = "Wikis",
ContentID = sueetieWikiPage.ContentID,
Title = sueetieWikiPage.PageTitle,
Tags = _tags,
DisplayTags = _displayTags,
AppID = sueetieWikiPage.ApplicationID,
IsRestricted = sueetieWikiPage.IsRestricted,
PublishDate = sueetieWikiPage.DateTimeModified,
ContainerName = sueetieWikiPage.ApplicationName,
GroupID = sueetieWikiPage.GroupID,
GroupKey = string.IsNullOrEmpty(sueetieWikiPage.GroupKey) ? "na" : sueetieWikiPage.GroupKey,
ContentTypeID = sueetieWikiPage.ContentTypeID,
Categories = _categories,
ApplicationTypeID = sueetieWikiPage.ApplicationTypeID,
ApplicationKey = sueetieWikiPage.ApplicationKey,
PermaLink = sueetieWikiPage.Permalink,
Author = sueetieWikiPage.DisplayName,
Username = sueetieWikiPage.UserName,
Body = _body + RaquoIt(sueetieWikiPage.PageTitle) + RaquoIt(_categories) + RaquoIt(_tags) + RaquoIt(_keywords) + RaquoIt(sueetieWikiPage.UserName)
};
return(doc);
}
public static void PopulateSueetieWikiPageList(IDataReader dr, SueetieWikiPage _sueetieWikiPage)
{
_sueetieWikiPage.PageID = (int)dr["pageid"];
_sueetieWikiPage.PageFileName = dr["pagefilename"] as string;
_sueetieWikiPage.PageTitle = dr["pagetitle"] as string;
_sueetieWikiPage.Keywords = dr["keywords"] as string;
_sueetieWikiPage.Abstract = dr["abstract"] as string;
_sueetieWikiPage.Namespace = dr["namespace"] as string;
_sueetieWikiPage.DateTimeCreated = (DateTime)dr["datetimecreated"];
_sueetieWikiPage.DateTimeModified = (DateTime)dr["datetimemodified"];
_sueetieWikiPage.UserID = (int)dr["userid"];
_sueetieWikiPage.ContentID = (int)dr["contentid"];
_sueetieWikiPage.Permalink = dr["permalink"] as string;
_sueetieWikiPage.IsRestricted = (bool)dr["isrestricted"];
_sueetieWikiPage.Email = dr["email"] as string;
_sueetieWikiPage.DisplayName = dr["displayname"] as string;
_sueetieWikiPage.ApplicationKey = dr["applicationkey"] as string;
_sueetieWikiPage.ApplicationName = dr["applicationname"] as string;
_sueetieWikiPage.GroupID = (int)dr["groupid"];
_sueetieWikiPage.GroupKey = dr["groupkey"] as string;
_sueetieWikiPage.GroupName = dr["groupname"] as string;
_sueetieWikiPage.ContentTypeID = (int)dr["contenttypeid"];
_sueetieWikiPage.Active = (bool)dr["active"];
_sueetieWikiPage.ApplicationID = (int)dr["applicationid"];
_sueetieWikiPage.ApplicationTypeID = (int)dr["applicationtypeid"];
_sueetieWikiPage.Categories = dr["categories"] as string;
_sueetieWikiPage.PageContent = dr["pagecontent"] as string;
_sueetieWikiPage.UserName = dr["username"] as string;
_sueetieWikiPage.Tags = dr["tags"] as string;
}
