public IActionResult AppLogs(AppLogSearchCriteria search)
{
var appData = logRetrivalService.GetAppLogs(search);
appData.ActiveTab = 2;
return(View(appData));
}
//API for getting logs
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
try
{
using (var reader = GetNewAppReader().OpenSession <AppLog>())
{
LuceneQueryStatistics stats = null;
var lst = reader.Query();
lst = lst.CaptureStatistics(s => { stats = s; });
lst = AddFilters(lst, search.SearchTerms);
lst = ApplySort(lst, search.SortBy, search.SortAscending, "LongdateAsTicks");
var totalRows = lst.AsQueryable().Count();
search.TotalRowCount = totalRows;
var resultList = lst.ApplyPaging(search.Page, search.PageSize).ToList();
search.CurrentRows = resultList.Count;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, resultList, totalRows));
}
}
catch (Exception ex)
{
log.Error(ex, "Error when getting App Log List ");
search.TotalRowCount = 0;
search.CurrentRows = 0;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, ex));
}
}
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
try
{
var lst = dbManager.Connection.GetTable <AppLog>().Where(x => x.LogType == search.LogType).AsQueryable();
lst = AddFilters(lst, search.SearchTerms);
lst = ApplySort(lst, search.SortBy, search.SortAscending, "LongdateAsTicks");
var totalRows = lst.AsQueryable().Count();
search.TotalRowCount = totalRows;
var resultList = lst.ApplyPaging(search.Page, search.PageSize).ToList();
search.CurrentRows = resultList.Count;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, resultList, totalRows));
}
catch (Exception ex)
{
log.Error(ex, "Error when getting Performance Log list ");
search.TotalRowCount = 0;
search.CurrentRows = 0;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, "Error when getting Performance Log list ", ex));
}
}
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
try
{
return(logReadRepository.GetAppLogs(search));
}
catch (Exception ex)
{
log.Error(ex, "Error when getting App Log List ");
search.TotalRowCount = 0;
search.CurrentRows = 0;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, ex));
}
}
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
try
{
var lst = LinqUtils.True <AppLog>();
if (search.FromDate.IsValidDate() && search.ToDate.IsValidDate())
{
if (search.FromDate.Value <= search.ToDate.Value)
{
lst = lst.Or(x => x.Longdate >= search.FromDate.Value.StartOfDay() && x.Longdate <= search.ToDate.Value.EndOfDay());
}
}
else if (search.FromDate.IsValidDate())
{
lst = lst.Or(x => x.Longdate >= search.FromDate.Value.StartOfDay());
}
else if (search.ToDate.IsValidDate())
{
lst = lst.Or(x => x.Longdate <= search.ToDate.Value.EndOfDay());
}
//if (search.Severity != null)
//{
// lst = lst.Or(x => x.Severity == search.Severity);
//}
var count = client.Search <AppLog>(s =>
s.Index(appLogIndexName)).Total;
var result = client.Search <AppLog>(s =>
s.Index(appLogIndexName).Skip(search.GetSkipValue()).Take(search.PageSize));
var totalRows = count;
search.TotalRowCount = totalRows;
var resultList = result.Documents.ToList();
search.CurrentRows = result.Documents.Count;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, resultList, totalRows));
}
catch (Exception ex)
{
log.Error(ex, "Error when getting App Log List ");
search.TotalRowCount = 0;
search.CurrentRows = 0;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, ex));
}
}
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
throw new NotImplementedException();
}
//API for getting logs
public ReturnListWithSearchModel <AppLog, AppLogSearchCriteria> GetAppLogs(AppLogSearchCriteria search)
{
try
{
using (var reader = GetNewAppReader())
{
var searcher = new IndexSearcher(reader);
var lst = searcher.AsQueryable <AppLog>();
if (search.FromDate.IsValidDate() && search.ToDate.IsValidDate())
{
if (search.FromDate.Value <= search.ToDate.Value)
{
lst = lst.Where(x => x.Longdate >= search.FromDate.Value.StartOfDay() && x.Longdate <= search.ToDate.Value.EndOfDay());
}
}
else if (search.FromDate.IsValidDate())
{
lst = lst.Where(x => x.Longdate >= search.FromDate.Value.StartOfDay());
}
else if (search.ToDate.IsValidDate())
{
lst = lst.Where(x => x.Longdate <= search.ToDate.Value.EndOfDay());
}
if (search.Severity != null)
{
lst = lst.Where(x => x.Severity == search.Severity);
}
if (search.SortBy == "AppLogId")
{
lst = search.SortAscending ? lst.OrderBy(x => x.LogId) : lst.OrderByDescending(x => x.LogId);
}
else if (search.SortBy == "LogType")
{
lst = search.SortAscending ? lst.OrderBy(x => x.LogType) : lst.OrderByDescending(x => x.LogType);
}
else if (search.SortBy == "CorelationId")
{
lst = search.SortAscending ? lst.OrderBy(x => x.CorelationId) : lst.OrderByDescending(x => x.CorelationId);
}
else if (search.SortBy == "FunctionId")
{
lst = search.SortAscending ? lst.OrderBy(x => x.FunctionId) : lst.OrderByDescending(x => x.FunctionId);
}
else if (search.SortBy == "Severity")
{
lst = search.SortAscending ? lst.OrderBy(x => x.Severity) : lst.OrderByDescending(x => x.Severity);
}
else if (search.SortBy == "App")
{
lst = search.SortAscending ? lst.OrderBy(x => x.App) : lst.OrderByDescending(x => x.App);
}
else if (search.SortBy == "MachineName")
{
lst = search.SortAscending ? lst.OrderBy(x => x.MachineName) : lst.OrderByDescending(x => x.MachineName);
}
else if (search.SortBy == "ProcessId")
{
lst = search.SortAscending ? lst.OrderBy(x => x.ProcessId) : lst.OrderByDescending(x => x.ProcessId);
}
else if (search.SortBy == "ThreadId")
{
lst = search.SortAscending ? lst.OrderBy(x => x.ThreadId) : lst.OrderByDescending(x => x.ThreadId);
}
else if (search.SortBy == "CurrentFunction")
{
lst = search.SortAscending ? lst.OrderBy(x => x.CurrentFunction) : lst.OrderByDescending(x => x.CurrentFunction);
}
else if (search.SortBy == "CurrentSourceFilename")
{
lst = search.SortAscending ? lst.OrderBy(x => x.CurrentSourceFilename) : lst.OrderByDescending(x => x.CurrentSourceFilename);
}
else if (search.SortBy == "CurrentSourceLineNumber")
{
lst = search.SortAscending ? lst.OrderBy(x => x.CurrentSourceLineNumber) : lst.OrderByDescending(x => x.CurrentSourceLineNumber);
}
else if (search.SortBy == "UserIdentity")
{
lst = search.SortAscending ? lst.OrderBy(x => x.UserIdentity) : lst.OrderByDescending(x => x.UserIdentity);
}
else if (search.SortBy == "RemoteAddress")
{
lst = search.SortAscending ? lst.OrderBy(x => x.RemoteAddress) : lst.OrderByDescending(x => x.RemoteAddress);
}
else if (search.SortBy == "UserAgent")
{
lst = search.SortAscending ? lst.OrderBy(x => x.UserAgent) : lst.OrderByDescending(x => x.UserAgent);
}
else if (search.SortBy == "Result")
{
lst = search.SortAscending ? lst.OrderBy(x => x.Result) : lst.OrderByDescending(x => x.Result);
}
else if (search.SortBy == "ResultCode")
{
lst = search.SortAscending ? lst.OrderBy(x => x.ResultCode) : lst.OrderByDescending(x => x.ResultCode);
}
else if (search.SortBy == "Message")
{
lst = search.SortAscending ? lst.OrderBy(x => x.Message) : lst.OrderByDescending(x => x.Message);
}
else if (search.SortBy == "PerfModule")
{
lst = search.SortAscending ? lst.OrderBy(x => x.PerfModule) : lst.OrderByDescending(x => x.PerfModule);
}
else if (search.SortBy == "PerfFunctionName")
{
lst = search.SortAscending ? lst.OrderBy(x => x.PerfFunctionName) : lst.OrderByDescending(x => x.PerfFunctionName);
}
else if (search.SortBy == "StartTime")
{
lst = search.SortAscending ? lst.OrderBy(x => x.StartTime) : lst.OrderByDescending(x => x.StartTime);
}
else if (search.SortBy == "ElapsedTime")
{
lst = search.SortAscending ? lst.OrderBy(x => x.ElapsedTime) : lst.OrderByDescending(x => x.ElapsedTime);
}
else if (search.SortBy == "PerfStatus")
{
lst = search.SortAscending ? lst.OrderBy(x => x.PerfStatus) : lst.OrderByDescending(x => x.PerfStatus);
}
else if (search.SortBy == "Request")
{
lst = search.SortAscending ? lst.OrderBy(x => x.Request) : lst.OrderByDescending(x => x.Request);
}
else if (search.SortBy == "Response")
{
lst = search.SortAscending ? lst.OrderBy(x => x.Response) : lst.OrderByDescending(x => x.Response);
}
else
{
lst = search.SortAscending ? lst.OrderBy(x => x.LongdateAsTicks) : lst.OrderByDescending(x => x.LongdateAsTicks);
}
var totalRows = lst.AsQueryable().Count();
search.TotalRowCount = totalRows;
var resultList = lst.ApplyPaging(search.Page, search.PageSize).ToList();
search.CurrentRows = resultList.Count;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, resultList, totalRows));
}
}
catch (Exception ex)
{
log.Error(ex, "Error when getting App Log List ");
search.TotalRowCount = 0;
search.CurrentRows = 0;
return(new ReturnListWithSearchModel <AppLog, AppLogSearchCriteria>(search, ex));
}
}
