public bool UpdateAddress(int addressID, string shippingName, string contactFirstName, string contactLastName, string shippingAddress, string shippingCity, string shippingState, string shippingPostal, string shippingPhone, string shippingEmail, string shippingFax, string shippingNote)
{
StringBuilder str = new StringBuilder(string.Empty);
if (string.IsNullOrEmpty(shippingName))
{
str.Append("Shipping Name, ");
}
if (string.IsNullOrEmpty(shippingAddress))
{
str.Append("Shipping Address, ");
}
if (string.IsNullOrEmpty(shippingCity))
{
str.Append("Shipping City, ");
}
if (string.IsNullOrEmpty(shippingState))
{
str.Append("Shipping State, ");
}
if (str.Length > 0)
{
throw new ApplicationException(string.Format("You must provide a {0}.", str.ToString().Substring(0, (str.Length - 2))));
}
SPG.ShippingAddressesDataTable addresses = Adapter.GetAddressByID(addressID);
if (addresses.Count() == 0)
{
//It is a new Shipping Address
return(InsertAddress(addressID, shippingName, contactFirstName, contactLastName, shippingAddress, shippingCity, shippingState, shippingPostal, shippingPhone, shippingEmail, shippingFax, shippingNote));
}
SPG.ShippingAddressesRow address = addresses[0];
object[] originalRecord = address.ItemArray;
SetAddressFields(shippingName, contactFirstName, contactLastName, shippingAddress, shippingCity, shippingState, shippingPostal, shippingPhone, shippingEmail, shippingFax, shippingNote, address);
if (!(originalRecord == null))
{
UpdateAuditTrail(address, originalRecord);
}
int rowsAffected = Adapter.Update(address);
return(rowsAffected == 1);
}
public bool InsertAddress(int addressID, string shippingName, string contactFirstName, string contactLastName, string shippingAddress, string shippingCity, string shippingState, string shippingPostal, string shippingPhone, string shippingEmail, string shippingFax, string shippingNote)
{
SPG.ShippingAddressesDataTable addresses = new SPG.ShippingAddressesDataTable();
SPG.ShippingAddressesRow address = addresses.NewShippingAddressesRow();
address.AddressID = addressID;
SetAddressFields(shippingName, contactFirstName, contactLastName, shippingAddress, shippingCity, shippingState, shippingPostal, shippingPhone, shippingEmail, shippingFax, shippingNote, address);
address.strEnteredBy = Properties.Settings.Default.UserName;
address.dtmEnteredOn = DateTime.Now;
addresses.AddShippingAddressesRow(address);
int rowsAffected = Adapter.Update(addresses);
return(rowsAffected == 1);
}
