public AudittingLogResponse InsertAudittingLog(AudittingLogEntity audittingLogEntity)
{
var response = new AudittingLogResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!audittingLogEntity.Validate())
{
foreach (string error in audittingLogEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
audittingLogEntity.EventId = Guid.NewGuid().ToString();
response.Message = AudittingLogDao.InsertAudittingLog(audittingLogEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.EventId = audittingLogEntity.EventId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
/// <summary>
/// Deletes the auditting log.
/// </summary>
/// <param name="audittingLog">The auditting log.</param>
/// <returns></returns>
public string DeleteAudittingLog(AudittingLogEntity audittingLog)
{
const string sql = @"uspDelete_AudittingLog";
object[] parms = { "@EventID", audittingLog.EventId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified auditting log.
/// </summary>
/// <param name="audittingLog">The auditting log.</param>
/// <returns></returns>
private static object[] Take(AudittingLogEntity audittingLog)
{
return(new object[]
{
"@ComponentName", audittingLog.ComponentName,
"@EventAction", audittingLog.EventAction,
"@Reference", audittingLog.Reference,
"@Amount", audittingLog.Amount,
"@LoginName", audittingLog.LoginName
});
}
/// <summary>
/// Inserts the auditting log.
/// </summary>
/// <param name="audittingLog">The auditting log.</param>
/// <returns></returns>
public int InsertAudittingLog(AudittingLogEntity audittingLog)
{
const string sql = @"uspAudittingLog";
return(Db.Insert(sql, true, Take(audittingLog)));
}
