private static void SerializePersons(List <FieldNameInputValuePairObject> serializedObject, IList <DJListRow> djRows) { Encoding enc = new UTF8Encoding(true, true); foreach (var value in djRows) { if (value.Row[6].Any(char.IsDigit)) { if (!personKeys.Contains(value.Row[6].Trim()) && value.Row[5] != "N/A" && !string.IsNullOrEmpty(value.Row[5])) { personKeys.Add(value.Row[6].Trim()); var pairList = new List <FieldNameInputValuePair>(); var rowVal5 = value.Row[5].Count() > 32 ? value.Row[5].Substring(0, 32) : value.Row[5]; var rowVal1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(0, 32) : value.Row[1]; var rowVal0 = value.Row[0].Count() > 32 ? value.Row[0].Substring(0, 32) : value.Row[0]; var rowVal6 = value.Row[6].Count() > 16 ? value.Row[6].Substring(0, 16) : value.Row[6]; var rowValExt5 = value.Row[5].Count() > 32 ? value.Row[5].Substring(32, value.Row[5].Count() - 32) : ""; var rowValExt1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(32, value.Row[1].Count() - 32) : ""; var rowValExt0 = value.Row[0].Count() > 32 ? value.Row[0].Substring(32, value.Row[0].Count() - 32) : ""; var rowValExt6 = value.Row[6].Count() > 16 ? value.Row[6].Substring(16, value.Row[6].Count() - 16) : ""; var rowVal7 = value.Row[7].Count() > 8 ? value.Row[7].Substring(0, 8) : value.Row[7]; var rowValExt7 = value.Row[7].Count() > 8 ? value.Row[7].Substring(8, value.Row[7].Count() - 8) : ""; var rowVal8 = CountryCodes.GetCountryCode(value.Row[8]); var rowValExt8 = ""; var rowVal10 = value.Row[10].Count() > 1 ? value.Row[10].Substring(0, 1) : value.Row[10]; var rowValExt10 = value.Row[10].Count() > 1 ? value.Row[10].Substring(1, value.Row[10].Count() - 1) : ""; var rowVal11 = value.Row[11].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Count() > 8 ? value.Row[11].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Substring(0, 8) : value.Row[11].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty); var dateRowVal11 = rowVal11.Count() < 8?"" : rowVal11.Substring(4, 4) + rowVal11.Substring(2, 2) + rowVal11.Substring(0, 2); var rowValExt11 = dateRowVal11.Count() > 8 ? dateRowVal11.Substring(8, dateRowVal11.Count() - 8) : ""; var pair1 = new FieldNameInputValuePair("LASTNAME_COMPANYNAME", enc.GetString(enc.GetBytes(rowVal5)), enc.GetString(enc.GetBytes(rowValExt5))); var pair2 = new FieldNameInputValuePair("FIRST_NAME", enc.GetString(enc.GetBytes(rowVal1)), enc.GetString(enc.GetBytes(rowValExt1))); var pair3 = new FieldNameInputValuePair("CUSTNO", rowVal6, rowVal6); var pair4 = new FieldNameInputValuePair("CUSTCONTACT", "", ""); var pair5 = new FieldNameInputValuePair("H_COUNTRY", rowVal8, rowValExt8); var pair6 = new FieldNameInputValuePair("BIRTHDATE", dateRowVal11, rowValExt11); var pair7 = new FieldNameInputValuePair("GENDER", enc.GetString(enc.GetBytes(rowVal10)), enc.GetString(enc.GetBytes(rowValExt10))); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(pair4); pairList.Add(pair5); pairList.Add(pair6); pairList.Add(pair7); pairList.Add(new FieldNameInputValuePair("INSTITUTE", enc.GetString(enc.GetBytes("GE00")), enc.GetString(enc.GetBytes("GE00")))); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = rowVal6; serializedObject.Add(serializedPairObject); } } } }