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);
}
}
}
}
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);
}
}
}
}
