private static FileUploadQuery CreateQuery(SpreadsheetDocument document, OpenXmlElement row)
{
var companyTl = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.CompanyTl));
var checksum = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Checksum));
var modifiedOn = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.ModifiedOn));
var company = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Company));
var created = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Created));
var dateContacted = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.DateContacted));
var nextPlannedContact = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.NextPlannedContact));
var resolution = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Resolution));
var resolutionOther = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.ResolutionOther));
var offeredPlacements = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.OfferedPlacements));
var occupationalPath = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.OccupationalPath));
var technicalRouteWay = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.TechnicalRouteWay));
var pathwayOffered = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.PathwayOffered));
var routeOffered = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.RouteOffered));
var postCode = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.PostCode));
var region = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Region));
var query = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Query));
var queryOther = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.QueryOther));
var createdBy = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.CreatedBy));
var placementOffered = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.PlacementOffered));
var referToProvider = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.ReferToProvider));
var provider1 = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Provider1));
var provider2 = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Provider2));
var provider3 = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(QueryColumnIndex.Provider3));
var fileUploadQuery = new FileUploadQuery
{
CompanyTl = new Guid(companyTl),
Checksum = checksum,
ModifiedOn = modifiedOn.ToDate(),
Company = company,
Created = created.ToDate(),
DateContacted = dateContacted.ToDate(),
NextPlannedContact = nextPlannedContact.ToDate(),
Resolution = resolution,
ResolutionOther = resolutionOther,
OfferedPlacements = int.Parse(offeredPlacements),
OccupationalPath = occupationalPath,
TechnicalRouteWay = technicalRouteWay,
PathwayOffered = pathwayOffered,
RouteOffered = routeOffered,
PostCode = postCode,
Region = region,
Query = query,
QueryOther = queryOther,
CreatedBy = createdBy,
PlacementOffered = placementOffered,
ReferToProvider = GetNullableBool(referToProvider),
Provider1 = provider1,
Provider2 = provider2,
Provider3 = provider3
};
return(fileUploadQuery);
}
public CsvLoadedSuccess()
{
var fileReader = new CsvQueryFileReader();
using (var stream = File.Open(DataFilePath, FileMode.Open))
{
_loadResult = fileReader.Load(stream);
_firstRecord = _loadResult.Data[0];
}
}