Beispiel #1
0
        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);
        }
Beispiel #2
0
 public int InsertDoubleOptTRTransaction(int parentTransactionID, string mobileNumber, int subscriptionServiceID, DoubleOptStatus status, InputMechanisms inputMechanism)
 {
     return(InsertDoubleOptTRTransaction(parentTransactionID, mobileNumber, subscriptionServiceID, status, null, null, inputMechanism));
 }