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 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_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 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 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 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 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 selectNAME_KOR(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string selectNAME_KORQuery = MARKETDATA_SYMBOL_INFO_Table_DAO.SelectNAME_KORQuery_;
selectNAME_KORQuery = selectNAME_KORQuery.Replace("@NAME_KORValue@", this.NAME_KOR_);
dbCommand.CommandText = selectNAME_KORQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
if (!(rowCount == 0 || rowCount == 1))
{
throw new Exception();
}
foreach (DataRow item in dr)
{
this.SYMBOL_ = item[0].ToString();
this.NAME_ENG_ = item[1].ToString();
this.NAME_KOR_ = item[2].ToString();
this.SYMBOL_TYPE_ = item[3].ToString();
this.PROVIDER_ = item[4].ToString();
this.DESCRIPTION_ = item[5].ToString();
this.TENOR_ = item[6].ToString();
this.SUB_TYPE_ = item[7].ToString();
this.LINKEDCURVE_ = item[8].ToString();
this.RATE_TYPE_ = item[9].ToString();
this.LEG_TENOR_ = item[10].ToString();
this.CURRENCY_ = item[11].ToString();
}
conn.Close();
}
catch (Exception)
{
conn.Close();
throw;
}
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
this.DAOList_ = new List <MARKETDATA_SYMBOL_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = MARKETDATA_SYMBOL_INFO_Table_DAOManager.SelectQuery_;
selectQuery = selectQuery.Replace("@SYMBOL_TYPEKeyColumnValue@", this.KeyColumn_SYMBOL_TYPE_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO();
dao.SYMBOL_ = item[0].ToString();
dao.NAME_ENG_ = item[1].ToString();
dao.NAME_KOR_ = item[2].ToString();
dao.SYMBOL_TYPE_ = item[3].ToString();
dao.PROVIDER_ = item[4].ToString();
dao.DESCRIPTION_ = item[5].ToString();
dao.TENOR_ = item[6].ToString();
dao.SUB_TYPE_ = item[7].ToString();
dao.LINKEDCURVE_ = item[8].ToString();
dao.RATE_TYPE_ = item[9].ToString();
dao.LEG_TENOR_ = item[10].ToString();
dao.CURRENCY_ = item[11].ToString();
this.DAOList_.Add(dao);
}
conn.Close();
}
catch (Exception)
{
conn.Close();
}
}
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 select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <MATSER_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = MATSER_INFO_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
MATSER_INFO_Table_DAO dao = new MATSER_INFO_Table_DAO();
dao.ITEM_CODE_ = item[0].ToString();
dao.ITEM_NAME_ = item[1].ToString();
dao.NOTIONAL_ = item[2].ToString();
dao.REMAIN_NOTIONAL_ = item[3].ToString();
dao.CURRENCY_ = item[4].ToString();
dao.TRADE_DATE_ = item[5].ToString();
dao.MATURITY_DATE_ = item[6].ToString();
dao.COUNTERPARTY_ = item[7].ToString();
dao.EXPORT_ITEMCODE_ = item[8].ToString();
dao.TRADE_ID_ = item[9].ToString();
dao.TRADE_STATUS_ = item[10].ToString();
dao.INSTRUMENT_TYPE_ = item[11].ToString();
dao.UNDERLYING_TYPE_ = item[12].ToString();
dao.UNDERLYING_DETAIL_TYPE_ = item[13].ToString();
dao.CONTRACT_TYPE_ = item[14].ToString();
dao.CONTRACT_SUBTYPE_ = item[15].ToString();
dao.CONTRACT_DETAIL_TYPE_ = item[16].ToString();
dao.BOOKING_TYPE_ = item[17].ToString();
this.DAOList_.Add(dao);
}
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <TD_MRCURVE_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = TD_MRCURVE_Table_DAOManager.SelectQuery_;
selectQuery = selectQuery.Replace("@KeyColumn_RefDateValue@", this.KeyColumn_RefDate_);
selectQuery = selectQuery.Replace("@KeyColumn_CurveCodeValue@", this.KeyColumn_CurveCode_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
TD_MRCURVE_Table_DAO dao = new TD_MRCURVE_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.CURVE_CODE_ = item[1].ToString();
dao.BOND_CLASS_ID_ = item[2].ToString();
dao.D001_ = item[3].ToString();
dao.M003_ = item[4].ToString();
dao.M006_ = item[5].ToString();
dao.M009_ = item[6].ToString();
dao.M012_ = item[7].ToString();
dao.M018_ = item[8].ToString();
dao.M024_ = item[9].ToString();
dao.M030_ = item[10].ToString();
dao.M036_ = item[11].ToString();
dao.M048_ = item[12].ToString();
dao.M060_ = item[13].ToString();
dao.M084_ = item[14].ToString();
dao.M120_ = item[15].ToString();
dao.M180_ = item[16].ToString();
dao.M240_ = item[17].ToString();
dao.M360_ = item[18].ToString();
this.DAOList_.Add(dao);
}
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <EVENT_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = EVENT_INFO_Table_DAOManager.SelectQuery_;
selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO();
dao.EVENT_CODE_ = item[0].ToString();
dao.EVENT_DATE_ = item[1].ToString();
dao.EVENT_TYPE_ = item[2].ToString();
dao.EVENT_SUBTYPE_ = item[3].ToString();
dao.EVENT_NAME_ = item[4].ToString();
dao.EVENT_DESCRIPTION_ = item[5].ToString();
dao.CURRENCY_ = item[6].ToString();
dao.NOTIONAL_ = item[7].ToString();
dao.REMAIN_NOTIONAL_ = item[8].ToString();
dao.EVENT_AMOUNT_ = item[9].ToString();
dao.COUNTERPARTY_ = item[10].ToString();
dao.FLOATING_FLAG_ = item[11].ToString();
dao.CALCULATION_TYPE_ = item[12].ToString();
dao.FIXING_UNDERLYINGS_ = item[13].ToString();
dao.FIXING_OBSERVATION_ = item[14].ToString();
dao.FIXING_FLAG_ = item[15].ToString();
dao.EXPIRED_FLAG_ = item[16].ToString();
dao.ITEM_CODE_ = item[17].ToString();
dao.ITEM_TYPE_ = item[18].ToString();
dao.ITEM_NAME_ = item[19].ToString();
this.DAOList_.Add(dao);
}
}
// 메모리에 어디까지 올릴건가
// 지금은 그냥 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 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_);
}
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 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 void selectInterval(DbConnection conn, DateTime startDate, DateTime endDate)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
this.DAOList_ = new List <TD_MRSTOCKFACTOR_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string SelectInterValQuery_ = TD_MRSTOCKFACTOR_Table_DAOManager.SelectInterValQuery_;
SelectInterValQuery_ = SelectInterValQuery_.Replace("@KeyColumnValue@", this.STOCK_ID_);
SelectInterValQuery_ = SelectInterValQuery_.Replace("@StartDateValue@", startDate.ToString(StringFormat.DbDateFormat_));
SelectInterValQuery_ = SelectInterValQuery_.Replace("@EndDateValue@", endDate.ToString(StringFormat.DbDateFormat_));
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = SelectInterValQuery_;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
TD_MRSTOCKFACTOR_Table_DAO dao = new TD_MRSTOCKFACTOR_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.STOCK_ID_ = item[1].ToString();
dao.STOCK_NAME_ = item[2].ToString();
dao.CURR_PRICE_ = item[3].ToString();
dao.DIVIDEND_RATE_ = item[4].ToString();
this.DAOList_.Add(dao);
}
conn.Close();
}
catch (Exception)
{
conn.Close();
throw;
}
}
public string select_date_code_id(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string select_date_code_id_Query = OTC_TD_MRSTOCKFACTORVOL_Table_DAO.Select_date_code_id_Query_;
select_date_code_id_Query = select_date_code_id_Query.Replace("@STD_DATEValue@", this.STD_DATE_);
select_date_code_id_Query = select_date_code_id_Query.Replace("@KR_CODEValue@", this.KR_CODE_);
select_date_code_id_Query = select_date_code_id_Query.Replace("@STOCK_IDValue@", this.STOCK_ID_);
dbCommand.CommandText = select_date_code_id_Query;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
if (!(rowCount == 0 || rowCount == 1))
{
throw new Exception();
}
foreach (DataRow item in dr)
{
this.STD_DATE_ = item[0].ToString();
this.KR_CODE_ = item[1].ToString();
this.STOCK_ID_ = item[2].ToString();
this.VOL_ = item[3].ToString();
this.QUANTO_VOL_ = item[4].ToString();
this.QUANTO_RHO_ = item[5].ToString();
}
conn.Close();
return(select_date_code_id_Query);
}
catch (Exception)
{
conn.Close();
throw;
}
}
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 select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <POSITION_PL_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = POSITION_PL_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO();
dao.ITEM_CODE_ = item[0].ToString();
dao.TRADE_ID_ = item[1].ToString();
dao.NOTIONAL_ = item[2].ToString();
dao.REMAIN_NOTIONAL_ = item[3].ToString();
dao.BOOK_PRICE_ = item[4].ToString();
dao.BOOK_NOTIONAL_ = item[5].ToString();
dao.EVAL_PRICE_ = item[6].ToString();
dao.BOOK_PL_ = item[7].ToString();
dao.TOTAL_EVAL_PL_ = item[8].ToString();
dao.DAILY_EVAL_PL_ = item[9].ToString();
dao.TRADE_PL_ = item[10].ToString();
dao.TOTAL_PL_ = item[11].ToString();
dao.ETC_PL_ = item[12].ToString();
dao.STD_DATE_ = item[13].ToString();
this.DAOList_.Add(dao);
}
}
public void selectDateCurve(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string selectDateCurveQuery = CURVE_DATA_Table_DAO.SelectDateCurveQuery_;
selectDateCurveQuery = selectDateCurveQuery.Replace("@CURVE_DATEVALUE@", this.CURVE_DATE_);
selectDateCurveQuery = selectDateCurveQuery.Replace("@CURVE_CODEVALUE@", this.CURVE_CODE_);
dbCommand.CommandText = selectDateCurveQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
if (!(rowCount == 0 || rowCount == 1))
{
throw new Exception("unique curveCode violation ");
}
foreach (DataRow item in dr)
{
this.CURVE_DATE_ = item[0].ToString();
this.CURVE_CODE_ = item[1].ToString();
this.TENOR_ = item[2].ToString();
this.VALUE_ = item[3].ToString();
this.CURVE_TYPE_ = item[4].ToString();
}
conn.Close();
}
catch (Exception e)
{
conn.Close();
throw;
}
}
public void select_date_id_otherid_Query(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
try
{
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string select_date_id_otherid_Query = OTC_TD_MRELSSTOCKCORR_Table_DAO.Select_date_id_otherid_Query_;
select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@STD_DATEValue@", this.STD_DATE_);
select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@STOCK_IDValue@", this.STOCK_ID_);
select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@OTHER_IDValue@", this.OTHER_ID_);
dbCommand.CommandText = select_date_id_otherid_Query;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
if (!(rowCount == 0 || rowCount == 1))
{
throw new Exception();
}
foreach (DataRow item in dr)
{
this.STD_DATE_ = item[0].ToString();
this.STOCK_ID_ = item[1].ToString();
this.OTHER_ID_ = item[2].ToString();
this.CORR_ = item[3].ToString();
}
conn.Close();
}
catch (Exception)
{
conn.Close();
throw;
}
}
