protected void Page_Load(object sender, EventArgs e)
{
string x = Request.QueryString["serial"];
Vehiculito vehiculo = objGestion.consultarVehiculo(x);
if (vehiculo != null)
{
Label9.Text = vehiculo.placa;
Label10.Text = vehiculo.color;
Label16.Text = vehiculo.marca;
Label11.Text = vehiculo.modelo;
Label13.Text = vehiculo.serial;
}
else
{
Label9.Text = "";
Label10.Text = "";
Label16.Text = "";
Label11.Text = "";
Label13.Text = "";
}
}
public Vehiculito consultarVehiculo(string serial)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder
{
DataSource = "lincecars123.database.windows.net",
UserID = "admin123",
Password = "******",
InitialCatalog = "linceCars"
};
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand comando = new SqlCommand();
comando.Connection = connection;
comando.CommandText = "exec [dbo].[usp_ConsultaVeh] " + '"' + serial + '"';
SqlDataReader registro = comando.ExecuteReader();
if (registro.Read())
{
Vehiculito vehiculo = new Vehiculito();
vehiculo.serial = registro.GetString(0);
vehiculo.placa = registro.GetString(1);
vehiculo.color = registro.GetString(2);
vehiculo.marca = registro.GetString(3);
vehiculo.modelo = registro.GetString(4);
vehiculo.QR = registro.GetString(5);
vehiculo.imagen = registro.GetString(6);
vehiculo.nitEmp = registro.GetInt64(7);
return(vehiculo);
}
else
{
registro.Close();
return(null);
}
}
}
