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