public static List<Marca> ObtenerTodas()
{
List<Marca> list = new List<Marca>();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = cadena;
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
string consulta = "SELECT idMarca, nombreMarca FROM Marcas";
cmd.CommandText = consulta;
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
Marca m = new Marca();
m.idMarca = (int)dr["idMarca"];
m.nombreMarca = dr["nombreMarca"].ToString();
list.Add(m);
}
dr.Close();
cn.Close();
return list;
}
public static List<Vehiculo> ObtenerTodos(string orden)
{
List<Vehiculo> list = new List<Vehiculo>();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = cadena;
try
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
string consulta = "SELECT V.idVehiculo, V.dominio, V.km, pinturaDanada, V.idMarca, M.nombreMarca, V.idCliente, C.nombre, C.apellido, V.ano FROM Vehiculos V JOIN Marcas M ON V.idMarca = M.idMarca JOIN Clientes C ON C.idCliente = V.idCliente";
if(orden != null)
consulta += " ORDER BY " + orden;
cmd.CommandText = consulta;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Vehiculo v = new Vehiculo();
v.idVehiculo = (int)dr["idVehiculo"];
v.dominio = dr["dominio"].ToString();
if (dr["km"] == DBNull.Value) v.km = null;
else v.km = (int?)dr["km"];
v.pinturaDanada = (Boolean)dr["pinturaDanada"];
v.ano = (int)dr["ano"];
Marca m = new Marca();
m.idMarca = (int)dr["idMarca"];
m.nombreMarca = dr["nombreMarca"].ToString();
v.marca = m;
Cliente c = new Cliente();
c.idCliente = (int)dr["idCliente"];
c.apellido = dr["apellido"].ToString();
c.nombre = dr["nombre"].ToString();
c.completarNombre();
v.cliente = c;
list.Add(v);
}
}
catch(SqlException e) { throw e; }
finally
{
cn.Close();
}
return list;
}
public static Vehiculo ObtenerPorId(int id)
{
Vehiculo v = new Vehiculo();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = cadena;
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
string consulta = "SELECT V.idVehiculo, V.dominio, V.km, pinturaDanada, V.idMarca, M.nombreMarca, V.idCliente, C.nombre, C.apellido, V.ano FROM Vehiculos V JOIN Marcas M ON V.idMarca = M.idMarca JOIN Clientes C ON C.idCliente = V.idCliente WHERE V.idVehiculo = @idVehiculo";
cmd.CommandText = consulta;
cmd.Parameters.AddWithValue("@idVehiculo", id);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
v.idVehiculo = (int)dr["idVehiculo"];
v.dominio = dr["dominio"].ToString();
if (dr["km"] == DBNull.Value) v.km = null;
else v.km = (int?)dr["km"];
v.pinturaDanada = (Boolean)dr["pinturaDanada"];
v.ano = (int)dr["ano"];
Marca m = new Marca();
m.idMarca = (int)dr["idMarca"];
m.nombreMarca = dr["nombreMarca"].ToString();
v.marca = m;
Cliente c = new Cliente();
c.idCliente = (int)dr["idCliente"];
c.apellido = dr["apellido"].ToString();
c.nombre = dr["nombre"].ToString();
c.completarNombre();
v.cliente = c;
}
dr.Close();
cn.Close();
return v;
}
