예제 #1
0
        public int mtdBuscarId()
        {
            clConexion objconexion = new clConexion();
            string     consulta    = "SELECT IdCliente FROM Cliente WHERE Documento='" + Documento + "'";
            DataTable  dtBuscarId  = objconexion.mtdDesconectdo(consulta);

            int id = 0;

            for (int i = 0; i < dtBuscarId.Rows.Count; i++)
            {
                clVehiculo objVehiculo = new clVehiculo();

                id = Convert.ToInt32(dtBuscarId.Rows[i]["IdCliente"]);
            }

            return(id);
        }
예제 #2
0
        public int mtdVerificarVehculo()
        {
            clConexion objconexion   = new clConexion();
            string     consulta      = "SELECT IdCliente FROM Vehiculo WHERE IdCliente='" + IdCliente + "'";
            DataTable  idClienteVehi = objconexion.mtdDesconectdo(consulta);

            int id = 0;

            for (int i = 0; i < idClienteVehi.Rows.Count; i++)
            {
                clVehiculo objVehiculo = new clVehiculo();

                id = Convert.ToInt32(idClienteVehi.Rows[i]["IdCliente"]);
            }

            return(id);
        }
예제 #3
0
        public string mtdVerBuscPlaca()
        {
            clConexion objconexion = new clConexion();
            string     consulta    = "SELECT Placa FROM Vehiculo WHERE Placa = '" + Placa + "'";
            DataTable  dtPlaca     = objconexion.mtdDesconectdo(consulta);

            string placa = "";

            for (int i = 0; i < dtPlaca.Rows.Count; i++)
            {
                clVehiculo objVehiculo = new clVehiculo();

                placa = dtPlaca.Rows[i]["Placa"].ToString();
            }

            return(placa);
        }