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