public async Task <ContactModel> GetDefaultBeneficiaryAsync()
{
var Beneficiaries = await OfflineStorageRepo.QueryTableAsync <ContactModel>(SelectDefaultBeneficiary);
if (Beneficiaries != null && Beneficiaries.Count > 0)
{
return(Beneficiaries[0]);
}
return(null);
}
private async Task <UserModel> GetUserRecordAsync()
{
var list = await OfflineStorageRepo.QueryTableAsync <UserModel>(
SelectTopUser);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
public async Task RemoveUserRecordAsync(UserModel model)
{
var list = await OfflineStorageRepo.QueryTableAsync <UserModel>(
SelectTopUser);
foreach (var allModel in list)
{
await OfflineStorageRepo.DeleteRecordAsync(allModel);
}
_MasterRepo.InitializeDataSource();
}
public async Task <ContactModel> GetContactWithIDAsync(ContactModel model)
{
ID = model.Id.ToString();
SelectWithIDQuery = $"SELECT * FROM ContactModel where UserID = {ID}";
var list = await OfflineStorageRepo.QueryTableAsync <ContactModel>(
SelectWithIDQuery);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
public async Task SaveContactToLocalStorageAsync(ContactModel model)
{
var returnedModel = await GetContactWithIDAsync(model);
if (returnedModel != null)
{
model.Id = returnedModel.Id;
var affected = await OfflineStorageRepo.UpdateRecordAsync(model);
var whatIsAff = affected;
}
else
{
await OfflineStorageRepo.InsertRecordAsync(model);
}
}
public async Task SetUserRecordAsync(UserModel model)
{
var localUser = await GetUserRecordAsync();
if (localUser != null)
{
model.Id = localUser.Id;
var affected = await OfflineStorageRepo.UpdateRecordAsync(model);
var whatIsAff = affected;
}
else
{
await OfflineStorageRepo.InsertRecordAsync(model);
}
_MasterRepo.DataSource.User = await GetUserModelFromOfflineAsync();
}
public async Task <List <ContactModel> > GetTrustedSourcesAsync()
{
return(await OfflineStorageRepo.QueryTableAsync <ContactModel>(SelectTrustedSources));
}
