public bool UpdateRecord(SampleDataModel Rec) { bool rslt = false; AuditTestEntities ent = new AuditTestEntities(); var dbRec = ent.SampleData.FirstOrDefault(s => s.ID == Rec.ID); if (dbRec != null) { // audit process 1 - gather old values SampleDataModel OldRecord = new SampleDataModel(); OldRecord.ID = dbRec.ID; OldRecord.FirstName = dbRec.FirstName; OldRecord.lastname = dbRec.LastName; OldRecord.DateOfBirth = dbRec.DateOfBirth; // update the live record dbRec.FirstName = Rec.FirstName; dbRec.LastName = Rec.lastname; dbRec.DateOfBirth = Rec.DateOfBirth; ent.SaveChanges(); CreateAuditTrail(AuditActionType.Update, Rec.ID, OldRecord, Rec); rslt = true; } return(rslt); }
public List <SampleDataModel> GetAllData(bool ShowDeleted) { List <SampleDataModel> rslt = new List <SampleDataModel>(); AuditTestEntities ent = new AuditTestEntities(); List <SampleData> SearchResults = new List <SampleData>(); if (ShowDeleted) { SearchResults = ent.SampleData.ToList(); } else { SearchResults = ent.SampleData.Where(s => s.Deleted == false).ToList(); } foreach (var record in SearchResults) { SampleDataModel rec = new SampleDataModel(); rec.ID = record.ID; rec.FirstName = record.FirstName; rec.lastname = record.LastName; rec.DateOfBirth = record.DateOfBirth; rec.Deleted = record.Deleted; rslt.Add(rec); } return(rslt); }
public void CreateRecord(SampleDataModel Rec) { AuditTestEntities ent = new AuditTestEntities(); SampleData dbRec = new SampleData(); dbRec.FirstName = Rec.FirstName; dbRec.LastName = Rec.lastname; dbRec.DateOfBirth = Rec.DateOfBirth; ent.SampleData.Add(dbRec); ent.SaveChanges(); // save first so we get back the dbRec.ID for audit tracking SampleData DummyObject = new SampleData(); // Storage of this null object shows data before creation = nix, naught, nothing! CreateAuditTrail(AuditActionType.Create, dbRec.ID, DummyObject, dbRec); }
public SampleDataModel GetData(int ID) { SampleDataModel mod = new SampleDataModel(); AuditTestEntities ent = new AuditTestEntities(); SampleData rec = ent.SampleData.FirstOrDefault(s => s.ID == ID); if (rec != null) { mod.ID = rec.ID; mod.FirstName = rec.FirstName; mod.lastname = rec.LastName; mod.DateOfBirth = rec.DateOfBirth; } return(mod); }