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);
}
}
