public List <double> volatilityList(DateTime startDate, DateTime endDate, Underlying under, string type)
        {
            HistoryVolCalculator histVolCal = new HistoryVolCalculator();

            OracleDataBaseConnect connect = new OracleDataBaseConnect();

            connect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO");
            string queryName = "Underlying";

            connect.addQuery(queryName, "");
            connect.excute();

            List <double> resultVol = new List <double>();

            foreach (DataRow item in connect.ResultDataSet_.Tables[queryName].Rows)
            {
                double vol = Convert.ToDouble(item["Value"].ToString());
                resultVol.Add(vol);
            }

            histVolCal.ValueList_ = resultVol;
            histVolCal.historyCalVol();

            return(histVolCal.ValueList_);
        }
        public static DataBaseConnect CreateDBConnet(string p)
        {
            DataBaseConnect conn = new OracleDataBaseConnect();
            conn.DBSetting_ = DBSettingInfoManger.dbSetting(p);

            return conn;
        }
        public List<double> volatilityList(DateTime startDate,DateTime endDate, Underlying under, string type)
        {
            HistoryVolCalculator histVolCal = new HistoryVolCalculator();

            OracleDataBaseConnect connect = new OracleDataBaseConnect();
            connect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO");
            string queryName = "Underlying";

            connect.addQuery(queryName,"");
            connect.excute();

            List<double> resultVol = new List<double>();

            foreach (DataRow item in connect.ResultDataSet_.Tables[queryName].Rows)
	        {
		        double vol = Convert.ToDouble(item["Value"].ToString());
                resultVol.Add(vol);
	        }

            histVolCal.ValueList_ = resultVol;
            histVolCal.historyCalVol();

            return histVolCal.ValueList_;

        }
        public static OracleDataBaseConnect CreateOracleDBConnet(string p)
        {
            OracleDataBaseConnect conn = new OracleDataBaseConnect();

            conn.DBSetting_ = DBSettingInfoManger.dbSetting(p);

            return(conn);
        }
        private DataSet connectDB()
        {
            DataSet dataSet = new DataSet();

            string query = "";

            OracleDataBaseConnect dbConnect = new OracleDataBaseConnect();
            dbConnect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO");

            dbConnect.addQuery("OptionPositionHist", query);
            dbConnect.excute();

            return dbConnect.ResultDataSet_;
        }
        private DataSet connectDB()
        {
            DataSet dataSet = new DataSet();

            string query = "";

            OracleDataBaseConnect dbConnect = new OracleDataBaseConnect();

            dbConnect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO");

            dbConnect.addQuery("OptionPositionHist", query);
            dbConnect.excute();

            return(dbConnect.ResultDataSet_);
        }
        public List <double> loadHistory(string itemCode, DateTime startDate, DateTime endDate)
        {
            OracleDataBaseConnect conn = OracleDataBaseConnect.CreateOracleDBConnet("Local");

            QueryStr query = new QueryStr(fileInfo1_);

            query.VariableMap_.Add("stockID", itemCode);
            query.VariableMap_.Add("startDate", startDate.ToString("yyyyMMdd"));
            query.VariableMap_.Add("endDate", endDate.ToString("yyyyMMdd"));

            conn.addQuery("Test", query.getQuery());
            conn.excute();

            List <double> valueList = new List <double>();
            List <string> datestr   = new List <string>();

            foreach (DataRow item in conn.ResultDataSet_.Tables["Test"].Rows)
            {
                valueList.Add(Convert.ToDouble(item["CURR_PRICE"].ToString()));
                datestr.Add(item["STD_DATE"].ToString());
            }

            return(Result_);
        }
        //public ObservableCollection<Instrument> getPosition()
        //{
        //    loadedPosition_ = new List<string>();
        //    ObservableCollection<Instrument> position = new ObservableCollection<Instrument>() ;

        //    DataTable table = positionDataSet_.Tables["Position"];

        //    foreach (DataRow row in table.Rows)
        //    {
        //        Instrument inst = this.buildInstrument(row["KR_CD"].ToString());
        //        //if (inst.Underlying_ != null)
        //        //{
        //        //    position.Add(inst);
        //        //}
        //    }


        //    return position;

        //}

        public void updateDB()
        {
            OracleDataBaseConnect conn = new OracleDataBaseConnect();
            //conn.addQuery(
        }
        //public ObservableCollection<Instrument> getPosition()
        //{
        //    loadedPosition_ = new List<string>();
        //    ObservableCollection<Instrument> position = new ObservableCollection<Instrument>() ;

        //    DataTable table = positionDataSet_.Tables["Position"];

        //    foreach (DataRow row in table.Rows)
        //    {
        //        Instrument inst = this.buildInstrument(row["KR_CD"].ToString());
        //        //if (inst.Underlying_ != null)
        //        //{
        //        //    position.Add(inst);
        //        //}
        //    }


        //    return position;

        //}

        public void updateDB()
        {
            OracleDataBaseConnect conn = new OracleDataBaseConnect();
            //conn.addQuery(

        }