@ActionMapping(params = "myaction=updateTextArea")
  public void updateProduct(
      ActionRequest request,
      ActionResponse response,
      @ModelAttribute(displayTextCommantString) DisplayTextCommantVO textAreaVO,
      BindingResult result,
      Model model) {

    java.util.Date date1 = new java.util.Date();
    Date dt = new Date(date1.getTime());
    textAreaVO.setCommentstatus(
        TGPProcurementPropertiesUtil.getProperty(
            TGPProcurementConstants.TGP_MARKETINFO_COMMENT_STATUS_ENABLE));
    textAreaVO.setCreatedbyuserid(Long.valueOf(request.getRemoteUser()));
    textAreaVO.setModifiedbyuserid(Long.valueOf(request.getRemoteUser()));
    textAreaVO.setCommoditytype(
        TGPProcurementPropertiesUtil.getProperty(TGPProcurementConstants.TGP_MARKETINFO_POWER));
    try {
      if (!("".equalsIgnoreCase(textAreaVO.getTextcomment()))) {
        tgpMarketInfoDelegate.saveTextAreaComment(textAreaVO);
        listOfDisplayTextCommantVO =
            tgpMarketInfoDelegate.displayTextCommentforSupplier(
                dt,
                TGPProcurementPropertiesUtil.getProperty(
                    TGPProcurementConstants.TGP_MARKETINFO_POWER));
        response.setRenderParameter(
            TGPProcurementConstants.SUCCESS_MESSAGE,
            TGPProcurementConstants.TGP_TEXT_AREA_ADDED_SUCESSFULLY);
      } else {
        response.setRenderParameter(
            TGPProcurementConstants.ERROR_MESSAGE, TGPProcurementConstants.TGP_TEXT_AREA_ERROR_MSG);
      }
    } catch (TGPProcurementException e) {
      response.setRenderParameter(TGPProcurementConstants.ERROR_MESSAGE, e.getErrorCode());
    }
    listOfDisplayTextCommantVO.add(textAreaVO);
    model.addAttribute(displayTextCommantVOString, listOfDisplayTextCommantVO);
    displayTextComment(model);
  }
  @ActionMapping(params = "myaction=upLoadCSVDataforGasFile")
  public void upLoadCSVDataforGas(
      ActionRequest request,
      ActionResponse response,
      @ModelAttribute(tgpUploadCSVDataforMarketInfoString)
          UploadCSVDataforMarketInfo tgpUploadCSVDataforMarketInfo,
      BindingResult result,
      Model model) {
    try {
      if (!(""
          .equalsIgnoreCase(tgpUploadCSVDataforMarketInfo.getFileData().getFileItem().getName()))) {
        tgpUploadCSVDataforMarketInfo.setCreatedbyUserid(Long.valueOf(request.getRemoteUser()));
        tgpUploadCSVDataforMarketInfo.setCommoditytype(
            TGPProcurementPropertiesUtil.getProperty(TGPProcurementConstants.TGP_MARKETINFO_POWER));
        List<UploadCSVDataforMarketInfo> uploadCSVDataforMarketInfoSet =
            tgpMarketInfoDelegate.getUploaedDataforMarketInfo(tgpUploadCSVDataforMarketInfo);

        if (uploadCSVDataforMarketInfoSet.size() > 0) {

          response.setRenderParameter(
              TGPProcurementConstants.SUCCESS_MESSAGE,
              TGPProcurementConstants.TGP_UPLOAD_MARKET_INFO_SUCCESS_MESSAGE);
        } else {
          response.setRenderParameter(
              TGPProcurementConstants.ERROR_MESSAGE,
              TGPProcurementConstants.TGP_UPLOAD_MARKET_INFO_FILE_UPLOAD_ERROR_MESSAGE);
        }

      } else {
        response.setRenderParameter(
            TGPProcurementConstants.ERROR_MESSAGE,
            TGPProcurementConstants.TGP_MARKET_INFO_UPLOAD_ENERGY_REPORT_NO_FILE_ERROR_MSG);
      }
    } catch (TGPProcurementException tgpEx) {
      response.setRenderParameter(TGPProcurementConstants.ERROR_MESSAGE, tgpEx.getErrorCode());
      if (TGPObjectUtil.isDefined(tgpEx.getArguments())) {
        response.setRenderParameter(
            TGPProcurementConstants.MESSAGE_ARGUMENTS, tgpEx.getArguments());
      }
    } catch (Exception ex) {
      response.setRenderParameter(
          TGPProcurementConstants.ERROR_MESSAGE,
          TGPProcurementConstants.TGP_UPLOAD_MARKET_INFO_FILE_UPLOAD_ERROR_MESSAGE);
    }
  }
  @ModelAttribute(displayTextCommantVOString)
  public List<DisplayTextCommantVO> displayTextComment(Model aModel) {

    java.util.Date date1 = new java.util.Date();
    Date dt = new Date(date1.getTime());

    try {
      listOfDisplayTextCommantVO =
          tgpMarketInfoDelegate.displayTextCommentforSupplier(
              dt,
              TGPProcurementPropertiesUtil.getProperty(
                  TGPProcurementConstants.TGP_MARKETINFO_POWER));
    } catch (TGPProcurementException e) {
      tgpMessage.setErrorMessage(e.getErrorCode());
    }
    aModel.addAttribute("listOfDisplayTextCommantVO", listOfDisplayTextCommantVO);
    return listOfDisplayTextCommantVO;
  }
  @ActionMapping(params = "myaction=disableTextComment")
  public void disableTextComment(@RequestParam Long textcommentid, Model model) {

    java.util.Date date1 = new java.util.Date();
    Date dt = new Date(date1.getTime());

    try {
      listOfDisplayTextCommantVO =
          tgpMarketInfoDelegate.displayTextCommentforSupplier(
              dt,
              TGPProcurementPropertiesUtil.getProperty(
                  TGPProcurementConstants.TGP_MARKETINFO_POWER));
      DisplayTextCommantVO displayTextCommantVO =
          tgpMarketInfoDelegate.getTextVOforDisable(textcommentid, dt);
      tgpMarketInfoDelegate.disableTextComment(displayTextCommantVO);
      listOfDisplayTextCommantVO.add(displayTextCommantVO);

    } catch (TGPProcurementException e) {
      tgpMessage.setErrorMessage(e.getErrorCode());
    }

    model.addAttribute(displayTextCommantVOString, listOfDisplayTextCommantVO);
    displayTextComment(model);
  }