public static async Task <bool> InsertDB(int RequestID, int RequestType, string InMessage, string CRMData, string OutMessage, string ErrorMessage) { MessageLogModel messageLogModel = new MessageLogModel(); messageLogModel.RequestID = RequestID; messageLogModel.RequestType = RequestType; messageLogModel.InMessage = InMessage; messageLogModel.Response = CRMData; messageLogModel.Request = OutMessage; messageLogModel.ErrorMessage = ErrorMessage; string sqlSP = "sp_MessageLog_Insert"; using (IDbConnection dbConnection = new SqlConnection(StaticVars.DBConnectionString)) { try { dbConnection.Open(); int rowsAffected = await dbConnection.ExecuteAsync(sqlSP, messageLogModel, commandType : CommandType.StoredProcedure); } catch (Exception ex) { } } return(true); }
public static async Task <bool> InsertDB(string InMessage, string CRMData, string OutMessage) { string databaseConnection = "Server=tcp:sqlsimserver.database.windows.net,1433;Initial Catalog=TPMessages;Persist Security Info=False;User ID=sqlsimserver;Password=Orlando9876!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; MessageLogModel messageLogModel = new MessageLogModel(); messageLogModel.InMessage = InMessage; messageLogModel.Response = CRMData; messageLogModel.Request = OutMessage; // string sqlSP = @"INSERT INTO MessageLog (InMessage, CRMData, OutMessage) VALUES(@InMessage, @CRMData, @OutMessage)"; string sqlSP = "sp_MessageLog_Insert"; using (IDbConnection dbConnection = new SqlConnection(databaseConnection)) { try { dbConnection.Open(); int rowsAffected = await dbConnection.ExecuteAsync(sqlSP, messageLogModel, commandType : CommandType.StoredProcedure); if (rowsAffected > 0) { // log.LogInformation("Sucess...."); } } catch (Exception ex) { // log.LogInformation(ex.Message.ToString()); } } return(true); }
protected virtual void OnNewMessage(MessageLogModel message) { NewMessageDelegate handler = NewMessage; if (handler != null) { handler(message); } }
private void Log_NewMessage(MessageLogModel message) { if (Manager == null) { return; } Manager.RCore.Log.Write(message); }
public Task WriteLogAsync(MessageLog messageLog) { return(_hubContext.Clients.All.LogMessage(MessageLogModel.FromEntity(messageLog))); }
public void Write(MessageLogModel message) { OnNewMessage(message); }