private void SerializeTemp(List <FieldNameInputValuePairObject> serializedObject, IList <DJListRow> djRows) { foreach (var value in djRows) { if (value.Row[0].Any(char.IsDigit)) { if ((!permKeys.Contains(value.Row[0].Trim())) && value.Row[5] != "N/A" && !string.IsNullOrEmpty(value.Row[5])) { permKeys.Add(value.Row[0].Trim()); var pairList = new List <FieldNameInputValuePair>(); var idOrPassport = string.IsNullOrEmpty(value.Row[4]) ? value.Row[5] : value.Row[4]; var rowVal0 = value.Row[0].Count() > 16 ? value.Row[0].Substring(0, 16) : value.Row[0]; var rowVal4 = idOrPassport.Count() > 16 ? idOrPassport.Substring(0, 16) : idOrPassport; var rowVal1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(0, 32) : value.Row[1]; var rowVal2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(0, 32) : value.Row[2]; var country = string.IsNullOrEmpty(value.Row[6])?"RSA": value.Row[6]; var rowVal6 = country.Count() > 3 ? country.Substring(0, 3) : country; var rowValExt4 = rowVal4.Count() > 16 ? rowVal4.Substring(16, rowVal4.Count() - 16) : ""; var rowValExt1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(32, value.Row[1].Count() - 32) : ""; var rowValExt2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(32, value.Row[2].Count() - 32) : ""; var rowValExt6 = country.Count() > 3 ? country.Substring(3, country.Count() - 3) : ""; var rowVal3 = value.Row[3].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Count() > 8 ? value.Row[3].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Substring(0, 8) : value.Row[3].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty); var rowValExt3 = rowVal3.Count() > 8 ? rowVal3.Substring(8, rowVal3.Count() - 8) : ""; var pair1 = new FieldNameInputValuePair("LASTNAME_COMPANYNAME", rowVal2, rowValExt2); var pair2 = new FieldNameInputValuePair("FIRST_NAME", rowVal1, rowValExt1); var pair3 = new FieldNameInputValuePair("CUSTNO", rowVal0, rowVal0);//EMPLNO var pair4 = new FieldNameInputValuePair("PASS_NO", rowVal4, rowVal4); var pair5 = new FieldNameInputValuePair("BIRTH_COUNTRY", rowVal6, rowValExt6); var pair6 = new FieldNameInputValuePair("BIRTHDATE", rowVal3, rowValExt3); var pair7 = new FieldNameInputValuePair("EMPLNO", rowVal0, rowVal0);//TOWN 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", "GGE0", "GGE0")); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = rowVal0; serializedObject.Add(serializedPairObject); } } } }
private static List <FieldNameInputValuePairObject> CreateRelationshipFile(MatchedDJListObject matchedResults) { var cnt = 0; var pairingObjects = new List <FieldNameInputValuePairObject>(); foreach (var resultPair in matchedResults.PersonList) { var per = matchedResults.PersonList[cnt].Row[0].Trim(); var perb = matchedResults.EntityList[cnt]; var per2 = matchedResults.EntityList[cnt].Row[0].Trim(); var val = relationshipKeys.Contains(matchedResults.PersonList[cnt].Row[6].Trim()); var val2 = personKeys.Contains(matchedResults.PersonList[cnt].Row[6].Trim()); var val3 = entityKeys.Contains(matchedResults.EntityList[cnt].Row[0].Trim()); if (!relationshipKeys.Contains(matchedResults.PersonList[cnt].Row[6].Trim()) && personKeys.Contains(matchedResults.PersonList[cnt].Row[6].Trim()) && entityKeys.Contains(matchedResults.EntityList[cnt].Row[0].Trim())) { if (matchedResults.PersonList[cnt].Row[6].Any(char.IsDigit) && matchedResults.EntityList[cnt].Row[0].Any(char.IsDigit)) { relationshipKeys.Add(matchedResults.PersonList[cnt].Row[6].Trim()); var pairList = new List <FieldNameInputValuePair>(); var pair0 = new FieldNameInputValuePair("INSTITUTE", "GE00", ""); var pair1 = new FieldNameInputValuePair("CUSTNO", matchedResults.PersonList[cnt].Row[6], ""); var pair2 = new FieldNameInputValuePair("REL_CUSTNO", matchedResults.EntityList[cnt].Row[0], ""); var pair3 = new FieldNameInputValuePair("REL_TYPE", "" + "DI", ""); var pair4 = new FieldNameInputValuePair("REL_SHARE", "0.0", ""); var pair5 = new FieldNameInputValuePair("REL_FLAG1", "", ""); var pair6 = new FieldNameInputValuePair("REL_FLAG2", "", ""); var pair7 = new FieldNameInputValuePair("REL_FLAG3", "", ""); var pair8 = new FieldNameInputValuePair("REL_COMMENT", "", ""); var pair9 = new FieldNameInputValuePair("PROCESSFLAG", "", ""); pairList.Add(pair0); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(pair4); pairList.Add(pair5); pairList.Add(pair6); pairList.Add(pair7); pairList.Add(pair8); pairList.Add(pair9); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = matchedResults.PersonList[cnt].Row[6]; pairingObjects.Add(serializedPairObject); } } cnt++; } return(pairingObjects); }
private static List <FieldNameInputValuePairObject> CreateRelationshipList(IList <DJListRow> personList, IList <DJListRow> entityList) { var pairingObjects = new List <FieldNameInputValuePairObject>(); Encoding enc = new UTF8Encoding(true, true); foreach (var person in personList) { var matchCIF = entityList.FirstOrDefault(f => f.Row[1] == person.Row[1]) == null ? "" : entityList.FirstOrDefault(f => f.Row[1] == person.Row[1]).Row[2]; if (!relationshipKeys.Contains(person.Row[4].Trim()) && personKeys.Contains(person.Row[4].Trim()) && entityKeys.Contains(matchCIF.Trim())) { relationshipKeys.Add(person.Row[4].Trim()); var pairList = new List <FieldNameInputValuePair>(); var pair0 = new FieldNameInputValuePair("INSTITUTE", "LBFN", ""); var pair1 = new FieldNameInputValuePair("CUSTNO", person.Row[4], ""); var pair2 = new FieldNameInputValuePair("REL_CUSTNO", "" + matchCIF, ""); var pair3 = new FieldNameInputValuePair("REL_TYPE", "" + "DI", ""); var pair4 = new FieldNameInputValuePair("REL_SHARE", "0.0", ""); var pair5 = new FieldNameInputValuePair("REL_FLAG1", "", ""); var pair6 = new FieldNameInputValuePair("REL_FLAG2", "", ""); var pair7 = new FieldNameInputValuePair("REL_FLAG3", "", ""); var pair8 = new FieldNameInputValuePair("REL_COMMENT", "", ""); var pair9 = new FieldNameInputValuePair("PROCESSFLAG", "", ""); pairList.Add(pair0); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(pair4); pairList.Add(pair5); pairList.Add(pair6); pairList.Add(pair7); pairList.Add(pair8); pairList.Add(pair9); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = enc.GetString(enc.GetBytes(person.Row[4].ToUpper())); pairingObjects.Add(serializedPairObject); } } return(pairingObjects.OrderBy(s => s.CustNo).ToList()); }
private static void SerializeEntities(List <FieldNameInputValuePairObject> serializedObject, IList <DJListRow> djRows) { Encoding enc = new UTF8Encoding(true, true); foreach (var value in djRows) { if (value.Row[0].Any(char.IsDigit)) { if (!entityKeys.Contains(value.Row[0].Trim()) && value.Row[1] != "N/A" && !string.IsNullOrEmpty(value.Row[1])) { entityKeys.Add(value.Row[0].Trim()); var pairList = new List <FieldNameInputValuePair>(); var rowVal1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(0, 32) : value.Row[1]; var rowVal0 = value.Row[0].Count() > 16 ? value.Row[0].Substring(0, 16) : value.Row[0]; var rowVal5 = value.Row[5].Count() > 32 ? value.Row[5].Substring(0, 32) : value.Row[5]; 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() > 16 ? value.Row[0].Substring(16, value.Row[0].Count() - 32) : ""; 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 pair1 = new FieldNameInputValuePair("LASTNAME_COMPANYNAME", rowVal1, rowValExt1); var pair2 = new FieldNameInputValuePair("FIRST_NAME", "", ""); var pair3 = new FieldNameInputValuePair("CUSTNO", rowVal0, rowVal0); var pair4 = new FieldNameInputValuePair("CUSTCONTACT", "", ""); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(pair4); pairList.Add(new FieldNameInputValuePair("INSTITUTE", enc.GetString(enc.GetBytes("GE00")), enc.GetString(enc.GetBytes("GE00")))); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = rowVal0; serializedObject.Add(serializedPairObject); } } } }
public IList <IList <FieldNameInputValuePair> > Serialize(IList <DJListRow> inputObject) { var serializedObject = new List <IList <FieldNameInputValuePair> >(); foreach (var value in inputObject) { var pairList = new List <FieldNameInputValuePair>(); var columnCount = value.ColumnCount; var sheetName = value.ExcelSheetName; for (int i = 1; i <= columnCount; i++) { var key = sheetName + "_" + i; var fieldName = reader.GetData(key); var pair = new FieldNameInputValuePair(fieldName, value.Row[i - 1]); pairList.Add(pair); } serializedObject.Add(pairList); } return(serializedObject); }
private static void SerializePerson(IList <DJListRow> PersonList, List <FieldNameInputValuePairObject> serializedObject) { Encoding enc = new UTF8Encoding(true, true); foreach (var value in PersonList) { if (value.Row[4].Any(char.IsDigit)) { if (!personKeys.Contains(value.Row[4].Trim()) && value.Row[2] != "N/A" && !string.IsNullOrEmpty(value.Row[2])) { personKeys.Add(value.Row[4].Trim()); var pairList = new List <FieldNameInputValuePair>(); var columnCount = value.ColumnCount; var sheetName = value.ExcelSheetName; var rowVal4 = value.Row[4].Count() > 16 ? value.Row[4].Substring(0, 16) : value.Row[4]; var rowVal1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(0, 32) : value.Row[1]; var rowVal2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(0, 32) : value.Row[2]; var rowVal3 = value.Row[3].Count() > 32 ? value.Row[3].Substring(0, 32) : value.Row[3]; var rowValExt4 = value.Row[4].Count() > 16 ? value.Row[4].Substring(16, value.Row[4].Count() - 16) : ""; var rowValExt1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(32, value.Row[1].Count() - 32) : ""; var rowValExt2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(32, value.Row[2].Count() - 32) : ""; var rowValExt3 = value.Row[3].Count() > 32 ? value.Row[3].Substring(32, value.Row[3].Count() - 32) : ""; var pair1 = new FieldNameInputValuePair("LASTNAME_COMPANYNAME", enc.GetString(enc.GetBytes(rowVal2)), enc.GetString(enc.GetBytes(rowValExt2))); var pair2 = new FieldNameInputValuePair("FIRST_NAME", enc.GetString(enc.GetBytes(rowVal3)), enc.GetString(enc.GetBytes(rowValExt3))); var pair3 = new FieldNameInputValuePair("CUSTNO", rowVal4, rowVal4); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(new FieldNameInputValuePair("INSTITUTE", enc.GetString(enc.GetBytes("LBFN")), enc.GetString(enc.GetBytes("LBFN")))); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = enc.GetString(enc.GetBytes(rowVal4.ToUpper())); serializedObject.Add(serializedPairObject); } } } }
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); } } } }
private void SerializePerm(List <FieldNameInputValuePairObject> serializedObject, IList <DJListRow> djRows) { foreach (var value in djRows) { if (value.Row[0].Any(char.IsDigit)) { if (!permKeys.Contains(value.Row[0].Trim()) && value.Row[2] != "N/A" && !string.IsNullOrEmpty(value.Row[2])) { permKeys.Add(value.Row[0].Trim()); var pairList = new List <FieldNameInputValuePair>(); var rowVal0 = value.Row[0].Count() > 16 ? value.Row[0].Substring(0, 16) : value.Row[0]; var rowVal2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(0, 32) : value.Row[2]; var rowVal1 = value.Row[1].Count() > 32 ? value.Row[1].Substring(0, 32) : value.Row[1]; var rowVal3 = value.Row[3].Count() > 16 ? value.Row[3].Substring(0, 16) : value.Row[3]; var rowValExt2 = value.Row[2].Count() > 32 ? value.Row[2].Substring(32, value.Row[2].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 rowValExt3 = value.Row[3].Count() > 16 ? value.Row[3].Substring(16, value.Row[3].Count() - 16) : ""; var rowVal7 = value.Row[7].Count() > 7 ? value.Row[7].Substring(0, 7) : value.Row[7]; var rowValExt7 = value.Row[7].Count() > 7 ? value.Row[7].Substring(7, value.Row[7].Count() - 7) : ""; var rowVal6 = value.Row[6].Count() > 28 ? value.Row[6].Substring(0, 28) : value.Row[6]; var rowValExt6 = value.Row[6].Count() > 28 ? value.Row[6].Substring(28, value.Row[6].Count() - 28) : ""; var rowVal5 = value.Row[5].Count() > 1 ? value.Row[5].Substring(0, 1) : value.Row[5]; var rowValExt5 = value.Row[5].Count() > 1 ? value.Row[5].Substring(1, value.Row[5].Count() - 1) : ""; var rowVal4 = value.Row[4].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Count() > 8 ? value.Row[4].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty).Substring(0, 8) : value.Row[4].Replace(".", string.Empty).Replace(",", string.Empty).Replace("\\", string.Empty).Replace("/", string.Empty); var rowValExt4 = rowVal4.Count() > 8 ? rowVal4.Substring(8, rowVal4.Count() - 8) : ""; var pair1 = new FieldNameInputValuePair("LASTNAME_COMPANYNAME", rowVal2, rowValExt2); var pair2 = new FieldNameInputValuePair("FIRST_NAME", rowVal1, rowValExt1); var pair3 = new FieldNameInputValuePair("CUSTNO", rowVal0, rowVal0); var pair4 = new FieldNameInputValuePair("PASS_NO", rowVal3, rowVal3); var pair5 = new FieldNameInputValuePair("ZIP", rowVal7, rowValExt7); var pair6 = new FieldNameInputValuePair("BIRTHDATE", rowVal4, rowValExt4); var pair7 = new FieldNameInputValuePair("GENDER", rowVal5, rowValExt5); var pair8 = new FieldNameInputValuePair("EMPLNO", rowVal0, rowVal0); var pairTown = new FieldNameInputValuePair("TOWN", rowVal6, rowValExt6); pairList.Add(pair1); pairList.Add(pair2); pairList.Add(pair3); pairList.Add(pair4); pairList.Add(pair5); pairList.Add(pair6); pairList.Add(pair7); pairList.Add(pair8); pairList.Add(pairTown); pairList.Add(new FieldNameInputValuePair("INSTITUTE", "GGE0", "GGE0")); var serializedPairObject = new FieldNameInputValuePairObject(); serializedPairObject.FieldNameInputValuePairList = pairList; serializedPairObject.CustNo = rowVal0; serializedObject.Add(serializedPairObject); } } } }