private void DoEquipmentAudit(List <HetSeniorityAudit> audits, EntityEntry entry, string smUserId)
{
HetEquipment changed = (HetEquipment)entry.Entity;
int tempChangedId = changed.EquipmentId;
// if this is an "empty" record - exit
if (tempChangedId <= 0)
{
return;
}
HetEquipment original = HetEquipment.AsNoTracking()
.Include(x => x.LocalArea)
.Include(x => x.Owner)
.FirstOrDefault(a => a.EquipmentId == tempChangedId);
// record doesn't exist
if (original == null)
{
return;
}
// compare the old and new
if (changed.IsSeniorityAuditRequired(original))
{
DateTime currentTime = DateTime.UtcNow;
// create the audit entry.
HetSeniorityAudit seniorityAudit = new HetSeniorityAudit
{
BlockNumber = original.BlockNumber,
EndDate = currentTime
};
int tempLocalAreaId = original.LocalArea.LocalAreaId;
int tempOwnerId = original.Owner.OwnerId;
changed.SeniorityEffectiveDate = currentTime;
seniorityAudit.AppCreateTimestamp = currentTime;
seniorityAudit.AppLastUpdateTimestamp = currentTime;
seniorityAudit.AppCreateUserid = smUserId;
seniorityAudit.AppLastUpdateUserid = smUserId;
seniorityAudit.EquipmentId = tempChangedId;
seniorityAudit.LocalAreaId = tempLocalAreaId;
seniorityAudit.OwnerId = tempOwnerId;
if (seniorityAudit.Owner != null)
{
seniorityAudit.OwnerOrganizationName = seniorityAudit.Owner.OrganizationName;
}
if (original.SeniorityEffectiveDate != null)
{
seniorityAudit.StartDate = (DateTime)original.SeniorityEffectiveDate;
}
seniorityAudit.Seniority = original.Seniority;
seniorityAudit.ServiceHoursLastYear = original.ServiceHoursLastYear;
seniorityAudit.ServiceHoursTwoYearsAgo = original.ServiceHoursTwoYearsAgo;
seniorityAudit.ServiceHoursThreeYearsAgo = original.ServiceHoursThreeYearsAgo;
audits.Add(seniorityAudit);
}
}
/// <summary>
/// Override for Save Changes to implement the audit log
/// </summary>
/// <returns></returns>
public override int SaveChanges()
{
// get all of the modified records
IEnumerable <EntityEntry> modifiedEntries = ChangeTracker.Entries()
.Where(e => e.State == EntityState.Added ||
e.State == EntityState.Modified);
// manage the audit columns and the concurrency column
DateTime currentTime = DateTime.UtcNow;
List <HetSeniorityAudit> seniorityAudits = new List <HetSeniorityAudit>();
foreach (EntityEntry entry in modifiedEntries)
{
if (AuditableEntity(entry.Entity))
{
SetAuditProperty(entry.Entity, "AppLastUpdateUserid", SmUserId);
SetAuditProperty(entry.Entity, "AppLastUpdateUserDirectory", DirectoryName);
SetAuditProperty(entry.Entity, "AppLastUpdateUserGuid", SmUserGuid);
SetAuditProperty(entry.Entity, "AppLastUpdateTimestamp", currentTime);
if (entry.State == EntityState.Added)
{
SetAuditProperty(entry.Entity, "AppCreateUserid", SmUserId);
SetAuditProperty(entry.Entity, "AppCreateUserDirectory", DirectoryName);
SetAuditProperty(entry.Entity, "AppCreateUserGuid", SmUserGuid);
SetAuditProperty(entry.Entity, "AppCreateTimestamp", currentTime);
SetAuditProperty(entry.Entity, "ConcurrencyControlNumber", 1);
}
else
{
int controlNumber = (int)GetAuditProperty(entry.Entity, "ConcurrencyControlNumber");
controlNumber = controlNumber + 1;
SetAuditProperty(entry.Entity, "ConcurrencyControlNumber", controlNumber);
}
}
if (entry.Entity is HetEquipment)
{
DoEquipmentAudit(seniorityAudits, entry, SmUserId);
}
}
// *************************************************
// attempt to save updates
// *************************************************
int result;
try
{
result = base.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
// e.InnerException.Message "20180: Concurrency Failure 5" string
if (e.InnerException != null &&
e.InnerException.Message.StartsWith("20180"))
{
// concurrency error
throw new HetsDbConcurrencyException("This record has been updated by another user.");
}
throw;
}
// *************************************************
// manage seniority audit records
// *************************************************
if (seniorityAudits.Count > 0)
{
foreach (HetSeniorityAudit seniorityAudit in seniorityAudits)
{
HetSeniorityAudit.Add(seniorityAudit);
}
}
base.SaveChanges();
return(result);
}
