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