//public void ChangeParentHierarchy()
//{
// int count = AccountHierarchyNodes.Count();
// List<AccountHierarchyDBComparisonClass> TempAccHierarchyNode = new List<AccountHierarchyDBComparisonClass>();
// TempAccHierarchyNode = AccountHierarchyNodes;
// for (int i = 0; i < count; i++)
// {
// if (RemoveNodeUIDList.Contains(AccountHierarchyNodes[i].NodeUID))
// TempAccHierarchyNode.Remove(GetNodeByNodeUID(RemoveNodeUIDList[i].ToString()));
// }
// AccountHierarchyNodes = TempAccHierarchyNode;
//}
public void RemoveNodeList(Guid nodeUID)
{
AccountHierarchyDBComparisonClass tempNode = new AccountHierarchyDBComparisonClass();
for (int i = 0; i < AccountHierarchyNodes.Count(); i++)
{
tempNode = AccountHierarchyNodes[i];
if (AccountHierarchyNodes[i].NodeUID == nodeUID)
{
tempNode.ParentNodeUID = nodeUID;
tempNode.RootNodeUID = nodeUID;
tempNode.NodeUID = AccountHierarchyNodes[i].NodeUID;
RemoveNodeUIDList.Add(AccountHierarchyNodes[i].NodeUID);
}
if (AccountHierarchyNodes[i].ParentNodeUID == nodeUID)
{
tempNode.RootNodeUID = nodeUID;
RemoveNodeUIDList.Add(AccountHierarchyNodes[i].ParentNodeUID);
}
if ((RemoveNodeUIDList.Contains(AccountHierarchyNodes[i].ParentNodeUID)))
{
RemoveNodeUIDList.Add(AccountHierarchyNodes[i].NodeUID);
tempNode.RootNodeUID = nodeUID;
}
AccountHierarchyNodes[i] = tempNode;
//
}
}
public void SetRootNodeValues()
{
AccountHierarchyDBComparisonClass NodeDetails = new AccountHierarchyDBComparisonClass();
NodeDetails.NodeUID = parentUID[0];
NodeDetails.ParentNodeUID = parentUID[0];
NodeDetails.RootNodeUID = parentUID[0];
AccountHierarchyNodes.Add(NodeDetails);
}
public void SetNodeValue(Guid rootnode, Guid parentnode, Guid childnode, int leftNodePosition, int rightNodePosition)
{
AccountHierarchyDBComparisonClass node = new AccountHierarchyDBComparisonClass();
node.RootNodeUID = rootnode;
node.ParentNodeUID = parentnode;
node.NodeUID = childnode;
node.LeftPosition = leftNodePosition;
node.RightPosition = rightNodePosition;
}
public AccountHierarchyDBComparisonClass GetNodeByNodeUID(string nodeUID)
{
AccountHierarchyDBComparisonClass NodeByNodeUID = new AccountHierarchyDBComparisonClass();
foreach (var node in AccountHierarchyNodes)
{
if (nodeUID == node.NodeUID.ToString())
{
NodeByNodeUID = node;
break;
}
}
return(NodeByNodeUID);
}
public AccountHierarchyDBComparisonClass GetNodeByNodeUIDAndParentUID(Guid nodeUID, Guid parentUID)
{
AccountHierarchyDBComparisonClass Node = new AccountHierarchyDBComparisonClass();
foreach (var node in AccountHierarchyNodes)
{
if (node.NodeUID == nodeUID && node.ParentNodeUID == parentUID)
{
Node = node;
return(Node);
}
}
return(Node);
}
public void AssociateCustomer(Guid parentCustomerUID, Guid childCustomerUID)
{
customerRelationshipServiceSupport.CreateCustomerRelationshipModel = CustomerRelationshipServiceSteps.GetDefaultValidCustomerRelationshipServiceCreateRequest();
customerRelationshipServiceSupport.CreateCustomerRelationshipModel.ParentCustomerUID = parentCustomerUID;
customerRelationshipServiceSupport.CreateCustomerRelationshipModel.ChildCustomerUID = childCustomerUID;
customerRelationshipServiceSupport.PostValidCreateCustomerRelationshipRequestToService();
AccountHierarchyDBComparisonClass NodeDetails = new AccountHierarchyDBComparisonClass();
NodeDetails.NodeUID = childCustomerUID;
NodeDetails.ParentNodeUID = parentCustomerUID;
NodeDetails.RootNodeUID = parentUID[0];
AccountHierarchyNodes.Add(NodeDetails);
}
public static bool ValidateDB(AccountHierarchyDBComparisonClass AccountHierarchyNode)
{
List <AccountHierarchyDBComparisonClass> AccountHierarchyQueryResult = new List <AccountHierarchyDBComparisonClass>();
//WaitForDB();
bool dbResult = false;
string query = string.Empty;
int expectedResult = 1;
string nodeUID = AccountHierarchyNode.NodeUID.ToString().Replace("-", "");
string rootNodeUID = AccountHierarchyNode.RootNodeUID.ToString().Replace("-", "");
string parentNodeUID = AccountHierarchyNode.ParentNodeUID.ToString().Replace("-", "");
if (expectedResult == 1)
{
query = string.Format(DBQueries.AccountHierarchyValidation, rootNodeUID, parentNodeUID, nodeUID, AccountHierarchyNode.LeftPosition.ToString(), AccountHierarchyNode.RightPosition.ToString());
}
else
{
query = string.Format(DBQueries.AccountHierarchyCountByRootNodeUID, AccountHierarchyNode.RootNodeUID);
}
LogResult.Report(Log, "log_ForInfo", "Query: " + query);
List <string> queryResults = GetSQLResults(query);
if (queryResults.Count != 0)
{
if (queryResults[0] != "")
{
LogResult.Report(Log, "log_ForInfo", "Expected Value: " + expectedResult.ToString() + ", Actual Value: " + queryResults[0]);
dbResult = queryResults[0].Equals(expectedResult.ToString());
}
if (dbResult == false)
{
LogResult.Report(Log, "log_ForError", "DB Verification Failed");
return(false);
}
}
else
{
LogResult.Report(Log, "log_ForError", "No Rows Returned From DB");
}
return(dbResult);
}
