How do I get the List from firebase sorted?

Question

The items display but I want them to be in ClubId order but can't get it to sort. What do I need to fix?

Model/Club.cs

 public class Club
        { 
            public int ClubId { get; set; }
            public string DateTime { get; set; }
            public string Heading { get; set; }
            public string Location { get; set; }
            public string Image { get; set; }
            public string Height { get; set; }
            public string WebLink { get; set; }
        }

Helper/FirebaseHelper.cs

public async Task<List<Club>> GetAllClub()
        {
            return (await firebase
              .Child("Club")
              .OrderByKey()
              .OnceAsync<Club>()).Select(item => new Club
              {
                  Heading = item.Object.Heading,
                  DateTime = item.Object.DateTime,
                  Location = item.Object.Location,
                  Image = item.Object.Image,
                  Height = item.Object.Height,
                  WebLink = item.Object.WebLink,
                  ClubId = item.Object.ClubId
              }).ToList();
        }

ClubPage.xaml.cs

protected async override void OnAppearing()
        {
            base.OnAppearing();
            var allClub = await firebaseHelper.GetAllClub();
            lstClub.ItemsSource = allClub;
        }

Answer 1

Try this. OrderByDescending with BalId

 
public async Task<List<Club>> GetAllClub()
        {
            return (await firebase
              .Child("Club")
              .OnceAsync<Club>()).Select(item => new Club
              {
                  Heading = item.Object.Heading,
                  DateTime = item.Object.DateTime,
                  Location = item.Object.Location,
                  Image = item.Object.Image,
                  Height = item.Object.Height,
                  WebLink = item.Object.WebLink,
                  ClubId = item.Object.ClubId
             }).OrderByDescending(x => x.ClubId).ToList();
        }

Answer 2

Hello,

How can I get the Maximum ClubId?

You have ordered by descending ClubId with GetAllClub method. you can get the maximum ClubId at the last record in List<Club>. You can refer to the following code.

List<Club> clubs   = await  GetAllClub();
var MaxClubId =  clubs.Last<Club>().ClubId;

Best Regards,

Leon Lu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.