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