/// <summary> Gets the events by page. </summary>
/// <param name="siteId"> The site identifier. </param>
/// <param name="pageId"> The page identifier. </param>
/// <returns> DataTable. </returns>
public static DataTable GetEventsByPage(int siteId, int pageId)
{
var dataTable = new DataTable();
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("ItemGuid", typeof(Guid));
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ModuleGuid", typeof(Guid));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("Title", typeof(string));
dataTable.Columns.Add("Description", typeof(string));
dataTable.Columns.Add("ViewRoles", typeof(string));
dataTable.Columns.Add("CreatedDate", typeof(DateTime));
dataTable.Columns.Add("LastModUtc", typeof(DateTime));
dataTable.Columns.Add("Location", typeof(string));
dataTable.Columns.Add("Latitude", typeof(string));
dataTable.Columns.Add("Longitude", typeof(string));
using (var reader = DBReservations.GetReservationsByPage(siteId, pageId))
{
while (reader.Read())
{
var row = dataTable.NewRow();
row["ItemID"] = reader["ItemID"];
row["ItemGuid"] = reader["ItemGuid"];
row["ModuleID"] = reader["ModuleID"];
row["ModuleGuid"] = reader["ModuleGuid"];
row["ModuleTitle"] = reader["ModuleTitle"];
row["Title"] = reader["Title"];
row["Description"] = reader["Description"];
row["ViewRoles"] = reader["ViewRoles"];
row["CreatedDate"] = Convert.ToDateTime(reader["CreatedDate"]);
row["LastModUtc"] = Convert.ToDateTime(reader["LastModUtc"]);
row["Location"] = reader["Location"];
row["Latitude"] = reader["Latitude"];
row["Longitude"] = reader["Longitude"];
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
