private static MatchedDJListObject MatchCompanyAndPerson(IList <DJListRow> personData, IList <DJListRow> entityData)
{
var PersonList = new List <DJListRow>();
var EntityList = new List <DJListRow>();
var allUnmatched = new List <string>();
foreach (var personRow in personData)
{
var regNumberField = personRow.Row[0];
if (!string.IsNullOrEmpty(regNumberField))
{
var regNumberFieldEntity = entityData.FirstOrDefault(d => d.Row[0].Trim() == regNumberField.Trim());
PersonList.Add(personRow);
var test1 = regNumberFieldEntity;
var test = test1;
if (test == null)
{
allUnmatched.Add(regNumberField);
}
EntityList.Add(regNumberFieldEntity);
}
}
var matchedList = new MatchedDJListObject(PersonList, EntityList);
return(matchedList);
}
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);
}
