public void insertHistoryDB()
{
INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO();
dao.INDEX_CODE_ = this.Code_;
dao.INDEX_NAME_ = this.Name_;
try
{
dao.deleteIndex(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in this.TimeSeries_)
{
dao.INDEX_DATE_ = QueryStr.wrapComma(item.Key);
dao.INDEX_VALUE_ = QueryStr.wrapComma(item.Value);
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
}
catch (SqlCeException)
{
OutputLogViewModel.addResult("DataBase Connection Error : DB Load");
throw;
}
}
public TimeSeries <string> historySeries(DateTime sDate, DateTime eDate)
{
TimeSeries <string> hist = new TimeSeries <string>();
INDEX_DATA_Table_DAOManager dao_m = new INDEX_DATA_Table_DAOManager();
dao_m.INDEX_CODE_ = this.Code_;
dao_m.selectInterval(DataBaseConnectManager.ConnectionFactory("myDB"), sDate, eDate);
foreach (var item in dao_m.DAOList_)
{
string date = item.INDEX_DATE_;
int year = Convert.ToInt32(date.Substring(0, 4));
int month = Convert.ToInt32(date.Substring(4, 2));
int day = Convert.ToInt32(date.Substring(6, 2));
string value = item.INDEX_VALUE_;
hist.Add(new Date(new DateTime(year, month, day)), value);
}
return(hist);
}
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel)
{
foreach (var item in this.excel_fixedCouponScheduleListViewModel_.Excel_fixedCouponScheduleViewModel_)
{
EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO();
dao.ITEM_CODE_ = masterInformationViewModel.Item_code_;
dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_;
dao.ITEM_NAME_ = masterInformationViewModel.Item_name_;
//dao.CALCULATION_TYPE_ =
dao.COUNTERPARTY_ = masterInformationViewModel.Counterparty_;
dao.CURRENCY_ = this.excel_issueInfoViewModel_.Currency_.CurrencyString_;
//dao.EVENT_AMOUNT_ =
dao.EVENT_CODE_ = EventViewModel.eventCodeGen();
//dao.EVENT_DATE_ =
//dao.EVENT_DESCRIPTION_ =
//dao.EVENT_NAME_ =
//dao.EVENT_SUBTYPE_
//dao.EVENT_TYPE_
dao.EXPIRED_FLAG_ = "false";
//dao.FIXING_FLAG_ =
//dao.FIXING_OBSERVATION_ =
//dao.FIXING_UNDERLYINGS_ =
//dao.FLOATING_FLAG_ =
dao.NOTIONAL_ = this.excel_issueInfoViewModel_.Notional_;
//dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_;
dao.REMAIN_NOTIONAL_ = "undefined";
item.bookingEvent(masterInformationViewModel, dao);
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
}
public TimeSeries <string> historySeriesMRO(DateTime sDate, DateTime eDate)
{
TimeSeries <string> hist = new TimeSeries <string>();
TD_MRSTOCKFACTOR_Table_DAOManager dao_m = new TD_MRSTOCKFACTOR_Table_DAOManager();
dao_m.STOCK_ID_ = this.Code_;
dao_m.selectInterval(DataBaseConnectManager.ConnectionFactory("MRO"), sDate, eDate);
foreach (var item in dao_m.DAOList_)
{
string date = item.STD_DATE_;
int year = Convert.ToInt32(date.Substring(0, 4));
int month = Convert.ToInt32(date.Substring(4, 2));
int day = Convert.ToInt32(date.Substring(6, 2));
string value = item.CURR_PRICE_;
hist.Add(new Date(new DateTime(year, month, day)), value);
}
return(hist);
}
public double loadData(string code, DateTime refDate)
{
INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO();
dao.INDEX_DATE_ = refDate.ToString(StringFormat.DbDateFormat_);
dao.INDEX_CODE_ = code;
double result = 0.0;
try
{
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
}
catch (Exception)
{
OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
try
{
result = Convert.ToDouble(dao.INDEX_VALUE_);
}
catch (Exception)
{
OutputLogViewModel.addResult("data converting error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
return(result);
}
public static Excel_underlyingInfoViewModel loadUnderInfo(DateTime refDate, string nameTrans)
{
// nameTrans를 가지고 code를 찾음.
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.NAME_KOR_ = (nameTrans.Trim()).ToUpper();
dao.selectNAME_KOR(DataBaseConnectManager.ConnectionFactory("myDB"));
// 코드를 찾아서 symbol을 로드함.
// symbol을 통해서 type을 로드함
// type을 통해서 symbolVM을 만들음
string underType = dao.SYMBOL_TYPE_;
Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType);
e_mds.setFromDAO(dao);
Excel_underlyingInfoViewModel e_uivm = e_mds.underlyingInfoVM();
e_uivm.BasePrice_ = e_mds.dataLoad(Excel_loaderViewModel.availableMarketDataDate(refDate), e_mds.Symbol_);
return(e_uivm);
}
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel)
{
// 상품이 모두 만들어진 후에 event를 gen 해서 박아넣음
foreach (var item in this.excel_hifive_StepDownKI_ViewModel_.SubScheduleDataList_)
{
EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO();
dao.EVENT_DATE_ = item.EventDate_.ToString(DataBaseStringFormat.DateFormat_);
dao.EVENT_TYPE_ = "settlement";
dao.EVENT_SUBTYPE_ = "earlyRedemption";
dao.EVENT_DESCRIPTION_ = "coupon : " + item.Coupon_ + " trigger : " + item.Trigger_;
dao.EVENT_NAME_ = "중도상환";
dao.CURRENCY_ = "KRW";
double amt = Convert.ToDouble(this.excel_issueInfoViewModel_.Notional_) + Convert.ToDouble(this.excel_issueInfoViewModel_.Notional_) * Convert.ToDouble(item.Coupon_) / 100;
dao.EVENT_AMOUNT_ = amt.ToString();
dao.FIXING_UNDERLYINGS_ = this.excel_underlyingCalcInfoViewModel_.underlyingString();
dao.FIXING_FLAG_ = "false";
//dao.OBSERVATION_END_DATE_ = dao.EVENT_DATE_;
dao.ITEM_CODE_ = masterInformationViewModel.Item_code_;
dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_;
dao.ITEM_NAME_ = masterInformationViewModel.Item_name_;
dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
}
public static Excel_marketDataSymbol getDefinedSymbol(string code)
{
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.SYMBOL_ = code.Trim();
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
// 코드를 찾아서 symbol을 로드함.
// symbol을 통해서 type을 로드함
// type을 통해서 symbolVM을 만들음
string underType = dao.SYMBOL_TYPE_;
if (underType == null)
{
throw new Exception("symbol doesn't exist in symbolList : " + dao.SYMBOL_);
}
Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType);
e_mds.setFromDAO(dao);
return(e_mds);
}
public override void loadDefinedSymbolFromDB()
{
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
// ir 쪽을 죄다 로드함.
daoM.KeyColumn_ = "ircurve".ToUpper();
daoM.KeyColumn_SYMBOL_TYPE_ = "ircurve".ToUpper();
try
{
daoM.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.definedIRCurveSymbolList_.Clear();
foreach (var item in daoM.DAOList_)
{
Excel_irCurveSymbolViewModel eicvm = new Excel_irCurveSymbolViewModel();
eicvm.setFromDAO(item);
this.definedIRCurveSymbolList_.Add(eicvm);
}
}
catch (Exception)
{
//OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_));
}
}
public void load(string curveID, DateTime d)
{
this.Tenor_ = new List <string>();
this.Data_ = new List <string>();
CURVETENOR_INFO_Table_DAO tenor_dao = new CURVETENOR_INFO_Table_DAO();
tenor_dao.CURVE_CODE_ = curveID;
tenor_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
string[] tenor_info = tenor_dao.TENORLIST_.Split(';');
CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO();
dao.CURVE_CODE_ = curveID;
dao.CURVE_DATE_ = d.ToString(StringFormat.DbDateFormat_);
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
int maxLenth = Math.Min(15, tenor_info.Length);
for (int i = 0; i < maxLenth; i++)
{
this.Tenor_.Add(tenor_info[i]);
//this.Data_.Add(dao.DataList_[i]);
}
}
public void bookingEvent(MasterInformationViewModel masterInformationViewModel)
{
EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO();
dao.EVENT_DATE_ = this.eventDate_;
dao.EVENT_TYPE_ = "Termination";
dao.EVENT_SUBTYPE_ = this.detailTerminationType_;
dao.EVENT_DESCRIPTION_ = this.description_;
dao.EVENT_NAME_ = "Early Redemption";
dao.CURRENCY_ = "";
generalTerminationEventDetailViewModel_.bookingDetailEvent(masterInformationViewModel, dao);
//dao.EVENT_AMOUNT_ = generalTerminationEventDetailViewModel_.InitialFixingAmount_;
//dao.FIXING_UNDERLYINGS_ = generalTerminationEventDetailViewModel_.FixingUnderlying_;
//dao.FIXING_FLAG_ = generalTerminationEventDetailViewModel_.InitialFixingFlag_;
//dao.OBSERVATION_END_DATE_ = generalTerminationEventDetailViewModel_.ObservationEndDate_;
dao.ITEM_CODE_ = masterInformationViewModel.Item_code_;
dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_;
dao.ITEM_NAME_ = masterInformationViewModel.Item_name_;
dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
public void dbUpdate()
{
EVENT_INFO_Table_DAO updateDao = new EVENT_INFO_Table_DAO();
//set insertDao
updateDao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
}
public bool hasHoliday(string dateStr_yyyyMMdd)
{
this.HOLIDAY_DATE_ = dateStr_yyyyMMdd;
this.select(DataBaseConnectManager.ConnectionFactory("mydb"));
return(false);
}
public void dbDelete()
{
EVENT_INFO_Table_DAO insertDao = new EVENT_INFO_Table_DAO();
insertDao.KeyColumn_ = this.event_code_;
//set insertDao
insertDao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
}
public void bookingPL()
{
POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO();
dao.TRADE_ID_ = this.tradeID_;
dao.BOOK_PRICE_ = this.bookValue_;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
//dao.TOTAL_EVAL_PL_ =
}
public static string getProvider(string code)
{
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.SYMBOL_ = code;
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
return(dao.PROVIDER_);
}
// 메모리에 어디까지 올릴건가
// 지금은 그냥 db access함
public void loadMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
try
{
this.setFromDAO(mt_dao);
}
catch (Exception)
{
OutputLogViewModel.addResult("favor not implemeted");
}
//DataTable tb = new DataTable();
//using (SqlCeConnection connection = new SqlCeConnection(connectionStr_))
//using (SqlCeCommand command = connection.CreateCommand())
//{
// string itemCodeWrap = QueryStr.wrapComma(itemCode);
// command.CommandText = "SELECT TRADE_ID, ITEM_CODE , ITEM_NAME , NOTIONAL , TYPE, " +
// " TRADE_DATE , MATURITY_DATE , COUNTERPARTY , EXPORT_ITEMCODE FROM MASTERINFORMATION WHERE ITEM_CODE =" + itemCodeWrap;
// connection.Open();
// SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
// dataAdapter.Fill(tb);
//}
//DataRow[] resultRows = tb.Select();
//string formatString = "yyyyMMdd";
//foreach (DataRow item in resultRows)
//{
// this.tradeID_ = item["TRADE_ID"].ToString();
// this.itemCode_ = item["ITEM_CODE"].ToString();
// this.name_ = item["ITEM_NAME"].ToString();
// this.notional_ = item["NOTIONAL"].ToString();
// this.type_ = item["TYPE"].ToString();
// this.tradeDate_ = DateTime.ParseExact(item["TRADE_DATE"].ToString(), formatString,null);
// this.maturityDate_ = DateTime.ParseExact(item["MATURITY_DATE"].ToString(), formatString, null);
// this.conterParty_ = item["COUNTERPARTY"].ToString();
// this.export_ItemCode_ = item["EXPORT_ITEMCODE"].ToString();
//}
this.dataContextRefersh();
}
public void deleteDao(Excel_marketDataSymbol excel_marketDataSymbol)
{
try
{
excel_marketDataSymbol.buildDAO().delete(DataBaseConnectManager.ConnectionFactory("myDB"));
//this.symbolDAOList_.Add(excel_marketDataSymbol.buildDAO());
}
catch (Exception)
{
OutputLogViewModel.addResult("symbol data db insert error : " + this.addedDao_.SYMBOL_);
}
}
public override string value(DateTime dateTime, Excel_instrumentViewModel excel_instrumentViewModel, Excel_underlyingInfoViewModel excel_uivm)
{
TD_MRSTOCKFACTOR_Table_DAO dao = new TD_MRSTOCKFACTOR_Table_DAO();
dao.STOCK_ID_ = excel_uivm.KrCode_;
dao.STD_DATE_ = StringConverter.dbDateTimeToDateString(dateTime);
dao.select_ID_Date(DataBaseConnectManager.ConnectionFactory("MRO"));
string v = dao.DIVIDEND_RATE_;
return(v);
}
public void loadMarketDataSymbolFromDB()
{
this.symbolDAOList_.Clear();
MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager();
daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));
foreach (var item in daoM.DAOList_)
{
this.symbolDAOList_.Add(item);
}
}
public void loadBookingInfo()
{
POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO();
dao.KeyColumn_ = this.tradeID_;
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
#region setFromDao
this.BookValue_ = dao.BOOK_PRICE_;
#endregion
}
private void AddSymbolButton_Click(object sender, RoutedEventArgs e)
{
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.DESCRIPTION_ = descriptionTb_.Text;
dao.NAME_ENG_ = name_engTb_.Text;
dao.NAME_KOR_ = name_korTb_.Text;
dao.PROVIDER_ = providerTb_.Text;
dao.SYMBOL_TYPE_ = symbol_typeTb_.Text;
dao.SYMBOL_ = symbolTb_.Text;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
this.viewModel_.loadMarketDataSymbolFromDB();
}
public static Excel_instrumentViewModel loadInstrumentVM(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.ITEM_CODE_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
Excel_instrumentViewModel e_ivm =
CodeClassificationGenerator.CreateInstrument(mt_dao.ITEM_CODE_);
e_ivm.MasterInformationViewModel_.setFromDAO(mt_dao);
return(e_ivm);
}
public static void removeMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
try
{
mt_dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
}
catch (Exception)
{
throw;
}
}
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel)
{
EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO();
foreach (var item in this.excel_multiAsset_compositeOption_subtypeViewModel_)
{
item.bookingEvent(masterInformationViewModel, dao);
}
dao.ITEM_CODE_ = masterInformationViewModel.Item_code_;
dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_;
dao.ITEM_NAME_ = masterInformationViewModel.Item_name_;
dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_;
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
public override string dataLoad(DateTime refDate, string code)
{
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.SYMBOL_ = code;
dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
this.setFromDAO(dao);
IndexMarketDataLoader indexLoader = IndexMarketDataLoader.CreateMarketDataLoader(this.provider_);
string value = indexLoader.load(refDate, code);
return(value);
}
public override string value(DateTime refDate, string code, string other_code)
{
OTC_TD_MRELSSTOCKCORR_Table_DAO dao = new OTC_TD_MRELSSTOCKCORR_Table_DAO();
dao.STD_DATE_ = StringConverter.dbDateTimeToDateString(refDate);
dao.STOCK_ID_ = code;
dao.OTHER_ID_ = other_code;
dao.select_date_id_otherid_Query(DataBaseConnectManager.ConnectionFactory("MRO"));
if (dao.CORR_ == null)
{
dao.CORR_ = "0.5";
}
return(dao.CORR_);
}
public void removeHoliday(DateTime d)
{
try
{
HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO();
dao.HOLIDAY_DATE_ = StringConverter.dbDateTimeToDateString(d);
dao.HOLIDAY_COUNTRY_NAME_ = this.calendarName_;
dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
this.dataReload();
}
catch (Exception e)
{
OutputLogViewModel.addResult("remove fail : " + d.ToString("yyyyMMdd") + " " + e.Message);
throw;
}
}
public void insertDB()
{
INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO();
dao.INDEX_DATE_ = this.Date_;
dao.INDEX_CODE_ = this.Name_;
dao.INDEX_NAME_ = this.Name_;
dao.INDEX_VALUE_ = this.Value_;
try
{
dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
catch (SqlCeException)
{
OutputLogViewModel.addResult("dataBase load error : " + this.Name_);
}
}
public override string value(DateTime dateTime, Excel_instrumentViewModel e_instVM, Excel_underlyingInfoViewModel excel_uivm)
{
OTC_TD_MRSTOCKFACTORVOL_Table_DAO dao = new OTC_TD_MRSTOCKFACTORVOL_Table_DAO();
dao.STD_DATE_ = StringConverter.dbDateTimeToDateString(dateTime);
dao.STOCK_ID_ = excel_uivm.KrCode_;
dao.KR_CODE_ = e_instVM.MasterInformationViewModel_.Export_itemcode_;
string sql = dao.select_date_code_id(DataBaseConnectManager.ConnectionFactory("MRO"));
if (dao.STOCK_ID_ == "KR7060980000")
{
dao.VOL_ = "0.33";
}
//SQL_Logger.addLog(sql);
return(dao.VOL_);
}
