public bool Insert(string Name, DateTime ModifiedDate) { PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); int PhoneNumberTypeId = 0; return(phonenumbertypeComponent.InsertNewPhoneNumberType(ref PhoneNumberTypeId, Name, ModifiedDate)); }
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 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 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 bool Update(string Name, DateTime ModifiedDate, int Original_PhoneNumberTypeId) { PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); return(phonenumbertypeComponent.UpdatePhoneNumberType(Name, ModifiedDate, Original_PhoneNumberTypeId)); }
public bool Update(PhoneNumberType phonenumbertype, int old_phoneNumberTypeId) { PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); return(phonenumbertypeComponent.UpdatePhoneNumberType(phonenumbertype.Name, phonenumbertype.ModifiedDate, old_phoneNumberTypeId)); }
public int UpdateDataset(System.Data.DataSet dataset) { PhoneNumberTypeDAC phonenumbertypecomponent = new PhoneNumberTypeDAC(); return(phonenumbertypecomponent.UpdateDataset(dataset)); }
public void Delete(int Original_PhoneNumberTypeId) { PhoneNumberTypeDAC phonenumbertypeComponent = new PhoneNumberTypeDAC(); phonenumbertypeComponent.DeletePhoneNumberType(Original_PhoneNumberTypeId); }