[Ils-source] r1269 - trunk/src/com/resolutions/ils/data

[scribe at crosswire.org]

Author: scribe
Date: 2014-10-08 16:37:52 -0700 (Wed, 08 Oct 2014)
New Revision: 1269

Modified:
   trunk/src/com/resolutions/ils/data/Resource.java
Log:
committed Adams patch to add getResource by resource title to
Resource class and to update setCompany to use DataObject.setCompany


Modified: trunk/src/com/resolutions/ils/data/Resource.java
===================================================================
--- trunk/src/com/resolutions/ils/data/Resource.java	2014-09-30 00:24:04 UTC (rev 1268)
+++ trunk/src/com/resolutions/ils/data/Resource.java	2014-10-08 23:37:52 UTC (rev 1269)
@@ -12,6 +12,7 @@
     static String LOOKUPALL = "SELECT * FROM RESOURCE WHERE COMPANYID={COMPANYID} ORDER BY RESOURCPOSTDATE DESC";
     static String LOOKUPALLCURRENT = "SELECT * FROM RESOURCE WHERE COMPANYID={COMPANYID} AND RESOURCEXP>{RESOURCEXP} ORDER BY RESOURCPOSTDATE DESC";
     static String LOOKUP = "SELECT * FROM RESOURCE WHERE RESOURCID={RESOURCID} AND COMPANYID={COMPANYID}";
+    static String LOOKUPBYTITLE = "SELECT * FROM RESOURCE WHERE RESOURCTITLE={RESOURCTITLE} AND COMPANYID={COMPANYID}";
     static String DELETE = "DELETE FROM RESOURCE WHERE RESOURCID={RESOURCID} AND COMPANYID={COMPANYID}";
 
     public Resource() {
@@ -20,22 +21,30 @@
     protected DataObject createDataObject() { return new Resource(); }
 
     static public Resource getResource(ILSSession session, int resourceID) {
-    Resource query = new Resource();
+        Resource query = new Resource();
         query.setResourceID(resourceID);
-        query.setValue("COMPANYID", new Integer(session.getCompanyID()));
+        query.setCompanyID(session.getCompanyID());
         Vector rows = query.getDataSet(LOOKUP);
         return (rows.size() > 0) ? (Resource)rows.get(0) : null;
     }
 
+    static public Resource getResource(ILSSession session, String resourceTitle){
+        Resource query = new Resource();
+        query.setResourceTitle(resourceTitle);
+        query.setCompanyID(session.getCompanyID());
+        Vector rows = query.getDataSet(LOOKUPBYTITLE);
+        return (rows.size() > 0) ? (Resource)rows.get(0) : null;
+    }
+
     static public Vector getAllResources(ILSSession session) {
     Resource query = new Resource();
-        query.setValue("COMPANYID", new Integer(session.getCompanyID()));
+        query.setCompanyID(session.getCompanyID());
         return query.getDataSet(LOOKUPALL);
     }
 
     static public Vector getAllCurrentResources(ILSSession session) {
     Resource query = new Resource();
-        query.setValue("COMPANYID", new Integer(session.getCompanyID()));
+        query.setCompanyID(session.getCompanyID());
         query.setResourceExpiration(new Date());
         return query.getDataSet(LOOKUPALLCURRENT);
     }
@@ -43,7 +52,7 @@
     static public int deleteResource(ILSSession session, int resourceID) {
         Resource query = new Resource();
         query.setResourceID(resourceID);
-        query.setValue("COMPANYID", new Integer(session.getCompanyID()));
+        query.setCompanyID(session.getCompanyID());
         return query.executeSQL(DELETE);
     }