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