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