Update Query
@Modifying
@Transactional
@Query("update CreateCustomer u set u.paid=:paid where u.id=:id")
public void UpdatePaidInCreateCustomer(@Param("paid") float paid,@Param("id") long id) ;
------------------------------------------------------------------------------
@Modifying
@Transactional
@Query("update CreateCustomer u set u.cgst=:cgst, u.sgst=:sgst,u.igst=:igst, u.otherCharges=:otherCharges, u.totalAmount=:totalAmount,u.paid=:paid,u.discount=:discount,u.remark=:remark,u.pmtMode=:pmtMode,u.recipt=:recipt where u.CusRefid = :CusRefid")
public void updateTaxCGST(@Param("cgst") float cgst , @Param("sgst") float sgst , @Param("igst") float igst ,@Param("otherCharges") float otherCharges , @Param("totalAmount") float totalAmount,@Param("paid") float paid,@Param("discount") float discount,@Param("remark") String remark,
@Param("pmtMode") String pmtMode,@Param("recipt") String recipt,@Param("CusRefid") long CusRefid);
Delete Query (delete all same type item once)
@Transactional
@Modifying
@Query("delete from CreateBill2 b where b.cusrefid in(:integers)")
public void deleteBill2(List<Long> integers);
Comments
Post a Comment