src/com/shrewdify/diaroser/utils/DbHelper.java
public void addCdrRecords(HashMap<String,String> tdsValues) throws SQLException{
		if(connection != null){
			psCdrRecords.setString(1, "cdrRecords");
			psCdrRecords.setInt(2, 1);
			psCdrRecords.setString(3, tdsValues.get(Constants.SRC_USERNAME));
			psCdrRecords.setString(4, tdsValues.get(Constants.SRC_HOSTNAME));
			psCdrRecords.setString(5, tdsValues.get(Constants.BNUMBER));
			psCdrRecords.setString(6, tdsValues.get(Constants.START_TIME));
			psCdrRecords.setString(7, tdsValues.get(Constants.END_TIME));
			psCdrRecords.setString(8, tdsValues.get(Constants.ACCOUNT));	
			psCdrRecords.setInt(9, Integer.valueOf(tdsValues.get(Constants.AMOUNTCONSUMED)));
			psCdrRecords.setLong(10, Long.valueOf(tdsValues.get(Constants.TIMECONSUMED)));
			psCdrRecords.setInt(11, Integer.parseInt(tdsValues.get(Constants.CHARGEMODE)));
			psCdrRecords.setInt(12, Integer.parseInt(tdsValues.get(Constants.RATECARD)));
			psCdrRecords.setInt(13, Integer.valueOf(tdsValues.get(Constants.INITIAL_CHARGE)));
			psCdrRecords.execute();
		
		}
	}
/**
	 * 
	 * @param tdsValues  // It Contains all the Values to be inserted in CDR's Table.
	 * @throws SQLException
	 */
@param tdsValues  // It Contains all the Values to be inserted in CDR's Table.
@param tdsValues // It Contains all the Values to be inserted in CDR ' s Table .
public void addCdrRecords(HashMap<String,String> tdsValues) throws SQLException{
		if(connection != null){
			psCdrRecords.setString(1, "cdrRecords");
			psCdrRecords.setInt(2, 1);
			psCdrRecords.setString(3, tdsValues.get(Constants.SRC_USERNAME));
			psCdrRecords.setString(4, tdsValues.get(Constants.SRC_HOSTNAME));
			psCdrRecords.setString(5, tdsValues.get(Constants.BNUMBER));
			psCdrRecords.setString(6, tdsValues.get(Constants.START_TIME));
			psCdrRecords.setString(7, tdsValues.get(Constants.END_TIME));
			psCdrRecords.setString(8, tdsValues.get(Constants.ACCOUNT));	
			psCdrRecords.setInt(9, Integer.valueOf(tdsValues.get(Constants.AMOUNTCONSUMED)));
			psCdrRecords.setLong(10, Long.valueOf(tdsValues.get(Constants.TIMECONSUMED)));
			psCdrRecords.setInt(11, Integer.parseInt(tdsValues.get(Constants.CHARGEMODE)));
			psCdrRecords.setInt(12, Integer.parseInt(tdsValues.get(Constants.RATECARD)));
			psCdrRecords.setInt(13, Integer.valueOf(tdsValues.get(Constants.INITIAL_CHARGE)));
			psCdrRecords.execute();
		}
	}
public void addCdrRecords ( HashMap < String , String > tdsValues ) throws SQLException { if ( connection != null ) { psCdrRecords . setString ( 1 , "cdrRecords" ) ; psCdrRecords . setInt ( 2 , 1 ) ; psCdrRecords . setString ( 3 , tdsValues . get ( Constants . SRC_USERNAME ) ) ; psCdrRecords . setString ( 4 , tdsValues . get ( Constants . SRC_HOSTNAME ) ) ; psCdrRecords . setString ( 5 , tdsValues . get ( Constants . BNUMBER ) ) ; psCdrRecords . setString ( 6 , tdsValues . get ( Constants . START_TIME ) ) ; psCdrRecords . setString ( 7 , tdsValues . get ( Constants . END_TIME ) ) ; psCdrRecords . setString ( 8 , tdsValues . get ( Constants . ACCOUNT ) ) ; psCdrRecords . setInt ( 9 , Integer . valueOf ( tdsValues . get ( Constants . AMOUNTCONSUMED ) ) ) ; psCdrRecords . setLong ( 10 , Long . valueOf ( tdsValues . get ( Constants . TIMECONSUMED ) ) ) ; psCdrRecords . setInt ( 11 , Integer . parseInt ( tdsValues . get ( Constants . CHARGEMODE ) ) ) ; psCdrRecords . setInt ( 12 , Integer . parseInt ( tdsValues . get ( Constants . RATECARD ) ) ) ; psCdrRecords . setInt ( 13 , Integer . valueOf ( tdsValues . get ( Constants . INITIAL_CHARGE ) ) ) ; psCdrRecords . execute ( ) ; } }
@param tdsValues  // It Contains all the Values to be inserted in CDR's Table.
@param tdsValues // It Contains all the Values to be inserted in CDR ' s Table .