public int Post(Models.SysAuditTrail audittrail) { try { var identityUserId = User.Identity.GetUserId(); var mstUserId = (from d in db.MstUsers where "" + d.Id == identityUserId select d.Id).SingleOrDefault(); Data.SysAuditTrail newAuditTrail = new Data.SysAuditTrail(); // newAuditTrail.UserId = mstUserId; newAuditTrail.AuditDate = Convert.ToDateTime(audittrail.AuditDate); newAuditTrail.TableInformation = audittrail.TableInformation; newAuditTrail.RecordInformation = audittrail.RecordInformation; newAuditTrail.FormInformation = audittrail.FormInformation; newAuditTrail.ActionInformation = audittrail.ActionInformation; // db.SysAuditTrails.InsertOnSubmit(newAuditTrail); db.SubmitChanges(); return newAuditTrail.Id; } catch { return 0; } }
// ================== // Insert Audit Trail // ================== public void InsertAuditTrail(Int32 UserId, String Entity, String Activity, String OldObject, String NewObject) { try { var currentUser = from d in db.MstUsers where d.Id == UserId select d; if (currentUser.Any()) { if (currentUser.FirstOrDefault().ActivateAuditTrail) { Data.SysAuditTrail newAuditTrail = new Data.SysAuditTrail { AuditDate = DateTime.Now, UserId = UserId, Entity = Entity, Activity = Activity, OldObject = OldObject, NewObject = NewObject }; db.SysAuditTrails.InsertOnSubmit(newAuditTrail); db.SubmitChanges(); } } } catch (Exception e) { Debug.WriteLine(e); } }