public async Task <int> CreatepocketMoney(Data.pocketMoney pocketMoney) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); //var db = new ISQLite().Connition; int res = _sqLiteConnection.Insert(pocketMoney); var x = 0; return(res); }
public async Task <int> DleatepocketMoney(Data.pocketMoney pocketMoney) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); //var db = new ISQLite().Connition; var res = _sqLiteConnection.Delete(pocketMoney); if (res != null) { return(res); } else { return(0); } var x = 5; }
public async Task <int> UpdatepocketMoney(Data.pocketMoney pocketMoney) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); var existingpocketMoney = _sqLiteConnection.Query <Data.pocketMoney>("select * from pocketMoney where pocketMoney_id = ?", pocketMoney.pocketMoney_id).FirstOrDefault(); if (existingpocketMoney != null) { var res = _sqLiteConnection.Update(pocketMoney); return(res); } else { var res = 0; return(res); } }