private static Address CreateAddress()
{
Address address = new Address();
address.AddressId = GetNewAddressId();
return GetAddressInfo(address);
}
private static Address GetAddressInfo(Address address)
{
address.Address1 = GetAddress1();
address.Address2 = GetAddress2();
address.Address3 = GetAddress3();
address.City = GetCity();
address.State = GetState();
address.ZipCode = GetZipCode();
address.Province = GetProvince();
address.CountryCode = GetCountryCode();
return address;
}
public Customer()
{
CustomerId = 0;
FirstName = String.Empty;
LastName = String.Empty;
Address = new Address();
Phone = String.Empty;
Email = String.Empty;
LastOrderDate = DateTime.Today;
}
public long UpdateAddress(Address address)
{
return (new AddressDao(Connection, SchemaName)).Update(address);
}
public long AddAddress(Address address)
{
return (new AddressDao(Connection, SchemaName)).Insert(address);
}
private static Address GetCustomerAddress()
{
Address address = new Address();
address.AddressId = DbHelper.GetRandomRowId(
TableName.ADDRESS.ToString(),
DbDefault.GetTableStructure(TableName.ADDRESS).PKColumns[0]);
return address;
}
private String BuildQuery(String statement, Address address)
{
return String.Format(statement,
GFXDDbi.Escape(address.Address1),
GFXDDbi.Escape(address.Address2),
GFXDDbi.Escape(address.Address3),
GFXDDbi.Escape(address.City),
GFXDDbi.Escape(address.State.ToString()),
GFXDDbi.Escape(address.ZipCode.ToString()),
GFXDDbi.Escape(address.Province.ToString()),
(int)address.CountryCode);
}
public int Update(Address address)
{
String statement = QualifyTableName(DbDefault.GetUpdateStatement(
TableName.ADDRESS, new long[] { address.AddressId }));
if (Connection != null)
return GFXDDbi.Update(Connection, BuildQuery(statement, address));
else
return GFXDDbi.Update(BuildQuery(statement, address));
}
public long Insert(Address address)
{
String statement = QualifyTableName(DbDefault.GetInsertStatement(
TableName.ADDRESS, new long[] { address.AddressId }));
statement = BuildQuery(statement, address);
if (Connection != null)
return GFXDDbi.Insert(Connection, statement);
else
return GFXDDbi.Insert(statement);
}