public IActionResult AuditResponseInternalView(InternalQuestions questions) { try { _log4net.Info(" Http POST request " + nameof(AuditResponseInternalView) + " method called"); string Token = HttpContext.Request.Cookies["Token"]; if (string.IsNullOrEmpty(Token)) { ViewBag.Message = "Please Login"; return(View("Login")); } AuditResponse auditResponse = new AuditResponse(); SeverityProvider severityProvider = new SeverityProvider(config); auditResponse = severityProvider.GetResponseforInternal(questions, Token); Storage obj = new Storage(); obj.add(auditResponse); context.AuditResponse.Add(auditResponse); context.SaveChanges(); return(View(auditResponse)); } catch (Exception e) { _log4net.Error("Error From GET " + nameof(AuditResponseInternalView) + " Error Message: " + e.Message); return(View("Error")); } }
public ActionResult Create([Bind(Include = "UserId,SubdivisionId,Role,UserLastName,UserName,UserMiddleName,UserEmail,UserPhone")] Users users) { //ViewBag.SubdivisionList = new SelectList(db.Subdivisions, "SubdivisionId", "SubdivisionName", users.SubdivisionId); if (ModelState.IsValid) { db.Users.Add(users); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(users)); }
public ActionResult Create([Bind(Include = "SubdivisionId,SubdivisionName")] Subdivisions subdivisions) { if (ModelState.IsValid) { db.Subdivisions.Add(subdivisions); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(subdivisions)); }
public ActionResult Create(Sertificates sertificates) { if (ModelState.IsValid) { sertificates.Discrepancy = false; db.Sertificates.Add(sertificates); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sertificates)); }
public ActionResult Create([Bind(Include = "NewsContent,NewsDateTime,UserId,NewsId,NewsTitle")] News news) { if (ModelState.IsValid) { string userEmail = User.Identity.GetUserName(); Users user = db.Users.Where(u => u.UserEmail == userEmail).FirstOrDefault(); news.UserId = user.UserId; news.NewsDateTime = DateTime.Now; db.News.Add(news); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(news)); }
public ActionResult Create([Bind(Include = "StandartId,ApplicationDateTime,ApplicationId,UserId,ApplicationContent")] Applications applications) { if (ModelState.IsValid) { string userEmail = User.Identity.GetUserName(); Users user = db.Users.Where(u => u.UserEmail == userEmail).FirstOrDefault(); applications.UserId = user.UserId; applications.ApplicationDateTime = DateTime.Now; db.Applications.Add(applications); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(applications)); }
public void Log(string createdBy, HttpRequest request, bool isSucceed, Exception exception) { Guid.TryParse(request.Headers["RequestId"], out Guid id); var msg = _dbContext.AuditLog.Find(id); if (msg == null) { string body = GetBody(request); msg = new AuditLog() { Id = id, Body = body, CreatedDateTime = DateTime.UtcNow, RequestIp = $"{request.Headers.Referer} - {request.HttpContext.Connection.RemoteIpAddress}", Endpoint = request.Path, Method = request.Method, CreatedBy = createdBy }; _dbContext.AuditLog.Add(msg); } if (exception != null) { msg.Exception = JObject.FromObject(exception).ToString(Newtonsoft.Json.Formatting.None); } msg.Success = isSucceed; _dbContext.SaveChanges(); }
public void CreateCompanyAudit() { using (var transactionScope = new TransactionScope()) { using (var dataContext = new DataContext()) { using (var dataTransaction = dataContext.Database.BeginTransaction()) { dataContext.Set <Company>().Add(new Company { Name = "Sookin & Son" }); dataContext.SaveChanges(); dataTransaction.Commit(); } } using (var auditContext = new AuditContext()) { using (var auditTransaction = auditContext.Database.BeginTransaction()) { auditContext.Set <AuditRecord>().Add(new AuditRecord { ActionName = "Test", UserLoginName = "JDoe" }); auditContext.SaveChanges(); auditTransaction.Commit(); } } transactionScope.Complete(); } }
public static void PurgeTable <T>(this AuditContext auditContext, DbSet <T> table) where T : class { foreach (var row in table) { auditContext.Set <T>().Remove(row); } auditContext.SaveChanges(); }
/// <summary> /// /// </summary> /// <param name="eventWrapper"></param> public void SaveEvent(Event eventWrapper) { using (var context = new AuditContext(_options)) { context.Events.Add(eventWrapper); context.SaveChanges(); } }
private void CleanAuditEventTable() { using (var db = new AuditContext().CreateContext(m_settings)) { db.ObjectContext.ExecuteStoreCommand("Delete From AuditEvents"); db.SaveChanges(); } }
public static void Main(string[] args) { using (var db = new AuditContext()) { try { if (!db.Products.Any()) { Product p = new Product { Id = new Guid(), Color = "Blue", Name = "iPhone 7" }; db.Products.Add(p); db.SaveChanges(); } if (!db.Users.Any()) { User u = new User { Id = new Guid(), FirstName = "John", LastName = "Doe" }; db.Users.Add(u); db.SaveChanges(); } while (true) { foreach (var log in db.AuditLogs) { Console.WriteLine("{0:s} - {1}.{2} OLD: {3} => NEW: {4}", log.DateChanged, log.EntityName, log.PropertyName, log.OldValue, log.NewValue); } Console.Write("Press ENTER to update log: "); Console.ReadLine(); UpdateValues(db); } } catch (Exception x) { Console.WriteLine(x.Message); throw; } } }
public void Log(string category, string message) { using (var db = new AuditContext().CreateContext(m_settings)) { AuditEvent auditEvent = new AuditEvent(category, message); db.AuditEvents.Add(auditEvent); db.SaveChanges(); } }
private static void UpdateValues(AuditContext db) { Random r = new Random(); int i = r.Next(1, 3); UpdateUser(db, i); UpdateProduct(db, i); db.SaveChanges(); }
public ActionResult Create(Standarts standarts, HttpPostedFileBase uploadFile) { byte[] fileData = null; // считываем переданный файл в массив байтов using (var binaryReader = new BinaryReader(uploadFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadFile.ContentLength); } // установка массива байтов standarts.StandartFile = fileData; if (ModelState.IsValid && uploadFile != null && uploadFile.ContentLength > 0) { db.Standarts.Add(standarts); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(standarts)); }
public void Post([FromBody] AuditEntity auditEntity) { var existingEntity = GetEntity(auditEntity.Application, auditEntity.EntityId, auditEntity.EntityType); if (!string.IsNullOrWhiteSpace(existingEntity)) { CalculatePatch(existingEntity, auditEntity); } _context.Add(auditEntity); _context.SaveChanges(); }
public void SaveChangesFailed(DbContextErrorEventData eventData) { using (var auditContext = new AuditContext(_connectionString)) { auditContext.Attach(_audit); _audit.Succeeded = false; _audit.EndTime = DateTime.UtcNow; _audit.ErrorMessage = eventData.Exception.Message; auditContext.SaveChanges(); } }
public int SavedChanges(SaveChangesCompletedEventData eventData, int result) { using (var auditContext = new AuditContext(_connectionString)) { auditContext.Attach(_audit); _audit.Succeeded = true; _audit.EndTime = DateTime.UtcNow; auditContext.SaveChanges(); } return(result); }
public InterceptionResult <int> SavingChanges( DbContextEventData eventData, InterceptionResult <int> result) { _audit = CreateAudit(eventData.Context); using (var auditContext = new AuditContext(_connectionString)) { auditContext.Add(_audit); auditContext.SaveChanges(); } return(result); }