X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;fp=src%2Fhabeas%2FUtility.java;h=4a4042c727c3c36b5900727031f9f975c1c12e94;hp=f36623bcee83613b61034af516e98c97063ac0db;hb=466a2393accd0d6d2df5f68d53488c667d5369de;hpb=fdaede7966b1cfd8a38dcc51fa8ec60420b842b4

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index f36623b..4a4042c 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -240,6 +240,38 @@ public class Utility {
         }
         
     }
+
+    static boolean updateNoticeDispatchDetails(int selid, boolean notice_sent, 
+            java.util.Date sent_date, String rpad_reference, 
+            boolean notice_delivered, java.util.Date delivery_date) {
+        try {
+            Connection conn = DriverManager.getConnection(JDBC + connectionURL);
+            PreparedStatement st = conn.prepareStatement("UPDATE legalnotices"
+                    + " SET NoticeSent=?, SentDate=?, RPADReference=?,"
+                    + " NoticeDelivered=?, DeliveryDate=? WHERE id=?;");
+            
+            st.setBoolean(1, notice_sent);
+            st.setDate(2,  toSqlDate(sent_date));
+            st.setString(3, rpad_reference);
+            st.setBoolean(4, notice_delivered);
+            st.setDate(5, toSqlDate(delivery_date));
+            st.setInt (6, selid);
+            st.execute();
+            conn.close();
+            return true;
+        } catch (SQLException ex) {
+            Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+            return false;
+        }
+        
+    }
+
+    private static Date toSqlDate(java.util.Date date) {
+            if (date == null)
+                return null;
+            Date sqldate = new Date (date.getTime()/1000);
+            return sqldate;
+    }
     public Utility () {
         
     }