Exemplo n.º 1
0
        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
            }
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        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);
        }