public void Excluir(Video_autor variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("DELETE FROM video_autor WHERE video_id = @video_id AND autor_id = @autor_id;"); query.SetParameter("video_id", variavel.video_id.video_id) .SetParameter("autor_id", variavel.autor_id.autor_id); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }
public void Salvar(Video_autor variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("INSERT INTO video_autor (video_id, autor_id) VALUES (@video_id, @autor_id) "); query.SetParameter("video_id", variavel.video_id.video_id) .SetParameter("autor_id", variavel.autor_id.autor_id); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }