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