/*ejecuta la consulta que se pasa como parametro cogiendo la base de datos cuyo string de conexion esta en el parametro conexion del fichero de configuracion*/ public void ejecutar_sql(string sql) { try { MySql.Data.MySqlClient.MySqlConnection mscon = new MySql.Data.MySqlClient.MySqlConnection(Properties.Settings.Default.conexion); mscon.Open(); MySql.Data.MySqlClient.MySqlCommand mscom = new MySql.Data.MySqlClient.MySqlCommand(sql, mscon); mscom.ExecuteNonQuery(); mscon.Close(); } catch (MySql.Data.MySqlClient.MySqlException e) { LinkException le = new LinkException(e.Message); throw le; } }
private void OnMessage(object sender, ChannelContext ctx) { Message msg = MessageIO.ReadMessage(new MemoryStream((byte[])ctx.Message)); SendCallback callback = this._callbacks.ContainsKey(msg.Flag) ? this._callbacks[msg.Flag] : null; if (msg.MessageType == MessageType.CONNECTACK) { this.HandleConnectAck(callback, msg); return; } Identity msgFrom = msg.Token != null && this._idByToken.ContainsKey(msg.Token) ? this._idByToken[msg.Token] : null; // must CONNECT/CONNECTACK for got token before SEND if (msgFrom == null) { var error = new LinkException(Text.E_UNKNOWN_MSG_FROM); if (callback == null) throw error; callback.Error = error; return; } #region raise callback of client if (callback != null) { this.HandleCallback(callback, msg, msgFrom); return; } else if (this.IsError(msg)) { this._log.ErrorFormat(Text.E_GOT_ERROR, msg.StatusCode, msg.StatusPhase); return; } #endregion #region raise event if (msg.MessageType == MessageType.SENDACK) { if (this.AckMessageHandler != null) this.AckMessageHandler(msg.Content, msgFrom); return; } if (this.MessageHandler == null) return; EndpointContext endpointContext = new EndpointContext(ctx, this, msgFrom, msg.Flag, msg.Token); endpointContext.Message = msg.Content; try { this.MessageHandler(endpointContext); } catch (Exception e) { // onMessage error should be reply to client if (e is LinkException) endpointContext.Error( ((LinkException)e).ErrorCode, ((LinkException)e).Message); else endpointContext.Error(0, e.Message); } #endregion }
private void OnMessage(object sender, ChannelContext ctx) { Message msg = MessageIO.ReadMessage(new MemoryStream((byte[])ctx.Message)); SendCallback callback = this._callbacks.ContainsKey(msg.Flag) ? this._callbacks[msg.Flag] : null; if (msg.MessageType == MessageType.CONNECTACK) { this.HandleConnectAck(callback, msg); return; } Identity msgFrom = msg.Token != null && this._idByToken.ContainsKey(msg.Token) ? this._idByToken[msg.Token] : null; // must CONNECT/CONNECTACK for got token before SEND if (msgFrom == null) { var error = new LinkException(Text.E_UNKNOWN_MSG_FROM); if (callback == null) { throw error; } callback.Error = error; return; } #region raise callback of client if (callback != null) { this.HandleCallback(callback, msg, msgFrom); return; } else if (this.IsError(msg)) { this._log.Error(Text.E_GOT_ERROR, msg.StatusCode, msg.StatusPhase); return; } #endregion #region raise event if (msg.MessageType == MessageType.SENDACK) { if (this.AckMessageHandler != null) { this.AckMessageHandler(msg.Content, msgFrom); } return; } if (this.MessageHandler == null) { return; } EndpointContext endpointContext = new EndpointContext(ctx, this, msgFrom, msg.Flag, msg.Token); endpointContext.Message = msg.Content; try { this.MessageHandler(endpointContext); } catch (Exception e) { // onMessage error should be reply to client if (e is LinkException) { endpointContext.Error( ((LinkException)e).ErrorCode, ((LinkException)e).Message); } else { endpointContext.Error(0, e.Message); } } #endregion }