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