public ActionResult LogHistoryTransactionTable(int transId)
{
var bookaudit = _dbEntities.AuditLogs.Where(x => x.TableName == "Booking").ToList();
var logs = JsonExtractorHelper.BookingLogsHistory(bookaudit, transId);
//var list = logs.GroupBy(d => DbFunctions.TruncateTime(d.Logdate)).OrderBy(g => g.Key).Select(g => g.Select(v=>v.BookingEventList).ToList()).ToList();
return(PartialView("_BookingTransLog", logs));
}
public IEnumerable <AuditLogViewModel> AuditLogs()
{
List <AuditLogViewModel> auditList = new List <AuditLogViewModel>();
var auditloglist = (from audt in dbEntities.AuditLogs select audt).ToList();
auditList = (from a in auditloglist
select new AuditLogViewModel()
{
logId = a.AuditLogId,
dateLog = a.EventDateUTC,
username = a.UserName,
audit_operation = a.AuditOperation,
tablename = a.TableName,
audit_Data = JsonExtractorHelper.GetJson(a.AuditData)
}).OrderByDescending(x => x.logId).ToList();
return(auditList);
}
