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