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