Fran's questions

I made a little api in php:

<?php 
    header('Content-Type: application/json');
    header('Access-Control-Allow-Origin: *');

    include_once'conexion.php';
    $cliente_usu = $_GET['cliente_usuario'];
    $cliente_pass = $_GET['cliente_pass'];
    if($_SERVER["REQUEST_METHOD"] == 'GET')
    {

        $consulta_buscar_usuario = 'SELECT * FROM api_usuario WHERE usuario_nombre = ? AND usuario_contrasena = ?';
        $ejecutar_cbu = $pdo->prepare($consulta_buscar_usuario);
        $ejecutar_cbu->execute(array($cliente_usu,$cliente_pass));
        $data_respuesta = $ejecutar_cbu->fetch();
    }
    echo json_encode($data_respuesta);
?>

that receives a username and password and returns a json, the problem is that it repeats the information

it should only return what is inside the red box, I use a local apache server and a mysql database with which it connects correctly, to consume the api I use the following line: http://localhost/api/datos.php? client_user=admin&client_pass=admin

I have an asp.net mvc5 project is there a

@Html.CheckboxFor(model => model.mi_atributo, new { @class = "form-check-input"})

, to which I want to put a message when the pointer is positioned on it, I found this:

@Html.EditorFor(m => m.mi_atributo, new { htmlAttributes = new { Title = "mi mensaje" }, })

, Y

@Html.PasswordFor(m => m.Password, new { Title = "mi mensaje"  }) 

but it doesn't seem to work with CheckboxFor, I use mvc version 5.2.7.0.

I have a registration form that works, that when executed successfully calls Limpiarthat makes the form blank, but if I put the the OnBeginform stops working completely

@using (Ajax.BeginForm("Registrar", "", new AjaxOptions
            {
                HttpMethod = "POST",              
                //OnBegin = "Iniciar",
                OnSuccess = "Limpiar",  
                UpdateTargetId = "div_tabla_sucursal",
                InsertionMode = InsertionMode.Replace
            }

In a script I have the following:

function Iniciar () {
    // Deshabilitamos el botón de Submit
    $("#btn_registrar").prop("disabled", true);
};

var Limpiar = function () {
    // Limpia el formulario
    $("#Frm_Registro").trigger("reset");
    // Habilitamos el botón de Submit
    $("#btn_registrar").prop("disabled", false);
    // Mostramos un mensaje de éxito.
    $("#ExitoAlert").show("slow").delay(2000).hide("slow");
};

the first time it was executed correctly and if it did not make any modifications it stopped executing, when I remove it onBeginfrom the form onSuccessit executes without problems, but when I place it it stops working completely.

I have a registration form which I want to put an id

@using (Ajax.BeginForm("Registrar", new AjaxOptions
            {
                HttpMethod = "POST",
                InsertionMode = InsertionMode.Replace,
                UpdateTargetId = "div_tabla_sucursal",
                OnSuccess = "Limpiar"
            },
            new { @id="frmRegistro" }))
            {
                <div id="div_formulario_registrar_sucursal">
                    @Html.Partial("_ListaFormularioRegistrarSucursal", Model.Modelo_Sucursales)
                </div>
            }

But when I added it it generates the following

I also have another form which does not generate that error

@using (Ajax.BeginForm("Filtrar", "Usuario", null,
    new AjaxOptions
    {
        HttpMethod = "POST",
        UpdateTargetId = "Div_Tabla_Usuarios",
        InsertionMode = InsertionMode.Replace
    }, new { @id = "frmFiltrarNombrePersona" }))
{
    @Html.Label("Ingrese el nombre de la persona")
    @Html.TextBox("NombrePersona", null, new { @class = "form-control" })
    <div id="Div_Tabla_Usuarios">
        @Html.Partial("_TablaUsuarios", Model)
    </div>
}

In examples that I have looked for, he presents them to me in the same way.

I have a table in sql server called Brand, it contains four fields:

IIDMARCA int, 
NOMBRE varchar, 
DESCRIPCION varchar, 
BHABILITADO int

and I have a stored procedure that queries three of those four fields

CREATE PROCEDURE SP_LISTAR_MARCAS
AS
BEGIN
SELECT IIDMARCA, NOMBRE, DESCRIPCION
FROM Marca
WHERE BHABILITADO = 1
END

In my asp.net project I have the following drawback:

If in the procedure I place select * from marca, in my view I place the column item.b enabled, the problem is eliminated, but I am not interested in listing all the columns, and I do not know how to solve this, I appreciate in advance all the help you can give me, if you know requires more information I will be pending.

this would be my controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

using prototipo_03.Models;

namespace procedimientos_almacenados.Controllers
{
    public class MarcaController : Controller
    {
        BDPasajeEntities bd = new BDPasajeEntities();
        // GET: Marca
        public ActionResult Index()
        {
            ListarMarcas();
            return View();
        }

        public void ListarMarcas()
        {
            List<Marca> ListaMarca = new List<Marca>();

            using (bd)
            {
                var ListaMarca3 = bd.SP_LISTAR_MARCAS().ToList();
                foreach (var item in ListaMarca3)
                {
                    var asignar = new Marca
                    {
                        IIDMARCA = item.IIDMARCA,
                        NOMBRE = item.NOMBRE,
                        DESCRIPCION = item.DESCRIPCION,
                    };
                    ListaMarca.Add(asignar);
                }
                ViewBag.ListaMarca = ListaMarca;
            } 
    }
}

this is my view

@using prototipo_03.Models

@{
    ViewBag.Title = "Index";
    List<Marca> ListaMarca = (List<Marca>)ViewBag.ListaMarca;
}

<table class="table table-bordered table-hover">
    <thead>
        <tr>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in ListaMarca)
        {
        <tr>
            <td>@item.IIDMARCA</td>
            <td>@item.NOMBRE</td>
            <td>@item.DESCRIPCION</td>
        </tr>
        }
    </tbody>
</table>

I have tried to implement my own model that calls MarcaCLS to differentiate the Marca that comes from the model brought from the database, but I am limited in this matter, which I did in the same way but I don't know how to make it work

 public partial class Marca
    {
        public int IIDMARCA { get; set; }
        public string NOMBRE { get; set; }
        public string DESCRIPCION { get; set; }
        public Nullable<int> BHABILITADO { get; set; }
    }

I have to list all the columns in the procedure and list them all in the controller and in the view for it to run correctly, but I'm not interested in listing all the columns in the table.