public Address GetByID(int _addressId) { AddressDAC _addressComponent = new AddressDAC(); IDataReader reader = _addressComponent.GetByIDAddress(_addressId); Address _address = null; while(reader.Read()) { _address = new Address(); if(reader["AddressId"] != DBNull.Value) _address.AddressId = Convert.ToInt32(reader["AddressId"]); if(reader["AddressLine1"] != DBNull.Value) _address.AddressLine1 = Convert.ToString(reader["AddressLine1"]); if(reader["AddressLine2"] != DBNull.Value) _address.AddressLine2 = Convert.ToString(reader["AddressLine2"]); if(reader["AddressLine3"] != DBNull.Value) _address.AddressLine3 = Convert.ToString(reader["AddressLine3"]); if(reader["CountryRegionCode"] != DBNull.Value) _address.CountryRegionCode = Convert.ToString(reader["CountryRegionCode"]); if(reader["City"] != DBNull.Value) _address.City = Convert.ToString(reader["City"]); if(reader["StateProvinceId"] != DBNull.Value) _address.StateProvinceId = Convert.ToInt32(reader["StateProvinceId"]); if(reader["PostalCode"] != DBNull.Value) _address.PostalCode = Convert.ToString(reader["PostalCode"]); if(reader["ZipCode"] != DBNull.Value) _address.ZipCode = Convert.ToString(reader["ZipCode"]); if(reader["SpatialLocation"] != DBNull.Value) _address.SpatialLocation = Convert.ToString(reader["SpatialLocation"]); if(reader["RowGuid"] != DBNull.Value) _address.RowGuid = new Guid(reader["RowGuid"].ToString()); if(reader["ModifiedDate"] != DBNull.Value) _address.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _address.NewRecord = false; } reader.Close(); return _address; }
public List<Address> GetAll() { AddressDAC _addressComponent = new AddressDAC(); IDataReader reader = _addressComponent.GetAllAddress().CreateDataReader(); List<Address> _addressList = new List<Address>(); while(reader.Read()) { if(_addressList == null) _addressList = new List<Address>(); Address _address = new Address(); if(reader["AddressId"] != DBNull.Value) _address.AddressId = Convert.ToInt32(reader["AddressId"]); if(reader["AddressLine1"] != DBNull.Value) _address.AddressLine1 = Convert.ToString(reader["AddressLine1"]); if(reader["AddressLine2"] != DBNull.Value) _address.AddressLine2 = Convert.ToString(reader["AddressLine2"]); if(reader["AddressLine3"] != DBNull.Value) _address.AddressLine3 = Convert.ToString(reader["AddressLine3"]); if(reader["CountryRegionCode"] != DBNull.Value) _address.CountryRegionCode = Convert.ToString(reader["CountryRegionCode"]); if(reader["City"] != DBNull.Value) _address.City = Convert.ToString(reader["City"]); if(reader["StateProvinceId"] != DBNull.Value) _address.StateProvinceId = Convert.ToInt32(reader["StateProvinceId"]); if(reader["PostalCode"] != DBNull.Value) _address.PostalCode = Convert.ToString(reader["PostalCode"]); if(reader["ZipCode"] != DBNull.Value) _address.ZipCode = Convert.ToString(reader["ZipCode"]); if(reader["SpatialLocation"] != DBNull.Value) _address.SpatialLocation = Convert.ToString(reader["SpatialLocation"]); if(reader["RowGuid"] != DBNull.Value) _address.RowGuid = new Guid(reader["RowGuid"].ToString()); if(reader["ModifiedDate"] != DBNull.Value) _address.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); _address.NewRecord = false; _addressList.Add(_address); } reader.Close(); return _addressList; }
public bool Update(Address address ,int old_addressId) { AddressDAC addressComponent = new AddressDAC(); return addressComponent.UpdateAddress( address.AddressLine1, address.AddressLine2, address.AddressLine3, address.CountryRegionCode, address.City, address.StateProvinceId, address.PostalCode, address.ZipCode, address.SpatialLocation, address.RowGuid, address.ModifiedDate, old_addressId); }
public bool Insert(Address address) { int autonumber = 0; AddressDAC addressComponent = new AddressDAC(); bool endedSuccessfuly = addressComponent.InsertNewAddress( ref autonumber, address.AddressLine1, address.AddressLine2, address.AddressLine3, address.CountryRegionCode, address.City, address.StateProvinceId, address.PostalCode, address.ZipCode, address.SpatialLocation, address.RowGuid, address.ModifiedDate); if(endedSuccessfuly) { address.AddressId = autonumber; } return endedSuccessfuly; }