public int addTimeSlip(int userId, TimeSlipVO tsvo)
{
int timeSlipId = 0;
CVDal dl = new CVDal(dataSource);
try
{
if(!CVUtility.isModuleVisible("Time Slips",userId, this.dataSource))
throw new AuthorizationFailedException("Time Slips - addTimeSlip");
dl.setSql("projecttimeslip.addtimeslip");
dl.setInt(1,tsvo.getProjectID());
dl.setInt(2,tsvo.getTaskID());
dl.setString(3,tsvo.getDescription());
dl.setDate(4,tsvo.getDate());
dl.setTime(5,tsvo.getStart());
dl.setTime(6,tsvo.getEnd());
dl.setFloat(7,tsvo.getBreakTime());
dl.setFloat(8,userId);
dl.setFloat(9,tsvo.getHours());
dl.setInt(10, tsvo.getTicketID());
dl.setInt(11, tsvo.getTimesheetID());
dl.executeUpdate();
timeSlipId = dl.getAutoGeneratedKey();
InitialContext ic = CVUtility.getInitialContext();
AuthorizationLocalHome authorizationHome = (AuthorizationLocalHome)ic.lookup("local/Authorization");
AuthorizationLocal authorizationLocal = authorizationHome.create();
authorizationLocal.setDataSource(dataSource);
authorizationLocal.saveCurrentDefaultPermission("Time Slips", timeSlipId, userId);
}
catch(Exception e)
{
System.out.println("[Exception][TimeSlipEJB.addTimeSlip] Exception Thrown: "+e);
e.printStackTrace();
} finally {
dl.destroy();
dl = null;
}
return timeSlipId;
}