public async Task <HttpResponseMessage> GetColumnLevelMetadataFromFile(int fileId) { DM.File file = fileService.GetFileByFileId(fileId); if (file == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, MessageStrings.FileNotFound)); } ColumnLevelMetadataViewModel columnLevelMetadataViewModel = new ColumnLevelMetadataViewModel(); try { columnLevelMetadataViewModel.SheetList = await this.fileService.GetDocumentSheetDetails(file); } catch (FileFormatException ex) { diagnostics.WriteErrorTrace(TraceEventId.Exception, ex); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } columnLevelMetadataViewModel.TypeList = this.fileService.RetrieveFileColumnTypes(); columnLevelMetadataViewModel.UnitList = this.fileService.RetrieveFileColumnUnits(); try { columnLevelMetadataViewModel.MetadataList = await this.fileService.GetColumnLevelMetadataFromFile(file); } catch (FileFormatException ex) { diagnostics.WriteErrorTrace(TraceEventId.Exception, ex); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, columnLevelMetadataViewModel)); }
public async Task <HttpResponseMessage> GetColumnLevelMetadata(int fileId) { ////HttpResponseMessage response = await GetColumnLevelMetadataFromFile(fileId); ////return response; DM.File file = fileService.GetFileByFileId(fileId); if (file == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, MessageStrings.FileNotFound)); } ////List<ColumnLevelMetadata> columnLevelMetadataList = await response.Content.ReadAsAsync<List<ColumnLevelMetadata>>(); List <ColumnLevelMetadata> columnLevelMetadataList = new List <ColumnLevelMetadata>(); if (file.FileColumns != null && file.FileColumns.Any()) { foreach (FileColumn fileColumn in file.FileColumns) { ColumnLevelMetadata columnLevelMetadata = new ColumnLevelMetadata() { Id = fileColumn.FileColumnId, SelectedEntityName = fileColumn.EntityName, EntityDescription = fileColumn.EntityDescription, Name = fileColumn.Name, Description = fileColumn.Description, SelectedTypeId = fileColumn.FileColumnTypeId.Value, SelectedUnitId = fileColumn.FileColumnUnitId }; columnLevelMetadataList.Add(columnLevelMetadata); } } ColumnLevelMetadataViewModel columnLevelMetadataViewModel = new ColumnLevelMetadataViewModel(); columnLevelMetadataViewModel.MetadataList = columnLevelMetadataList; try { columnLevelMetadataViewModel.SheetList = await this.fileService.GetDocumentSheetDetails(file); } catch (FileFormatException ex) { diagnostics.WriteErrorTrace(TraceEventId.Exception, ex); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } columnLevelMetadataViewModel.TypeList = this.fileService.RetrieveFileColumnTypes(); columnLevelMetadataViewModel.UnitList = this.fileService.RetrieveFileColumnUnits(); return(Request.CreateResponse(HttpStatusCode.OK, columnLevelMetadataViewModel)); }