public bool Insert(TransportationType transportationtype) { int autonumber = 0; TransportationTypeDAC transportationtypeComponent = new TransportationTypeDAC(); bool endedSuccessfuly = transportationtypeComponent.InsertNewTransportationType( ref autonumber, transportationtype.TypeName); if(endedSuccessfuly) { transportationtype.ID = autonumber; } return endedSuccessfuly; }
public TransportationType GetByID(int _iD) { TransportationTypeDAC _transportationTypeComponent = new TransportationTypeDAC(); IDataReader reader = _transportationTypeComponent.GetByIDTransportationType(_iD); TransportationType _transportationType = null; while(reader.Read()) { _transportationType = new TransportationType(); if(reader["ID"] != DBNull.Value) _transportationType.ID = Convert.ToInt32(reader["ID"]); if(reader["TypeName"] != DBNull.Value) _transportationType.TypeName = Convert.ToString(reader["TypeName"]); _transportationType.NewRecord = false; } reader.Close(); return _transportationType; }
public List<TransportationType> GetAll() { TransportationTypeDAC _transportationTypeComponent = new TransportationTypeDAC(); IDataReader reader = _transportationTypeComponent.GetAllTransportationType().CreateDataReader(); List<TransportationType> _transportationTypeList = new List<TransportationType>(); while(reader.Read()) { if(_transportationTypeList == null) _transportationTypeList = new List<TransportationType>(); TransportationType _transportationType = new TransportationType(); if(reader["ID"] != DBNull.Value) _transportationType.ID = Convert.ToInt32(reader["ID"]); if(reader["TypeName"] != DBNull.Value) _transportationType.TypeName = Convert.ToString(reader["TypeName"]); _transportationType.NewRecord = false; _transportationTypeList.Add(_transportationType); } reader.Close(); return _transportationTypeList; }
public bool Update(TransportationType transportationtype ,int old_iD) { TransportationTypeDAC transportationtypeComponent = new TransportationTypeDAC(); return transportationtypeComponent.UpdateTransportationType( transportationtype.TypeName, old_iD); }