public static async Task <IPictureGallery> GetGalleryAsync(this SQLiteDatabase database, string name)
{
IPictureGallery gallery = null;
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Gallery WHERE name = $name")) {
cmd.Parameters.AddWithValue("$name", name);
DataRow row = await database.GetRowAsync(cmd);
if (row != null)
{
return(await database.CreateGalleryFromDataRowAsync(row));
}
}
return(gallery);
}
public static async Task <IPictureGallery> GetGalleryAsync(this SQLiteDatabase database, long?id)
{
IPictureGallery gallery = null;
if (id.HasValue)
{
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Gallery WHERE id = $id")) {
cmd.Parameters.AddWithValue("$id", id);
DataRow row = await database.GetRowAsync(cmd);
if (row != null)
{
return(await database.CreateGalleryFromDataRowAsync(row));
}
}
}
return(gallery);
}
