public static void update(Int64 playlistId, Airplay Airplay, Int32 Position, Int32 OldPosition) { if (Math.Abs(Position - OldPosition) < 2) { return; } IPlaylistDao pdao = new DaoFactory().getPlaylistDao(); Playlist p = pdao.GetById(playlistId, false); p.biDeassociateAt(OldPosition); p.biAssociateAt(Airplay, Position); pdao.CommitTransactionFlush(); }
public void Save_persistentSong() { String schema = @" insert into Artist values(1, 'w'); insert into Code values(1, 'c'); insert into Playtime values(1, 20000000); insert into Publisher values(1, 'pu'); insert into Title values(1, 's'); insert into Writer values(1, 'w'); insert into Song(Id, WriterId, CodeId, ArtistId, TitleId, PublisherId, PlaytimeId) values(1,1,1,1,1,1,1); "; new SQLiteCommand(schema, SqliteConn).ExecuteNonQuery(); ISongDao sdao = new DaoFactory().getSongDao(); Song s = sdao.GetById(1L, false); Airplay a = new Airplay(s); a = dao.Save(a); dao.CommitTransactionFlush(); Assert.IsTrue(a.Id > 0); }