public void deleteAddress(Address address) { try { AxLogon(); using (axRecord = ax.CreateAxaptaRecord(tableName)) { // Execute a query to retrieve an editable record // where the name is MyStateUpdated. string stmt = "select forupdate * from %1 where %1.RecId == " + address.recId + ""; axRecord.ExecuteStmt(stmt); deleteAxRecord(); } ax.Logoff(); } catch (Exception e) { throw (e); } finally { ax.Logoff(); } }
public void createAddress(Address address) { try { AxLogon(); // Create a new AddressState table record. using (axRecord = ax.CreateAxaptaRecord(tableName)) { createAxRecord(address); } ax.Logoff(); } catch (Exception e) { throw (e); } finally { ax.Logoff(); } }
public List<Address> getListOfAdresses() { Addresses addresses = new Addresses(); // The AddressState field names for calls to // the AxRecord.get_field method. string strNameField = "NAME"; string strStateIdField = "STATEID"; string strRecIdField = "RecId"; // The output variables for calls to the // AxRecord.get_Field method. string fieldName, fieldStateId, recId; try { AxLogon(); // Create a query using the AxaptaRecord class // for the StateAddress table. using (axRecord = ax.CreateAxaptaRecord(tableName)) { // Execute the query on the table. string stmt = "select * from %1"; axRecord.ExecuteStmt(stmt); // Loop through the set of retrieved records. while (axRecord.Found) { // Retrieve the record data for the specified fields. fieldName = (String)axRecord.get_Field(strNameField); fieldStateId = (String)axRecord.get_Field(strStateIdField); recId = axRecord.get_Field(strRecIdField).ToString(); if (!String.IsNullOrEmpty(fieldName) && !String.IsNullOrEmpty(fieldStateId) && !String.IsNullOrEmpty(recId)) { Address address = new Address(); address.Name = fieldName; address.StateId = fieldStateId; address.recId = recId; addresses.Add(address); } // Advance to the next row. axRecord.Next(); } } ax.Logoff(); } catch (Exception e) { throw (e); } finally { ax.Logoff(); } return addresses; }
private void updateAxRecord(Address address) { // If the record is found then update the name. if (axRecord.Found) { // Start a transaction that can be committed. ax.TTSBegin(); axRecord.set_Field("NAME", address.Name); axRecord.set_Field("STATEID", address.StateId); axRecord.set_Field("COUNTRYREGIONID", address.CountryRegionId); axRecord.set_Field("INTRASTATCODE", ""); axRecord.Update(); // Commit the transaction. ax.TTSCommit(); } }
private void createAxRecord(Address address) { // Provide values for each of the AddressState record fields. axRecord.set_Field("NAME", address.Name); axRecord.set_Field("STATEID", address.StateId); axRecord.set_Field("COUNTRYREGIONID", address.CountryRegionId); axRecord.set_Field("INTRASTATCODE", ""); // Commit the record to the database. axRecord.Insert(); }