/// <summary>
/// Gets a DataTable with items on a specific page
/// </summary>
/// <param name="siteGuid"></param>
/// <param name="pageId"></param>
/// <returns>DataTable</returns>
public static DataTable GetByCMSPage(Guid siteGuid, int pageId)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ItemGuid", typeof(Guid));
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("SortOrder", typeof(int));
dataTable.Columns.Add("CreatedUtc", typeof(DateTime));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("ModuleViewRoles", typeof(string));
dataTable.Columns.Add("ItemViewRoles", typeof(string));
dataTable.Columns.Add("PublishBeginDate", typeof(DateTime));
dataTable.Columns.Add("PublishEndDate", typeof(DateTime));
using (IDataReader reader = DBItems.GetByCMSPage(siteGuid, pageId))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["ModuleID"] = reader["moduleId"];
row["ItemGuid"] = Guid.Parse(reader["itemGuid"].ToString());
row["ItemID"] = reader["itemId"];
row["SortOrder"] = reader["sortOrder"];
row["CreatedUtc"] = Convert.ToDateTime(reader["createdUtc"]);
row["ModuleTitle"] = reader["moduleTitle"];
row["ModuleViewRoles"] = reader["moduleViewRoles"];
row["ItemViewRoles"] = reader["itemViewRoles"];
if (reader["publishBeginDate"] != DBNull.Value)
{
row["PublishBeginDate"]
= Convert.ToDateTime(reader["publishBeginDate"]);
}
if (reader["publishEndDate"] != DBNull.Value)
{
row["PublishEndDate"]
= Convert.ToDateTime(reader["publishEndDate"]);
}
dataTable.Rows.Add(row);
}
}
return(dataTable);
}