예제 #1
0
        public List <Traject> GetTrajectenbyStations(long beginStationId, long eindStationId)
        {
            try
            {
                string query = "SELECT id, naam, actief FROM GetTrajects" +
                               " WHERE beginPerronId IN ( SELECT Id FROM Perron WHERE stationId = @beginstationid)" +
                               " AND eindPerronId IN ( SELECT Id FROM Perron WHERE = @eindstationid";

                List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
                {
                    new KeyValuePair <string, string>("beginstationid", beginStationId.ToString()),
                    new KeyValuePair <string, string>("eindstationid", eindStationId.ToString())
                };
                DataSet        results   = ExecuteSql(query, parameters);
                List <Traject> trajecten = new List <Traject>();
                if (results != null)
                {
                    for (int x = 0; x < results.Tables[0].Rows.Count; x++)
                    {
                        Traject t = DataSetParser.DataSetToTraject(results, x);
                        trajecten.Add(t);
                    }
                }
                return(trajecten);
            }
            catch
            {
                return(null);
            }
        }
예제 #2
0
        public Traject GetTrajectbyId(long id)
        {
            string sql = "Select * from Traject where id=@id";
            List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >
            {
                new KeyValuePair <string, string>("id", id.ToString())
            };

            DataSet results = ExecuteSql(sql, parameters);
            Traject t       = null;

            if (results != null && results.Tables[0].Rows.Count > 0)
            {
                t = DataSetParser.DataSetToTraject(results, 0);
            }
            return(t);
        }
예제 #3
0
        public List <Traject> GetAllTrajecten()
        {
            string sql = "Select * from Traject ";
            List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
            DataSet results = ExecuteSql(sql, parameters);

            List <Traject> trajecten = new List <Traject>();

            if (results != null)
            {
                for (int x = 0; x < results.Tables[0].Rows.Count; x++)
                {
                    Traject t = DataSetParser.DataSetToTraject(results, x);
                    trajecten.Add(t);
                }
            }
            return(trajecten);
        }