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