public static bool Add(BanIpHistory banIpHistory)
{
var connStr = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
var strSql = @"INSERT INTO T_Ban_IP_History(
[ZoneId],
[IP],
[LatestTriggerTime],
[RuleId],
[Remark])
VALUES (
@ZoneId,
@IP,
GETUTCDATE(),
@RuleId,
@Remark)";
using (var conn = new SqlConnection(connStr))
{
var cmd = new SqlCommand(strSql, conn);
cmd.Parameters.AddWithValue("@ZoneId", banIpHistory.ZoneId);
cmd.Parameters.AddWithValue("@IP", banIpHistory.IP);
cmd.Parameters.AddWithValue("@RuleId", banIpHistory.RuleId);
cmd.Parameters.AddWithValue("@Remark", banIpHistory.Remark);
conn.Open();
return(cmd.ExecuteNonQuery() > 0);
}
}
public static bool Update(BanIpHistory banIpHistory)
{
var connStr = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
var strSql = @"UPDATE T_Ban_IP_History
SET LatestTriggerTime = GETUTCDATE(),
RuleId = @RuleId,
Remark = @Remark
WHERE ZoneId = @ZoneId And IP = @IP";
using (var conn = new SqlConnection(connStr))
{
var cmd = new SqlCommand(strSql, conn);
cmd.Parameters.AddWithValue("@ZoneId", banIpHistory.ZoneId);
cmd.Parameters.AddWithValue("@IP", banIpHistory.IP);
cmd.Parameters.AddWithValue("@RuleId", banIpHistory.RuleId);
cmd.Parameters.AddWithValue("@Remark", banIpHistory.Remark);
conn.Open();
return(cmd.ExecuteNonQuery() > 0);
}
}
public static bool Add(BanIpHistory banIpHistory)
{
try
{
var banIpHistories = BanIpHistoryAccess.Get(banIpHistory.ZoneId, banIpHistory.IP);
if (null != banIpHistories && banIpHistories.Count > 0)
{
return(BanIpHistoryAccess.Update(banIpHistory));
}
else
{
return(BanIpHistoryAccess.Add(banIpHistory));
}
}
catch (Exception ex)
{
var zoneTableId = ZoneAccess.GetZoneByZoneId(banIpHistory.ZoneId).TableID;
AuditLogBusiness.Add(new AuditLogEntity(zoneTableId, LogLevel.Error,
$"Add ban ip histories failure, the reason is:[{ex.Message}].<br />stack trace:{ex.StackTrace}."));
return(false);
}
}
public static void Add(BanIpHistory banIPHistory, SqlTransaction trans, SqlConnection conn)
{
var strSql = @"IF NOT EXISTS
(
SELECT ID FROM T_Ban_IP_History WHERE IP=@IP AND ZONEID =@ZoneId
)
BEGIN
INSERT INTO T_Ban_IP_History(
[ZoneId],
[IP],
[LatestTriggerTime],
[RuleId],
[Remark])
VALUES (
@ZoneId,
@IP,
GETUTCDATE(),
@RuleId,
@Remark)
END;
ELSE
BEGIN
UPDATE T_Ban_IP_History
SET LatestTriggerTime = GETUTCDATE(),
RuleId = @RuleId,
Remark = @Remark
WHERE ZoneId = @ZoneId And IP = @IP;
END";
var cmd = new SqlCommand(strSql, conn, trans);
cmd.Parameters.AddWithValue("@ZoneId", banIPHistory.ZoneId);
cmd.Parameters.AddWithValue("@IP", banIPHistory.IP);
cmd.Parameters.AddWithValue("@RuleId", banIPHistory.RuleId);
cmd.Parameters.AddWithValue("@Remark", banIPHistory.Remark);
cmd.ExecuteNonQuery();
}
