public static void UpdateIcon(string _vid, BitmapSource _icon)
{
using (var command = new SQLiteCommand())
{
command.CommandText = @"Update [VideoRecords] Set [Icon] = @icon Where [Vid] = @vid;";
command.Parameters.Add(new SQLiteParameter("@icon")
{
DbType = DbType.Binary, Value = _icon.GetByteArray()
});
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _vid
});
accesser.ExecuteCommand(command);
}
}
public static void UpsertScreenlist(string _vid, BitmapSource _screenlist)
{
long id = 0;
using (var command = new SQLiteCommand())
{
command.CommandText = @"Select [Id] From [VideoScreenlists] Where [Vid] = @vid;";
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _vid
});
using (var reader = accesser.ExecuteReader(command))
{
if (reader.HasRows)
{
reader.Read();
id = reader.GetInt64(0);
}
}
}
if (id == 0)
{
using (var command = new SQLiteCommand())
{
command.CommandText = @"Insert into [VideoScreenlists] ([Vid], [Screenlist], [Deleted]) Values (@vid, @screenlist, @deleted)";
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _vid
});
command.Parameters.Add(new SQLiteParameter("@screenlist")
{
DbType = DbType.Binary, Value = _screenlist.GetByteArray()
});
command.Parameters.Add(new SQLiteParameter("@deleted")
{
DbType = DbType.Boolean, Value = 0
});
accesser.ExecuteCommand(command);
}
}
else
{
using (var command = new SQLiteCommand())
{
command.CommandText = @"Update [VideoScreenlists] Set [Screenlist] = @screenlist Where [Id] = @id;";
command.Parameters.Add(new SQLiteParameter("@id")
{
DbType = DbType.Int64, Value = id
});
command.Parameters.Add(new SQLiteParameter("@screenlist")
{
DbType = DbType.Binary, Value = _screenlist.GetByteArray()
});
accesser.ExecuteCommand(command);
}
}
}
