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);
}
private static IList<ColumnLevelMetadata> CreateColumnLevelMetadataList(string sheetName, IEnumerable<SheetCell> headerCells)
{
IList<ColumnLevelMetadata> columnLevelMetadaList = new List<ColumnLevelMetadata>();
if (headerCells == null || headerCells.Count() == 0)
{
return columnLevelMetadaList;
}
for (int i = 0; i < headerCells.Count(); i++)
{
ColumnLevelMetadata columnLevelMetadata = new ColumnLevelMetadata();
columnLevelMetadata.SelectedEntityName = sheetName;
columnLevelMetadata.Name = headerCells.ElementAt(i).Value;
columnLevelMetadaList.Add(columnLevelMetadata);
}
return columnLevelMetadaList;
}
private static IList<ColumnLevelMetadata> CreateColumnLevelMetadataList(string fileName, List<string> headers)
{
IList<ColumnLevelMetadata> columnLevelMetadaList = new List<ColumnLevelMetadata>();
if (headers == null || headers.Count == 0)
{
return columnLevelMetadaList;
}
for (int i = 0; i < headers.Count; i++)
{
ColumnLevelMetadata columnLevelMetadata = new ColumnLevelMetadata();
columnLevelMetadata.SelectedEntityName = fileName;
columnLevelMetadata.Name = headers.ElementAt(i);
columnLevelMetadaList.Add(columnLevelMetadata);
}
return columnLevelMetadaList;
}