// CUSTOMER METHODS
public static int UpdateCustomer(Customer customer)
{
// Transaction to perform 4 inter-related data inserts on multiple database tables
using (TransactionScope scope = new TransactionScope())
{
int returnValue = 1;
// Write PERSON record to database
BusinessObjects _personBusinessObject = new BusinessObjects();
returnValue = _personBusinessObject.UpdatePersonFromCustomer(customer);
if (returnValue == 1)
{ // If insert fails, rollback transaction & display error message
scope.Dispose();
ApplicationObjects.DisplayDataStatus(returnValue);
return 1;
}
// Write MAILING ADDRESS record to database
BusinessObjects _mailingAddressBusinessObject = new BusinessObjects();
returnValue = _mailingAddressBusinessObject.UpdateAddress(customer.MailingAddress);
if (returnValue == 1)
{ // If insert fails, rollback transaction & display error message
scope.Dispose();
ApplicationObjects.DisplayDataStatus(returnValue);
return 1;
}
// Write BILLING ADDRESS record to database
BusinessObjects _billingAddressBusinessObject = new BusinessObjects();
returnValue = _billingAddressBusinessObject.UpdateAddress(customer.BillingAddress);
if (returnValue == 1)
{ // If insert fails, rollback transaction & display error message
scope.Dispose();
ApplicationObjects.DisplayDataStatus(returnValue);
return 1;
}
// Committ data transaction & display success message
scope.Complete();
ApplicationObjects.DisplayDataStatus(returnValue);
return 0;
}// End transaction
}