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;
}
}
