public static void Add(List <BanIpHistory> banIpHistories) { var zoneId = banIpHistories[0].ZoneId; var zoneTableId = ZoneAccess.GetZoneByZoneId(zoneId).TableID; var connStr = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); using (var conn = new SqlConnection(connStr)) { conn.Open(); var tran = conn.BeginTransaction(); try { foreach (var banIPHistory in banIpHistories) { Add(banIPHistory, tran, conn); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); AuditLogAccess.Add(new AuditLogEntity(zoneTableId, LogLevel.Error, $"Error when adding ban ip history, \n eror message:{ex.Message} \n stack trace:{ex.StackTrace}")); } finally { conn.Close(); } } }
public static void Add(AuditLogEntity item) { if (item.ZoneTableID == 0) { item.ZoneTableID = ZoneAccess.GetZoneByZoneId(item.ZoneID).TableID; } try { var cons = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); using (var conn = new SqlConnection(cons)) { const string query = @"INSERT INTO dbo.t_Logs ( ZoneTableId , LogLevel , LogTime , LogOperator , IP , Detail , Remark ) VALUES ( @zoneTableId , @logLevel , @logTime , @operator , @ip , @detail , N'' )"; var cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@zoneTableId", item.ZoneTableID); cmd.Parameters.AddWithValue("@logLevel", item.LogType); cmd.Parameters.AddWithValue("@operator", item.LogOperator); cmd.Parameters.AddWithValue("@logTime", item.LogTime); cmd.Parameters.AddWithValue("@ip", item.IP); cmd.Parameters.AddWithValue("@detail", item.Detail); conn.Open(); cmd.ExecuteNonQuery(); } } catch (Exception ex) { Console.WriteLine($"Error when adding new log, error message:{ex.Message} \n stack trace:{ex.StackTrace}"); } }