public List <Bucketlist> GetBucketlistsByUser(string UserID) { try { con.Open(); string sql = "SELECT Naam, BucketListID, Eigenaar FROM `bucketlist` WHERE Eigenaar = @eigenaar "; var cmd = new MySqlCommand(sql, con); cmd.Parameters.AddWithValue("@eigenaar", UserID); MySqlDataReader rdr = cmd.ExecuteReader(); List <Bucketlist> Bucketlists = new List <Bucketlist>(); while (rdr.Read()) { Bucketlist bucketlist = new Bucketlist(); bucketlist.Naam = rdr.GetString(0); bucketlist.BucketListId = rdr.GetInt16(1); bucketlist.Eignenaar = rdr.GetGuid(2); Bucketlists.Add(bucketlist); } return(Bucketlists); } catch (Exception e) { Console.WriteLine(e); return(null); } finally { con.Close(); } }
public Task DeleteBucketList(Bucketlist bucketlist) { throw new NotImplementedException(); }
public static BucketlistDto ToDto(this Bucketlist model, IMapper mapper) { return(mapper.Map <BucketlistDto>(model)); }