public void Record(string message, int actionType, string userId) { try { string auditActionId = DetermineActionId(actionType); if (auditActionId != INVALID_ACTION) { string id = CreateProperId(message, actionType); AuditTrail auditTrail = new AuditTrail() { AuditTrailId = id, AccountId = userId, AuditActionsId = auditActionId, Message = message, DateAction = DateTime.Now }; entities.AuditTrails.Add(auditTrail); entities.SaveChanges(); } } catch (Exception e) { } }
protected void Button1_Click(object sender, EventArgs e) { AppUser AppUser = new AppUser(); if (AppUser.LoadByPrimaryKey(txtUserId.Text.Trim())) { if (AppUser.Password == AEScipher.Encrypt(txtUserId.Text, txtPassword.Text)) { HttpContext.Current.Session["UserId"] = AppUser.UserID; HttpContext.Current.Session["UserName"] = AppUser.UserName; AuditTrail AuditTrail = new AuditTrail(); string itemAction = "Login per Tanggal : " + DateTime.Now.ToShortDateString() + " , untuk UserID : " + AppUser.UserID; if (itemAction.Length > 200) { itemAction = itemAction.Substring(0, 200); } AuditTrail.ItemAction = itemAction; AuditTrail.Aksi = "LOGIN"; AuditTrail.DateAction = DateTime.Now; AuditTrail.Save(); Response.Redirect("~/Default.aspx"); } else { return; } } else { return; } }
public ActionResult Delete(PrimarySchoolStudent model) { try { // TODO: Add delete logic here SecondarySchoolStudent theStudent = work.SecondarySchoolStudentRepository.GetByID(model.PersonID); string firstName = model.FirstName; string lastName = model.LastName; work.SecondarySchoolStudentRepository.Delete(theStudent); Membership.DeleteUser(Convert.ToString(theStudent.UserID)); work.Save(); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Student was Deleted, First Name:-" + firstName + " Last Name:-" + lastName, UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public void LogAudit(int ActionId, string Remark, string AffectedWebPage, string UserId) { string ipAddress = string.Empty; if (httpContext.HttpContext.Connection.RemoteIpAddress != null) { ipAddress = httpContext.HttpContext.Connection.RemoteIpAddress.ToString(); } else { ipAddress = httpContext.HttpContext.Connection.LocalIpAddress.ToString(); } AuditTrail auditTrail = new AuditTrail { ActionDate = DateTime.Now, ActionId = ActionId, AffectedWebPage = AffectedWebPage, Ipaddress = ipAddress, Remark = Remark, UserId = UserId }; dbContext.AuditTrail.Add(auditTrail); dbContext.SaveChanges(); }
public Leerlijnenpakket( Guid id, Guid nummer, string naam, DateTime invuldatum, bool definitief, IEnumerable <Leerlijn> leerlijnen, AuditTrail <Leerlijnenpakket> auditTrail) { Contract.Requires(!string.IsNullOrWhiteSpace(naam), "Naam leerlijnenpakket is null of leeg"); Contract.Requires(leerlijnen != null, "Leerlijnen is null"); // vakgebieden waarnaar de leerlijnen verwijzen moeten uniek zijn binnen het leerlijnenpakket Contract.Requires( leerlijnen == null || Contract.ForAll( leerlijnen, leerlijn => !leerlijnen.Where(ll => ll != leerlijn).Select(ll => ll.Vakgebied) .Contains(leerlijn.Vakgebied))); Contract.Requires(auditTrail != null); Id = id; Nummer = nummer; Naam = naam; Invuldatum = invuldatum; Definitief = definitief; Leerlijnen = leerlijnen; AuditTrail = auditTrail; }
private object prepareJsonObject(AuditTrail v) { Dictionary <string, object> newData = null; Dictionary <string, object> oldData = null; if (v.NewData != null) { newData = JsonConvert.DeserializeObject <Dictionary <string, object> >(v.NewData); } if (v.OldData != null) { oldData = JsonConvert.DeserializeObject <Dictionary <string, object> >(v.OldData); } var filteredNew = sanitizerData(v.EntityName, newData); var filteredOld = sanitizerData(v.EntityName, oldData); if ((filteredNew != null && filteredNew.Count > 0) || (filteredOld != null && filteredOld.Count > 0)) { var summary = string.Format("On {0} {1}, {2} was {3} by {4}", v.RevisionStamp.ToLongDateString(), v.RevisionStamp.ToLongTimeString(), v.EntityName, v.Action.ConvertActionCodeToName(), v.UserName); return(new { summary, newData = filteredNew, oldData = filteredOld }); } return(null); }
public Leerlijn( Guid id, Vakgebied vakgebied, IEnumerable <Deellijn> deellijnen, AuditTrail <Leerlijn> auditTrail) { Contract.Requires(vakgebied != null, "vakgebied is null"); Contract.Requires( deellijnen != null && Contract.ForAll(deellijnen, deellijn => deellijn != null), "deellijnen is null"); Contract.Requires( deellijnen == null || Contract.ForAll( deellijnen, deellijn => deellijn == null || deellijn.Deelgebied != null), "deelgebied in deellijn is null"); Contract.Requires( deellijnen == null || Contract.ForAll( deellijnen, deellijn => deellijn == null || deellijn.Deelgebied == null || !deellijnen.Where(dl => dl != deellijn).Select(dl => dl.Deelgebied) .Contains(deellijn.Deelgebied)), "deelgebieden waarnaar deellijnen verwijzen moeten uniek zijn binnen de leerlijn"); Contract.Requires(auditTrail != null); Id = id; Vakgebied = vakgebied; Deellijnen = deellijnen; AuditTrail = auditTrail; }
public async Task <ActionResult> Update(AdminRegisterViewModel model) { using (var context = new AppDbContext()) { var oldUser = context.Users.FirstOrDefault(u => u.Id == model.Id); if (oldUser == null) { return(HttpNotFound()); } oldUser.PhoneNumber = model.PhoneNumber; oldUser.Email = model.Email; oldUser.AccountNumber = model.AccountNumber; var audit = new AuditTrail { Date = DateTime.Now, Title = "Updated User Datil", Detail = $"Update the details of {oldUser.AgentName}", RefUrl = Url.Action("Manage", new { oldUser.Id }) }; context.AuditTrails.Add(audit); context.SaveChanges(); ShowMessage("User updated", AlertType.Success); } return(RedirectToAction("Index")); }
public ActionResult deallocate(int id) { DeviceInfo deviceInfo = _context.DeviceInfo.FirstOrDefault(d => d.DeviceId == id); var employeeId = deviceInfo.EmployeeId; deviceInfo.AssignedDate = null; deviceInfo.EmployeeId = null; deviceInfo.AssignedBy = null; deviceInfo.IsAssigned = false; _context.DeviceInfo.Update(deviceInfo); _context.SaveChanges(); //Update Deallocated device in audit trail AuditTrail auditTrailInfo = new AuditTrail(); auditTrailInfo.AuditId = 0; auditTrailInfo.UniqueCode = deviceInfo.UniqueCode; var query = _context.EmployeeInfo .Where(v => v.EmployeeId == employeeId) .Select(v => v.EmployeeEmail).ToList(); auditTrailInfo.EmployeeEmail = query[0]; auditTrailInfo.Date = DateTime.Now; _context.AuditTrail.Update(auditTrailInfo); _context.SaveChanges(); return(Ok(deviceInfo)); }
public static void CreateAuditTrailForDelete <E>(E entity, ApplicationData app) where E : IEntityObject { StringBuilder oldValues = new StringBuilder("Deleted Values :" + Environment.NewLine); foreach (var prop in entity.Details.Properties.All().OfType <IEntityStorageProperty>()) { if (app.AuditExcludes.Where(Exclude => Exclude.propName == prop.Name).Count() < 1) { AuditTrail auditRecord = app.AuditTrails.AddNew(); auditRecord.ChangeType = "Deleted"; auditRecord.Updated = DateTime.Now; auditRecord.ChangedBy = Application.Current.User.Name + ";" + Application.Current.User.FullName; auditRecord.ReferenceId = (int)entity.Details.Properties["Id"].Value; auditRecord.ReferenceType = entity.Details.EntitySet.Details.Name; auditRecord.ReferenceProp = prop.Name; auditRecord.OriginalValues = Convert.ToString(prop.OriginalValue); //prop.OriginalValue.ToString(); } } foreach (var prop in entity.Details.Properties.All().OfType <IEntityReferenceProperty>()) { if (app.AuditExcludes.Where(Exclude => Exclude.propName == prop.Name).Count() < 1) { AuditTrail auditRecord = app.AuditTrails.AddNew(); auditRecord.ChangeType = "Deleted"; auditRecord.Updated = DateTime.Now; auditRecord.ChangedBy = Application.Current.User.Name + ";" + Application.Current.User.FullName; auditRecord.ReferenceId = (int)entity.Details.Properties["Id"].Value; auditRecord.ReferenceType = entity.Details.EntitySet.Details.Name; auditRecord.ReferenceProp = prop.Name; auditRecord.OriginalValues = Convert.ToString(prop.OriginalValue); //prop.OriginalValue.ToString(); } } }
public ActionResult Delete(Store model) { try { // TODO: Add delete logic here string name = model.ItemName; Store theStoreItem = work.StoreRepository.GetByID(model.StoreID); work.StoreRepository.Delete(theStoreItem); work.Save(); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Deleted an Item in the Store ,Item Name :-" + name, UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Store model) { if (String.IsNullOrEmpty(model.Level)) { model.Level = ""; } try { if (!(ModelState.IsValid)) { return(View(model)); } model.DateEntered = DateTime.Now; work.StoreRepository.Insert(model); work.Save(); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Added an Item in the Store ,Item Name :-" + model.ItemName, UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(Parent model) { try { // TODO: Add delete logic here string firstName = model.FirstName; string lastName = model.LastName; Parent theParent = work.ParentRepository.GetByID(model.ParentID); int pID = theParent.ParentID; List <PrimarySchoolStudent> thePri = work.PrimarySchoolStudentRepository.Get(a => a.ParentID == pID).ToList(); foreach (PrimarySchoolStudent p in thePri) { p.Parent = null; p.ParentID = null; } work.ParentRepository.Delete(theParent); work.Save(); Membership.DeleteUser(Convert.ToString(theParent.UserID)); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Parent was Deleted First Name:-" + firstName + " Last Name:-" + lastName, UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(Store model) { if (String.IsNullOrEmpty(model.Level)) { model.Level = ""; } try { if (ModelState.IsValid) { work.StoreRepository.Update(model); work.Save(); // TODO: Add update logic here if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Edited an Item in the Store ,Item Name :-" + model.ItemName, UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } } } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(RedirectToAction("Index")); }
public ActionResult Delete(NewsBoard model) { try { NewsBoard theNews = work.NewsBoardRepository.GetByID(model.NewsBoardID); work.NewsBoardRepository.Delete(theNews); work.Save(); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Deleted a news from the news Board", UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } // TODO: Add delete logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(NewsBoard model) { model.Date = DateTime.Now; try { if (ModelState.IsValid) { work.NewsBoardRepository.Update(model); work.Save(); if (User.Identity.Name != "5000001") { AuditTrail audit = new AuditTrail { Date = DateTime.Now, Action = "Created a News on News Board", UserID = User.Identity.Name }; work.AuditTrailRepository.Insert(audit); work.Save(); } // TODO: Add update logic here return(RedirectToAction("Index")); } else { return(View(model)); } } catch { return(View()); } }
public Adres( Guid id, Adressoort adressoort, bool isGeheim, FSharpOption <string> straatnaam, FSharpOption <int> huisnummer, FSharpOption <string> huisnummertoevoeging, FSharpOption <string> huisnummeraanduiding, FSharpOption <string> postcode, FSharpOption <string> plaatsnaam, FSharpOption <string> locatieomschrijving, FSharpOption <string> adresregelBuitenland1, FSharpOption <string> adresregelBuitenland2, FSharpOption <string> adresregelBuitenland3, Land land, AuditTrail <Adres> auditTrail) { Id = id; Adressoort = adressoort; IsGeheim = isGeheim; Straatnaam = straatnaam; Huisnummer = huisnummer; Huisnummertoevoeging = huisnummertoevoeging; Huisnummeraanduiding = huisnummeraanduiding; Postcode = postcode; Plaatsnaam = plaatsnaam; Locatieomschrijving = locatieomschrijving; AdresregelBuitenland1 = adresregelBuitenland1; AdresregelBuitenland2 = adresregelBuitenland2; AdresregelBuitenland3 = adresregelBuitenland3; Land = land; AuditTrail = auditTrail; }
public static void CreateAuditTrailForInsert <E>(E entity, ApplicationData app) where E : IEntityObject { StringBuilder newValues = new StringBuilder("Inserted Values :" + Environment.NewLine); foreach (var prop in entity.Details.Properties.All().OfType <IEntityStorageProperty>()) { if (prop.Name != "Id" && prop.Name != "RowVersion" && prop.Name != "Modified" && prop.Name != "ModifiedBy" && prop.Name != "Created" && prop.Name != "CreatedBy" && prop.Name != "isVerifyOnly") { AuditTrail auditRecord = app.AuditTrails.AddNew(); auditRecord.ChangeType = "Inserted"; auditRecord.ReferenceId = (int)entity.Details.Properties["Id"].Value; auditRecord.ReferenceType = entity.Details.EntitySet.Details.Name; auditRecord.Updated = DateTime.Now; auditRecord.ChangedBy = Application.Current.User.FullName; auditRecord.ReferenceProp = prop.Name; auditRecord.NewValues = prop.Value.ToString(); } } foreach (var prop in entity.Details.Properties.All().OfType <IEntityReferenceProperty>()) { if (prop.Name != "Id" && prop.Name != "RowVersion" && prop.Name != "Modified" && prop.Name != "ModifiedBy" && prop.Name != "Created" && prop.Name != "CreatedBy" && prop.Name != "isVerifyOnly") { AuditTrail auditRecord = app.AuditTrails.AddNew(); auditRecord.ChangeType = "Inserted"; auditRecord.ReferenceId = (int)entity.Details.Properties["Id"].Value; auditRecord.ReferenceType = entity.Details.EntitySet.Details.Name; auditRecord.Updated = DateTime.Now; auditRecord.ChangedBy = Application.Current.User.FullName; auditRecord.ReferenceProp = prop.Name; auditRecord.NewValues = prop.Value.ToString(); } } }
//public JsonResult OnGet(int id) //{ // AuditTrail SD = new AuditTrail(_context); // var AuditTrail = SD.GetAudit(id); // return new JsonResult(AuditTrail); //} public JsonResult OnGetAsync(int id) { AuditTrail SD = new AuditTrail(_context); var AuditTrail = SD.GetAudit(id); return(new JsonResult(AuditTrail)); }
void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext) { // TODO: Add your acction filter's tasks here // Log Action Filter Call try { if (Settings.Default.PerformGlobalAudit == true) { AuditTrail Trail = new AuditTrail(); Trail.SessionID = filterContext.HttpContext.Session.SessionID.ToString(); Trail.UserID = ((filterContext.HttpContext.User.Identity.Name != null) || (filterContext.HttpContext.User.Identity.Name != "")) ? filterContext.HttpContext.User.Identity.Name : "Guest"; Trail.PageURL = filterContext.HttpContext.Request.RawUrl; Trail.UserIP = filterContext.HttpContext.Request.UserHostAddress; Trail.Location = "N/A"; Trail.BrowserType = filterContext.HttpContext.Request.Browser.Type; Trail.BrowserVersion = filterContext.HttpContext.Request.Browser.Version; Trail.DateTimeStamp = DateTime.Now; db.AuditTrail.Add(Trail); db.SaveChanges(); } this.OnActionExecuting(filterContext); } catch (Exception ex) { //////Elmah.Log Error string exxe = ex.Message; } }
public void Insert(AuditTrail model) { using (var dataAccess = new AuditTrailDataAccess(_connectionString)) { dataAccess.Insert(model); } }
public async Task <IActionResult> PutAuditTrail(int id, AuditTrail auditTrail) { if (id != auditTrail.Id) { return(BadRequest()); } _context.Entry(auditTrail).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AuditTrailExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <AuditTrail> > PostAuditTrail(AuditTrail auditTrail) { _context.AuditTrail.Add(auditTrail); await _context.SaveChangesAsync(); return(CreatedAtAction("GetAuditTrail", new { id = auditTrail.Id }, auditTrail)); }
public async Task CreateAudit <TEntity>(TEntity entity, AuditType action) where TEntity : class, IEntityBase, IAuditDescriptionBase { var type = entity.GetType(); var trail = new AuditTrail() { EntityId = $"{entity.GetId()}", Action = Enum.GetName(typeof(AuditType), action), Entity = type.Name, Description = entity.GetAuditDescription(action) }; var entry = Db.Entry(entity); var props = from prop in type.GetProperties() let info = prop.PropertyType.GetTypeInfo() let map = prop.GetCustomAttributes(typeof(NotMappedAttribute), true) // let empty = prop.GetCustomAttributes(typeof(ByPassAttribute), true) where prop.Name != "Id" && (info.IsValueType || prop.PropertyType.IsAssignableFrom(typeof(string))) && !map.Any() select prop; switch (action) { case AuditType.Create: trail.NewValues = props.Aggregate(new StringBuilder(Environment.NewLine), (s, prop) => s.AppendLine($"{prop.Name}: {entry.CurrentValues[prop.Name]}")).ToString(); break; case AuditType.Update: var original = await entry.GetDatabaseValuesAsync(); props = from prop in props where !Equals(entry.CurrentValues[prop.Name], original[prop.Name]) select prop; trail.NewValues = props.Aggregate(new StringBuilder(Environment.NewLine), (s, prop) => s.AppendLine($"{prop.Name}: {entry.CurrentValues[prop.Name]}")).ToString(); trail.OriginalValues = props.Aggregate(new StringBuilder(Environment.NewLine), (s, prop) => s.AppendLine($"{prop.Name}: {original[prop.Name]}")).ToString(); break; case AuditType.Delete: trail.OriginalValues = props.Aggregate(new StringBuilder(Environment.NewLine), (s, prop) => s.AppendLine($"{prop.Name}: {entry.CurrentValues[prop.Name]}")).ToString(); break; case AuditType.Authorize: case AuditType.Suspend: case AuditType.Resume: case AuditType.List: case AuditType.View: default: break; } Db.AuditTrails.Add(trail); await Db.SaveChangesAsync(); }
public override Task <int> SaveChangesAsync() { auditList.Clear(); _auditFactory = new AuditTrailFactory(this); var entityList = ChangeTracker.Entries().Where(p => p.State == EntityState.Added || p.State == EntityState.Deleted || p.State == EntityState.Modified || !(p.Entity is AuditTrail) || p.Entity != null); foreach (var entity in entityList) { AuditTrail audit = _auditFactory.GetAudit(entity); auditList.Add(audit); } //var retVal = base.SaveChanges(); if (auditList.Count > 0) { auditList.ForEach(p => { Audit.Add(p); }); //base.SaveChanges(); } return(base.SaveChangesAsync()); }
private object AuditTrailForBlackListClient(Reginfo previousReginfo, string remarks) { Reginfo currentReginfo = (Reginfo)_repository.GetRegInfoByMphone(previousReginfo.Mphone); var diffList = auditTrailService.GetAuditTrialFeildByDifferenceBetweenObject(currentReginfo, previousReginfo); previousReginfo.Remarks = remarks; AuditTrail auditTrail = new AuditTrail(); auditTrail.Who = currentReginfo.UpdateBy; auditTrail.WhatActionId = 4; auditTrail.WhichParentMenuId = 2; auditTrail.WhichMenu = "Client Profile"; auditTrail.WhichId = previousReginfo.Mphone; auditTrail.Response = "Black List Performed Successfully"; auditTrail.InputFeildAndValue = diffList; //auditTrail.InputFeildAndValue = new List<AuditTrialFeild> //{ // new AuditTrialFeild // { // WhichFeildName = "BlackList", // WhichValue= previousReginfo.BlackList, // WhatValue = currentReginfo.BlackList // } //}; auditTrailService.InsertIntoAuditTrail(auditTrail); return(currentReginfo); }
private void AuditTrailForStatusChange(Reginfo prevRegInfo, Reginfo currentReginfo, string remarks) { currentReginfo.Remarks = remarks; AuditTrail auditTrail = new AuditTrail(); auditTrail.Who = currentReginfo.UpdateBy; auditTrail.WhatActionId = 4; auditTrail.WhichParentMenuId = 8; auditTrail.WhichMenu = "Change Status"; auditTrail.WhichId = currentReginfo.Mphone; var diffList = auditTrailService.GetAuditTrialFeildByDifferenceBetweenObject(currentReginfo, prevRegInfo); auditTrail.InputFeildAndValue = diffList; if (currentReginfo.Status == "I") { auditTrail.Response = "Inward BLock Performed Successfully"; } else if (currentReginfo.Status == "C") { auditTrail.Response = "Close Performed Successfully"; } else { auditTrail.Response = "Outward Block Performed Successfully"; } auditTrailService.InsertIntoAuditTrail(auditTrail); }
public object AddRemoveLien(string remarks, Reginfo prevReginfo) { //reginfo.LienM = 0; //reginfo.Remarks = remarks; _repository.AddOrRemoveLien(prevReginfo, remarks); Reginfo currentRegInfo = (Reginfo)_repository.GetRegInfoByMphone(prevReginfo.Mphone); currentRegInfo.Remarks = remarks; AuditTrail auditTrail = new AuditTrail(); auditTrail.Who = currentRegInfo.UpdateBy; auditTrail.WhatActionId = 4; auditTrail.WhichParentMenuId = 2; auditTrail.WhichMenu = "Client Profile"; auditTrail.WhichId = prevReginfo.Mphone; auditTrail.Response = "Lien Performed Successfully"; //auditTrail.InputFeildAndValue = new List<AuditTrialFeild> //{ // new AuditTrialFeild // { // WhichFeildName = "LienM", // WhichValue= prevReginfo.LienM.ToString(), // WhatValue = currentRegInfo.LienM.ToString() // }, // new AuditTrialFeild // { // WhichFeildName = "Remarks", // WhichValue= prevReginfo.Remarks, // WhatValue = currentRegInfo.Remarks // } //}; auditTrailService.InsertIntoAuditTrail(auditTrail); return(currentRegInfo); }
private void AuditTrailForClientCLose(Reginfo prevRegInfo, Reginfo currentReginfo, string remarks) { currentReginfo.Remarks = remarks; AuditTrail auditTrail = new AuditTrail(); auditTrail.Who = currentReginfo.UpdateBy; auditTrail.WhatActionId = 4; auditTrail.WhichParentMenuId = 2; auditTrail.WhichMenu = "Client Profile"; auditTrail.WhichId = currentReginfo.Mphone; var diffList = auditTrailService.GetAuditTrialFeildByDifferenceBetweenObject(currentReginfo, prevRegInfo); auditTrail.InputFeildAndValue = diffList; if (currentReginfo.Status == "C") { auditTrail.Response = "Close Performed Successfully"; } else { auditTrail.Response = "Active Performed Successfully"; } //auditTrail.InputFeildAndValue = new List<AuditTrialFeild> //{ // new AuditTrialFeild // { // WhichFeildName = "Status", // WhichValue= prevRegInfo.Status, // WhatValue = reginfo.Status // } //}; auditTrailService.InsertIntoAuditTrail(auditTrail); }
// POST: api/AuditTrails //// [ResponseType(typeof(AuditTrail))] public dynamic PostAuditTrail([FromBody] AuditTrail auditTrail) { //var USER_ID = getUserID(); auditTrail.User = db.Users.Where(x => x.User_ID == auditTrail.User_ID).FirstOrDefault(); //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} //auditTrail.DateTime = auditTrail.DateTime; //auditTrail.TransactionDescription = auditTrail.TransactionDescription; //auditTrail.TransactionType = auditTrail.TransactionType; //auditTrail.User_ID = auditTrail.User.User_ID; // db.AuditTrails.Add(auditTrail); // db.SaveChanges(); //return CreatedAtRoute("DefaultApi", new { id = auditTrail.AuditTrailID }, auditTrail); //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} db.AuditTrails.Add(auditTrail); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = auditTrail.AuditTrailID }, auditTrail)); }
public void CreatePermission(PermissionRecord permmision) { try { AuditTrail trail = new AuditTrail(); trail.TimeStamp = CurrentDate; trail.UserId = PersonalInformation.UserId; trail.UserIP = _UtilityService.RemoteIP; trail.AuditActionId = (int)Telehire.Core.Utility.SystemEnums.AuditActionEnum.Create_Permission; trail.Details = PersonalInformation.FullName + " created Permission: " + permmision.Name; //trail.AirlineId = PersonalInformation.AirlineId; _AuditTrailRep.SaveOrUpdate(trail); } catch { } }
public void UpdateUser(PersonalInformation userInfo) { try { AuditTrail trail = new AuditTrail(); trail.TimeStamp = CurrentDate; trail.UserId = PersonalInformation.UserId; trail.UserIP = _UtilityService.RemoteIP; trail.AuditActionId = (int)Telehire.Core.Utility.SystemEnums.AuditActionEnum.Update_user; trail.Details = PersonalInformation.FullName + " updated a user: " + userInfo.FullName; //trail.AirlineId = PersonalInformation.AirlineId; _AuditTrailRep.SaveOrUpdate(trail); } catch { } }
public static void logAction(string Action, object objInQuestion) { using (FinanceManagerDataContext db = new FinanceManagerDataContext()) { try { AuditTrail _newAudit = new AuditTrail() { Action = Action, AffectedTable = (objInQuestion.GetType()).Name, CreatedBy = HttpContext.Current.User.Identity.Name, CreatedDate = DateTime.Now, ActionDescription = getPropertiesOfObject(objInQuestion), AuditTrailId = Guid.NewGuid() }; db.AuditTrails.InsertOnSubmit(_newAudit); db.SubmitChanges(); } catch (Exception) { } } }
public void Log(string auditSection, string auditAction, string details, string otherRefId = null, Person userInfo = null) { var username = (HttpContext.Current.User == null) ? null : HttpContext.Current.User.Identity.Name; if (username == null && userInfo == null) return; //if (this._webUser.GetCurrentUserName == null) return; if (string.IsNullOrEmpty(auditSection) || string.IsNullOrEmpty(auditAction) || string.IsNullOrEmpty(details)) return; var user = userInfo ?? (_personRepo.Table.FirstOrDefault(x => x.Email == username) ?? new Person()); //var user = Membership.GetUser(this._webUser.GetCurrentUserName.UserName); auditSection = auditSection.Trim(); auditAction = auditAction.Trim(); details = details.Trim(); //1. get or insert into Section var section = this._section.Table.FirstOrDefault(x => x.Name.ToLower() == auditSection.ToLower()); if (section == null) { section = new AuditSection { Name = auditSection }; this._section.Add(section); } //get or insert into action var action = this._action.Table.FirstOrDefault(x => x.AuditSectionId == section.Id && x.Name.ToLower() == auditAction.ToLower()); if (action == null) { action = new AuditAction { Name = auditAction, AuditSectionId = section.Id }; this._action.Add(action); } //finally save it var trail = new AuditTrail { Details = details, //Source = _webUser.GetCurrentUserName.Source, Source = user.FullName, PersonalInfoId = user.Id, //UserId = new Guid(user.ProviderUserKey.ToString()), UserId = new Guid(user.UserId), AuditActionId = action.Id, TimeStamp = this._dateTime.ConvertToUserTime(DateTime.Now), UserIP = CommonHelper.RemoteIP, OtherRefId = otherRefId, BrowserName = CommonHelper.UserBrowser, IsMobile = CommonHelper.IsMobileBrowser }; //set the medium and browserName here . . . this._trail.Add(trail); // throw new NotImplementedException(); }
public void UserLogOut() { try { AuditTrail trail = new AuditTrail(); trail.TimeStamp = CurrentDate; trail.UserIP = _UtilityService.RemoteIP; trail.UserId = PersonalInformation.UserId; trail.AuditActionId = (int)Telehire.Core.Utility.SystemEnums.AuditActionEnum.User_LogOut; trail.Details = PersonalInformation.FullName + " logged out."; //trail.AirlineId = PersonalInformation.AirlineId; _AuditTrailRep.SaveOrUpdate(trail); } catch { } }
public static AuditTrail CreateAuditTrail(string entityId, string entityType, string entityState, string original, string current, long ID, global::System.Guid tid, string name, long createdById, long modifiedById, global::System.DateTimeOffset created, global::System.DateTimeOffset modified) { AuditTrail auditTrail = new AuditTrail(); auditTrail.EntityId = entityId; auditTrail.EntityType = entityType; auditTrail.EntityState = entityState; auditTrail.Original = original; auditTrail.Current = current; auditTrail.Id = ID; auditTrail.Tid = tid; auditTrail.Name = name; auditTrail.CreatedById = createdById; auditTrail.ModifiedById = modifiedById; auditTrail.Created = created; auditTrail.Modified = modified; return auditTrail; }
public void DeleteUserPermission(UserPermission permmission) { try { AuditTrail trail = new AuditTrail(); trail.TimeStamp = CurrentDate; trail.UserId = PersonalInformation.UserId; trail.UserIP = _UtilityService.RemoteIP; var personIn = EngineContext.Current.Resolve<IUserService>(); var pp = personIn.GetUserPersonalInformation("", permmission.UserId); trail.AuditActionId = (int)Telehire.Core.Utility.SystemEnums.AuditActionEnum.Delete_UserPermission; trail.Details = PersonalInformation.FullName + " removed a Permission: " + permmission.Permission.Name + " for user: " + pp.FullName; //trail.AirlineId = PersonalInformation.AirlineId; _AuditTrailRep.SaveOrUpdate(trail); } catch { } }