public string save(string curveCode, DateTime refDate, string venderName = "local") { try { //Excel_irCurveLoaderViewModel e_irCurveLoader = new Excel_irCurveLoaderViewModel(); //e_irCurveLoader.loadDefinedSymbolFromDB(); //e_irCurveLoader. CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO(); dao.CURVE_DATE_= StringConverter.dbDateTimeToDateString(refDate); dao.CURVE_CODE_ = curveCode; foreach (var item in this.Excel_yieldCurveViewModel_.Excel_rateDataViewModel_) { dao.TENOR_ = item.Tenor_; dao.VALUE_ = item.Value_; dao.CURVE_TYPE_ = item.RateType_; dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); } return "save complete"; } catch (Exception e) { return "save fail : " + e.Message + " , " + e.Source; } }