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);
}
}
