public JsonResult AuditLog(PropertyAuditLogCriteria criteria) { var page = _propertyAuditLogQueries.GetChanges(criteria); return Json(new { total = page.TotalPages, page = page.CurrentPage, records = page.TotalItems, rows = (from item in page.Items select new { id = item.PropertyId, cell = new object[] { item.Field, item.OldValue, item.NewValue, item.Timestamp.ToShortDateString(), item.HistUserName, item.HistFullName, item.HistEmailAddress } }).ToArray() }); }
public Page<PropertyHistoryDetail> GetChanges(PropertyAuditLogCriteria criteria) { var sql = Sql.Builder .OrderBy(criteria.OrderBy + " " + criteria.OrderByDirection) .Where("propertyId=@0", criteria.PropertyId); if (criteria.Field.ToLower() != "all") sql.And("field=@0", criteria.Field); return _repository.PagedQuery<PropertyHistoryDetail>(criteria.PageNumber, criteria.ItemsPerPage, sql.SQL, sql.Arguments); }