public int InsertDoubleOptTRTransaction(int parentTransactionID, string mobileNumber, int subscriptionServiceID, DoubleOptStatus status, string exception, int?subscriptionID, InputMechanisms inputMechanism)
{
int transactionID = 0;
if (!string.IsNullOrEmpty(exception))
{
exception = "'" + exception.Replace("'", "''") + "'";
}
else
{
exception = "NULL";
}
using (CDB cdb = new CDB("Insert double OPT TR Transaction"))
{
string queryString = string.Format("Insert_trSubscriptionDoubleOpt {0},'{1}',{2},{3},{4},{5},{6}", parentTransactionID, mobileNumber, subscriptionServiceID, (int)status, exception, subscriptionID == null ? "NULL" : subscriptionID.ToString(), (int)inputMechanism);
transactionID = int.Parse(cdb.Execute(queryString, CDB.exmReturnTypes.RETURN_SCALAR).ToString());
}
return(transactionID);
}
public int InsertDoubleOptTRTransaction(int parentTransactionID, string mobileNumber, int subscriptionServiceID, DoubleOptStatus status, InputMechanisms inputMechanism)
{
return(InsertDoubleOptTRTransaction(parentTransactionID, mobileNumber, subscriptionServiceID, status, null, null, inputMechanism));
}