public void sqlBatch(JArray queries, ICallback success, ICallback error) { try { DbConnection.BeginTransaction(); foreach (JToken parsedValue in queries.Children()) { JArray parameters = new JArray(); String query = null; if (parsedValue.Type == JTokenType.Array) { foreach (JToken token in parsedValue.Value <JArray>().Children()) { if (token.Type == JTokenType.String) { query = token.Value <String>(); } else { parameters.Add(token.ToObject <Object>()); } } } else if (parsedValue.Type == JTokenType.String) { query = parsedValue.Value <String>(); } object[] parms = ReactJsonConverter.jsonToReact(parameters); if (query != null) { bool result = this.execute(query, new CallbackContext(success, error), parms); if (!result) { DbConnection.Rollback(); break; } } else { DbConnection.Rollback(); break; } } DbConnection.Commit(); } catch (Exception ex) { error.Invoke("Unexpected error"); } }
public void executeSql(string query, JArray parms, ICallback success, ICallback error) { object[] convertedParams = ReactJsonConverter.jsonToReact(parms); this.execute(query, new CallbackContext(success, error), convertedParams); }