public async Task <AuditSearchModel> GetAudits(AuditSearchModel model)
{
var url = ODataApiUri + "/Audit?" + GetFilterString(model);
var result = await GetOdataResultFromApi(url);
var searchResultCount = 0;
if (result.Count != null)
{
int.TryParse(result.Count.ToString(), out searchResultCount);
}
model.TotalRows = searchResultCount;
model.AuditSearchResult.Clear();
try
{
model.AuditSearchResult.AddRange(result.Items.Select(item => JsonConvert.DeserializeObject <AuditModel>(item.ToString())));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(model);
}
public async Task <IActionResult> ChangeLogGrid(AuditSearchModel model)
{
model = InitializeAuditModel(model);
var result = await _customerApiClient.GetAudits(model);
return(PartialView(result));
}
public IActionResult Grid(AuditSearchModel model)
{
model = InitializeModel(model);
var result = _auditApiClient.GetAudits(model).Result;
model.SelectedTable = !string.IsNullOrWhiteSpace(model.SelectedTable)
? model.SelectedTable
: model.TableList.FirstOrDefault(x => x.ToLower().Contains("please"));
return(PartialView(result));
}
public IActionResult PersonContactByChangeLog(AuditSearchModel model)
{
model = InitializeAuditModel(model);
model.SelectedTable = "PersonContactDetails";
if (Request.IsAjaxRequest())
{
var result = _customerApiClient.GetAudits(model).Result;
return(PartialView("ChangeLog", result));
}
return(PartialView("ChangeLog", model));
}
public IActionResult PersonAddressChangeLog(AuditSearchModel model)
{
model = InitializeAuditModel(model);
model.SelectedTable = "Addresses";
if (Request.IsAjaxRequest())
{
var person = _customerApiClient.GetPerson(model.PersonId).Result;
var personAddress = person.PersonAddresses?.FirstOrDefault();
model.AddressId = personAddress?.AddressId ?? 0;
var result = _customerApiClient.GetAudits(model).Result;
return(PartialView("ChangeLog", result));
}
return(PartialView("ChangeLog", model));
}
private string GetFilterString(AuditSearchModel auditSearchModel)
{
var filterString = string.Empty;
if (auditSearchModel != null)
{
if (!string.IsNullOrWhiteSpace(auditSearchModel.SelectedTable))
{
if (auditSearchModel.PersonId > 0)
{
if (auditSearchModel.SelectedTable == "Persons")
{
filterString = ODataFilterConstant.Filter + @"KeyValues eq '{""Id"":";
filterString += auditSearchModel.PersonId + "}'";
}
else if (auditSearchModel.SelectedTable == "Addresses")
{
filterString = ODataFilterConstant.Filter + @"KeyValues eq '{""Id"":";
filterString += auditSearchModel.AddressId + "}'";
}
else
{
filterString = ODataFilterConstant.Filter + @"(contains(NewValues,'""PersonId"":";
filterString += auditSearchModel.PersonId + "') eq true";
filterString += @" or contains(OldValues,'""PersonId"":";
filterString += auditSearchModel.PersonId + "') eq true)";
}
}
else if (auditSearchModel.Id > 0)
{
filterString += $"Id eq {auditSearchModel.Id}";
}
if (!string.IsNullOrWhiteSpace(auditSearchModel.SelectedTable))
{
filterString += $" and TableName eq '{auditSearchModel.SelectedTable}'";
}
}
AddPageSizeNumberAndSortingInFilterString(auditSearchModel, ref filterString);
}
return(filterString);
}
private AuditSearchModel InitializeModel(AuditSearchModel model)
{
if (model == null)
{
model = new AuditSearchModel
{
TargetGridId = "AuditGrid",
SortColumn = "Id",
SortDirection = "Desc",
PageSize = 8,
PageNumber = 1
};
}
else
{
if (string.IsNullOrWhiteSpace(model.SortColumn))
{
model.SortColumn = "Id";
model.SortDirection = "Desc";
}
}
return(model);
}
public async Task <AuditSearchModel> GetAudits(AuditSearchModel model)
{
return(await _auditApiClient.GetAudits(model));
}
public IActionResult Search(AuditSearchModel search)
{
return(Ok(AuditService.GetAuditModels(search)));
}
private AuditSearchModel InitializeAuditModel(AuditSearchModel model)
{
InitializeSearchModel(model, "PersonChangeLogGrid", "Id", "Desc");
return(model);
}
