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