public List <MotorTransmissie> GeefAlleMTS(string naam)
{
List <MotorTransmissie> uitvs = new List <MotorTransmissie>();
string query = "geefallemtvan";
SqlParameter pm1 = new SqlParameter("@uitvoering_naam", naam);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(pm1);
Openconn();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
MotorTransmissie u = new MotorTransmissie();
u.Naam = reader.GetString(reader.GetOrdinal("naam"));
u.Prijs = reader.GetDecimal(reader.GetOrdinal("prijs"));
u.Id = reader.GetInt32(reader.GetOrdinal("id"));
u.LiterPer100 = reader.GetDecimal(reader.GetOrdinal("literper100"));
u.Paardenkracht = reader.GetInt32(reader.GetOrdinal("paardenkracht"));
uitvs.Add(u);
}
Closeconn();
return(uitvs);
}
public List <MotorTransmissie> GeefMtsVorAanpassing(int autoid)
{
Openconn();
List <MotorTransmissie> mts = new List <MotorTransmissie>();
string query1 = "select * from motortransmissie where uitvoering_id = (select uitvoering_id from motortransmissie mt " +
"inner join[auto] a on mt.id = a.motortransmissie_id " +
"where a.id = @autoid)";
string query2 = "select * from motortransmissie mt " +
"inner join[auto] a on mt.id = a.motortransmissie_id " +
"where a.id = @autoid";
SqlCommand cmd1 = new SqlCommand(query2, conn);
cmd1.Parameters.Add(new SqlParameter("@autoid", autoid));
Openconn();
SqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
MotorTransmissie mt = new MotorTransmissie();
mt.Id = reader.GetInt32(reader.GetOrdinal("id"));
mt.LiterPer100 = reader.GetDecimal(reader.GetOrdinal("literper100"));
mt.Paardenkracht = reader.GetInt32(reader.GetOrdinal("paardenkracht"));
mt.Naam = reader.GetString(reader.GetOrdinal("naam"));
mt.Prijs = reader.GetDecimal(reader.GetOrdinal("prijs"));
mts.Add(mt);
}
Closeconn();
SqlCommand cmd2 = new SqlCommand(query1, conn);
cmd2.Parameters.Add(new SqlParameter("@autoid", autoid));
Openconn();
SqlDataReader reader1 = cmd2.ExecuteReader();
while (reader1.Read())
{
MotorTransmissie mt = new MotorTransmissie();
mt.Id = reader1.GetInt32(reader1.GetOrdinal("id"));
mt.LiterPer100 = reader1.GetDecimal(reader1.GetOrdinal("literper100"));
mt.Paardenkracht = reader1.GetInt32(reader1.GetOrdinal("paardenkracht"));
mt.Naam = reader1.GetString(reader1.GetOrdinal("naam"));
mt.Prijs = reader1.GetDecimal(reader1.GetOrdinal("prijs"));
mts.Add(mt);
}
Closeconn();
return(mts);
}
