/// <summary> /// Return Database object /// </summary> /// <returns></returns> private object GetDB() { Models.core.Database db = new Models.core.Database(); db.type = ServerSettings.DatabaseType; if (!String.IsNullOrEmpty(db.type) && db.type != "") { switch (db.type.ToLower()) { case "sqlite": db.path = ServerSettings.DatabaseFile; break; case "sqlserver": db.login = ServerSettings.DatabaseUsername; db.password = ServerSettings.DatabasePassword; db.table = ServerSettings.DatabaseName; db.server = ServerSettings.DatabaseServer; break; case "mysql": db.login = ServerSettings.MySQL_Username; db.password = ServerSettings.MySQL_Password; db.table = ServerSettings.MySQL_SchemaName; db.server = ServerSettings.MySQL_Hostname; break; } return(db); } else { return(HttpStatusCode.BadRequest); } }
/// <summary> /// Setup Database and Init it /// </summary> /// <returns></returns> private object SetupDB() { Models.core.Database db = this.Bind(); if (!String.IsNullOrEmpty(db.type) && db.type != "") { switch (db.type.ToLower()) { case "sqlite": ServerSettings.DatabaseType = "SQLite"; ServerSettings.DatabaseFile = db.path; break; case "sqlserver": ServerSettings.DatabaseType = "SQLServer"; ServerSettings.DatabaseUsername = db.login; ServerSettings.DatabasePassword = db.password; ServerSettings.DatabaseName = db.table; ServerSettings.DatabaseServer = db.server; break; case "mysql": ServerSettings.DatabaseType = "MySQL"; ServerSettings.MySQL_Username = db.login; ServerSettings.MySQL_Password = db.password; ServerSettings.MySQL_SchemaName = db.table; ServerSettings.MySQL_Hostname = db.server; break; } //ShokoServer.workerSetupDB.RunWorkerAsync(); return(HttpStatusCode.OK); } else { return(HttpStatusCode.BadRequest); } }