public List <AuditTrailsTemp.AuditChange> GetAudit(int ID)
{
List <AuditTrailsTemp.AuditChange> result = new List <AuditTrailsTemp.AuditChange>();
var AuditTrail = db.AuditTrails.Where(s => s.KeyFieldID == ID).OrderByDescending(s => s.DateTimeStamp);
var serializer = new XmlSerializer(typeof(AuditTrailsTemp.AuditDelta));
foreach (var record in AuditTrail)
{
AuditTrailsTemp.AuditChange Change = new AuditTrailsTemp.AuditChange();
Change.DateTimeStamp = record.DateTimeStamp.ToString();
Change.AuditActionTypeName = record.AuditAction;
List <AuditTrailsTemp.AuditDelta> delta = new List <AuditTrailsTemp.AuditDelta>();
delta = JsonConvert.DeserializeObject <List <AuditTrailsTemp.AuditDelta> >(record.Changes);
Change.Changes.AddRange(delta);
result.Add(Change);
}
return(result);
}
public List <AuditTrailsTemp.AuditChange> GetAllAudit()
{
List <AuditTrailsTemp.AuditChange> result = new List <AuditTrailsTemp.AuditChange>();
var AuditTrail = db.AuditTrails;
var serializer = new XmlSerializer(typeof(AuditTrailsTemp.AuditDelta));
foreach (var record in AuditTrail)
{
AuditTrailsTemp.AuditChange Change = new AuditTrailsTemp.AuditChange();
Change.DateTimeStamp = record.DateTimeStamp.ToString();
Change.AuditActionTypeName = record.AuditAction + " " + record.Desc;
Change.ValueId = record.KeyFieldID;
Change.Username = record.Username;
List <AuditTrailsTemp.AuditDelta> delta = new List <AuditTrailsTemp.AuditDelta>();
delta = JsonConvert.DeserializeObject <List <AuditTrailsTemp.AuditDelta> >(record.Changes);
Change.Changes.AddRange(delta);
result.Add(Change);
}
return(result.OrderByDescending(p => Convert.ToDateTime(p.DateTimeStamp)).ToList());
}
