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); }