public Departure Get(int id) { DbPlane dbp = new DbPlane(); DbDestination dbd = new DbDestination(); using (SqlConnection con = new SqlConnection(data.GetConnectionString())) { con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Booking_Departure WHERE Id = @id", con); cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id; SqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); return(new Departure { Id = (int)rdr["Id"], Plane = dbp.Get((int)rdr["Plane_Id"]), EndDestination = dbd.Get((int)rdr["EndDestination"]), StartDestination = dbd.Get((int)rdr["StartDestination"]), DepartureTime = (DateTime)rdr["DepartureTime"], Seats = dbSeat.GetAll((int)rdr["Id"]) }); // husk at tilføje seats til listen } }
public IEnumerable <Departure> GetAll() { DbPlane dbp = new DbPlane(); DbDestination dbd = new DbDestination(); List <Departure> departures = new List <Departure>(); Departure d = null; using (SqlConnection con = new SqlConnection(data.GetConnectionString())) { con.Open(); using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM dbo.Booking_Departure ORDER BY DepartureTime ASC"; var rdr = cmd.ExecuteReader(); while (rdr.Read()) { d = new Departure { Id = (int)rdr["Id"], Plane = dbp.Get((int)rdr["Plane_Id"]), EndDestination = dbd.Get((int)rdr["EndDestination"]), StartDestination = dbd.Get((int)rdr["StartDestination"]), DepartureTime = (DateTime)rdr["DepartureTime"] }; // husk seats departures.Add(d); } } } return(departures); }