public List <BusStationDTO> GetAllBus()
{
string query = "Select * from BusStation";
SqlParameter[] sqlParameters = new SqlParameter[0];
try
{
DataTable dt = conn.ExecuteSelectQuery(query, sqlParameters);
List <BusStationDTO> list = new List <BusStationDTO>();
foreach (DataRow r in dt.Rows)
{
BusStationDTO dto = GetBusStationDTOFromDataRow(r);
list.Add(dto);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
public List <RoleDTO> GetAll()
{
string sql = "Select * from role ";
List <RoleDTO> list = new List <RoleDTO>();
SqlParameter[] sqlParameters = new SqlParameter[0];
DataTable dt = conn.ExecuteSelectQuery(sql, sqlParameters);
foreach (DataRow i in dt.Rows)
{
list.Add(GetRoleRow(i));
}
return(list);
}
