public IActionResult OnGet()
{
if (!HttpContext.Session.GetInt32("UserID").HasValue)
{
return(Redirect("./login?referer=analytics"));
}
if (Request.Query.ContainsKey("ID"))
{
try
{
Festival = Festival.Read(int.Parse(Request.Query["ID"]));
}
catch
{
return(NotFound());
}
}
else
{
Festival = new Festival();
}
return(Page());
}
public List <Festival> GetFestivals()
{
List <Festival> result = new List <Festival>();
System.Data.DataTableReader query;
if (Scope.Read(HttpContext.Session.GetInt32("UserID").Value)?.HasFlag(UserScopes.SeeAllData) ?? false)
{
query = Sql.Query($"SELECT * FROM Festival;");
}
else
{
query = Sql.Query($"SELECT * FROM Festival WHERE OwnerID = {HttpContext.Session.GetInt32("UserID").Value};");
}
if (query.HasRows)
{
while (query.Read())
{
result.Add(Festival.Read(query.GetInt32(0)));
}
return(result);
}
Message = "Geen Festivals gevonden.";
return(result);
}