public bool Insert(PhoneNumberType phonenumbertype) { int autonumber = 0; PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); bool endedSuccessfuly = phonenumbertypeComponent.InsertNewPhoneNumberType( ref autonumber, phonenumbertype.Name, phonenumbertype.ModifiedDate); if(endedSuccessfuly) { phonenumbertype.PhoneNumberTypeId = autonumber; } return endedSuccessfuly; }
public PhoneNumberType GetByID(int _phoneNumberTypeId) { PhoneNumberTypeDAC _phoneNumberTypeComponent = new PhoneNumberTypeDAC(); IDataReader reader = _phoneNumberTypeComponent.GetByIDPhoneNumberType(_phoneNumberTypeId); PhoneNumberType _phoneNumberType = null; while(reader.Read()) { _phoneNumberType = new PhoneNumberType(); if(reader["PhoneNumberTypeId"] != DBNull.Value) _phoneNumberType.PhoneNumberTypeId = Convert.ToInt32(reader["PhoneNumberTypeId"]); if(reader["Name"] != DBNull.Value) _phoneNumberType.Name = Convert.ToString(reader["Name"]); if(reader["ModifiedDate"] != DBNull.Value) _phoneNumberType.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _phoneNumberType.NewRecord = false; } reader.Close(); return _phoneNumberType; }
public List<PhoneNumberType> GetAll() { PhoneNumberTypeDAC _phoneNumberTypeComponent = new PhoneNumberTypeDAC(); IDataReader reader = _phoneNumberTypeComponent.GetAllPhoneNumberType().CreateDataReader(); List<PhoneNumberType> _phoneNumberTypeList = new List<PhoneNumberType>(); while(reader.Read()) { if(_phoneNumberTypeList == null) _phoneNumberTypeList = new List<PhoneNumberType>(); PhoneNumberType _phoneNumberType = new PhoneNumberType(); if(reader["PhoneNumberTypeId"] != DBNull.Value) _phoneNumberType.PhoneNumberTypeId = Convert.ToInt32(reader["PhoneNumberTypeId"]); if(reader["Name"] != DBNull.Value) _phoneNumberType.Name = Convert.ToString(reader["Name"]); if(reader["ModifiedDate"] != DBNull.Value) _phoneNumberType.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _phoneNumberType.NewRecord = false; _phoneNumberTypeList.Add(_phoneNumberType); } reader.Close(); return _phoneNumberTypeList; }
public bool Update(PhoneNumberType phonenumbertype ,int old_phoneNumberTypeId) { PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); return phonenumbertypeComponent.UpdatePhoneNumberType( phonenumbertype.Name, phonenumbertype.ModifiedDate, old_phoneNumberTypeId); }