private IEnumerator Databasecall(string Path, WWWForm Varibles, DatabaseCallback Callback)
{
WWW urlRequest = new WWW(Path, Varibles);
yield return(urlRequest);
Callback.Invoke(urlRequest.text);
}
private static void UpdateCreateDatabaseCallback(DatabaseCallback cb, DatabaseArgs args, DatabaseState state)
{
args.state = state;
if (args.state == DatabaseState.Starting)
{
args.elapsedMilliseconds = 0;
}
if (cb != null)
{
cb(args);
}
}
public void SaveStoreData(DatabaseCallback callback)
{
DatabaseReference reference = FirebaseDatabase.DefaultInstance.GetReference(PLAYERS);
reference.Child(this.GetUserID()).Child(STORE_DATA).SetRawJsonValueAsync(GetStoreDataFromFiles()).ContinueWith(task =>
{
if (task.IsFaulted && task.Exception != null)
{
callback(false, "Could Not Save Store Data");
}
else if (task.IsCompleted)
{
callback(true, "Saved Store Data");
}
});
}
public DatabaseSync openDatabaseSync(string name, string version, string displayName, int estimatedSize, DatabaseCallback creationCallback)
{
return(default(DatabaseSync));
}
public static Database openDatabase(string name, JsString version, JsString displayName, int estimatedSize, DatabaseCallback creationCallback)
{
return(null);
}
public static Database openDatabase(string name, JsString version, JsString displayName, int estimatedSize, DatabaseCallback creationCallback) { return null; }
public Database openDatabase(string name, string version, string displayName, int estimatedSize, DatabaseCallback creationCallback) { return default(Database); }
public static void DeleteDbIfExists(SqlConnectionStringBuilder csB, int callbackFrequencyInMilliseconds, DatabaseCallback cb)
{
if (SqlUtilities.DatabaseExist(csB))
{
bool databaseDropped = false;
string dbName;
string fop;
dbName = csB.InitialCatalog;
fop = csB.FailoverPartner;
try
{
csB.InitialCatalog = string.Empty;
csB.FailoverPartner = string.Empty;
SqlUtilities.CloseDatabaseConnections(csB.ConnectionString, dbName);
if (!SqlUtilities.IsDatabaseConnected(csB.ConnectionString, dbName))
{
csB.InitialCatalog = dbName;
csB.FailoverPartner = fop;
SqlUtilities.DropDatabase(csB, callbackFrequencyInMilliseconds, cb);
databaseDropped = true;
}
}
finally
{
csB.InitialCatalog = dbName;
csB.FailoverPartner = fop;
}
if (databaseDropped == false)
{
try
{
csB.InitialCatalog = dbName;
csB.FailoverPartner = fop;
SqlUtilities.DropDatabase(csB, callbackFrequencyInMilliseconds, cb);
databaseDropped = true;
}
catch (Exception)
{
throw new InvalidOperationException(string.Format("Drop database failed. Users are connected to database {0}", dbName));
}
}
}
}
public static void DropDatabase(SqlConnectionStringBuilder connectionBuilder, int callbackFrequencyInMilliseconds, DatabaseCallback cb)
{
try
{
string databaseName = connectionBuilder.InitialCatalog;
bool pooling = connectionBuilder.Pooling;
string fop = connectionBuilder.FailoverPartner;
connectionBuilder.InitialCatalog = string.Empty;
connectionBuilder.Pooling = false;
connectionBuilder.FailoverPartner = string.Empty;
using (SqlConnection connection = new SqlConnection(connectionBuilder.ConnectionString))
{
string createDatabaseString = string.Format(Constants.SqlScript.DropDatabase, databaseName);
SqlCommand command = new SqlCommand(createDatabaseString, connection);
connectionBuilder.InitialCatalog = databaseName;
connectionBuilder.Pooling = pooling;
connectionBuilder.FailoverPartner = fop;
connection.Open();
DatabaseArgs args = new DatabaseArgs();
UpdateCreateDatabaseCallback(cb, args, DatabaseState.Starting);
IAsyncResult result = command.BeginExecuteNonQuery();
while (!result.IsCompleted)
{
System.Threading.Thread.Sleep(callbackFrequencyInMilliseconds);
args.elapsedMilliseconds = args.elapsedMilliseconds + callbackFrequencyInMilliseconds;
UpdateCreateDatabaseCallback(cb, args, DatabaseState.Working);
}
command.EndExecuteNonQuery(result);
UpdateCreateDatabaseCallback(cb, args, DatabaseState.Finished);
}
}
catch (Exception exception)
{
System.Diagnostics.Debug.Assert(false);
throw exception;
}
}
public Database OpenDatabase(JsString name, JsString version, JsString displayName, int estimatedSize, DatabaseCallback creationCallback)
{
return(default(Database));
}
public void QueryDatabase(QueryValues QueryValues, DatabaseCallback Callback)
{
StartCoroutine(Databasecall(DATABASE_LOCATION, toFormVariables(QueryValues), Callback));
}
