Cascading Select with Web API + EF core UPDATED / (mikesdotnetting improved) RSS

• • Reply
  wavemaster

  Contributor

  2619 Points

  2753 Posts

  Cascading Select with Web API + EF core UPDATED / (mikesdotnetting improved)

  Mar 13, 2021 10:54 PM|wavemaster|LINK

  Hitting some obstacles modifying this to use Web API + EF Core 5.X

  My variation is Locations and Clients

  <div class="row" style="padding-top:10px">
          <div class="col-md-4">
              <select bind="SelectedLocationId">
                  <option value=@(0)></option>
                  @foreach (var location in Locations)
                  {
                      <option value="@location.OwnerId">@location.Location</option>
                  }
              </select>
              
              
              @if (SelectedLocationId != default)
              {
                  var clients = Locations.Single(c => c.OwnerId == SelectedLocationId).Clients;
  
                  <select bind="SelectedClientId">
                      <option value=@(0)></option>
                      @foreach (var client in Clients)
                      {
                          <option value="@client">@client.Cname</option>
                      }
                  </select>
  
                  //var selectedClient = clients.FirstOrDefault(x => x.ClientId == SelectedClientId);
                  //if (selectedClient != null)
                  {
                      //<div>
                        //  Title: @selectedClient.Cname<br />                        
                      //</div>
                  }
              }
  
              
          </div>        
              
      </div>    
  }
  
  
  @code {
      List<LocationGrid> Locations = new List<LocationGrid>();
      List<ClientGrid> Clients = new List<ClientGrid>();
  
      int _selectedLocationId;
      int SelectedLocationId
      {
          get => _selectedLocationId;
          set
          {
              _selectedLocationId = value;
              SelectedClientId = default;
          }
      }
      int SelectedClientId { get; set; }
      string OwnerId { get; set; }
      string locationName { get; set; }
      string clientName { get; set; }
      string baseUrl = "https://localhost:5001";
      
      protected override async Task OnInitializedAsync()
      {    
          var httpClient = _clientFactory.CreateClient("ServerAPI");
          httpClient.DefaultRequestHeaders.Add("Accept", "application/json");
              
          Locations = await httpClient.GetFromJsonAsync<List<LocationGrid>>($"{baseUrl}/api/Location/ByProviderSelect/22");
      }

  To make progress I have modified my code and have Clients loaded with the total population of Clients for all Locations

  ok, some progress currently my breakpoint here is being hit

  SelectedLocationId has the value from the selected Location

  I have modified the code what is not working with:

  var clients = Clients.Where(c => c.OwnerLocationId == SelectedLocationId);

  This works!

  Now, unfortunately I am loading all Clients and then making a selection rather than just loading the one client I need, but right now I am not looking for performance, just stuff that works. 

  If anyone want to be generous and explain how that would work.....

  Click on "Mark as Answer" if my answers help you along.