public Destination Get(int id) { DbPlane dbp = new DbPlane(); Destination d = null; using (SqlConnection con = new SqlConnection(data.GetConnectionString())) { con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Booking_Destination WHERE Id = @id", con); cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { d = new Destination { Id = (int)reader["Id"], NameDestination = (string)reader["NameDestination"] }; } } return(d); }
public IEnumerable <Destination> GetAll() { DbPlane dbp = new DbPlane(); List <Destination> destinations = new List <Destination>(); using (SqlConnection con = new SqlConnection(data.GetConnectionString())) { con.Open(); using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM dbo.Booking_Destination"; var rdr = cmd.ExecuteReader(); while (rdr.Read()) { Destination d = new Destination { Id = (int)rdr["Id"], NameDestination = (String)rdr["NameDestination"], }; destinations.Add(d); } } } return(destinations); }
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> GetAllDeparturesFromTo(int start, int end, DateTime fromDate, DateTime toDate) { DbPlane dbp = new DbPlane(); DbDestination dbd = new DbDestination(); List <Departure> departures = new List <Departure>(); using (SqlConnection con = new SqlConnection(data.GetConnectionString())) { con.Open(); using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM dbo.Booking_Departure Where StartDestination = @start AND EndDestination = @end AND DepartureTime >= @fromDate AND DepartureTime <= @toDate ORDER BY DepartureTime ASC"; cmd.Parameters.Add("@start", SqlDbType.Int).Value = start; cmd.Parameters.Add("@end", SqlDbType.Int).Value = end; cmd.Parameters.Add("@fromDate", SqlDbType.DateTime).Value = fromDate; cmd.Parameters.Add("@toDate", SqlDbType.DateTime).Value = toDate; var rdr = cmd.ExecuteReader(); while (rdr.Read()) { departures.Add(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 } } } return(departures); }
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); }