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.InboxEvent; 52 import org.campware.cream.om.InboxEventPeer; 53 54 58 public class InboxEventSQL extends CreamAction 59 { 60 protected void initScreen() 61 { 62 setModuleType(DOCUMENT); 63 setModuleName("INBOX"); 64 } 65 75 public void doInsert(RunData data, Context context) 76 throws Exception 77 { 78 InboxEvent entry = new InboxEvent(); 79 data.getParameters().setProperties(entry); 80 81 String myCode=data.getParameters().getString("inboxeventcode"); 82 83 entry.setInboxEventCode(getTempCode()); 84 85 entry.setIssuedDate(parseDate(data.getParameters().getString("issueddate"))); 86 entry.setClosedDate(parseDate(data.getParameters().getString("closeddate"))); 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(InboxEventPeer.DATABASE_NAME); 93 boolean success = false; 94 try { 95 entry.save(conn); 96 entry.setInboxEventCode(getRowCode("IE", entry.getInboxEventId())); 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 118 InboxEvent entry = new InboxEvent(); 119 data.getParameters().setProperties(entry); 120 121 entry.setIssuedDate(parseDate(data.getParameters().getString("issueddate"))); 122 entry.setClosedDate(parseDate(data.getParameters().getString("closeddate"))); 123 entry.setCreated(parseDateTime(data.getParameters().getString("created"))); 124 entry.setModifiedBy(data.getUser().getName()); 125 entry.setModified(new Date ()); 126 127 entry.setSentTime(parseDate(data.getParameters().getString("senttime"))); 128 129 entry.setModified(true); 130 entry.setNew(false); 131 entry.save(); 132 } 133 134 138 public void doDelete(RunData data, Context context) 139 throws Exception 140 { 141 Criteria criteria = new Criteria(); 142 criteria.add(InboxEventPeer.INBOX_EVENT_ID, data.getParameters().getInt("inboxeventid")); 143 InboxEventPeer.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(InboxEventPeer.INBOX_EVENT_ID, delIds); 156 InboxEventPeer.doDelete(criteria); 157 } 158 159 } 160 | Popular Tags |