public async Task <List <FormItem> > GetForms(string userId) { await Initialize(); //the following is an incremental sync and is called when we DONT pull to refresh. await SyncForm(); return(await formTable.OrderByDescending(c => c.EnteredDateUTC).ToListAsync()); }
public async Task <ICollection <T> > ReadAllItemsOrderedAsync <TKey>(Expression <Func <T, TKey> > orderbyExpression = null, bool descending = false) { if (descending) { return(await table.OrderByDescending(orderbyExpression).ToListAsync()); } else { return(await table.OrderBy(orderbyExpression).ToListAsync()); } }
/// <summary> /// 取得請假記錄清單 /// </summary> /// <param name="是否要先進行同步工作"></param> /// <returns></returns> public async Task <ObservableCollection <LeaveRecord> > GetAsync(bool 是否要先進行同步工作 = false) { ErrorMessage = ""; try { if (是否要先進行同步工作) { // 將本地端的異動與伺服器端的紀錄進行同步處理 ErrorMessage = await SyncAsync(); } // 取得所有的請假記錄集合 IEnumerable <LeaveRecord> items = await 請假紀錄Table .OrderByDescending(x => x.請假日期) .ToEnumerableAsync(); return(new ObservableCollection <LeaveRecord>(items)); } catch (MobileServiceInvalidOperationException msioe) { ErrorMessage = string.Format(@"Invalid sync operation: {0}", msioe.Message); } catch (Exception e) { ErrorMessage = string.Format(@"Sync error: {0}", e.Message); } return(null); }
private async Task RefreshOrderList() { MobileServiceInvalidOperationException exception = null; try { orders = await ordersTable .OrderByDescending(x => x.Id) .ToCollectionAsync(); customers = await customersTable.CreateQuery().ToCollectionAsync(); ListItems.ItemsSource = orders; TextCustomer.ItemsSource = customers; } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } }
public async Task <IEnumerable <FormTable5> > GetForms() { await Initialize(); await SyncForm(); return(await formTable.OrderByDescending(c => c.EnteredDateUTC).ToEnumerableAsync()); }
public async Task <IEnumerable <PollResponse> > GetResponsesForPollAsync(string questionId) { await InitializeAsync(); return(await responseTable .OrderByDescending(r => r.UpdatedAt) .Take(100).ToEnumerableAsync()); }
public async Task <List <Transaction> > GetAllTransactions(string cardid, bool all = false) { if (string.IsNullOrEmpty(cardid)) { return(new List <Transaction>()); } await SyncAsync(); IMobileServiceTableQuery <Transaction> query = all ? _transTable.OrderByDescending(t => t.TransDate) .ThenByDescending(t => t.InternalDifference) .Where(t => t.CardID == cardid) : _transTable.OrderByDescending(t => t.TransDate) .ThenByDescending(t => t.InternalDifference) .Where(t => t.CardID == cardid && t.Description != "Card Load" && !t.Description.StartsWith("Card Transfer")); return(await query.ToListAsync()); }
public async Task <IEnumerable <Item> > GetItemsAsync(bool forceRefresh = false) { await InitializeAsync(); if (forceRefresh) { await PullLatestAsync(); } return(await itemsTable.OrderByDescending(c => c.CreatedAt).ToEnumerableAsync()); }
/*addition*/ /// <summary> /// Get the latest news from the database /// </summary> /// <param name="action"></param> /// <returns></returns> public async Task <ObservableCollection <News> > GetLatestNews(int num = 0) { try { #if OFFLINE_SYNC_ENABLED if (syncItems) { await this.SyncAsync(); } #endif IEnumerable <News> items = await NewsTable.OrderByDescending(news => news.NewsDate).Take(num).ToEnumerableAsync(); return(new ObservableCollection <News>(items)); } catch (MobileServiceInvalidOperationException msioe) { Debug.WriteLine(@"Invalid sync operation: {0}", msioe.Message); } catch (Exception e) { Debug.WriteLine(@"Sync error: {0}", e.Message); } return(null); }
public IMobileServiceTableQuery <T> OrderByDescending <TKey>(Expression <Func <T, TKey> > keySelector) { return(_syncTable.OrderByDescending(keySelector)); }