public ListModel(IJsonSerializer jsonSerializer, IRepository <DictionaryValue, Guid> dictionaryValuesRepo, IWebHostEnvironment webHostEnvironment, IAuditLogRepository auditLogsRepo, PS_PayGradeAppService oS_PayGradeAppService)
{
JsonSerializer = jsonSerializer;
DictionaryValuesRepo = dictionaryValuesRepo;
this.webHostEnvironment = webHostEnvironment;
AuditLogsRepo = auditLogsRepo;
PS_PayGradeAppService = oS_PayGradeAppService;
}
public async Task <IActionResult> OnPostPayGrade()
{
if (ModelState.IsValid)
{
try
{
var FormData = Request.Form;
PS_PayGrade_Dto payGrade_Dto = JsonSerializer.Deserialize <PS_PayGrade_Dto>(FormData["info"]);
bool IsEditing = payGrade_Dto.Id > 0;
if (IsEditing)
{
PS_PayGrade curPayGrade = await PS_PayGradeAppService.Repository.GetAsync(payGrade_Dto.Id);
if (AuditingManager.Current != null)
{
EntityChangeInfo entityChangeInfo = new EntityChangeInfo();
entityChangeInfo.EntityId = payGrade_Dto.Id.ToString();
entityChangeInfo.EntityTenantId = payGrade_Dto.TenantId;
entityChangeInfo.ChangeTime = DateTime.Now;
entityChangeInfo.ChangeType = EntityChangeType.Updated;
entityChangeInfo.EntityTypeFullName = typeof(PS_PayGrade).FullName;
entityChangeInfo.PropertyChanges = new List <EntityPropertyChangeInfo>();
List <EntityPropertyChangeInfo> entityPropertyChanges = new List <EntityPropertyChangeInfo>();
var auditProps = typeof(PS_PayGrade).GetProperties().Where(x => Attribute.IsDefined(x, typeof(CustomAuditedAttribute))).ToList();
PS_PayGrade mappedInput = ObjectMapper.Map <PS_PayGrade_Dto, PS_PayGrade>(payGrade_Dto);
foreach (var prop in auditProps)
{
EntityPropertyChangeInfo propertyChange = new EntityPropertyChangeInfo();
object origVal = prop.GetValue(curPayGrade);
propertyChange.OriginalValue = origVal == null ? "" : origVal.ToString();
object newVal = prop.GetValue(mappedInput);
propertyChange.NewValue = newVal == null ? "" : newVal.ToString();
if (propertyChange.OriginalValue == propertyChange.NewValue)
{
continue;
}
propertyChange.PropertyName = prop.Name;
if (prop.Name.EndsWith("Id"))
{
try
{
string valuePropName = prop.Name.TrimEnd('d', 'I');
propertyChange.PropertyName = valuePropName;
var valueProp = typeof(PS_PayGrade).GetProperty(valuePropName);
DictionaryValue _origValObj = (DictionaryValue)valueProp.GetValue(payGrade_Dto);
if (_origValObj == null)
{
_origValObj = await DictionaryValuesRepo.GetAsync((Guid)origVal);
}
string _origVal = _origValObj.Value;
propertyChange.OriginalValue = origVal == null ? "" : _origVal;
DictionaryValue _newValObj = (DictionaryValue)valueProp.GetValue(mappedInput);
if (_newValObj == null)
{
_newValObj = await DictionaryValuesRepo.GetAsync((Guid)newVal);
}
string _newVal = _newValObj.Value;
propertyChange.NewValue = _newValObj == null ? "" : _newVal;
}
catch (Exception ex)
{
}
}
propertyChange.PropertyTypeFullName = prop.Name.GetType().FullName;
entityChangeInfo.PropertyChanges.Add(propertyChange);
}
#region ExtraProperties
//List<EmployeeExtraPropertyHistory> allExtraPropertyHistories = new List<EmployeeExtraPropertyHistory>();
//if (department_Dto.ExtraProperties != curPayGrade.ExtraProperties)
//{
// //GeneralInfo oldGeneralInfo = department.GetProperty<GeneralInfo>("generalInfo");
// //List<EmployeeExtraPropertyHistory> physicalIdsHistory = new List<EmployeeExtraPropertyHistory>();
// //var generalInfoPhysicalIdAuditProps = typeof(PhysicalID).GetProperties().Where(x => Attribute.IsDefined(x, typeof(CustomAuditedAttribute))).ToList();
// //List<PhysicalId<Guid>> NewPhysicalIds = generalInfo.PhysicalIds.Where(x => !oldGeneralInfo.PhysicalIds.Any(y => y.Id == x.Id)).ToList();
// //List<PhysicalId<Guid>> UpdatedPhysicalIds = generalInfo.PhysicalIds.Where(x => oldGeneralInfo.PhysicalIds.Any(y => y.Id == x.Id)).ToList();
// //List<PhysicalId<Guid>> DeletedPhysicalIds = oldGeneralInfo.PhysicalIds.Where(x => !generalInfo.PhysicalIds.Any(y => y.Id == x.Id)).ToList();
// //for (int i = 0; i < NewPhysicalIds.Count; i++)
// //{
// // PhysicalId<Guid> curPhId = generalInfo.PhysicalIds[i];
// // EmployeeExtraPropertyHistory newPhIdHistory = new EmployeeExtraPropertyHistory(2, "Physical Id", curPhId.IDNumber, "Created");
// // physicalIdsHistory.Add(newPhIdHistory);
// //}
// //for (int i = 0; i < UpdatedPhysicalIds.Count; i++)
// //{
// // PhysicalId<Guid> curPhId = generalInfo.PhysicalIds[i];
// // PhysicalId<Guid> oldPhId = oldGeneralInfo.PhysicalIds.First(x => x.Id == curPhId.Id);
// // EmployeeExtraPropertyHistory updatedPhIdHistory = new EmployeeExtraPropertyHistory(2, "Physical Id", curPhId.IDNumber, "Updated");
// // foreach (var prop in generalInfoPhysicalIdAuditProps)
// // {
// // updatedPhIdHistory.PropertyChanges = new List<EmployeeTypePropertyChange>();
// // EmployeeTypePropertyChange propertyChange = new EmployeeTypePropertyChange();
// // object origVal = prop.GetValue(oldPhId);
// // propertyChange.OriginalValue = origVal == null ? "" : origVal.ToString();
// // object newVal = prop.GetValue(curPhId);
// // propertyChange.NewValue = newVal == null ? "" : newVal.ToString();
// // if (propertyChange.OriginalValue == propertyChange.NewValue) continue;
// // propertyChange.PropertyName = prop.Name;
// // if (prop.Name.EndsWith("Id"))
// // {
// // try
// // {
// // string valuePropName = prop.Name.TrimEnd('d', 'I');
// // propertyChange.PropertyName = valuePropName;
// // var valueProp = typeof(PhysicalID).GetProperty(valuePropName);
// // DictionaryValue _origValObj = (DictionaryValue)valueProp.GetValue(oldPhId);
// // if (_origValObj == null) _origValObj = await DictionaryValuesRepo.GetAsync((Guid)origVal);
// // string _origVal = _origValObj.Value;
// // propertyChange.OriginalValue = origVal == null ? "" : _origVal;
// // DictionaryValue _newValObj = (DictionaryValue)valueProp.GetValue(curPhId);
// // if (_newValObj == null) _newValObj = await DictionaryValuesRepo.GetAsync((Guid)newVal);
// // string _newVal = _newValObj.Value;
// // propertyChange.NewValue = _newValObj == null ? "" : _newVal;
// // }
// // catch (Exception ex)
// // {
// // }
// // }
// // propertyChange.PropertyTypeFullName = prop.Name.GetType().FullName;
// // updatedPhIdHistory.PropertyChanges.Add(propertyChange);
// // }
// // physicalIdsHistory.Add(updatedPhIdHistory);
// //}
// //for (int i = 0; i < DeletedPhysicalIds.Count; i++)
// //{
// // PhysicalId<Guid> curPhId = generalInfo.PhysicalIds[i];
// // EmployeeExtraPropertyHistory deletedPhIdHistory = new EmployeeExtraPropertyHistory(2, "Physical Id", curPhId.IDNumber, "Deleted");
// // physicalIdsHistory.Add(deletedPhIdHistory);
// //}
// entityChangeInfo.SetProperty("extraPropertiesHistory", allExtraPropertyHistories);
//}
#endregion
AuditingManager.Current.Log.EntityChanges.Add(entityChangeInfo);
}
curPayGrade.Name = payGrade_Dto.Name;
curPayGrade.NameLocalized = payGrade_Dto.NameLocalized;
curPayGrade.Code = payGrade_Dto.Code;
curPayGrade.Description = payGrade_Dto.Description;
curPayGrade.PayGradeStatus = payGrade_Dto.PayGradeStatus;
curPayGrade.PayGradeLevel = payGrade_Dto.PayGradeLevel;
curPayGrade.PayRangeId = payGrade_Dto.PayRangeId;
curPayGrade.PayRange = null;
#region Child Entities
PS_PayGradeComponent_Dto[] payGradeComponents = payGrade_Dto.PayGradeComponents.ToArray();
int[] curPayGradeComponentsIds = curPayGrade.PayGradeComponents != null && curPayGrade.PayGradeComponents.Count > 0 ? curPayGrade.PayGradeComponents.Select(x => x.PayComponent.Id).ToArray() : new int[0];
List <int> toDeleteSkills = new List <int>();
for (int i = 0; i < curPayGradeComponentsIds.Length; i++)
{
PS_PayGradeComponent curPayGradeComponent = curPayGrade.PayGradeComponents.First(x => x.PayComponent.Id == curPayGradeComponentsIds[i]);
if (!payGradeComponents.Any(x => x.PayComponent.Id == curPayGradeComponentsIds[i]))
{
curPayGrade.PayGradeComponents.Remove(curPayGrade.PayGradeComponents.First(x => x.PayComponent.Id == curPayGradeComponentsIds[i]));
toDeleteSkills.Add(curPayGradeComponentsIds[i]);
}
}
for (int i = 0; i < payGradeComponents.Length; i++)
{
if (curPayGrade.PayGradeComponents == null)
{
curPayGrade.PayGradeComponents = new List <PS_PayGradeComponent>();
}
if (!curPayGrade.PayGradeComponents.Any(x => x.PayComponentId == payGradeComponents[i].PayComponent.Id))
{
curPayGrade.PayGradeComponents.Add(new PS_PayGradeComponent()
{
PayComponentId = payGradeComponents[i].PayComponent.Id, MaxAnnualLimit = payGradeComponents[i].MaxAnnualLimit
});
}
else
{
var _payGradeComponent = curPayGrade.PayGradeComponents.First(x => x.PayComponentId == payGradeComponents[i].PayComponent.Id);
_payGradeComponent.MaxAnnualLimit = payGradeComponents[i].MaxAnnualLimit;
//_functionLoc.FunctionValidityStart = posFunctions[i].FunctionValidityStart;
//_functionLoc.FunctionValidityEnd = posFunctions[i].FunctionValidityEnd;
//_functionLoc.Name = posFunctions[i].Name;
//curFunction.PayGradeComponents.Remove(curFunction.PayGradeComponents.First(x => x.PayGradeId == _functionLoc.PayGradeId));
await PS_PayGradeAppService.PayComponentsRepository.UpdateAsync(_payGradeComponent);
}
}
for (int i = 0; i < toDeleteSkills.Count; i++)
{
await PS_PayGradeAppService.PayComponentsRepository.DeleteAsync(x => x.PayComponentId == toDeleteSkills[i]);
}
#endregion
PS_PayGrade_Dto updated = ObjectMapper.Map <PS_PayGrade, PS_PayGrade_Dto>(await PS_PayGradeAppService.Repository.UpdateAsync(curPayGrade));
updated = await PS_PayGradeAppService.GetAsync(updated.Id);
return(StatusCode(200, updated));
}
else
{
payGrade_Dto.Id = 0;
payGrade_Dto.PayRange = null;
if (payGrade_Dto.PayGradeComponents != null)
{
payGrade_Dto.PayGradeComponents.ForEach(x => { x.Id = 0; x.PayComponentId = x.PayComponent.Id; x.PayComponent = null; });
}
PS_PayGrade_Dto added = await PS_PayGradeAppService.CreateAsync(payGrade_Dto);
added = await PS_PayGradeAppService.GetAsync(added.Id);
if (AuditingManager.Current != null)
{
EntityChangeInfo entityChangeInfo = new EntityChangeInfo();
entityChangeInfo.EntityId = added.Id.ToString();
entityChangeInfo.EntityTenantId = added.TenantId;
entityChangeInfo.ChangeTime = DateTime.Now;
entityChangeInfo.ChangeType = EntityChangeType.Created;
entityChangeInfo.EntityTypeFullName = typeof(PS_PayGrade).FullName;
AuditingManager.Current.Log.EntityChanges.Add(entityChangeInfo);
}
return(StatusCode(200, added));
}
}
catch (Exception ex)
{
}
}
return(StatusCode(500));
}
public async Task <JsonResult> OnGetDataAuditTrail()
{
dynamic result = new ExpandoObject();
List <dynamic> DS = new List <dynamic>();
List <dynamic> secondaryDS = new List <dynamic>();
List <dynamic> tertiaryDS = new List <dynamic>();
var departmentLogs = AuditLogsRepo.WithDetails().Where(x => x.Url == HttpContext.Request.Path.Value && x.EntityChanges != null && x.EntityChanges.Count > 0).ToList();
List <PS_PayGrade_Dto> Entities = await PS_PayGradeAppService.GetAllPayGradesAsync();
TextInfo textInfo = new CultureInfo("en-US", false).TextInfo;
for (int i = 0; i < departmentLogs.Count; i++)
{
AuditLog auditLog = departmentLogs[i];
if (auditLog.EntityChanges == null || auditLog.EntityChanges.Count == 0)
{
continue;
}
var entityChanges = auditLog.EntityChanges.ToList();
for (int j = 0; j < entityChanges.Count; j++)
{
EntityChange entityChange = entityChanges[j];
dynamic changeRow = new ExpandoObject();
changeRow.AuditLogId = entityChange.Id;
changeRow.EntityChangeId = entityChange.Id;
PS_PayGrade_Dto department = Entities.First(x => x.Id.ToString() == entityChange.EntityId);
changeRow.Id = department.Id;
changeRow.Name = department.Name;
changeRow.Date = entityChange.ChangeTime.ToShortDateString();
changeRow.Time = entityChange.ChangeTime.ToShortTimeString();
changeRow.User = auditLog.UserName;
changeRow.Status = entityChange.ChangeType.GetDisplayName();
DS.Add(changeRow);
dynamic generalTypeRow = new ExpandoObject();
generalTypeRow.EntityChangeId = entityChange.Id;
generalTypeRow.TypeId = 1;
generalTypeRow.Type = "General";
generalTypeRow.Name = "";
generalTypeRow.Status = "Updated";
changeRow.Type = "General";
//changeRow.Name = "";
changeRow.ChangeStatus = "Updated";
secondaryDS.Add(generalTypeRow);
var generalPropertyChanges = entityChange.PropertyChanges.ToList();
for (int k = 0; k < generalPropertyChanges.Count; k++)
{
EntityPropertyChange propertyChange = generalPropertyChanges[k];
dynamic propertyChangeRow = new ExpandoObject();
propertyChangeRow.TypeId = 1;
propertyChangeRow.EntityChangeId = propertyChange.EntityChangeId;
propertyChangeRow.Field = textInfo.ToTitleCase(propertyChange.PropertyName.ToSentenceCase());
propertyChangeRow.NewValue = propertyChange.NewValue != "null" && propertyChange.NewValue != "\"\"" ? propertyChange.NewValue.TrimStart('"').TrimEnd('"') : "—";
propertyChangeRow.OriginalValue = propertyChange.OriginalValue != "null" && propertyChange.OriginalValue != "\"\"" ? propertyChange.OriginalValue.TrimStart('"').TrimEnd('"') : "—";;
changeRow.Field = textInfo.ToTitleCase(propertyChange.PropertyName.ToSentenceCase());
changeRow.NewValue = propertyChange.NewValue != "null" && propertyChange.NewValue != "\"\"" ? propertyChange.NewValue.TrimStart('"').TrimEnd('"') : "—";
changeRow.OriginalValue = propertyChange.OriginalValue != "null" && propertyChange.OriginalValue != "\"\"" ? propertyChange.OriginalValue.TrimStart('"').TrimEnd('"') : "—";;
tertiaryDS.Add(propertyChangeRow);
}
//List<EmployeeExtraPropertyHistory> extraPropertyHistories = entityChange.GetProperty<List<EmployeeExtraPropertyHistory>>("extraPropertiesHistory");
//if (extraPropertyHistories != null && extraPropertyHistories.Count > 0)
//{
// foreach (EmployeeExtraPropertyHistory extraPropertyHistory in extraPropertyHistories)
// {
// dynamic typeRow = new ExpandoObject();
// typeRow.EntityChangeId = entityChange.Id;
// typeRow.TypeId = extraPropertyHistory.TypeId;
// typeRow.Type = extraPropertyHistory.Type;
// typeRow.Name = extraPropertyHistory.Name;
// typeRow.Status = extraPropertyHistory.Status;
// secondaryDS.Add(typeRow);
// var propertyChanges = extraPropertyHistory.PropertyChanges.ToList();
// for (int k = 0; k < propertyChanges.Count; k++)
// {
// EmployeeTypePropertyChange propertyChange = propertyChanges[k];
// dynamic propertyChangeRow = new ExpandoObject();
// propertyChangeRow.TypeId = extraPropertyHistory.TypeId;
// propertyChangeRow.EntityChangeId = typeRow.EntityChangeId;
// propertyChangeRow.Field = textInfo.ToTitleCase(propertyChange.PropertyName.ToSentenceCase());
// propertyChangeRow.NewValue = propertyChange.NewValue != "null" && propertyChange.NewValue != "\"\"" ? propertyChange.NewValue.TrimStart('"').TrimEnd('"') : "—";
// propertyChangeRow.OriginalValue = propertyChange.OriginalValue != "null" && propertyChange.OriginalValue != "\"\"" ? propertyChange.OriginalValue.TrimStart('"').TrimEnd('"') : "—"; ;
// tertiaryDS.Add(propertyChangeRow);
// }
// }
//}
}
}
result.ds = DS;
result.secondaryDS = secondaryDS;
result.tertiaryDS = tertiaryDS;
var secondaryGrid = new JsonResult(result);
return(secondaryGrid);
}
