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));
}
