public IActionResult InsertAbsencesLogView([FromBody] AuditLogFilter model)
{
try
{
model.LoginUserId = base.CurrentUser.Id;
model.DistrictId = base.CurrentUser.DistrictId;
model.OrganizationId = base.CurrentUser.OrganizationId == "-1" ? null : base.CurrentUser.OrganizationId;
// Audit Log
var audit = new AuditLog
{
UserId = CurrentUser.Id,
EntityId = model.EntityId.ToString(),
EntityType = AuditLogs.EntityType.Absence,
ActionType = AuditLogs.ActionType.Viewed,
DistrictId = CurrentUser.DistrictId,
OrganizationId = CurrentUser.OrganizationId == "-1" ? null : CurrentUser.OrganizationId
};
_audit.InsertAuditLog(audit);
return(Ok());
}
catch (Exception ex)
{
}
finally
{
}
return(null);
}
public IActionResult InsertAuditLogout([FromBody] AuditLogFilter model)
{
try
{
model.LoginUserId = base.CurrentUser.Id;
model.DistrictId = base.CurrentUser.DistrictId;
model.OrganizationId = base.CurrentUser.OrganizationId == "-1" ? null : base.CurrentUser.OrganizationId;
// Audit Log
var audit = new AuditLog
{
UserId = CurrentUser.Id,
EntityType = AuditLogs.EntityType.User,
ActionType = AuditLogs.ActionType.LoggedOut,
DistrictId = CurrentUser.DistrictId,
OrganizationId = CurrentUser.OrganizationId == "-1" ? null : CurrentUser.OrganizationId
};
_audit.InsertAuditLog(audit);
return(Ok());
}
catch (Exception ex)
{
}
finally
{
}
return(null);
}
public IQueryable <AuditLog> Get(AuditLogFilter parameters = null)
{
var sqlRawParams = GetSqlRawParameter(parameters);
if (sqlRawParams.SqlParameters.Count == 0)
{
return(dbContext.AuditLogs.Include(a => a.UserAccount).AsNoTracking());
}
return(dbContext.AuditLogs.FromSqlRaw(sqlRawParams.SqlQuery, sqlRawParams.SqlParameters.ToArray()).AsNoTracking());
}
/// <summary>
/// Retrieves a list of audit records
/// </summary>
/// <param name="page">
/// The requested page from the server. This is an optional
/// argument and if omitted the server will default to returning the
/// first page with a maximum of <c>100</c> items.
/// </param>
/// <param name="filter">
/// A filter object to filter the audit records on the
/// server. If omitted, the server will return all objects as a
/// paginated response.
/// </param>
/// <returns></returns>
public AuditLogList GetAuditRecords(
PageInput page = null,
AuditLogFilter filter = null)
{
// setup parameters
GraphQLParameters parameters = new GraphQLParameters();
parameters.Add("page", page, true);
parameters.Add("filter", filter, true);
return(RunQuery <AuditLogList>(@"getAuditLog", parameters));
}
public List <AuditLogView> GetAuditView(AuditLogFilter model)
{
var sql = "[Users].[GetAuditLog]";
var queryParams = new DynamicParameters();
queryParams.Add("@StartDate", model.StartDate);
queryParams.Add("@EndDate", model.EndDate);
queryParams.Add("@LoginUserId", model.LoginUserId);
queryParams.Add("@SearchByEmployeeName", model.SearchByEmployeeName);
queryParams.Add("@DistrictId", model.DistrictId);
queryParams.Add("@OrganizationId", model.OrganizationId == "0" ? null : model.OrganizationId);
var result = Db.Query <AuditLogView>(sql, queryParams, commandType: CommandType.StoredProcedure).ToList();
return(result);
}
public IActionResult GetAuditView([FromBody] AuditLogFilter model)
{
try
{
model.LoginUserId = base.CurrentUser.Id;
var reportDetails = _audit.GetAuditView(model);
return(Ok(reportDetails));
}
catch (Exception ex)
{
}
finally
{
}
return(null);
}
public IActionResult GetAbsencesAuditView([FromBody] AuditLogFilter model)
{
try
{
model.LoginUserId = base.CurrentUser.Id;
model.DistrictId = base.CurrentUser.DistrictId;
model.OrganizationId = base.CurrentUser.OrganizationId == "-1" ? null : base.CurrentUser.OrganizationId;
var reportDetails = _audit.GetAbsencesAuditView(model);
return(Ok(reportDetails));
}
catch (Exception ex)
{
}
finally
{
}
return(null);
}
public SqlRawParameter GetSqlRawParameter(AuditLogFilter parameters)
{
if (parameters == null)
{
return(new SqlRawParameter());
}
var sqlQry = new StringBuilder();
sqlQry.AppendLine("SELECT * FROM AuditLogs");
var whereClauses = new List <string>();
var sqlParams = new List <SqlParameter>();
if (parameters.AuditLogEventId > 0)
{
sqlParams.Add(new SqlParameter(nameof(parameters.AuditLogEventId).Parametarize(), parameters.AuditLogEventId));
whereClauses.Add($"{nameof(AuditLog.AuditLogEventId)} = {nameof(parameters.AuditLogEventId).Parametarize()}");
}
if (!parameters.DTLogFrom.IsNullOrEmpty())
{
sqlParams.Add(new SqlParameter(nameof(parameters.DTLogFrom).Parametarize(), parameters.DTLogFrom.Value.Date));
sqlParams.Add(new SqlParameter(nameof(parameters.DTLogTo).Parametarize(), parameters.DTLogTo.Value.Date));
whereClauses.Add($"CAST({nameof(AuditLog.DTLog)} AS DATE) BETWEEN {nameof(parameters.DTLogFrom).Parametarize()} AND {nameof(parameters.DTLogTo).Parametarize()} ");
}
if (!String.IsNullOrEmpty(parameters.UserAccountId))
{
sqlParams.Add(new SqlParameter(nameof(parameters.UserAccountId).Parametarize(), parameters.UserAccountId));
whereClauses.Add($"{nameof(AuditLog.UserAccountId)} = {parameters.UserAccountId.Parametarize()}");
}
if (whereClauses.Count > 0)
{
sqlQry.AppendLine(" WHERE ");
sqlQry.AppendLine(String.Join(" AND ", whereClauses.ToArray()));
}
return(new SqlRawParameter()
{
SqlParameters = sqlParams, SqlQuery = sqlQry.ToString()
});
}
public List <AuditLogAbsenceView> GetAbsencesAuditView(AuditLogFilter model)
{
var sql = "[Users].[GetAuditLogAbsences]";
var queryParams = new DynamicParameters();
queryParams.Add("@DistrictId", model.DistrictId);
queryParams.Add("@OrganizationId", model.OrganizationId);
if (model.EntityId.Length > 0)
{
queryParams.Add("@StartDate", null);
queryParams.Add("@EndDate", null);
}
else
{
queryParams.Add("@StartDate", model.StartDate);
queryParams.Add("@EndDate", model.EndDate);
}
queryParams.Add("@EntityId", model.EntityId);
queryParams.Add("@LoginUserId", model.LoginUserId);
var result = Db.Query <AuditLogAbsenceView>(sql, queryParams, commandType: CommandType.StoredProcedure).ToList();
return(result);
}
public IActionResult Get([FromQuery] AuditLogFilter parameters = null)
{
try
{
var model2 = repository.Get(parameters).ToList();
var model = repository.Get(parameters).Select(a => new
{
a.AuditLogId,
a.AuditLogEventId,
a.AuditLogEventDesc,
a.DTLog,
UserAccountFullName = a.UserAccount != null ? a.UserAccount.FullName : "",
a.Notes
});
return(Ok(model));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.FetchError));
}
}
public async Task <AuditLog> GetAuditLogAsync(string nextPageKey = null, int?pageSize = null, AuditLogFilter filter = null, Timeframe from = null, Timeframe to = null, bool?oldestFirst = null,
CancellationToken cancellationToken = default)
{
var queryParamValues = new Dictionary <string, object>();
if (nextPageKey is not null)
{
queryParamValues[nameof(nextPageKey)] = nextPageKey;
}
if (pageSize is not null)
{
queryParamValues[nameof(pageSize)] = pageSize;
}
if (filter is not null)
{
queryParamValues[nameof(filter)] = filter.ToString();
}
if (from is not null)
{
queryParamValues[nameof(from)] = from.ToString();
}
if (to is not null)
{
queryParamValues[nameof(to)] = to.ToString();
}
if (oldestFirst is not null)
{
queryParamValues["sort"] = oldestFirst is true ? "timestamp" : "-timestamp";
}
var response = await GetAuditLogsUrl()
.SetQueryParams(queryParamValues)
.GetJsonIfNotEmptyAsync(new AuditLog(), cancellationToken)
.ConfigureAwait(false);
return(response);
}
public List <AuditLogAbsenceView> GetAbsencesAuditView(AuditLogFilter model)
{
return(_repo.GetAbsencesAuditView(model));
}
public List <AuditLogView> GetAuditView(AuditLogFilter model)
{
return(_repo.GetAuditView(model));
}
