public partial Task OnAfterSaveChanges(List <AuditEntry> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(Task.CompletedTask);
}
foreach (var auditEntry in auditEntries)
{
// Get the final value of the temporary properties
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.PrimaryKeys[prop.Metadata.Name] = prop.CurrentValue;
}
else if (!prop.Metadata.Name.Contains("RowId"))
{
auditEntry.NewValues[prop.Metadata.Name] = prop.CurrentValue;
}
if (prop.Metadata.Name.Contains("RowId"))
{
auditEntry.KeyValue = (Guid)prop.CurrentValue;
}
}
// Save the Audit entry
Audits.Add(auditEntry.ToAudit());
}
return(SaveChangesAsync());
}
// GET: Audits/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Audits audits = db.Audits.Find(id);
if (audits == null)
{
return(HttpNotFound());
}
else
{
var auditsViewModel = new AuditsViewModel()
{
Auditor = audits.Auditor,
Project = audits.Project,
BaselineId = audits.BaselineId,
BaselinePlan = audits.BaselinePlan,
Comments = audits.Comments,
Id = audits.Id,
PerformedDate = audits.PerformedDate,
ProjectId = audits.ProjectId,
ReportNumber = audits.ReportNumber,
ScheduledDate = audits.ScheduledDate
};
var projects = db.ProjectUser.Where(pu => pu.UserName.Trim() == User.Identity.Name).Select(pu => pu.Project);
ViewBag.ProjectsList = new SelectList(projects, "Id", "Name");
ViewBag.BaselineList = new SelectList(db.BaselinePlan.Where(b => b.ProjectId == audits.ProjectId), "Id", "Name");
return(View(auditsViewModel));
}
}
public async void SortData(string columnName)
{
var action = await Application.Current.MainPage.DisplayActionSheet("Select Sort Order for Audit Date", "Cancel", null, "Sort Ascending", "Sort Descending");
if (action == "Sort Ascending" && columnName == "InspectionDate")
{
Audits = new ObservableCollection <Audit>(Audits.OrderBy(x => x.InspectionDate).ToList());
InspectionDateSortImage = "ic_sort_ASC";
}
if (action == "Sort Descending" && columnName == "InspectionDate")
{
Audits = new ObservableCollection <Audit>(Audits.OrderByDescending(x => x.InspectionDate).ToList());
InspectionDateSortImage = "ic_sort";
}
if (action == "Sort Ascending" && columnName == "InspectionStatus")
{
Audits = new ObservableCollection <Audit>(Audits.OrderBy(x => x.InspectionStatus).ToList());
InspectionStatusSortImage = "ic_sort_ASC";
}
if (action == "Sort Descending" && columnName == "InspectionStatus")
{
Audits = new ObservableCollection <Audit>(Audits.OrderByDescending(x => x.InspectionStatus).ToList());
InspectionStatusSortImage = "ic_sort";
}
}
private Task OnAfterSaveChanges(Guid transactionId, IReadOnlyCollection <AuditEntry> auditEntries)
{
if (auditEntries == null || !auditEntries.Any())
{
return(Task.CompletedTask);
}
foreach (var auditEntry in auditEntries)
{
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[prop.Metadata.Name] = prop.CurrentValue;
}
else
{
auditEntry.NewValues[prop.Metadata.Name] = prop.CurrentValue;
}
}
Audits.Add(auditEntry.ToAuditEntity(transactionId));
}
return(SaveChangesAsync());
}
private int OnAfterSaveChanges(List <AuditEntry> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(0);
}
foreach (var auditEntry in auditEntries)
{
// Get the final value of the temporary properties
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[prop.Metadata.Name] = prop.CurrentValue;
}
else
{
auditEntry.NewValues[prop.Metadata.Name] = prop.CurrentValue;
}
}
// Add the Audit entry
Audits.Add(auditEntry.ToAudit());
}
return(SaveChanges());
}
private Task OnAfterSaveChanges(List <AuditEntry> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(Task.CompletedTask);
}
foreach (var auditEntry in auditEntries)
{
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[prop.Metadata.Name] = prop.CurrentValue;
}
else
{
auditEntry.NewValues[prop.Metadata.Name] = prop.CurrentValue;
}
}
Audits.Add(auditEntry.ToAudit(_currentUserId.Value));
}
return(SaveChangesAsync());
}
private void ExecuteDelete(object parameter)
{
Collection <AuditDateModel> deleteditems = new Collection <AuditDateModel>();
IMessageBoxService msg = new MessageBoxService();
string title = "Deleting Audit Date";
string confirmtxt = "Do you want to delete the selected item";
if (Audits.Count(x => x.Selected) > 1)
{
title = title + "s";
confirmtxt = confirmtxt + "s";
}
if (msg.ShowMessage(confirmtxt + "?", title, GenericMessageBoxButton.OKCancel, GenericMessageBoxIcon.Question).Equals(GenericMessageBoxResult.OK))
{
foreach (AuditDateModel si in Audits)
{
if (si.Selected)
{
if (si.ID > 0)
{
DeleteItem(si.ID, "AuditDates");
}
deleteditems.Add(si);
}
}
foreach (AuditDateModel pm in deleteditems)
{
Audits.Remove(pm);
}
deleteditems.Clear();
}
msg = null;
}
private void ExecuteAddNew(object parameter)
{
Audits.Add(new AuditDateModel {
DateAudit = DateTime.Now, AssetID = AssetID, IsDirty = true
});
ScrollToSelectedItem = Audits.Count - 1;
}
private Task OnAfterSaveChanges(List <AuditEntry> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(Task.CompletedTask);
}
foreach (var auditEntry in auditEntries)
{
// Get the final value of the temporary properties
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[prop.Metadata.Name] = Convert.ToString(prop.CurrentValue);
}
else
{
auditEntry.NewValues[prop.Metadata.Name] = Convert.ToString(prop.CurrentValue);
}
}
// Save the Audit entry
Audits.Add(auditEntry.ToAudit());
}
return(SaveChangesAsync());
}
public ActionResult Report(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Audits audit = db.Audits.Find(id);
if (audit != null)
{
var auditReportViewModel = new AuditReportViewModel();
auditReportViewModel.Audit = audit;
auditReportViewModel.AuditReports = db.AuditReport.ToList();
auditReportViewModel.Id = id;
auditReportViewModel.MyResults = db.AuditReportResults.Where(r => r.AuditId == id).ToList();
if (audit.PerformedDate == null || auditReportViewModel.MyResults.Count == 0)
{
for (int i = 0; i < auditReportViewModel.AuditReports.Count; i++)
{
auditReportViewModel.MyResults.Add(new AuditReportResults()
{
AuditId = id,
AuditReportId = auditReportViewModel.AuditReports[i].Id
});
}
}
return(View(auditReportViewModel));
}
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
private List <AuditEntry> OnBeforeSaveChanges()
{
var auditEntries = new List <AuditEntry>();
ChangeTracker.DetectChanges();
var entries = ChangeTracker.Entries();
foreach (var entry in entries)
{
if (entry.Entity is Audit || !(entry.Entity is ITrackable) || entry.State == EntityState.Detached || entry.State == EntityState.Unchanged)
{
continue;
}
var auditEntry = new AuditEntry(entry);
auditEntry.TableName = entry.Metadata.GetTableName();
auditEntries.Add(auditEntry);
foreach (var property in entry.Properties)
{
if (property.IsTemporary)
{
auditEntry.TemporaryProperties.Add(property);
continue;
}
string propertyName = property.Metadata.Name;
if (property.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[propertyName] = property.CurrentValue;
continue;
}
switch (entry.State)
{
case EntityState.Added:
auditEntry.NewValues[propertyName] = property.CurrentValue;
break;
case EntityState.Deleted:
auditEntry.OldValues[propertyName] = property.OriginalValue;
break;
case EntityState.Modified:
if (property.IsModified)
{
auditEntry.OldValues[propertyName] = property.OriginalValue;
auditEntry.NewValues[propertyName] = property.CurrentValue;
}
break;
}
}
}
foreach (var auditEntry in auditEntries.Where(_ => !_.HasTemporaryProperties))
{
Audits.Add(auditEntry.ToAudit());
}
return(auditEntries.Where(_ => _.HasTemporaryProperties).ToList());
}
public ActionResult Create([Bind(Include = "Id,ProjectId,ReportNumber,ScheduledDate,PerformedDate,Auditor,Comments,BaselineId")] AuditsViewModel auditViewModel)
{
if (ModelState.IsValid)
{
var audit = new Audits()
{
Auditor = auditViewModel.Auditor,
BaselineId = auditViewModel.BaselineId,
Project = auditViewModel.Project,
PerformedDate = auditViewModel.PerformedDate,
Comments = auditViewModel.Comments,
BaselinePlan = auditViewModel.BaselinePlan,
ProjectId = auditViewModel.ProjectId,
ReportNumber = auditViewModel.ReportNumber,
ScheduledDate = auditViewModel.ScheduledDate
};
db.Audits.Add(audit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var projects = db.ProjectUser.Where(pu => pu.UserName.Trim() == User.Identity.Name).Select(pu => pu.Project);
ViewBag.BaselineId = new SelectList(db.BaselinePlan.Where(b => b.ProjectId == auditViewModel.ProjectId), "Id", "Name");
ViewBag.ProjectId = new SelectList(projects, "Id", "Name", auditViewModel.ProjectId);
return(View(auditViewModel));
}
private System.Threading.Tasks.Task OnAfterSaveChanges(List <AuditEntry> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(System.Threading.Tasks.Task.CompletedTask);
}
foreach (var auditEntry in auditEntries)
{
// Get the final value of the temporary properties
foreach (var prop in auditEntry.TemporaryProperties)
{
if (prop.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[prop.Metadata.Name] = prop.CurrentValue;
}
else
{
auditEntry.NewValues[prop.Metadata.Name] = prop.CurrentValue;
}
}
// Save the Audit entry
Audits.Add(auditEntry.ToAudit(CurrentLoggedUser));
}
return(System.Threading.Tasks.Task.CompletedTask);
}
public void Add(Money balance, MarketPrice price = null)
{
lock (_lock)
{
CurrentBalance = balance;
Audits.Add(new AuditEntry(DateTime.UtcNow, balance, price));
}
}
/// <summary>
/// Vide les propriétés de navigation.
/// </summary>
protected virtual void ClearNavigationProperties()
{
InspectionSteps.Clear();
Publication = null;
Anomalies.Clear();
Audits.Clear();
LinkedInspectionSteps.Clear();
}
public ActionResult DeleteConfirmed(int id)
{
Audits audits = db.Audits.Find(id);
db.Audits.Remove(audits);
db.SaveChanges();
return(RedirectToAction("Index"));
}
IAuditItem IAuditContext.CreateNew()
{
var a = new Audit();
Audits.Add(a);
a.IPAddress = IPAddress;
a.Username = UserName;
return(a);
}
public async Task AuditLogging()
{
ChangeTracker.DetectChanges();
var auditEntries = new List <AuditEntry>();
foreach (var entry in ChangeTracker.Entries())
{
if (entry.Entity is Audit || entry.State == EntityState.Detached || entry.State == EntityState.Unchanged)
{
continue;
}
var auditEntry = new AuditEntry(entry)
{
TableName = entry.Entity.GetType().Name,
UserId = _currentUser.UserId,
UserName = _currentUser.UserName
};
auditEntries.Add(auditEntry);
foreach (var property in entry.Properties)
{
var propertyName = property.Metadata.Name;
if (property.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[propertyName] = property.CurrentValue;
continue;
}
switch (entry.State)
{
case EntityState.Added:
auditEntry.AuditType = AuditType.Create;
auditEntry.NewValues[propertyName] = property.CurrentValue;
break;
case EntityState.Deleted:
auditEntry.AuditType = AuditType.Delete;
auditEntry.OldValues[propertyName] = property.OriginalValue;
break;
case EntityState.Modified:
if (property.IsModified)
{
auditEntry.ChangedColumns.Add(propertyName);
auditEntry.AuditType = AuditType.Update;
auditEntry.OldValues[propertyName] = property.OriginalValue;
auditEntry.NewValues[propertyName] = property.CurrentValue;
}
break;
}
}
}
foreach (var auditEntry in auditEntries)
{
await Audits.AddAsync(auditEntry.ToAudit());
}
}
//TODO Handle audit table here
private Task OnAfterSaveChanges(List <Audit> auditEntries)
{
if (auditEntries == null || auditEntries.Count == 0)
{
return(Task.CompletedTask);
}
Audits.AddRange(auditEntries);
return(SaveChangesAsync());
}
protected virtual void SaveAudit(IEnumerable <EntityEntry> dbEntityEntries, IEnumerable <EntityState> originalEntityStates)
{
var entitiesWithOriginalStates = dbEntityEntries.Zip(originalEntityStates, (x, y) => new { x.Entity, State = y });
var audits = entitiesWithOriginalStates
.Where(x => x.State != EntityState.Unchanged && x.State != EntityState.Detached &&
x.Entity.GetType().IsDefined(typeof(AuditMeAttribute), false)).Select(x => CreateAudit(x.Entity, x.State)).ToList();
Audits.AddRange(audits);
base.SaveChanges();
}
private bool CanExecuteSave(object obj)
{
if (!isdirty)
{
return(false);
}
if (Audits.Count(x => x.IsDirty) == 0)
{
return(false);
}
return(_canexecutesave);
}
public bool Delete(int auditId)
{
using (var scope = _serviceProvider.CreateScope())
{
var _ctx = scope.ServiceProvider.GetService(typeof(SQLHoshinCoreContext)) as SQLHoshinCoreContext;
Audits auditToRemove = _ctx.Audits.FirstOrDefault(a => a.AuditID == auditId);
_ctx.Audits.Remove(auditToRemove);
_ctx.SaveChanges();
return(true);
}
}
public ActionResult Edit([Bind(Include = "Id,ProjectId,ReportNumber,ScheduledDate,PerformedDate,Auditor,Comments,BaselineId")] Audits audits)
{
if (ModelState.IsValid)
{
db.Entry(audits).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BaselineId = new SelectList(db.BaselinePlan, "Id", "Name", audits.BaselineId);
ViewBag.ProjectId = new SelectList(db.Project, "Id", "Name", audits.ProjectId);
return(View(audits));
}
async Task AuditTemporaryProperties(IEnumerable <Tuple <EntityEntry, Audit> > temporatyEntities)
{
if (temporatyEntities != null && temporatyEntities.Any())
{
await Audits.AddRangeAsync(temporatyEntities.ForEach(t => t.Item2.KeyValues = JsonConvert.SerializeObject(t.Item1.Properties.Where(p => p.Metadata.IsPrimaryKey()).ToDictionary(p => p.Metadata.Name, p => p.CurrentValue).NullIfEmpty()))
.Select(t => t.Item2)
);
await SaveChangesAsync();
}
await Task.CompletedTask;
}
// GET: Audits/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Audits audits = db.Audits.Find(id);
if (audits == null)
{
return(HttpNotFound());
}
return(View(audits));
}
/// <summary>
/// Helper to construct a ProKnowApi object
/// </summary>
/// <param name="baseUrl">The base URL to ProKnow, e.g. 'https://example.proknow.com'</param>
/// <param name="credentialsId">The ID from the ProKnow credentials JSON file</param>
/// <param name="credentialsSecret">The secret from the ProKnow credentials JSON file</param>
/// <param name="lockRenewalBuffer">The number of seconds to use as a buffer when renewing a lock for a draft
/// structure set</param>
private void ConstructorHelper(string baseUrl, string credentialsId, string credentialsSecret, int lockRenewalBuffer)
{
LockRenewalBuffer = lockRenewalBuffer;
Requestor = new Requestor(baseUrl, credentialsId, credentialsSecret);
CustomMetrics = new CustomMetrics(this);
ScorecardTemplates = new ScorecardTemplates(this);
Workspaces = new Workspaces(this);
Roles = new Roles(this);
Users = new Users(this);
Uploads = new Uploads(this);
Patients = new Patients(this);
Collections = new Collections(this);
Audit = new Audits(this);
}
private void ExecuteDelete(object parameter)
{
int _id = ((MaintenanceRecordModel)parameter).ID;
if (_id != 0)
{
IMessageBoxService _msgbox = new MessageBoxService();
if (_msgbox.ShowMessage("Do you want to delete this Audit?", "Deleting Audit", GenericMessageBoxButton.OKCancel, GenericMessageBoxIcon.Question) == GenericMessageBoxResult.OK)
{
DeleteItem(_id, "AuditDates");
Audits.Remove((MaintenanceRecordModel)parameter);
}
_msgbox = null;
}
}
public ActionResult Report(AuditReportViewModel viewModel)
{
Audits audit = db.Audits.Find(viewModel.Id);
audit.PerformedDate = DateTime.Now;
db.Entry(audit).State = EntityState.Modified;
var listResults = db.AuditReportResults.Where(r => r.AuditId == viewModel.Id);
db.AuditReportResults.RemoveRange(listResults); // Remove old values
db.SaveChanges();
db.AuditReportResults.AddRange(viewModel.MyResults); // Insert new values
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Auditar
/// </summary>
/// <returns></returns>
public Audits ToAudit()
{
var audit = new Audits();
audit.TableName = TableName;
audit.DateTime = DateTime.UtcNow;
audit.KeyValues = KeyValue;
audit.OldValues = OldValues.Count == 0 ? null : JsonConvert.SerializeObject(OldValues);
audit.NewValues = NewValues.Count == 0 ? null : JsonConvert.SerializeObject(NewValues);
audit.Deleted = Deleted;
audit.LastAction = LastAction;
audit.LastActionDate = DateTime.UtcNow;
audit.IdUser = IdUser;
audit.UserName = UserName;
audit.RequestId = RequestId;
return(audit);
}
public AuditEntry Previous()
{
lock (_lock)
{
var c = CurrentBalance;
if (c == null)
{
return(null);
}
var aud = GetCurrent(c.Asset);
return(aud == null ?
null :
Audits.Where(x => x.Value.Asset.Id == CurrentBalance.Asset.Id && x != aud).OrderByDescending(x => x.UtcCreated).FirstOrDefault());
}
}
public static List<Audits> lstAudits(MPSfwk.Model.Audits aud_param, int tipLista, string ordBY)
{
SqlCommand comm = new SqlCommand();
if (tipLista == 0)
{
comm.CommandText = @"SELECT
ServerName,
ClasseName,
GeracaoDate,
UltimaAcaoDate
FROM ASPNETDB.dbo.ds_audit_xml" + MontaWhere(aud_param) +
" ORDER BY GeracaoDate DESC";
}
else if (tipLista == 1)
{
comm.CommandText = @"SELECT
ServerName,
ClasseName,
GeracaoDate,
convert(datetime,stuff(stuff(stuff(GeracaoDate, 9, 0, ' '), 12, 0, ':'), 15, 0, ':')) ConvGeracaoDate
FROM ASPNETDB.dbo.ds_audit_xml" + MontaWhere(aud_param) +
" GROUP BY ServerName, ClasseName, GeracaoDate" +
" ORDER BY convert(datetime,stuff(stuff(stuff(GeracaoDate, 9, 0, ' '), 12, 0, ':'), 15, 0, ':')) " + ordBY;
}
else if (tipLista == 2)
{
comm.CommandText = @"( SELECT DISTINCT ServerName, ClasseName, MAX(GeracaoDate)
FROM ASPNETDB.dbo.ds_audit_xml
WHERE GeracaoDate like '%" + aud_param.DTGeracaoFim + "%'" +
" GROUP BY ServerName, ClasseName, GeracaoDate " +
") ORDER BY ServerName, ClasseName " + ordBY;
}
else if (tipLista == 3)
{
comm.CommandText = @"SELECT
ServerName,
ClasseName,
GeracaoDate,
UltimaAcaoDate
FROM ASPNETDB.dbo.vw_ds_audit_xml_Ativos7days
WHERE GeracaoDate like '" + aud_param.IDGeracao + "%' " +
" ORDER BY ClasseName ASC, ServerName ASC";
}
else if (tipLista == 4)
{
comm.CommandText = @"SELECT
VALUE + ' ' + SEL
FROM ASPNETDB.dbo.ds_ListHosts
WHERE CHK = '1'
AND VALUE NOT IN (SELECT DISTINCT ServerName
FROM ASPNETDB.dbo.vw_ds_audit_xml_Ativos7days
WHERE GeracaoDate like '" + aud_param.IDGeracao + "%')";
}
comm.CommandType = CommandType.Text;
using (SqlDataReader dataReader = SQLServer.DataAccess.ExecuteReader(comm))
{
List<Audits> _lst = new List<Audits>();
while (dataReader.Read())
{
Audits aud = new Audits();
aud.IDServer = dataReader.GetString(0);
if (tipLista != 4)
{
aud.IDClasse = dataReader.GetString(1);
aud.IDGeracao = dataReader.GetString(2);
}
if ((tipLista == 0) || (tipLista == 3))
{ aud.DataUltimaAcao = dataReader.GetDateTime(3); }
else if (tipLista == 1)
{ aud.CVGeracao = dataReader.GetDateTime(3).ToString(); }
_lst.Add(aud);
}
return _lst;
}
}
