public CsvLoadedSuccess() { var fileReader = new CsvEmployerFileReader(); using (var stream = File.Open(DataFilePath, FileMode.Open)) { _loadResult = fileReader.Load(stream); _firstRecord = _loadResult.Data[0]; } }
private static FileUploadEmployer CreateEmployer(SpreadsheetDocument document, OpenXmlElement row) { var account = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Account)); var checksum = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Checksum)); var modifiedOn = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.ModifiedOn)); var companyName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.CompanyName)); var companyAka = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.CompanyAka)); var aupa = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Aupa)); var companyType = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.CompanyType)); var primaryContact = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.PrimaryContact)); var phone = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Phone)); var email = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Email)); var website = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Website)); var address1 = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Address1)); var city = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.City)); var countryRegion = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.CountryRegion)); var postCode = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.PostCode)); var createdBy = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.CreatedBy)); var created = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Created)); var modified = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Modified)); var modifiedBy = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.ModifiedBy)); var owner = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(EmployerColumnIndex.Owner)); var fileUploadEmployer = new FileUploadEmployer { Account = new Guid(account), Checksum = checksum, ModifiedOn = modifiedOn.ToDate(), CompanyName = companyName, CompanyAka = companyAka, Aupa = aupa, CompanyType = companyType, PrimaryContact = primaryContact, Phone = phone, Email = email, Website = website, Address1 = address1, City = city, CountryRegion = countryRegion, PostCode = postCode, CreatedBy = createdBy, Created = created.ToDate(), ModifiedBy = modifiedBy, Modified = modified.ToDate(), Owner = owner }; return(fileUploadEmployer); }
public static Entities.Employer Map(FileUploadEmployer fileEmployer, Entities.Employer employer) { if (employer == null) { employer = new Entities.Employer { Id = fileEmployer.Account }; } Enum.TryParse(fileEmployer.Aupa, out AupaStatus aupa); var companyType = GetCompanyType(fileEmployer.CompanyType); employer.AlsoKnownAs = fileEmployer.CompanyAka; employer.AupaStatus = (int)aupa; employer.CompanyName = fileEmployer.CompanyName; employer.CompanyType = (int)companyType; employer.CreatedOn = fileEmployer.Created; return(employer); }