public static DataTable GetHtmlContentByPage(int siteId, int pageId)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("Title", typeof(string));
dataTable.Columns.Add("Body", typeof(string));
dataTable.Columns.Add("ViewRoles", typeof(string));
using (IDataReader reader = DBHtmlContent.GetHtmlContentByPage(siteId, pageId))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["ItemID"] = reader["ItemID"];
row["ModuleID"] = reader["ModuleID"];
row["ModuleTitle"] = reader["ModuleTitle"];
row["Title"] = reader["Title"];
row["Body"] = reader["Body"];
row["ViewRoles"] = reader["ViewRoles"];
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
private bool Update()
{
this.lastModUtc = DateTime.UtcNow;
bool result = DBHtmlContent.UpdateHtmlContent(
this.itemID,
this.moduleID,
this.title,
this.excerpt,
this.body,
this.moreLink,
this.sortOrder,
this.beginDate,
this.endDate,
this.lastModUtc,
this.lastModUserGuid,
this.excludeFromRecentContent);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
///// <summary>
///// Gets an instance of HtmlContent.
///// </summary>
///// <param name="moduleID">moduleID</param>
///// <param name="itemID">itemID</param>
//private void GetHtmlContent(int moduleId, int itemId)
//{
// using (IDataReader reader = DBHtmlContent.GetHtmlContent(moduleId, itemId))
// {
// LoadFromReader(reader);
// }
//}
/// <summary>
/// Gets an instance of HtmlContent.
/// </summary>
/// <param name="moduleId">moduleId</param>
private void GetHtmlContent(int moduleId)
{
using (IDataReader reader = DBHtmlContent.GetHtmlContent(moduleId, DateTime.UtcNow))
{
LoadFromReader(reader);
}
}
/// <summary>
/// Creates this instance.
/// </summary>
/// <returns></returns>
private bool Create()
{
int newID = -1;
this.itemGuid = Guid.NewGuid();
newID = DBHtmlContent.AddHtmlContent(
this.itemGuid,
this.moduleGuid,
this.moduleID,
this.title,
this.excerpt,
this.body,
this.moreLink,
this.sortOrder,
this.beginDate,
this.endDate,
this.createdDate,
this.createdBy,
this.userGuid,
this.excludeFromRecentContent);
this.itemID = newID;
bool result = (newID > -1);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
/// <summary>
/// Gets an instance of HtmlContent.
/// </summary>
/// <param name="moduleID">moduleID</param>
/// <param name="itemID">itemID</param>
private void GetHtmlContent(int moduleId, int itemId)
{
using (IDataReader reader = DBHtmlContent.GetHtmlContent(moduleId, itemId))
{
LoadFromReader(reader);
}
}
public bool Save(HtmlContent content)
{
bool result = false;
if (content == null)
{
return(result);
}
content.LastModUtc = DateTime.UtcNow;
if (content.ItemId > -1)
{
result = DBHtmlContent.UpdateHtmlContent(
content.ItemId,
content.ModuleId,
content.Title,
content.Excerpt,
content.Body,
content.MoreLink,
content.SortOrder,
content.BeginDate,
content.EndDate,
content.LastModUtc,
content.LastModUserGuid,
content.ExcludeFromRecentContent);
}
else
{
content.ItemGuid = Guid.NewGuid();
int newId = DBHtmlContent.AddHtmlContent(
content.ItemGuid,
content.ModuleGuid,
content.ModuleId,
content.Title,
content.Excerpt,
content.Body,
content.MoreLink,
content.SortOrder,
content.BeginDate,
content.EndDate,
content.CreatedDate,
content.CreatedBy,
content.UserGuid,
content.ExcludeFromRecentContent);
content.ItemId = newId;
result = (newId > -1);
}
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
content.OnContentChanged(e);
}
return(result);
}
public bool Delete()
{
bool result = DBHtmlContent.DeleteHtmlContent(this.itemID);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = true;
OnContentChanged(e);
}
return(result);
}
public DataTable GetHtmlContentByPage(int siteId, int pageId)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("Title", typeof(string));
dataTable.Columns.Add("Body", typeof(string));
dataTable.Columns.Add("ViewRoles", typeof(string));
dataTable.Columns.Add("IncludeInSearch", typeof(bool));
dataTable.Columns.Add("CreatedByName", typeof(string));
dataTable.Columns.Add("CreatedByFirstName", typeof(string));
dataTable.Columns.Add("CreatedByLastName", typeof(string));
dataTable.Columns.Add("CreatedDate", typeof(DateTime));
dataTable.Columns.Add("LastModUtc", typeof(DateTime));
dataTable.Columns.Add("ExcludeFromRecentContent", typeof(bool));
using (IDataReader reader = DBHtmlContent.GetHtmlContentByPage(siteId, pageId))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["ItemID"] = reader["ItemID"];
row["ModuleID"] = reader["ModuleID"];
row["ModuleTitle"] = reader["ModuleTitle"];
row["Title"] = reader["Title"];
row["Body"] = reader["Body"];
row["ViewRoles"] = reader["ViewRoles"];
row["CreatedByName"] = reader["CreatedByName"];
row["CreatedByFirstName"] = reader["CreatedByFirstName"];
row["CreatedByLastName"] = reader["CreatedByLastName"];
row["IncludeInSearch"] = Convert.ToBoolean(reader["IncludeInSearch"]);
row["CreatedDate"] = Convert.ToDateTime(reader["CreatedDate"]);
row["LastModUtc"] = Convert.ToDateTime(reader["LastModUtc"]);
row["ExcludeFromRecentContent"] = Convert.ToBoolean(reader["ExcludeFromRecentContent"]);
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
public bool Delete(HtmlContent content)
{
if (content == null)
{
return(false);
}
bool result = DBHtmlContent.DeleteHtmlContent(content.ItemId);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = true;
content.OnContentChanged(e);
}
return(result);
}
public HtmlContent Fetch(int moduleId)
{
if (moduleId < 0)
{
return(null);
}
using (IDataReader reader = DBHtmlContent.GetHtmlContent(moduleId, DateTime.UtcNow))
{
if (reader.Read())
{
HtmlContent content = new HtmlContent();
LoadFromReader(content, reader);
return(content);
}
}
return(null);
}
public static bool DeleteBySite(int siteId)
{
return(DBHtmlContent.DeleteBySite(siteId));
}
public static bool DeleteByModule(int moduleId)
{
return(DBHtmlContent.DeleteByModule(moduleId));
}
public static IDataReader GetHtml(int moduleId, DateTime beginDate)
{
return(DBHtmlContent.GetHtmlContent(moduleId, beginDate));
}
public IDataReader GetHtmlForMetaWeblogApi(int siteId)
{
return(DBHtmlContent.GetHtmlForMetaWeblogApi(siteId));
}
