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)); }