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