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;
}
