public async Task <int> Createdebt(Data.debt O_debt) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); //var db = new ISQLite().Connition; int res = _sqLiteConnection.Insert(O_debt); var x = 0; return(res); }
public async Task <int> Dleatedebt(Data.debt O_debt) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); //var db = new ISQLite().Connition; var res = _sqLiteConnection.Delete(O_debt); if (res != null) { return(res); } else { return(0); } var x = 5; }
public async Task <int> Updatedebt(Data.debt O_debt) { _sqLiteConnection = await DependencyService.Get <ISQLite>().GetConnection(); var existingdebt = _sqLiteConnection.Query <Data.debt>("select * from debt where debt_id = ? and DebtCondition =?", O_debt.debt_id, O_debt.DebtCondition).FirstOrDefault(); if (existingdebt != null) { var res = _sqLiteConnection.Update(O_debt); return(res); } else { var res = 0; return(res); } }