public List <MatchEntity> Adapt(DataTable dt)
{
List <MatchEntity> results = new List <MatchEntity>();
foreach (DataRow rw in dt.Rows)
{
MatchEntity cust = new MatchEntity();
cust = AdaptItem(rw);
results.Add(cust);
}
return(results);
}
public MatchEntity AdaptItem(DataRow rw)
{
MatchEntity result = new MatchEntity();
result.SrcRecordId = SafeHelper.GetSafestring(rw["SrcRecordId"]);
result.DnBDUNSNumber = SafeHelper.GetSafestring(rw["DnBDUNSNumber"]);
result.DnBOrganizationName = SafeHelper.GetSafestring(rw["DnBOrganizationName"]);
result.DnBTradeStyleName = SafeHelper.GetSafestring(rw["DnBTradeStyleName"]);
result.DnBSeniorPrincipalName = SafeHelper.GetSafestring(rw["DnBSeniorPrincipalName"]);
result.DnBStreetAddressLine = SafeHelper.GetSafestring(rw["DnBStreetAddressLine"]);
result.DnBPrimaryTownName = SafeHelper.GetSafestring(rw["DnBPrimaryTownName"]);
result.DnBCountryISOAlpha2Code = SafeHelper.GetSafestring(rw["DnBCountryISOAlpha2Code"]);
result.DnBPostalCode = SafeHelper.GetSafestring(rw["DnBPostalCode"]);
result.DnBPostalCodeExtensionCode = SafeHelper.GetSafestring(rw["DnBPostalCodeExtensionCode"]);
result.DnBTerritoryAbbreviatedName = SafeHelper.GetSafestring(rw["DnBTerritoryAbbreviatedName"]);
result.DnBAddressUndeliverable = SafeHelper.GetSafestring(rw["DnBAddressUndeliverable"]);
result.DnBTelephoneNumber = SafeHelper.GetSafestring(rw["DnBTelephoneNumber"]);
result.DnBOperatingStatus = SafeHelper.GetSafestring(rw["DnBOperatingStatus"]);
result.DnBFamilyTreeMemberRole = SafeHelper.GetSafestring(rw["DnBFamilyTreeMemberRole"]);
result.DnBStandaloneOrganization = SafeHelper.GetSafestring(rw["DnBStandaloneOrganization"]);
result.DnBConfidenceCode = SafeHelper.GetSafeint(rw["DnBConfidenceCode"]);
result.DnBMatchGradeText = SafeHelper.GetSafestring(rw["DnBMatchGradeText"]);
result.DnBMatchDataProfileText = SafeHelper.GetSafestring(rw["DnBMatchDataProfileText"]);
result.DnBMatchDataProfileComponentCount = SafeHelper.GetSafeint(rw["DnBMatchDataProfileComponentCount"]);
result.DnBDisplaySequence = SafeHelper.GetSafestring(rw["DnBDisplaySequence"]);
result.TTCompanyName = SafeHelper.GetSafestring(rw["TTCompanyName"]);
result.TTAddress = SafeHelper.GetSafestring(rw["TTAddress"]);
result.TTCity = SafeHelper.GetSafestring(rw["TTCity"]);
result.TTState = SafeHelper.GetSafestring(rw["TTState"]);
result.TTPhoneNbr = SafeHelper.GetSafestring(rw["TTPhoneNbr"]);
result.MGVCompanyName = SafeHelper.GetSafestring(rw["MGVCompanyName"]);
result.MGVStreetNo = SafeHelper.GetSafestring(rw["MGVStreetNo"]);
result.MGVStreetName = SafeHelper.GetSafestring(rw["MGVStreetName"]);
result.MGVCity = SafeHelper.GetSafestring(rw["MGVCity"]);
result.MGVState = SafeHelper.GetSafestring(rw["MGVState"]);
result.MGVMailingAddress = SafeHelper.GetSafestring(rw["MGVPOBox"]);
result.MGVTelephone = SafeHelper.GetSafestring(rw["MGVTelephone"]);
result.MGVZipCode = SafeHelper.GetSafestring(rw["MGVZipCode"]);
result.MGVDensity = SafeHelper.GetSafestring(rw["MGVDensity"]);
result.MGVUniqueness = SafeHelper.GetSafestring(rw["MGVUniqueness"]);
result.MGVSIC = SafeHelper.GetSafestring(rw["MGVSIC"]);
result.MDPVCompanyName = SafeHelper.GetSafestring(rw["MDPVCompanyName"]);
result.MDPVStreetNo = SafeHelper.GetSafestring(rw["MDPVStreetNo"]);
result.MDPVStreetName = SafeHelper.GetSafestring(rw["MDPVStreetName"]);
result.MDPVCity = SafeHelper.GetSafestring(rw["MDPVCity"]);
result.MDPVState = SafeHelper.GetSafestring(rw["MDPVState"]);
result.MDPVMailingAddress = SafeHelper.GetSafestring(rw["MDPVPOBox"]);
result.MDPVTelephone = SafeHelper.GetSafestring(rw["MDPVTelephone"]);
result.MDPVZipCode = SafeHelper.GetSafestring(rw["MDPVZipCode"]);
result.MDPVDensity = SafeHelper.GetSafestring(rw["MDPVDensity"]);
result.MDPVUniqueness = SafeHelper.GetSafestring(rw["MDPVUniqueness"]);
result.MDPVSIC = SafeHelper.GetSafestring(rw["MDPVSIC"]);
result.MDPVDUNS = SafeHelper.GetSafestring(rw["MDPVDUNS"]);
result.MDPVNationalID = SafeHelper.GetSafestring(rw["MDPVNationalID"]);
result.MDPVURL = SafeHelper.GetSafestring(rw["MDPVURL"]);
result.MDPPhysicalAddress = SafeHelper.GetSafestring(rw["MDPPhysicalAddress"]);
result.MDPPhone = SafeHelper.GetSafestring(rw["MDPTelephone"]);
result.MDPCompanyName = SafeHelper.GetSafestring(rw["MDPCompanyName"]);
result.MDPMailingAddress = SafeHelper.GetSafestring(rw["MDPPOBox"]);
result.MGCompanyName = SafeHelper.GetSafestring(rw["MGCompanyName"]);
result.MGStreetNo = SafeHelper.GetSafestring(rw["MGStreetNo"]);
result.MGStreetName = SafeHelper.GetSafestring(rw["MGStreetName"]);
result.MGCity = SafeHelper.GetSafestring(rw["MGCity"]);
result.MGState = SafeHelper.GetSafestring(rw["MGState"]);
result.MGTelephone = SafeHelper.GetSafestring(rw["MGTelephone"]);
result.MGZipCode = SafeHelper.GetSafestring(rw["MGZipCode"]);
result.MGDensity = SafeHelper.GetSafestring(rw["MGDensity"]);
result.MGUniqueness = SafeHelper.GetSafestring(rw["MGUniqueness"]);
result.MGSIC = SafeHelper.GetSafestring(rw["MGSIC"]);
result.MGMailingAddress = SafeHelper.GetSafestring(rw["MGPOBox"]);
result.IsSelected = SafeHelper.GetSafebool(rw["IsSelected"]);
result.MatchDataCriteriaText = SafeHelper.GetSafestring(rw["MatchDataCriteriaText"]);
if (rw.Table.Columns["InputId"] != null)
{
result.InputId = SafeHelper.GetSafeint(rw["InputId"]);
}
if (rw.Table.Columns["DnBMailingAddress"] != null)
{
result.DnBMailingAddress = SafeHelper.GetSafestring(rw["DnBMailingAddress"]);
}
if (rw.Table.Columns["DnBMailingAddressUndeliverable"] != null)
{
result.DnBMailingAddressUndeliverable = SafeHelper.GetSafebool(rw["DnBMailingAddressUndeliverable"]);
}
result.DnBMarketabilityIndicator = rw["DnBMarketabilityIndicator"] != DBNull.Value ? Convert.ToBoolean(rw["DnBMarketabilityIndicator"]) : new bool?();
if (rw.Table.Columns["DnBTelephoneNumberUnreachableIndicator"] != null)
{
result.DnBTelephoneNumberUnreachableIndicator = SafeHelper.GetSafebool(rw["DnBTelephoneNumberUnreachableIndicator"]);
}
if (rw.Table.Columns["ScoreCompany"] != null)
{
result.ScoreCompany = SafeHelper.GetSafestring(rw["ScoreCompany"]);
}
if (rw.Table.Columns["RegistrationNumbers"] != null)
{
result.RegistrationNumbers = SafeHelper.GetSafestring(rw["RegistrationNumbers"]);
}
if (rw.Table.Columns["WebsiteURL"] != null)
{
result.WebsiteURL = SafeHelper.GetSafestring(rw["WebsiteURL"]);
}
return(result);
}
