public async Task<int> CreateDeal(Data.deal deals) { _sqLiteConnection = await DependencyService.Get<ISQLite>().GetConnection(); var res = _sqLiteConnection.Insert(deals); if(res != 1) { return 0; } else { return res; } }
public async Task<int> Update_Deal(Data.deal o_deal) { _sqLiteConnection = await DependencyService.Get<ISQLite>().GetConnection(); var existingDeal = _sqLiteConnection.Query<Data.deal>("select * from deal where deal_id = ?", o_deal.deal_id).FirstOrDefault(); if (existingDeal != null) { var res = _sqLiteConnection.Update(o_deal); return res; } else { var res = 0; return res; } }