public static Entities.Contact Map(FileUploadContact fileContact,
Entities.Contact contact, Guid employerGuid)
{
if (contact == null)
{
contact = new Entities.Contact();
contact.Id = Guid.NewGuid();
}
contact.EntityRefId = employerGuid;
var contactType = GetContactType(fileContact.ContactType);
var preferredMethodOfContact = GetPreferredMethodOfContact(fileContact.PreferredContact);
contact.ContactTypeId = (int)contactType;
contact.PreferredContactMethodType = (int)preferredMethodOfContact;
//contact.IsPrimary
contact.FirstName = fileContact.FirstName;
contact.MiddleName = fileContact.MiddleName;
contact.LastName = fileContact.LastName;
contact.JobTitle = fileContact.JobTitle;
contact.BusinessPhone = fileContact.PhoneBusiness;
contact.MobilePhone = fileContact.PhoneMobile;
contact.HomePhone = fileContact.PhoneHome;
//contact.Email = fileContact.Email;
contact.CreatedOn = fileContact.Created;
contact.ModifiedOn = fileContact.ModifiedOn;
return(contact);
}
public CsvLoadedSuccess()
{
var fileReader = new CsvContactFileReader();
using (var stream = File.Open(DataFilePath, FileMode.Open))
{
_loadResult = fileReader.Load(stream);
_firstRecord = _loadResult.Data[0];
}
}
private static FileUploadContact CreateContact(SpreadsheetDocument document, OpenXmlElement row)
{
var contact = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.Contact));
var checksum = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.Checksum));
var modifiedOn = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.ModifiedOn));
var companyName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.CompanyName));
var createdOn = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.CreatedOnCompany));
var contactType = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.ContactType));
var phoneHome = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.PhoneHome));
var jobTitle = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.JobTitle));
var phoneMobile = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.PhoneMobile));
var modifiedBy = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.ModifiedBy));
var modified = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.Modified));
var preferredContact = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.PreferredContact));
var fullName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.FullName));
var firstName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.FirstName));
var middleName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.MiddleName));
var lastName = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.LastName));
var phoneBusiness = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.PhoneBusiness));
var createdBy = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.CreatedBy));
var created = CellValueRetriever.Get(document, row.Descendants <Cell>().ElementAt(ContactColumnIndex.Created));
var isValid = ValidateMandatory(contact, contactType, preferredContact);
if (!isValid)
{
return(null);
}
var fileUploadContact = new FileUploadContact
{
Contact = new Guid(contact),
Checksum = checksum,
ModifiedOn = modifiedOn.ToDate(),
CompanyName = companyName,
CreatedOnCompany = createdOn.ToDate(),
ContactType = contactType,
PhoneHome = phoneHome,
JobTitle = jobTitle,
PhoneMobile = phoneMobile,
ModifiedBy = modifiedBy,
Modified = modified.ToDate(),
PreferredContact = preferredContact,
FullName = fullName,
FirstName = firstName,
MiddleName = middleName,
LastName = lastName,
PhoneBusiness = phoneBusiness,
CreatedBy = createdBy,
Created = created.ToDate()
};
return(fileUploadContact);
}
