Recursive inserting values in tables #11064

5 Answer(s)

• 

  0

  ismcagdas created 2 years ago

  Support Team

  Hi @uabel

  1. Is it possible to share the app service you are having this problem
  2. Could you also share your Abp NuGet package version ?

  Thanks,

  Save Cancel
• 

  0

  uabel created 2 years ago

  It is a very long function with several calls.

  ` private void HieararchyWalk(List<QMP3.CoreData.CoreData> hierarchy, List

          if (hierarchy != null)
          {
              foreach (var item in hierarchy)
              {
                  newParentId = item.ParentId;   
                  Logger.Debug("Id: " + item.Id + " Nummer: " + item.Nr);
                  List<CoreDataVersion> versions = new List<CoreDataVersion>();   
                  if (!allLanguages)
                  {
                      var element = _coreDataVersionRepository.GetAll().Where(r => r.CoreDataId == item.Id && r.GlobalLanguageId == defaultLanguage.Id)
                              .OrderByDescending(r => r.State == State.Freigegeben).ThenByDescending(s => s.Revision).FirstOrDefault();
                      if (element != null)
                      {
                          versions.Add(element);
                      }
                  }
                  else
                  {
                      foreach (var lang in _globalLanguageRepository.GetLanguages())
                      {
                          var element = _coreDataVersionRepository.GetAll().Where(r => r.CoreDataId == item.Id && r.GlobalLanguageId == lang.Id)
                              .OrderByDescending(r => r.State == State.Freigegeben).ThenByDescending(s => s.Revision).FirstOrDefault();
                          if (element != null)
                          {
                              versions.Add(element);
                          }
                      }
                  }
                  
                  item.CoreDataVersions = versions;
                  //item.CoreDataVersions = _coreDataVersionRepository.GetAll().Where(r => r.CoreDataId == item.Id).ToList();
                  //.Where(r => r.CoreDataId == item.Id)
                  //.OrderBy(s => s.State == State.Freigegeben)
                  //.ThenByDescending(s => s.Revision).ToList();
                  bool versionsToCopy = false;
                  
                  foreach (var version in item.CoreDataVersions)
                  {
                      var newElement = new CopiedElement();
                      counter++;
                      newParentId = CopyElement(version, item, newParentId, versionsToCopy);
                      newElement.Label = String.Concat(item.Nr, " ", version.Label);
                      newElement.Sprache = version.GlobalLanguage.Label;
                      copiedElements.Add(newElement);
                      versionsToCopy = true;
                  }
                  foreach (var ele in item.Children)
                  {
                      ele.ParentId = newParentId;
                  }
                  CoreDataIds.Add(newParentId.Value);
                  HieararchyWalk(item.Children, CoreDataIds, allLanguages);
              }
          }
      }
      public GetServiceOutput CopyStructure(GetServiceInput input)
      {
          List<QMP3.CoreData.CoreData> hierarchy = new List<QMP3.CoreData.CoreData>();
          var test = _coreDataRepository.GetAll().ToList();
          hierarchy = test
                          .Where(c => c.Id == input.CoreDataId)
                          .Select(c => new QMP3.CoreData.CoreData()
                          {
                              Id = c.Id,
                              Nr = c.Nr,
                              DataType = c.DataType,
                              Color = c.Color,
                              MenuId = c.MenuId,
                              Publish = c.Publish,
                              ParentId = c.ParentId,
                              CoreDataVersions = c.CoreDataVersions,
                              Children = GetChildren(test, c.Id)
                          })
                          .ToList();
          var coreDataIdsToDelete = new List<int>();
          defaultLanguage = _globalLanguageRepository.GetDefaultLanguage();
          HieararchyWalk(hierarchy, coreDataIdsToDelete, input.AllLanguages);
          return new GetServiceOutput
          {
              CopiedElements = copiedElements
          };
          //return null;
      }
      `
      
      
  

  Save Cancel
• 

  0

  ismcagdas created 2 years ago

  Support Team

  Thanks,

  Could you also share your ABP NuGet package version ?

  Save Cancel
• 

  0

  uabel created 2 years ago

  I'm using one of the oldest versions 0.7.5.0

  Save Cancel
• 

  0

  ismcagdas created 2 years ago

  Support Team

  Hi,

  I wasn't expecting sucn an old version :). Is it possible to share your project via email with [email protected] with reproduction steps ?

  We can try to optimize your code or offer you anoter solution.

  Save Cancel