public IEnumerable <EventLogs> GetAll(string searchValue, int pageSize, int skip, int take, string sortField, string dir, List <AdvancedSearchRequest> postValue, string additionalFilter = "")
{
var queryBuilder = new AdvancedSearchQueryBuilder(postValue);
var query = queryBuilder.getQuery();
var _builder = new SqlBuilder();
var selector = _builder.AddTemplate(" /**where**/");
foreach (dynamic d in query)
{
_builder.Where(d.sql, d.value);
}
var sql = string.Empty;
if (string.IsNullOrEmpty(sortField) || sortField == "userName")
{
sortField = "EventDate";
dir = "desc";
}
var whereEntity = selector.RawSql;
sql = $@"select
*
from EventLog
{whereEntity}
ORDER BY {sortField} {dir} OFFSET {skip} ROWS FETCH NEXT {take} ROWS ONLY";
var auditLogList = _context.Connection.Query <EventLogs>(sql, selector.Parameters);
return(auditLogList);
}
public IEnumerable <Core.AuditLog.Entities.AuditLog> GetAll(string searchValue, int pageSize, int skip, int take, string sortField, string dir, List <AdvancedSearchRequest> postValue, string additionalFilter = "")
{
var queryBuilder = new AdvancedSearchQueryBuilder(postValue);
var query = queryBuilder.getQuery();
var _builder = new SqlBuilder();
var selector = _builder.AddTemplate(" /**where**/");
foreach (dynamic d in query)
{
_builder.Where(d.sql, d.value);
}
var sql = string.Empty;
if (string.IsNullOrEmpty(sortField))
{
sortField = "TimeStamp";
dir = "desc";
}
var whereEntity = selector.RawSql;
sql = $@"select
AuditLogGuid,
RawData,
TimeStamp,
Resource,
ResourceId,
Actor,
IPAddress,
Action,
ActionId,
ActionResult,
ActionResultReason,
AdditionalInformation,
AdditionalInformationURl
from AuditLog
{whereEntity}
ORDER BY {sortField} {dir} OFFSET {skip} ROWS FETCH NEXT {take} ROWS ONLY";
var auditLogList = _context.Connection.Query <Core.AuditLog.Entities.AuditLog>(sql, selector.Parameters);
return(auditLogList);
}
public int GetAdvanceSearchCount(string searchValue, List <AdvancedSearchRequest> postValue, Guid userGuid, string additionalFilter)
{
var queryBuilder = new AdvancedSearchQueryBuilder(postValue);
var query = queryBuilder.getQuery();
var _builder = new SqlBuilder();
var selector = _builder.AddTemplate(" /**where**/");
foreach (dynamic d in query)
{
_builder.Where(d.sql, d.value);
}
var whereEntity = selector.RawSql;
var sql = $@"select count(1) from AuditLog {whereEntity}";
var countAuditLog = _context.Connection.ExecuteScalar <int>(sql, selector.Parameters);
return(countAuditLog);
}
