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