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; }
public Position GetByID(int _positionID) { PositionDAC _positionComponent = new PositionDAC(); IDataReader reader = _positionComponent.GetByIDPosition(_positionID); Position _position = null; while (reader.Read()) { _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; } reader.Close(); return _position; }
public bool Update(Position position, int old_positionID) { PositionDAC positionComponent = new PositionDAC(); return positionComponent.UpdatePosition(position.SiteID, position.Name, position.Code, old_positionID); }
public bool Insert(Position position) { int autonumber = 0; PositionDAC positionComponent = new PositionDAC(); bool endedSuccessfuly = positionComponent.InsertNewPosition(ref autonumber, position.SiteID, position.Name, position.Code); if (endedSuccessfuly) { position.PositionID = autonumber; } return endedSuccessfuly; }