@Override
 public Malfunction getMalfunctionById(Integer malfunctionId) {
   LOGGER.info("DAO:Get malfunction by id=" + malfunctionId.toString());
   HashMap<String, Object> hashMap = new HashMap<String, Object>();
   hashMap.put(MALFUNCTION_ID.getValue(), malfunctionId);
   return namedParameterJdbcTemplate.queryForObject(getMalfunction, hashMap, malfunctionMapper);
 }
 @Override
 public void deleteMalfunction(Integer malfunctionId) {
   LOGGER.info("DAO:Delete malfunction by id=" + malfunctionId.toString());
   HashMap<String, Object> hashMap = new HashMap<String, Object>();
   hashMap.put(MALFUNCTION_ID.getValue(), malfunctionId);
   namedParameterJdbcTemplate.update(deleteMalfunctionById, hashMap);
 }
 private MapSqlParameterSource getParametersMap(Malfunction malfunction) {
   MapSqlParameterSource parameterSource = new MapSqlParameterSource();
   parameterSource.addValue(MALFUNCTION_ID.getValue(), malfunction.getMalfunctionId());
   parameterSource.addValue(NAME.getValue(), malfunction.getName());
   parameterSource.addValue(AUTO.getValue(), malfunction.getAuto());
   parameterSource.addValue(DESCRIPTION.getValue(), malfunction.getDescription());
   parameterSource.addValue(APPLICATION_ID.getValue(), malfunction.getApplicationId());
   return parameterSource;
 }
 @Override
 public void updateMalfunction(Malfunction malfunction) {
   LOGGER.info("DAO:Update malfunction by id=" + malfunction.getMalfunctionId().toString());
   HashMap<String, Object> hashMap = new HashMap<String, Object>();
   hashMap.put(MALFUNCTION_ID.getValue(), malfunction.getMalfunctionId());
   hashMap.put(NAME.getValue(), malfunction.getName());
   hashMap.put(AUTO.getValue(), malfunction.getAuto());
   hashMap.put(DESCRIPTION.getValue(), malfunction.getDescription());
   namedParameterJdbcTemplate.update(updateMalfunctionById, hashMap);
 }
 @Override
 public void addCostsToMalfunction(
     Integer malfunctionId, Integer costRepair, Integer costService, Integer additionalExpenses) {
   LOGGER.info("DAO:Add all costs for malfunction with id=" + malfunctionId.toString());
   HashMap<String, Object> hashMap = new HashMap<String, Object>();
   hashMap.put(MALFUNCTION_ID.getValue(), malfunctionId);
   hashMap.put(COST_REPAIR.getValue(), costRepair);
   hashMap.put(COST_SERVICE.getValue(), costService);
   hashMap.put(ADDITIONAL_EXPENSES.getValue(), additionalExpenses);
   namedParameterJdbcTemplate.update(addCosts, hashMap);
 }