예제 #1
0
 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;
     }
 }
예제 #2
0
 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;
     }
 }