X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;h=d9a231bbcc491ffb6577513e32ee612c5fb2aa08;hp=bc999323b4f6c6ad179b9f808f8c67b38de2c30e;hb=02fd056bbcee3117ee1fad182f823159d2a25cff;hpb=ebe8c5c1a1ff2d63aca4d844887f39d763272eac

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index bc99932..d9a231b 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -482,6 +482,25 @@ public class Utility {
             return null;
         }
     }
+
+    static boolean updateNoticeBillStatus(int client_id, String from_status, 
+            String to_status) {
+        try {
+            Connection conn = DriverManager.getConnection(JDBC + connectionURL);
+            PreparedStatement st = conn.prepareStatement("UPDATE legalnotices"
+                    + " SET BillStatus=? WHERE BillStatus=? AND ClientId=?;");
+            st.setString (1, to_status);
+            st.setString (2, from_status);
+            st.setInt (3, client_id);
+            st.execute();
+            conn.close();
+            return true;
+        } catch (SQLException ex) {
+            Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+            return false;
+        }
+        
+    }
     public Utility () {
         
     }