public static async Task <bool> InsertDBRunningLog2(string InMessage)
{
RunningLogDataViewModel runningLogDataViewModel = new RunningLogDataViewModel();
runningLogDataViewModel.RunningLog = InMessage;
string sqlSP = "sp_RunningLogData_Insert";
using (IDbConnection dbConnection = new SqlConnection(StaticVars.DBConnectionString))
{
try
{
dbConnection.Open();
int rowsAffected = await dbConnection.ExecuteAsync(sqlSP, runningLogDataViewModel, commandType : CommandType.StoredProcedure);
}
catch (Exception ex)
{
}
}
return(true);
}
public static async Task <bool> InsertDBRunningLog(string InMessage, ILogger log)
{
RunningLogDataViewModel runningLogDataViewModel = new RunningLogDataViewModel();
runningLogDataViewModel.RunningLog = InMessage;
string sqlSP = "sp_RunningLogData_Insert";
using (IDbConnection dbConnection = new SqlConnection(StaticVars.DBConnectionString))
{
try
{
dbConnection.Open();
int rowsAffected = await dbConnection.ExecuteAsync(sqlSP, runningLogDataViewModel, commandType : CommandType.StoredProcedure);
log.LogInformation("Successfully inserted.");
}
catch (Exception ex)
{
log.LogInformation("Error: " + ex.Message.ToString());
}
}
return(true);
}