async public void Backgrounddownload(Imagemodel imagemodel)
{
StorageFolder folder = await KnownFolders.PicturesLibrary.CreateFolderAsync("ONE", CreationCollisionOption.OpenIfExists);
StorageFile newFile = await folder.CreateFileAsync(imagemodel.Title + ".jpg", CreationCollisionOption.OpenIfExists);
Uri uri = new Uri(imagemodel.CoverImage);
DownloadOperation download = backgroundDownload.CreateDownload(uri, newFile);
await download.StartAsync();
}
public static Imagemodel RandomShowOne()
{
using (SqliteConnection db = new SqliteConnection("Filename=images1.db"))
{
Imagemodel imageurl = new Imagemodel();;
db.Open();
SqliteCommand sqliteCommand = new SqliteCommand();
sqliteCommand.Connection = db;
sqliteCommand.CommandText = "Select * from Image order by random() limit 1";
SqliteDataReader reader = sqliteCommand.ExecuteReader();
while (reader.Read())
{
imageurl.imageId = reader.GetInt16(0);
imageurl.CoverImage = reader.GetString(1);
imageurl.Title = reader.GetString(2);
imageurl.Author = reader.GetString(3);
}
return(imageurl);
}
}
public static List <Imagemodel> ShowAll()
{
Imagemodel imagemodel = new Imagemodel();
List <Imagemodel> imagemodels = new List <Imagemodel>();
using (SqliteConnection db = new SqliteConnection("Filename=images1.db"))
{
db.Open();
SqliteCommand sqliteCommand = new SqliteCommand();
sqliteCommand.Connection = db;
sqliteCommand.CommandText = "select * from Image";
SqliteDataReader reader = sqliteCommand.ExecuteReader();
while (reader.Read())
{
imagemodel.imageId = reader.GetInt16(0);
imagemodel.CoverImage = reader.GetString(1);
imagemodel.Title = reader.GetString(2);
imagemodel.Author = reader.GetString(3);
imagemodels.Add(imagemodel);
}
db.Close();
}
return(imagemodels);
}
