public TravelAgent GetById(int id)
{
try
{
string sql = "SELECT Email, Password FROM TravelAgent WHERE TravelAgentId = @TravelAgentId";
List<KeyValuePair<string, string>> parameters = new List<KeyValuePair<string, string>>()
{
new KeyValuePair<string, string>("@TravelAgentId", id.ToString())
};
DataSet results = ExecuteSql(sql, parameters);
TravelAgent ta = DataSetParser.DataSetToTravelAgent(results, 0);
return ta;
}
catch
{
return null;
}
}
public List<TravelAgent> GetAll()
{
List<TravelAgent> travelAgentList = new List<TravelAgent>();
try
{
string sql = "SELECT TravelAgentId, Email, Password FROM TravelAgent";
DataSet results = ExecuteSql(sql, new List<KeyValuePair<string, string>>());
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
TravelAgent ta = DataSetParser.DataSetToTravelAgent(results, x);
travelAgentList.Add(ta);
}
return travelAgentList;
}
catch
{
return null;
}
}
