public List<BusinessEntityAddress> GetAll()
{
BusinessEntityAddressDAC _businessEntityAddressComponent = new BusinessEntityAddressDAC();
IDataReader reader = _businessEntityAddressComponent.GetAllBusinessEntityAddress().CreateDataReader();
List<BusinessEntityAddress> _businessEntityAddressList = new List<BusinessEntityAddress>();
while(reader.Read())
{
if(_businessEntityAddressList == null)
_businessEntityAddressList = new List<BusinessEntityAddress>();
BusinessEntityAddress _businessEntityAddress = new BusinessEntityAddress();
if(reader["BusinessEntityAddressId"] != DBNull.Value)
_businessEntityAddress.BusinessEntityAddressId = Convert.ToInt32(reader["BusinessEntityAddressId"]);
if(reader["BusinessEntityId"] != DBNull.Value)
_businessEntityAddress.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
if(reader["AddressId"] != DBNull.Value)
_businessEntityAddress.AddressId = Convert.ToInt32(reader["AddressId"]);
if(reader["AddressTypeId"] != DBNull.Value)
_businessEntityAddress.AddressTypeId = Convert.ToInt32(reader["AddressTypeId"]);
if(reader["RowGuid"] != DBNull.Value)
_businessEntityAddress.RowGuid = new Guid(reader["RowGuid"].ToString());
if(reader["ModifiedDate"] != DBNull.Value)
_businessEntityAddress.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["AddressLine1"] != DBNull.Value)
_businessEntityAddress.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if (reader["AddressLine2"] != DBNull.Value)
_businessEntityAddress.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
if (reader["AddressLine3"] != DBNull.Value)
_businessEntityAddress.AddressLine3 = Convert.ToString(reader["AddressLine3"]);
if (reader["CountryRegionCode"] != DBNull.Value)
_businessEntityAddress.CountryRegionCode = Convert.ToString(reader["CountryRegionCode"]);
if (reader["City"] != DBNull.Value)
_businessEntityAddress.City = Convert.ToString(reader["City"]);
if (reader["StateProvinceId"] != DBNull.Value)
_businessEntityAddress.StateProvinceId = Convert.ToInt32(reader["StateProvinceId"]);
if (reader["PostalCode"] != DBNull.Value)
_businessEntityAddress.PostalCode = Convert.ToString(reader["PostalCode"]);
if (reader["ZipCode"] != DBNull.Value)
_businessEntityAddress.ZipCode = Convert.ToString(reader["ZipCode"]);
if (reader["SpatialLocation"] != DBNull.Value)
_businessEntityAddress.SpatialLocation = Convert.ToString(reader["SpatialLocation"]);
if (reader["CountryName"] != DBNull.Value)
_businessEntityAddress.CountryName = Convert.ToString(reader["CountryName"]);
_businessEntityAddress.NewRecord = false;
_businessEntityAddressList.Add(_businessEntityAddress);
} reader.Close();
return _businessEntityAddressList;
}
public bool Update(BusinessEntityAddress businessentityaddress ,int old_businessEntityAddressId)
{
BusinessEntityAddressDAC businessentityaddressComponent = new BusinessEntityAddressDAC();
return businessentityaddressComponent.UpdateBusinessEntityAddress( businessentityaddress.BusinessEntityId, businessentityaddress.AddressId, businessentityaddress.AddressTypeId, businessentityaddress.RowGuid, businessentityaddress.ModifiedDate, old_businessEntityAddressId);
}
public bool Insert(BusinessEntityAddress businessentityaddress)
{
int autonumber = 0;
BusinessEntityAddressDAC businessentityaddressComponent = new BusinessEntityAddressDAC();
bool endedSuccessfuly = businessentityaddressComponent.InsertNewBusinessEntityAddress( ref autonumber, businessentityaddress.BusinessEntityId, businessentityaddress.AddressId, businessentityaddress.AddressTypeId, businessentityaddress.RowGuid, businessentityaddress.ModifiedDate);
if(endedSuccessfuly)
{
businessentityaddress.BusinessEntityAddressId = autonumber;
}
return endedSuccessfuly;
}
