Example #1
0
        public List <CompanyEntity> Adapt(DataTable dt)
        {
            List <CompanyEntity> results = new List <CompanyEntity>();

            foreach (DataRow rw in dt.Rows)
            {
                CompanyEntity cust = new CompanyEntity();
                cust = AdaptItem(rw);
                results.Add(cust);
            }
            return(results);
        }
Example #2
0
        public CompanyEntity AdaptItem(DataRow rw)
        {
            CompanyEntity result = new CompanyEntity();

            result.SrcRecordId          = SafeHelper.GetSafestring(rw["SrcRecordId"]);
            result.CompanyName          = SafeHelper.GetSafestring(rw["CompanyName"]);
            result.Address              = SafeHelper.GetSafestring(rw["Address"]);
            result.City                 = SafeHelper.GetSafestring(rw["City"]);
            result.State                = SafeHelper.GetSafestring(rw["State"]);
            result.PostalCode           = SafeHelper.GetSafestring(rw["PostalCode"]);
            result.CountryISOAlpha2Code = SafeHelper.GetSafestring(rw["CountryISOAlpha2Code"]);
            result.PhoneNbr             = SafeHelper.GetSafestring(rw["PhoneNbr"]);
            result.EncryptedSrcRecordId = StringCipher.Encrypt(result.SrcRecordId, General.passPhrase).Replace("+", "***");

            if (rw.Table.Columns["ErrorCode"] != null)
            {
                result.ErrorCode = SafeHelper.GetSafestring(rw["ErrorCode"]);
            }

            if (rw.Table.Columns["ErrorDescription"] != null)
            {
                result.ErrorDescription = SafeHelper.GetSafestring(rw["ErrorDescription"]);
            }

            if (rw.Table.Columns["StewardshipNotes"] != null)
            {
                result.StewardshipNotes = SafeHelper.GetSafestring(rw["StewardshipNotes"]);
            }

            if (rw.Table.Columns["RejectAllMatches"] != null)
            {
                result.RejectAllMatches = SafeHelper.GetSafebool(rw["RejectAllMatches"]);
            }

            result.RejectCompany = false;
            result.IsEdited      = false;
            if (rw.Table.Columns["DUNSNumber"] != null)
            {
                result.DUNSNumber = SafeHelper.GetSafestring(rw["DUNSNumber"]);
            }

            if (rw.Table.Columns["CEOName"] != null)
            {
                result.CEOName = SafeHelper.GetSafestring(rw["CEOName"]);
            }

            if (rw.Table.Columns["Website"] != null)
            {
                result.Website = SafeHelper.GetSafestring(rw["Website"]);
            }

            if (rw.Table.Columns["AltCompanyName"] != null)
            {
                result.AltCompanyName = SafeHelper.GetSafestring(rw["AltCompanyName"]);
            }

            if (rw.Table.Columns["AltAddress"] != null)
            {
                result.AltAddress = SafeHelper.GetSafestring(rw["AltAddress"]);
            }

            if (rw.Table.Columns["AltCity"] != null)
            {
                result.AltCity = SafeHelper.GetSafestring(rw["AltCity"]);
            }

            if (rw.Table.Columns["AltState"] != null)
            {
                result.AltState = SafeHelper.GetSafestring(rw["AltState"]);
            }

            if (rw.Table.Columns["AltPostalCode"] != null)
            {
                result.AltPostalCode = SafeHelper.GetSafestring(rw["AltPostalCode"]);
            }

            if (rw.Table.Columns["AltCountry"] != null)
            {
                result.AltCountry = SafeHelper.GetSafestring(rw["AltCountry"]);
            }

            if (rw.Table.Columns["Email"] != null)
            {
                result.Email = SafeHelper.GetSafestring(rw["Email"]);
            }

            if (rw.Table.Columns["RegistrationNbr"] != null)
            {
                result.RegistrationNbr = SafeHelper.GetSafestring(rw["RegistrationNbr"]);
            }

            if (rw.Table.Columns["RegistrationType"] != null)
            {
                result.RegistrationType = SafeHelper.GetSafestring(rw["RegistrationType"]);
            }

            if (rw.Table.Columns["Tags"] != null)
            {
                result.Tags = SafeHelper.GetSafestring(rw["Tags"]);
            }

            if (rw.Table.Columns["InputId"] != null)
            {
                result.InputId = SafeHelper.GetSafeint(rw["InputId"]);
            }

            if (rw.Table.Columns["inLanguage"] != null)
            {
                result.inLanguage = SafeHelper.GetSafestring(rw["inLanguage"]);
            }

            if (rw.Table.Columns["Address1"] != null)
            {
                result.Address1 = SafeHelper.GetSafestring(rw["Address1"]);
            }

            if (rw.Table.Columns["AltAddress1"] != null)
            {
                result.AltAddress1 = SafeHelper.GetSafestring(rw["AltAddress1"]);
            }

            if (rw.Table.Columns["FullAddress"] != null)
            {
                result.FullAddress = SafeHelper.GetSafestring(rw["FullAddress"]);
            }

            return(result);
        }