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() + "\"}"); } }