public IHttpActionResult GetLogSummary(FilterParsingLog filter)
{
if (HasRight(new string[] { "SLSIMPRT" }))
{
return(Ok <DataResponse <EntityList <EntityParsingLogSummary> > >(logRepository.GetSummaryList(filter, 0)));
}
return(Ok <DataResponse>(null));
}
public DataResponse <EntityList <EntityParsingLogSummary> > GetSummaryList(FilterParsingLog filter, int currentBusinessId)
{
var response = new DataResponse <EntityList <EntityParsingLogSummary> >();
base.DBInit();
var query = DBEntity.SalesImportSummeries.Where(a => a.ServiceId == filter.ServiceId);
if (filter.ImportedDateFrom == null)
{
filter.ImportedDateFrom = DateTime.UtcNow.AddDays(-67);
}
query = query.Where(a => a.ImportedDate > filter.ImportedDateFrom);
if (filter.ImportedDateTo != null)
{
query = query.Where(a => a.ImportedDate < filter.ImportedDateTo);
}
var entity = query.Select(a => new EntityParsingLogSummary
{
Id = a.Id,
BusinessId = a.BusinessId,
ImportedDate = a.ImportedDate,
ImportMode = a.DataMode == (int)SalesDataMode.ServiceImport ? "Service Import" : "Web Upload",
RowsSkipped = a.NumberOfSkips,
RowsInserted = a.NumberOfInserts,
RowsUpdated = a.NumberOfUpdates,
RowsFailed = a.NumberOfFails,
SourceFileUrl = a.ImportedFilePath,
RowsAffected = a.RowsAffected,
RowsImported = a.TotalRecords,
RowsResolved = a.SalesImportDetails.Count(b => b.ImportStatus == 1 || b.ImportStatus == 2),
NotReolved = a.SalesImportDetails.Count(b => b.ImportStatus == 5),
ImportedFrom = a.DataMode == (int)SalesDataMode.ServiceImport ? "Service Import" : "Web Upload",
FileType = a.SalesImportDetails.FirstOrDefault().DataType == (int)SalesDataType.MasterData ? "Collection File" : "Finance File"
}).OrderByDescending(o => o.ImportedDate);
response = GetList <EntityParsingLogSummary>(entity, filter.Skip, filter.Take);
base.DBClose();
return(response);
}
