public int eliminarPermiso(PermisosOperaciones p) { Command.CommandText = "delete from permisos where id = @id and idperfil = @idperfil"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("id", p.id); Command.Parameters.AddWithValue("idperfil", p.idperfil); return Command.ExecuteNonQuery(); }
public int insertarPermiso(PermisosOperaciones p) { Command.CommandText = "insert into permisos (idmenu, idcatpermiso, idperfil, accion) values (@idmenu, @idcatpermiso, @idperfil, @accion)"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idmenu", p.idmenu); Command.Parameters.AddWithValue("idcatpermiso", p.idcatpermiso); Command.Parameters.AddWithValue("idperfil", p.idperfil); Command.Parameters.AddWithValue("accion", p.accion); return Command.ExecuteNonQuery(); }