protected void clbAtualizar_Callback(object source, CallbackEventArgs e) { //************************* //* Deserializa requisição //************************* JavaScriptSerializer oSerializer = new JavaScriptSerializer(); var oJSON = oSerializer.Deserialize <dynamic>(e.Parameter); string Conexao = string.Empty; //***************************** //* Define operação à executar //***************************** switch ((string)oJSON["operacao"]) { case "Validar_Conexao": //******************** //* Driver ODBC/MySQL //******************** Conexao = String.Format("Driver={{{0}}};Server={1};Database={2};Port={3};UID={4};Password={5};persist security info=True;", oJSON["conexao_driver"], oJSON["conexao_server"], oJSON["conexao_database"], oJSON["conexao_port"], oJSON["conexao_user"], oJSON["conexao_password"]); //******************************************** //* Obtem conexão a partir do nome da empresa //******************************************** DBManager oDBManager = new DBManager(Conexao); //*************************************************** //* Realiza operação de consulta para testar conexão //*************************************************** oDBManager.ExecuteQuery("SELECT * FROM usuarios"); //**************************************** //* Retorna status da operação ao cliente //**************************************** oJSON["errorText"] = oDBManager.ErrorMessage; oJSON["error"] = oDBManager.Error; //***************** //* Libera objetos //***************** oDBManager.Dispose(); break; case "Atualizar_Banco": //******************** //* Driver ODBC/MySQL //******************** Conexao = String.Format("Driver={{{0}}};Server={1};Database={2};Port={3};UID={4};Password={5};persist security info=True;", oJSON["conexao_driver"], oJSON["conexao_server"], oJSON["conexao_database"], oJSON["conexao_port"], oJSON["conexao_user"], oJSON["conexao_password"]); //***************************************************** //* Inicia atualização e retorna mensagem para cliente //***************************************************** Security_Manager oSecutiry = new Security_Manager(); oJSON["errorText"] = oSecutiry.DatabaseUpdate(Conexao, oJSON["conexao_database"]); oJSON["error"] = false; break; } //**************************** //* Serializa dados e devolve //**************************** e.Result = new JavaScriptSerializer().Serialize(oJSON); }