// mechanism to get default values for dropdowns public async Task <ObservableCollection <AppValues> > GetDefaultValuesAsync(string Category, string parentKey = "") { // grab data from database DbAccessor db = new DbAccessor(); var Source = UtilHelper.ConvertToObservable <AppValues>(db.GetTableItemsObservable <AppValues>().Where(x => x.CatType == Category).ToList()); // filter list if we just need root parent values. if (!string.IsNullOrEmpty(parentKey)) { Source = UtilHelper.ConvertToObservable <AppValues>(Source.Where(x => x.ParentKey == parentKey).ToList()); } // grab the current culture here and set the value field var cult = this.GetCurrentCulture(); if (cult == "ar") { foreach (var item in Source) { item.Value = item.Arabic; } } else { foreach (var item in Source) { item.Value = item.English; } } return(Source); }
private async void GetDropdownValues() { // pull from db then pre-populate ApiServiceIndividual api = new ApiServiceIndividual(); _MainList = await api.GetDefaultValuesAsync("Complaints"); // set root list here Cat1List = UtilHelper.ConvertToObservable <AppValues>(_MainList.Where(x => x.ParentKey == "0").ToList()); }
public async Task <ObservableCollection <ComplaintRaised> > GetComplaintsAsync() { // grab data from database DbAccessor db = new DbAccessor(); var Source = db.GetTableItemsObservable <ComplaintRaised>(); // order by date asc so we see latest first var newsource = UtilHelper.ConvertToObservable <ComplaintRaised>(Source.OrderByDescending(x => x.CreateDateCast).ToList()); return(newsource); }