protected override void MapEntityToCustomProperties(IENTBaseEntity entity)
{
var eNTAudit = (ENTAudit)entity;
ID = eNTAudit.ENTAuditId;
ObjectName = eNTAudit.ObjectName;
RecordId = eNTAudit.RecordId;
PropertyName = eNTAudit.PropertyName;
OldValue = eNTAudit.OldValue;
NewValue = eNTAudit.NewValue;
AuditType = (AuditTypeEnum)eNTAudit.AuditType;
}
private string GetLocationClassCodesSelectStatement(AuditTypeEnum auditType)
{
return($@"
SELECT
LocationID,
ClassCodeState,
ClassCode,
ClassCodeDesc,
ClassCodeId = CASE WHEN (ClassCodeLookUpId IS NULL OR ClassCodeLookupId = 0)
THEN dbo.fnGetClassCodeId({(int)auditType}, ClassCodeState, ClassCode, ClassCodeDesc)
ELSE ClassCodeLookupId END
FROM dbo.ClassCodes2Audit
");
}
/// <summary>
/// Log audit/messages
/// </summary>
/// <param name="type">type of event</param>
/// <param name="server">server name</param>
/// <param name="username">username</param>
/// <param name="clientips">connected ip</param>
/// <param name="text">log text</param>
public static void Log(AuditTypeEnum type, string server, string username, string clientips, string text, string zoneName, string recordName)
{
if (!AuditTypes.HasFlag(type))
{
return;
}
if (AuditMedia.HasFlag(AuditMediaEnum.DB))
{
if (auditrecords.Count > 100)
{
throw new Exception("Audit records are not being save quick enough to the database, check server load or check if the database is locked");
}
auditrecords.Enqueue(new AuditRecord
{
Id = Guid.NewGuid(),
Server = (server != null) ? server.ToLower() : string.Empty,
TimestampUTC = DateTime.UtcNow,
Type = type.ToString(),
Username = username.ToLower(),
ClientIP = clientips,
Text = text,
Zone = zoneName,
RecordName = recordName
});
//first execution always access the database, easy to see startup errors
if (tDatabaseHandler == null)
{
DatabaseHandler(false);
tDatabaseHandler = new Thread(new ThreadStart(DatabaseHandler));
tDatabaseHandler.Start();
}
}
if (AuditMedia.HasFlag(AuditMediaEnum.File))
{
var log = log4net.LogManager.GetLogger("MSDNSAdmin");
log.InfoFormat(LogLineFormat, type.ToString(), (server != null) ? server.ToLower() : string.Empty, username.ToLower(), clientips, text, zoneName, recordName);
}
}
/// <summary>
/// Log audit/messages
/// </summary>
/// <param name="type">type of event</param>
/// <param name="server">server name</param>
/// <param name="username">username</param>
/// <param name="clientips">connected ip</param>
/// <param name="text">log text</param>
public static void Log(AuditTypeEnum type, string server, string username, string clientips, string text, string zoneName, string recordName)
{
if (!AuditTypes.HasFlag(type))
return;
if (AuditMedia.HasFlag(AuditMediaEnum.DB))
{
if (auditrecords.Count > 100)
throw new Exception("Audit records are not being save quick enough to the database, check server load or check if the database is locked");
auditrecords.Enqueue(new AuditRecord
{
Id = Guid.NewGuid(),
Server = (server != null ) ? server.ToLower() : string.Empty,
TimestampUTC = DateTime.UtcNow,
Type = type.ToString(),
Username = username.ToLower(),
ClientIP = clientips,
Text = text,
Zone = zoneName,
RecordName = recordName
});
//first execution always access the database, easy to see startup errors
if (tDatabaseHandler == null)
{
DatabaseHandler(false);
tDatabaseHandler = new Thread(new ThreadStart(DatabaseHandler));
tDatabaseHandler.Start();
}
}
if (AuditMedia.HasFlag(AuditMediaEnum.File))
{
var log = log4net.LogManager.GetLogger("MSDNSAdmin");
log.InfoFormat(LogLineFormat, type.ToString(), (server != null) ? server.ToLower() : string.Empty, username.ToLower(), clientips, text, zoneName, recordName);
}
}
public async Task <GetResponse <IReadOnlyList <IClassCode> > > GetAllByAuditType(AuditTypeEnum auditType)
{
var getResponse = new GetResponse <IReadOnlyList <IClassCode> >();
try
{
getResponse = await _classCodeRepository.GetAllByAuditType(auditType);
}
catch (Exception ex)
{
Console.WriteLine(ex);
getResponse.AddError(ex);
_logManager.LogError(ex, "Error retrieving classCodes");
}
return(getResponse);
}
public async Task <GetResponse <IReadOnlyList <IClassCode> > > GetAllByAuditType(AuditTypeEnum auditType)
{
{
var response = new GetResponse <IReadOnlyList <IClassCode> >();
try
{
using (var connection = ConnectionFactory.GetConnection())
{
var results = await connection.QueryAsync <ClassCodeDto>("spsClassCodesForAuditType", new { AuditTypeId = auditType }, commandType : CommandType.StoredProcedure);
response.Content = results
.Select(dto => dto.ToModel())
.AsList();
}
}
catch (Exception e)
{
var messaage = $@"Unable to retrieve class codes for audit type {auditType}.";
response.AddError(e);
LogManager.LogError(e, messaage);
Console.WriteLine(e);
}
return(response);
}
}