/**
* Method is used to save presenter material details in db
*
* @param session
* @param pCode presenter code
* @param op (INSERT/UPDATE)
* @param HttpServletRequest requestParameters
* @param pCode
* @param byteSession
* @param field_name
*/
public void storeMaterialToDB(
Session session,
int pCode,
String op,
HttpServletRequest requestParameters,
String byteSession,
String file_name,
String field_name) {
try {
if (op.equals("UPDATE")) {
Query deleteQ =
session.createQuery(
"delete PresenterMaterial where presenterCode =:presenterCode and fieldName =:fieldName");
deleteQ.setParameter("presenterCode", pCode);
deleteQ.setParameter("fieldName", field_name);
deleteQ.executeUpdate();
}
PresenterMaterial preMat = null;
byte[] bytearray = (byte[]) requestParameters.getSession().getAttribute(byteSession);
if (pCode > 0) {
preMat = new PresenterMaterial();
preMat.setPresenterCode(pCode);
preMat.setMaterialName(file_name);
preMat.setFieldName(field_name);
preMat.setMaterial(bytearray);
session.save(preMat);
}
log.log(Level.INFO, "---PresenterMaintenance Upload Material Done---");
} catch (Exception e) {
e.printStackTrace();
log.log(Level.SEVERE, e.getMessage());
}
}
