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);
}
}
