public string JSONparametrosAddDatabase(parametrosAddDatabase addDatabase)
{
try {
MariaConnect db = new MariaConnect("localhost", "TEST", "prueba", "prueba");
db.NonQuery("CALL registrar_conexion('" + addDatabase.database_type + "','"
+ addDatabase.user + "','"
+ addDatabase.pass + "','"
+ addDatabase.server + "','"
+ addDatabase.protocol + "','"
+ addDatabase.port + "','"
+ addDatabase.alias + "');");
/*ArrayList filas = new ArrayList();
*
* string prueba = "";
*
* filas = db.Select2("db_connection");
*
* for (int i = 0; i < filas.Count; i++) prueba += filas[i];
*
*
* return prueba;*/
return("Conexion exitosa");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public string addDatabase(parametrosAddDatabase addDatabase)
{
try {
MariaConnect db = new MariaConnect("localhost", "TEST", "prueba", "prueba", "3306");
db.NonQuery("CALL registrar_conexion('" + addDatabase.database_type + "','"
+ addDatabase.user + "','"
+ addDatabase.pass + "','"
+ addDatabase.server + "','"
+ addDatabase.protocol + "','"
+ addDatabase.port + "','"
+ addDatabase.alias + "');");
return("{\"message\": \"Conexion creada exitosamente\"}");
}
catch (Exception ex)
{
return("{\"messageError\": \"" + ex.ToString() + "\"}");
}
}