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); } }
public string remove_Curve(string curveCode, string venderName = "local") { try { CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO(); dao.CURVE_CODE_ = curveCode; dao.deleteCode(DataBaseConnectManager.ConnectionFactory("myDB")); return("delete complete"); } catch (Exception e) { return("delete fail : " + e.Message + " , " + e.Source); } }