public String addSubCategory() {

    CatList = new ListDao().catListByName(subcatname);

    // set foregin key status from category to subcategory table

    // subcat.setSubCatId(CatList.get(0).getCatId());
    category.setCatId(CatList.get(0).getCatId());
    subcat.setCategory(category);

    // set restof all column in subcategory table
    subcat.setSubCatName(subcat.getSubCatName());
    subcat.setSubCatDesc(subcat.getSubCatDesc());

    boolean status = new AddDao().addSubCategory(subcat);

    if (status) {
      FacesContext.getCurrentInstance()
          .addMessage(
              null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Data Saved Successfully", ""));
    } else {
      FacesContext.getCurrentInstance()
          .addMessage(
              null,
              new FacesMessage(FacesMessage.SEVERITY_WARN, "Data not Saved Successfully", ""));
    }
    return null;
  }