/*
 * Copyright 2007 The Kuali Foundation
 *
 * Licensed under the Educational Community License, Version 1.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.opensource.org/licenses/ecl1.php
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.kuali.rice.kns.util;

import java.math.BigDecimal;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import org.hibernate.HibernateException;

/**
 * This is a description of what this class does - g1zhang don't forget to fill this in. 
 * 
 * @author Kuali Rice Team (rice.collab@kuali.org)
 *
 */
public class HibernateKualiDecimalFieldType extends
HibernateImmutableValueUserType {

	/**
	 * This overridden method ...
	 * 
	 * @see org.kuali.rice.kns.util.HibernateImmutableValueUserType#nullSafeGet(java.sql.ResultSet, java.lang.String[], java.lang.Object)
	 */
	@Override
	public Object nullSafeGet(ResultSet rs, String[] names, Object source)
	throws HibernateException, SQLException {
		Object converted = source;

		if (source instanceof BigDecimal) {
			converted = new KualiDecimal((BigDecimal) source);
		}

		return converted;
	}

	/**
	 * This overridden method ...
	 * 
	 * @see org.kuali.rice.kns.util.HibernateImmutableValueUserType#nullSafeSet(java.sql.PreparedStatement, java.lang.Object, int)
	 */
	@Override
	public void nullSafeSet(PreparedStatement st, Object source, int index)
	throws HibernateException, SQLException {
		
		Object converted =getConverted(source);

		if (converted == null) {
			st.setNull(index, Types.DECIMAL);
		} else {
			st.setBigDecimal(index, (BigDecimal)converted);
		}

	}

	public Object getConverted(Object value){

		Object source = null;

		if (value instanceof KualiDecimal) {
			source = ((KualiDecimal) value).bigDecimalValue();
		}
		return source;
	}


	/**
	 * Returns String.class
	 * 
	 * @see org.hibernate.usertype.UserType#returnedClass()
	 */
	public Class returnedClass() {
		return BigDecimal.class;
	}

	/**
	 * Returns an array with the SQL VARCHAR type as the single member
	 * 
	 * @see org.hibernate.usertype.UserType#sqlTypes()
	 */
	public int[] sqlTypes() {
		return new int[] { Types.DECIMAL };
	}

}

@@ -1428,128 +1428,144 @@
 %0D%0A%09%09
-O
+BigDecimal o
 bject
- c
+ToC
 onvert
-ed
  = 
-source;%0D%0A%0D%0A%09%09if (source instanceof BigDecimal) %7B%0D%0A%09%09%09converted = new KualiDecimal((BigDecimal) source
+rs.getBigDecimal(names%5B0%5D);%0D%0A%0D%0A%09%09if (objectToConvert != null) %7B%0D%0A%09%09%09return new KualiDecimal(objectToConvert
 );%0D%0A
@@ -1580,25 +1580,20 @@
 %09return 
-converted
+null
 ;%0D%0A%09%7D%0D%0A%0D

make sure nullSafeGet pulls directly from ResultsSet