public static List <Festival> FromUsers(int UserID) { List <Festival> festivals = new List <Festival>(); var query = Sql.Query($"SELECT * FROM Festival WHERE OwnerID = {UserID};"); while (query.Read()) { Festival result = new Festival { EventID = query.GetInt32(0), EventName = query.GetString(1), StartDate = query.GetDateTime(2), EndDate = query.GetDateTime(3), EntryPrice = query.GetDecimal(4), YoutubeVideo = query.GetValue(5).ToString(), Image = query.GetValue(6).ToString(), Info = query.GetValue(7)?.ToString(), Location = query.GetString(8), Clicks = query.GetInt32(9), Draft = query.GetBoolean(10), OwnerID = query.GetInt32(11) }; festivals.Add(result); } return(festivals); }
public static Festival Read(int ID) { var query = Sql.Query($"SELECT * FROM Festival WHERE FestivalID = {ID};"); query.Read(); if (query.HasRows) { Festival result = new Festival(); result.EventID = query.GetInt32(0); result.EventName = query.GetString(1); result.StartDate = query.GetDateTime(2); result.EndDate = query.GetDateTime(3); result.EntryPrice = query.GetDecimal(4); result.YoutubeVideo = query.GetValue(5).ToString(); result.Image = query.GetValue(6).ToString(); result.Info = query.GetValue(7)?.ToString(); result.Location = query.GetString(8); result.Clicks = query.GetInt32(9); result.Draft = query.GetBoolean(10); result.OwnerID = query.GetInt32(11); return(result); } else { throw new NullReferenceException("Could not found " + ID); } }