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 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 List <IntershopWebService.SizeStock> getItemDims(string itemId, string company)
{
List <IntershopWebService.SizeStock> sizeStockList = new List <IntershopWebService.SizeStock>();
Axapta axapta = (Axapta)null;
try
{
axapta = this.axLogon(company);
string str = "select * from %1 where %1.ItemId == '" + itemId + "'";
AxaptaRecord axaptaRecord = axapta.CreateAxaptaRecord("InventSize");
axaptaRecord.ExecuteStmt(str);
while (axaptaRecord.Found)
{
IntershopWebService.SizeStock sizeStock = new IntershopWebService.SizeStock();
if (Convert.ToBoolean(axaptaRecord.get_Field("Color")))
{
sizeStock.color = Convert.ToString(axaptaRecord.get_Field("InventSizeId"));
}
else
{
sizeStock.size = Convert.ToString(axaptaRecord.get_Field("InventSizeId"));
}
sizeStockList.Add(sizeStock);
axaptaRecord.Next();
}
return(sizeStockList);
}
catch (Exception ex)
{
MessageLogger.info(string.Format("getItemDims(itemId={0}, company={1} -> error: {2})", itemId, company, ex.Message));
return((List <IntershopWebService.SizeStock>)null);
}
finally
{
axapta.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;
}
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);
}
