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);
}
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);
}