public TravelCompany GetById(int id) { try { string sql = "SELECT FirstName, LastName, BirthDate FROM TravelCompany WHERE TravelCompanyId = @TravelCompanyId "; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("@TravelCompanyId", id.ToString()) }; DataSet results = ExecuteSql(sql, parameters); TravelCompany tc = DataSetParser.DataSetToTravelCompany(results, 0); return(tc); } catch { return(null); } }
public List <TravelCompany> GetAll() { List <TravelCompany> tcList = new List <TravelCompany>(); try { string sql = "SELECT TravelCompanyId, FirstName, LastName, BirthDate FROM TravelCompany"; DataSet results = ExecuteSql(sql, new List <KeyValuePair <string, string> >()); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { TravelCompany tc = DataSetParser.DataSetToTravelCompany(results, x); tcList.Add(tc); } return(tcList); } catch { return(null); } }