Dynamics Community Forum Thread Details

I have a requirement to add an order hold code to a Sales Order when a credit card capture gets declined. In other words, upon a credit card authorization (CreditCardAuthTrans) entry in a /declined/ status getting inserted, I need to apply an order hold code to this sales order. I have been trying to get this to happen by inserting a hold code transaction (MCRHoldCodeTrans) for the sales order when a CreditCardAuthTrans) entry in a /declined/ status gets inserted (using event handlers, chain of command). I have tried a number of things posted below, and everytime I step through the code it appears to be correctly setting and inserting a MCRHoldCodeTrans, but when I query the database or check on the front end, it appears that nothing is happening. I even tried using doInsert() and this didn't work either. Has anyone ever seen anything like this, or have any ideas to try for this scenario? Thanks!

idea 1: insert MCRHoldCodeTrans on inserting event handler for CreditCardAuthTrans; I also tried this with the OnInsert event and it didn't work

[DataEventHandler(tableStr(CreditCardAuthTrans), DataEventType::Inserting)]
public static void CreditCardAuthTrans_onInserting(Common sender, DataEventArgs e)
{
CreditCardAuthTrans creditCardAuthTrans = sender as CreditCardAuthTrans;
MCRHoldCodeTrans holdCodeTrans;
CustParameters custParameters;
select custParameters where custParameters.DataAreaId == 'rev';
str declinedCCHoldCode = custParameters.revDeclinedCCOrderHoldCode;
CreditCardProcessorStatus status = creditCardAuthTrans.ProcessorStatus;
str salesId = creditCardAuthTrans.SalesId;

if(creditCardAuthTrans.ProcessorStatus == CreditCardProcessorStatus::Declined)
{
ttsbegin;
select forupdate holdCodeTrans;
holdCodeTrans.initValue();
holdCodeTrans.InventRefId = creditCardAuthTrans.SalesId;
holdCodeTrans.MCRHoldCode = declinedCCHoldCode;
holdCodetrans.RetailInfocodeId = 'HoldCode';
holdCodeTrans.insert();
ttscommit;
}
}

////Idea 2; Chain of Command on CreditCardAuthTrans.insert() but didn't work

public void insert()
{

MCRHoldCodeTrans holdCodeTrans;
CustParameters custParameters;
select custParameters where custParameters.DataAreaId == 'rev';
str declinedCCHoldCode = custParameters.revDeclinedCCOrderHoldCode;
CreditCardProcessorStatus status = this.ProcessorStatus;
str salesId = this.SalesId;

if(this.ProcessorStatus == CreditCardProcessorStatus::Declined)
{
//ttsbegin;
holdCodeTrans.InventRefId = this.SalesId;
holdCodeTrans.MCRHoldCode = declinedCCHoldCode;
holdCodetrans.RetailInfocodeId = 'HoldCode';
holdCodeTrans.insert();
//ttscommit;
}
next insert();

   [DataEventHandler(tableStr(CreditCardAuthTrans), DataEventType::Inserted)]    public static void CreditCardAuthTrans_onInserted(Common sender, DataEventArgs e)    {        CreditCardAuthTrans creditCardAuthTrans = sender as CreditCardAuthTrans;        MCRHoldCodeTrans holdCodeTrans;        CustParameters custParameters;        select custParameters where custParameters.DataAreaId == 'rev';        str declinedCCHoldCode = custParameters.revDeclinedCCOrderHoldCode;        CreditCardProcessorStatus status = creditCardAuthTrans.ProcessorStatus;        str salesId = creditCardAuthTrans.SalesId;                if(creditCardAuthTrans.ProcessorStatus == CreditCardProcessorStatus::Declined)        {            ttsbegin;            select forupdate holdCodeTrans;            holdCodeTrans.initValue();            holdCodeTrans.InventRefId = creditCardAuthTrans.SalesId;            holdCodeTrans.MCRHoldCode = declinedCCHoldCode;            holdCodetrans.RetailInfocodeId = 'HoldCode';            holdCodeTrans.insert();            ttscommit;        }    }/// Idea 2: CoC on CreditCardAuthTrans.insert()    public void insert()    {              MCRHoldCodeTrans holdCodeTrans;        CustParameters custParameters;        select custParameters where custParameters.DataAreaId == 'rev';        str declinedCCHoldCode = custParameters.revDeclinedCCOrderHoldCode;        CreditCardProcessorStatus status = this.ProcessorStatus;        str salesId = this.SalesId;                if(this.ProcessorStatus == CreditCardProcessorStatus::Declined)        {            //ttsbegin;            holdCodeTrans.InventRefId = this.SalesId;            holdCodeTrans.MCRHoldCode = declinedCCHoldCode;            holdCodetrans.RetailInfocodeId = 'HoldCode';            holdCodeTrans.insert();            //ttscommit;        }        next insert();/// Idea 3, event handler on inserting    [DataEventHandler(tableStr(CreditCardAuthTrans), DataEventType::Inserting)]    public static void CreditCardAuthTrans_onInserting(Common sender, DataEventArgs e)    {        CreditCardAuthTrans creditCardAuthTrans = sender as CreditCardAuthTrans;        MCRHoldCodeTrans holdCodeTrans;        CustParameters custParameters;        select custParameters where custParameters.DataAreaId == 'rev';        str declinedCCHoldCode = custParameters.revDeclinedCCOrderHoldCode;        CreditCardProcessorStatus status = creditCardAuthTrans.ProcessorStatus;        str salesId = creditCardAuthTrans.SalesId;                if(creditCardAuthTrans.ProcessorStatus == CreditCardProcessorStatus::Declined)        {            ttsbegin;            select forupdate holdCodeTrans;            holdCodeTrans.initValue();            holdCodeTrans.InventRefId = creditCardAuthTrans.SalesId;            holdCodeTrans.MCRHoldCode = declinedCCHoldCode;            holdCodetrans.RetailInfocodeId = 'HoldCode';            holdCodeTrans.insert();            ttscommit;        }    }