public static GenericDocumentJournalLineDao store(
BlgDataSourceConfig blgDsFactory, GenericDocumentJournalLineDao ObjToStore) {
if (ObjToStore == null) {
return null;
}
try (Connection connection = blgDsFactory.getConnection()) {
String query =
"INSERT INTO "
+ GenericDocumentJournalLineDao.TABLE_NAME
+ " VALUES(→guid,→guid_doc_hdr,→guid_doc_line,→guid_glcode,→descr,→remarks,→amount_debit,→amount_credit,→comp_guid,→branch_txn_guid,→store_guid,→profit_center_guid,→segment_guid,→project_guid,→dimension_guid,→position_id,→date_txn,→log_json::jsonb,→status,→reference_num,→tx_type)";
NamedParameterStatement stmt = new NamedParameterStatement(connection, query);
stmt.setString("guid", ObjToStore.getGuid());
stmt.setString("guid_doc_hdr", ObjToStore.getGuid_doc_hdr());
stmt.setString("guid_doc_line", ObjToStore.getGuid_doc_line());
stmt.setString("guid_glcode", ObjToStore.getGuid_glcode());
stmt.setString("descr", ObjToStore.getDescr());
stmt.setString("remarks", ObjToStore.getRemarks());
stmt.setBigDecimal("amount_debit", ObjToStore.getAmount_debit());
stmt.setBigDecimal("amount_credit", ObjToStore.getAmount_credit());
stmt.setString("comp_guid", ObjToStore.getComp_guid());
stmt.setString("branch_txn_guid", ObjToStore.getBranch_txn_guid());
stmt.setString("store_guid", ObjToStore.getStore_guid());
stmt.setString("profit_center_guid", ObjToStore.getProfit_center_guid());
stmt.setString("segment_guid", ObjToStore.getSegment_guid());
stmt.setString("project_guid", ObjToStore.getProject_guid());
stmt.setString("dimension_guid", ObjToStore.getDimension_guid());
stmt.setString("position_id", ObjToStore.getPosition_id());
stmt.setTimestamp("date_txn", ObjToStore.getDate_txn());
stmt.setString("log_json", ObjToStore.getLog_json());
stmt.setString("status", ObjToStore.getStatus());
stmt.setString("reference_num", ObjToStore.getReference_num());
stmt.setString("tx_type", ObjToStore.getTx_type());
int i = stmt.executeUpdate();
if (i != 1) {
throw new RuntimeException("Insert failed");
}
} catch (Exception e) {
throw new RuntimeException(e);
}
return getObject(blgDsFactory, ObjToStore.getGuid());
}
