public List<Position> GetAllBySiteID(int SiteID)
{
PositionDAC _positionComponent = new PositionDAC();
IDataReader reader = _positionComponent.GetAllPosition("SiteID = " + SiteID).CreateDataReader();
List<Position> _positionList = new List<Position>();
while (reader.Read())
{
if (_positionList == null)
_positionList = new List<Position>();
Position _position = new Position();
if (reader["PositionID"] != DBNull.Value)
_position.PositionID = Convert.ToInt32(reader["PositionID"]);
if (reader["SiteID"] != DBNull.Value)
_position.SiteID = Convert.ToInt32(reader["SiteID"]);
if (reader["Name"] != DBNull.Value)
_position.Name = Convert.ToString(reader["Name"]);
if (reader["Code"] != DBNull.Value)
_position.Code = Convert.ToString(reader["Code"]);
_position.NewRecord = false;
_positionList.Add(_position);
} reader.Close();
return _positionList;
}
