public virtual void Audittrail(VAuditTrails audit)
{
_context.AuditTrails.Add(new AuditTrails()
{
Action = audit.Action,
Actionby = audit.ActionBy,
ActionDate = audit.ActionDate,
Record = audit.Record,
RecordTable = audit.RecordTable,
RecordID = audit.RecordID
});
_context.SaveChanges();
}
public List <T> Getautdittrail <T>(VAuditTrails audittrail)
{
List <T> auditlist = new List <T>();
var dbaudits = _context.AuditTrails.Where(t => t.RecordTable == audittrail.RecordTable && t.Action == audittrail.Action);
foreach (var dbaudit in dbaudits)
{
var trail = JsonConvert.DeserializeObject <T>(dbaudit.Record);
trail.GetType().GetProperty("Actiondate").SetValue(trail, dbaudit.ActionDate);
auditlist.Add(trail);
//auditlist.Add((T) JsonConvert.DeserializeObject<T>(dbaudit.Record));
}
return(auditlist);
}
public JsonResult PatientsList()
{
try
{
var audittrail = new VAuditTrails()
{
Action = "Delete",
RecordTable = "Patients"
};
//Get patients
var patients = _audittrail.Getautdittrail <VPatients>(audittrail);
//Return result to jTable
return(Json(new { Result = "OK", Records = patients, TotalRecordCount = patients.Count() }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
