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