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