public void UpdateImage(CImage pImage)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "Images.db")))
{
connection.Update(pImage);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
}
}
public CImage GetImageByID(int ID)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "Images.db")))
{
string sql = "select * from CImage where id = '" + ID + "'";
var res = connection.Query<CImage>(sql);
CImage rezultat = res.FirstOrDefault();
return rezultat;
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return null;
}
}
