public Travel GetById(int id) { try { string sql = "SELECT ReisagentID, AccomodationID, CustomerID, Discount, DepartureDate, Insurance, Transport, price FROM Travel WHERE TravelID = @TravelID"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("@TravelID", id.ToString()) }; DataSet results = ExecuteSql(sql, parameters); Travel c = DataSetParser.DataSetToTravel(results, 0); return(c); } catch { return(null); } }
public List <Travel> GetAll() { List <Travel> TravelList = new List <Travel>(); try { string sql = "SELECT TravelId, ReisagentID, AccomodationID, CustomerID, Discount, DepartureDate, Insurance, Transport, price FROM Travel"; DataSet results = ExecuteSql(sql, new List <KeyValuePair <string, string> >()); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Travel c = DataSetParser.DataSetToTravel(results, x); TravelList.Add(c); } return(TravelList); } catch { return(null); } }