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