private void updateCatagory() { final Dao<CatagoryModel, Integer> catagoryDoa; try { catagoryDoa = getHelper().getCatagoryDao(); UpdateBuilder<CatagoryModel, Integer> updateBuilder = catagoryDoa.updateBuilder(); updateBuilder.updateColumnValue("catagoryName", catagoryEditText.getText().toString()); updateBuilder .where() .eq("categoryId", Integer.valueOf(catagoryModel.getCategoryId())) .and() .eq("catagoryName", catagoryModel.getCatagoryName()); ; updateBuilder.update(); Snackbar snackbar = Snackbar.make(view, "Catagory updated sucessfully!!", Snackbar.LENGTH_LONG); snackbar.show(); } catch (SQLException e) { e.printStackTrace(); } }
private void deleteCatagory() { final Dao<CatagoryModel, Integer> catagoryDoa; try { catagoryDoa = getHelper().getCatagoryDao(); DeleteBuilder<CatagoryModel, Integer> deleteBuilder = catagoryDoa.deleteBuilder(); deleteBuilder .where() .eq("categoryId", Integer.valueOf(catagoryModel.getCategoryId())) .and() .eq("catagoryName", catagoryModel.getCatagoryName()); deleteBuilder.delete(); Snackbar snackbar = Snackbar.make(view, "Catagory deleted sucessfully!!", Snackbar.LENGTH_LONG); snackbar.show(); } catch (SQLException e) { e.printStackTrace(); } }
private void setData() { catagoryEditText.setText(catagoryModel.getCatagoryName()); }