private async Task <ObservableCollection <Transaction> > GetTransactions() { try { if (Contact != null) { DateTime startDate = new DateTime(DateTime.Now.Year, 1, 1), endDate = new DateTime(DateTime.Now.Year, 12, 31); var criteria = new SQLControllerListCriteriaModel { Filter = new List <SQLControllerListFilterField>() { new SQLControllerListFilterField() { FieldName = "ContactId", ValueLBound = Contact.Id.ToString() }, new SQLControllerListFilterField() { FieldName = "Created", ValueLBound = startDate.ToString(), ValueUBound = endDate.ToString(), DateKind = SQLControllerListFilterField.DateKindEnum.Localized }, }, Sort = new List <SQLControllerListSortField>() { new SQLControllerListSortField() { FieldName = "Created", Descending = true } } }; return(new ObservableCollection <Transaction>(await TransactionController.LocalData.List(criteria))); } } catch (Exception e) { UserDialogs.Instance.Alert($"Unable to get transactions, {e.Message}", "Transactions"); } return(null); }
public async Task <List <EquipmentModel> > ListWithChildrenAsync(SQLControllerListCriteriaModel criteria) { try { List <EquipmentModel> list = await LocalData.List(criteria).ConfigureAwait(false); foreach (var model in list) { await SQLiteControllerBase .DatabaseAsync .GetChildrenAsync <EquipmentModel>(model, true); } return(list); } catch (Exception e) { throw e; } }
public async Task <List <CustomerModel> > ListWithChildrenAsync(SQLControllerListCriteriaModel criteria) { try { List <CustomerModel> list = await LocalData.List(criteria).ConfigureAwait(false); foreach (var model in list) { SQLiteNetExtensions .Extensions .ReadOperations .GetWithChildren <List <CustomerModel> >(SQLiteControllerBase.DatabaseAsync.GetConnection(), model, true); } return(list); } catch (Exception) { throw; } }
public async Task <List <T> > List(SQLControllerListCriteriaModel criteria) { try { if (criteria == null) { return(null); } criteria.View = typeof(T).Name; var query = SQLQuery.BuildListQuery <T>(criteria); return(await DatabaseAsync.QueryAsync <T>(query)); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Exception at List criteria: {0} {1}", typeof(T).Name, e); throw; } }
public async Task <List <SchedulerModel> > ListWithChildrenAsync(SQLControllerListCriteriaModel criteria = null) { try { List <SchedulerModel> list = criteria == null ? await LocalData.List().ConfigureAwait(false) : await LocalData.List(criteria).ConfigureAwait(false); foreach (var model in list) { await SQLiteControllerBase .DatabaseAsync .GetChildrenAsync(model, true) .ConfigureAwait(false); } return(list); } catch (Exception) { throw; } }