public void saveJobDetails() {
// TODO Auto-generated method stub
if (job == null) {
commonUTIL.showAlertMessage("Select Template");
return;
}
int rowCount = searchPanel.table.getRowCount();
Vector<UserJobsDetails> jobdets = new Vector<UserJobsDetails>();
for (int i = 0; i < searchPanel.getFilterBeanData().size(); i++) {
FilterBean filterBean = searchPanel.getFilterBeanData().get(i);
UserJobsDetails ud = new UserJobsDetails();
ud.setJobId(job.getId());
ud.setColumnName(filterBean.getColumnName());
ud.setCriteria(filterBean.getSearchCriteria());
ud.setValues(filterBean.getColumnValues());
ud.setFilterValues(filterBean.getIdSelected());
ud.setAnd_or(filterBean.getAnd_or());
ud.setRowid(i);
jobdets.add(ud);
}
try {
if (!reportPanel.getColumnSQL().equalsIgnoreCase(job.getSql())) {
job.setSql(reportPanel.getColumnSQL());
reportPanel.getRemoteTask().updateJob(job);
}
reportPanel.getRemoteTask().saveUserJobsDetails(jobdets, job.getId());
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void loadTemplates(int userID) {
Vector templates = null;
try {
templates = (Vector) reportPanel.getRemoteTask().getUserJob(userID);
for (int i = 0; i < templates.size(); i++) {
UserJob userjobs = (UserJob) templates.get(i);
tablemodel.insertRow(i, new Object[] {userjobs.getId(), userjobs.getTreeNodeName()});
}
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void setUserJob(UserJob job2) {
job = job2;
Vector<UserJobsDetails> jobdetails;
try {
jobdetails = (Vector) reportPanel.getRemoteTask().getDetailsJob(job.getId());
loadJobs(jobdetails);
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
public void saveTemplate(String templateName, int userID) {
if (!commonUTIL.isEmpty(templateName)) {
job = new UserJob();
job.setId(0);
job.setTabid(0);
job.setUserID(user.getId());
job.setType(getReportType().toUpperCase());
job.setTreeNodeName(templateName);
setTemplateFrame(templateName);
try {
job = (UserJob) reportPanel.getRemoteTask().saveUserJob(job);
tablemodel.insertRow(
tablemodel.getRowCount(), new Object[] {job.getId(), job.getTreeNodeName()});
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}