1 package org.campware.cream.modules.actions; 2 3 42 43 import java.util.Date ; 44 import org.apache.velocity.context.Context; 45 46 import org.apache.turbine.util.RunData; 47 import org.apache.torque.util.Criteria; 48 import org.apache.torque.util.Transaction; 49 import java.sql.Connection ; 50 51 import org.campware.cream.om.PrintSubscription; 52 import org.campware.cream.om.PrintSubscriptionPeer; 53 54 58 public class PrintSubscriptionSQL extends CreamAction 59 { 60 protected void initScreen() 61 { 62 setModuleType(DOCUMENT); 63 setModuleName("PRINT_SUBSCRIPTION"); 64 } 65 75 public void doInsert(RunData data, Context context) 76 throws Exception 77 { 78 PrintSubscription entry = new PrintSubscription(); 79 data.getParameters().setProperties(entry); 80 81 entry.setPrintSubsCode(getTempCode()); 82 83 entry.setIssuedDate(parseDate(data.getParameters().getString("issueddate"))); 84 entry.setClosedDate(parseDate(data.getParameters().getString("closeddate"))); 85 entry.setStartDate(parseDate(data.getParameters().getString("startdate"))); 86 entry.setEndDate(parseDate(data.getParameters().getString("enddate"))); 87 entry.setCreatedBy(data.getUser().getName()); 88 entry.setCreated(new Date ()); 89 entry.setModifiedBy(data.getUser().getName()); 90 entry.setModified(new Date ()); 91 92 Connection conn = Transaction.begin(PrintSubscriptionPeer.DATABASE_NAME); 93 boolean success = false; 94 try { 95 entry.save(conn); 96 entry.setPrintSubsCode(getRowCode("PS", entry.getPrintSubsId())); 97 entry.save(conn); 98 Transaction.commit(conn); 99 success = true; 100 101 } finally { 102 if (!success) Transaction.safeRollback(conn); 103 } 104 } 105 106 114 public void doUpdate(RunData data, Context context) 115 throws Exception 116 { 117 PrintSubscription entry = new PrintSubscription(); 118 data.getParameters().setProperties(entry); 119 120 entry.setIssuedDate(parseDate(data.getParameters().getString("issueddate"))); 121 entry.setClosedDate(parseDate(data.getParameters().getString("closeddate"))); 122 entry.setStartDate(parseDate(data.getParameters().getString("startdate"))); 123 entry.setEndDate(parseDate(data.getParameters().getString("enddate"))); 124 entry.setCreated(parseDateTime(data.getParameters().getString("created"))); 125 entry.setModifiedBy(data.getUser().getName()); 126 entry.setModified(new Date ()); 127 128 entry.setModified(true); 129 entry.setNew(false); 130 entry.save(); 131 132 } 133 134 138 public void doDelete(RunData data, Context context) 139 throws Exception 140 { 141 Criteria criteria = new Criteria(); 142 criteria.add(PrintSubscriptionPeer.PRINT_SUBS_ID, data.getParameters().getInt("printsubsid")); 143 PrintSubscriptionPeer.doDelete(criteria); 144 } 145 146 150 public void doDeleteselected(RunData data, Context context) 151 throws Exception 152 { 153 int[] delIds= data.getParameters().getInts("rowid"); 154 Criteria criteria = new Criteria(); 155 criteria.addIn(PrintSubscriptionPeer.PRINT_SUBS_ID, delIds); 156 PrintSubscriptionPeer.doDelete(criteria); 157 } 158 159 160 } 161 | Popular Tags |