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 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 void buildDAO() { // bussiness logic here EVENT_INFO_Table_DAO insertDao = new EVENT_INFO_Table_DAO(); insertDao.EVENT_CODE_ = this.Event_code_; insertDao.EVENT_DATE_ = this.Event_date_.ToString("yyyyMMdd"); insertDao.EVENT_TYPE_ = this.Event_type_; insertDao.EVENT_SUBTYPE_ = this.Event_subtype_; insertDao.EVENT_NAME_ = this.Event_name_; insertDao.EVENT_DESCRIPTION_ = this.Event_description_; insertDao.CURRENCY_ = this.Currency_; insertDao.NOTIONAL_ = this.Notional_; insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_; insertDao.EVENT_AMOUNT_ = this.Event_amount_; insertDao.COUNTERPARTY_ = this.Counterparty_; insertDao.FLOATING_FLAG_ = this.Floating_flag_; insertDao.CALCULATION_TYPE_ = this.Calculation_type_; insertDao.FIXING_UNDERLYINGS_ = this.Fixing_underlyings_; insertDao.FIXING_OBSERVATION_ = this.Fixing_observation_; insertDao.FIXING_FLAG_ = this.Fixing_flag_; insertDao.EXPIRED_FLAG_ = this.Expired_flag_; insertDao.ITEM_CODE_ = this.Item_code_; insertDao.ITEM_TYPE_ = this.Item_type_; insertDao.ITEM_NAME_ = this.Item_name_; }
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 void setFromDAO(EVENT_INFO_Table_DAO dao) { // bussiness logic here try { this.event_code_ = dao.EVENT_CODE_; this.Event_date_ = DateTime.ParseExact(dao.EVENT_DATE_, "yyyyMMdd", null); this.event_type_ = dao.EVENT_TYPE_; this.event_subtype_ = dao.EVENT_SUBTYPE_; this.event_name_ = dao.EVENT_NAME_; this.event_description_ = dao.EVENT_DESCRIPTION_; this.currency_ = dao.CURRENCY_; this.notional_ = dao.NOTIONAL_; this.remain_notional_ = dao.REMAIN_NOTIONAL_; this.event_amount_ = dao.EVENT_AMOUNT_; this.counterparty_ = dao.COUNTERPARTY_; this.floating_flag_ = dao.FLOATING_FLAG_; this.calculation_type_ = dao.CALCULATION_TYPE_; this.fixing_underlyings_ = dao.FIXING_UNDERLYINGS_; this.fixing_observation_ = dao.FIXING_OBSERVATION_; this.fixing_flag_ = dao.FIXING_FLAG_; this.expired_flag_ = dao.EXPIRED_FLAG_; this.item_code_ = dao.ITEM_CODE_; this.item_type_ = dao.ITEM_TYPE_; this.item_name_ = dao.ITEM_NAME_; } catch (Exception) { //OutputLogViewModel.addResult("event dao : " + e.Message + " " + item_code_ + " " + item_name_); } }
public void dbUpdate() { EVENT_INFO_Table_DAO updateDao = new EVENT_INFO_Table_DAO(); //set insertDao updateDao.delete(DataBaseConnectManager.ConnectionFactory("myDB")); }
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 <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); } }
public override void bookingDetailEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { //dao.EVENT_AMOUNT_ = Convert.ToDouble(masterInformationViewModel.RemainNotional_) // * Convert.ToDouble( this.fixedRate_ ) * this.yearFraction_; dao.EVENT_AMOUNT_ = "554443"; dao.FIXING_UNDERLYINGS_ = "Target Underlying"; dao.FIXING_FLAG_ = "TRUE"; //dao.OBSERVATION_END_DATE_ = dao.EVENT_DATE_; dao.EVENT_DESCRIPTION_ = this.description(); }
public override void bookingDetailEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { //dao.EVENT_AMOUNT_ = Convert.ToDouble(masterInformationViewModel.RemainNotional_) // * Convert.ToDouble( this.fixedRate_ ) * this.yearFraction_; dao.EVENT_AMOUNT_ = "97854673"; dao.FIXING_UNDERLYINGS_ = ""; dao.FIXING_FLAG_ = "TRUE"; //dao.OBSERVATION_END_DATE_ = dao.EVENT_DATE_; dao.EVENT_DESCRIPTION_ = this.description(); }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_.bookingEvent(masterInformationViewModel, dao); //dao.EVENT_AMOUNT_ = generalScheduleDeatilViewModel_.InitialFixingAmount_; //dao.FIXING_UNDERLYINGS_ = generalScheduleDeatilViewModel_.FixingUnderlying_; //dao.FIXING_FLAG_ = generalScheduleDeatilViewModel_.InitialFixingFlag_; dao.ITEM_CODE_ = masterInformationViewModel.Item_code_; dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; dao.ITEM_NAME_ = masterInformationViewModel.Item_name_; dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; }
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 void dbInsert() { // bussiness logic here EVENT_INFO_Table_DAO insertDao = new EVENT_INFO_Table_DAO(); insertDao.EVENT_DATE_ = this.Event_date_.ToString("yyyyMMdd"); insertDao.EVENT_TYPE_ = this.Event_type_; insertDao.EVENT_SUBTYPE_ = this.Event_subtype_; insertDao.EVENT_DESCRIPTION_ = this.Event_description_; insertDao.EVENT_NAME_ = this.Event_name_; insertDao.CURRENCY_ = this.Currency_; insertDao.EVENT_AMOUNT_ = this.Event_amount_; insertDao.FIXING_UNDERLYINGS_ = this.Fixing_underlyings_; insertDao.FIXING_FLAG_ = this.Fixing_flag_; insertDao.ITEM_CODE_ = this.Item_code_; insertDao.ITEM_TYPE_ = this.Item_type_; insertDao.ITEM_NAME_ = this.Item_name_; insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_; insertDao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { { EVENT_INFO_Table_DAO daoFirst = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_[0].bookingEvent(masterInformationViewModel, daoFirst); daoFirst.ITEM_CODE_ = masterInformationViewModel.Item_code_; daoFirst.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; daoFirst.ITEM_NAME_ = masterInformationViewModel.Item_name_; daoFirst.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; } { EVENT_INFO_Table_DAO daoSecond = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_[0].bookingEvent(masterInformationViewModel, daoSecond); daoSecond.ITEM_CODE_ = masterInformationViewModel.Item_code_; daoSecond.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; daoSecond.ITEM_NAME_ = masterInformationViewModel.Item_name_; daoSecond.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; } }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.CALCULATION_TYPE_ = "fixedCoupon"; dao.EVENT_AMOUNT_ = "unCalculated"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_DESCRIPTION_ = "fixed coupon description"; dao.EVENT_NAME_ = "fixed coupon name"; dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_= "fixed_interest"; //dao.EXPIRED_FLAG_ = "false"; dao.FIXING_FLAG_ = "true"; dao.FIXING_OBSERVATION_ = "undefined"; dao.FIXING_UNDERLYINGS_ = ""; dao.FLOATING_FLAG_ = "false"; //dao.NOTIONAL_ = this.excel_issueInfoViewModel_.Notional_; //dao.REMAIN_NOTIONAL_ = "undefined"; }
public void buildDAO() { // bussiness logic here EVENT_INFO_Table_DAO insertDao = new EVENT_INFO_Table_DAO(); insertDao.EVENT_CODE_ = this.Event_code_; insertDao.EVENT_DATE_ = this.Event_date_.ToString("yyyyMMdd"); insertDao.EVENT_TYPE_ = this.Event_type_; insertDao.EVENT_SUBTYPE_ = this.Event_subtype_; insertDao.EVENT_NAME_ = this.Event_name_; insertDao.EVENT_DESCRIPTION_ = this.Event_description_; insertDao.CURRENCY_ = this.Currency_; insertDao.NOTIONAL_ = this.Notional_; insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_; insertDao.EVENT_AMOUNT_ = this.Event_amount_; insertDao.COUNTERPARTY_ = this.Counterparty_; insertDao.FLOATING_FLAG_ = this.Floating_flag_; insertDao.CALCULATION_TYPE_ = this.Calculation_type_; insertDao.FIXING_UNDERLYINGS_ = this.Fixing_underlyings_; insertDao.FIXING_OBSERVATION_ = this.Fixing_observation_; insertDao.FIXING_FLAG_ = this.Fixing_flag_; insertDao.EXPIRED_FLAG_ = this.Expired_flag_; insertDao.ITEM_CODE_ = this.Item_code_; insertDao.ITEM_TYPE_ = this.Item_type_; insertDao.ITEM_NAME_ = this.Item_name_; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.CALCULATION_TYPE_ = "vanilla floating Coupon"; dao.EVENT_AMOUNT_ = "unCalculated"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_DESCRIPTION_ = "floating coupon description"; dao.EVENT_NAME_ = "floating coupon name"; dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_ = "floating_interest"; //dao.EXPIRED_FLAG_ = "false"; dao.FIXING_FLAG_ = "need calculation"; dao.FIXING_OBSERVATION_ = "undefined"; foreach (var item in excel_underlyingCalcIDViewModel_.Excel_selectedUnderlyingViewModel_) { if (item.Checked_) { dao.FIXING_UNDERLYINGS_ = item.NameTrans_.Value_ + ";"; } } dao.FLOATING_FLAG_ = "true"; //dao.NOTIONAL_ = this.excel_issueInfoViewModel_.Notional_; //dao.REMAIN_NOTIONAL_ = "undefined"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.EVENT_TYPE_ = "multiAssetcompositeOptionSubTypeTest"; dao.EVENT_NAME_ = "multi_vanillaCallPut"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.EVENT_TYPE_ = "compositeOptionSubTypeTest"; dao.EVENT_NAME_ = "upInOutCall"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { { EVENT_INFO_Table_DAO daoFirst = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_[0].bookingEvent(masterInformationViewModel, daoFirst); daoFirst.ITEM_CODE_ = masterInformationViewModel.Item_code_; daoFirst.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; daoFirst.ITEM_NAME_ = masterInformationViewModel.Item_name_; daoFirst.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; } { EVENT_INFO_Table_DAO daoSecond = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_[0].bookingEvent(masterInformationViewModel, daoSecond); daoSecond.ITEM_CODE_ = masterInformationViewModel.Item_code_; daoSecond.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; daoSecond.ITEM_NAME_ = masterInformationViewModel.Item_name_; daoSecond.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; } }
public void dbInsert() { // bussiness logic here EVENT_INFO_Table_DAO insertDao = new EVENT_INFO_Table_DAO(); insertDao.EVENT_DATE_ = this.Event_date_.ToString("yyyyMMdd"); insertDao.EVENT_TYPE_ = this.Event_type_; insertDao.EVENT_SUBTYPE_ = this.Event_subtype_; insertDao.EVENT_DESCRIPTION_ = this.Event_description_; insertDao.EVENT_NAME_ = this.Event_name_; insertDao.CURRENCY_ = this.Currency_; insertDao.EVENT_AMOUNT_ = this.Event_amount_; insertDao.FIXING_UNDERLYINGS_ = this.Fixing_underlyings_; insertDao.FIXING_FLAG_ = this.Fixing_flag_; insertDao.ITEM_CODE_ = this.Item_code_; insertDao.ITEM_TYPE_ = this.Item_type_; insertDao.ITEM_NAME_ = this.Item_name_; insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_; insertDao.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 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 override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { throw new NotImplementedException(); }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.EVENT_TYPE_ = "compositeOptionSubTypeTest"; dao.EVENT_NAME_ = "vanillaCallPut"; }
public void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.EVENT_DATE_ = this.paymentDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_TYPE_ = "Settlement"; dao.EVENT_SUBTYPE_ = "Pay"; //dao.EVENT_DESCRIPTION_ = this.description_; dao.EVENT_NAME_ = "FxExchange"; dao.CURRENCY_ = this.targetCurrency_.CurrencyCode_; ////dao.OBSERVATION_END_DATE_ = this.calculationDate_.ToString(StringFormat.DbDateFormat_); ////dao.OBSERVATION_END_DATE_ = this.calculationDate_.ToString(StringFormat.DbDateFormat_); }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.CALCULATION_TYPE_ = "fixedCoupon"; dao.EVENT_AMOUNT_ = "unCalculated"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_DESCRIPTION_ = "fixed coupon description"; dao.EVENT_NAME_ = "fixed coupon name"; dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_ = "fixed_interest"; //dao.EXPIRED_FLAG_ = "false"; dao.FIXING_FLAG_ = "true"; dao.FIXING_OBSERVATION_ = "undefined"; dao.FIXING_UNDERLYINGS_ = ""; dao.FLOATING_FLAG_ = "false"; //dao.NOTIONAL_ = this.excel_issueInfoViewModel_.Notional_; //dao.REMAIN_NOTIONAL_ = "undefined"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.EVENT_TYPE_ = "multiAssetcompositeOptionSubTypeTest"; dao.EVENT_NAME_ = "multi_upInOutCall"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { if (this.eventDAO_ == null) { //dao.EVENT_CODE_ = "testCode"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_ = "coupon"; dao.EVENT_NAME_ = "simple coupon"; dao.EVENT_DESCRIPTION_ = "simpleCalculation default"; //dao.CURRENCY_ = item[6].ToString(); //dao.NOTIONAL_ = item[7].ToString(); //dao.REMAIN_NOTIONAL_ = item[8].ToString(); dao.EVENT_AMOUNT_ = ""; //dao.COUNTERPARTY_ = item[10].ToString(); dao.FLOATING_FLAG_ = "true"; dao.CALCULATION_TYPE_ = "simpleCalculation"; foreach (var item in this.excel_underlyingCalcInfoViewModel_.Excel_underlyingInfoViewModel_) { dao.FIXING_UNDERLYINGS_ += item.NameTrans_.Value_ + " ; "; } dao.FIXING_OBSERVATION_ = "empty"; dao.FIXING_FLAG_ = "false"; dao.EXPIRED_FLAG_ = "false"; //dao.ITEM_CODE_ = item[17].ToString(); //dao.ITEM_TYPE_ = item[18].ToString(); //dao.ITEM_NAME_ = item[19].ToString(); } }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { if (this.eventDAO_ == null) { //dao.EVENT_CODE_ = "testCode"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_ = "coupon"; dao.EVENT_NAME_ = "simple coupon"; dao.EVENT_DESCRIPTION_ = "simpleCalculation default"; //dao.CURRENCY_ = item[6].ToString(); //dao.NOTIONAL_ = item[7].ToString(); //dao.REMAIN_NOTIONAL_ = item[8].ToString(); dao.EVENT_AMOUNT_ = ""; //dao.COUNTERPARTY_ = item[10].ToString(); dao.FLOATING_FLAG_ = "true"; dao.CALCULATION_TYPE_ = "simpleCalculation"; foreach (var item in this.excel_underlyingCalcInfoViewModel_.Excel_underlyingInfoViewModel_) { dao.FIXING_UNDERLYINGS_ += item.NameTrans_.Value_ + " ; "; } dao.FIXING_OBSERVATION_ = "empty"; dao.FIXING_FLAG_ = "false"; dao.EXPIRED_FLAG_ = "false"; //dao.ITEM_CODE_ = item[17].ToString(); //dao.ITEM_TYPE_ = item[18].ToString(); //dao.ITEM_NAME_ = item[19].ToString(); } }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO(); this.fx_exchangeLegViewModel_.bookingEvent(masterInformationViewModel, dao); //dao.EVENT_AMOUNT_ = generalScheduleDeatilViewModel_.InitialFixingAmount_; //dao.FIXING_UNDERLYINGS_ = generalScheduleDeatilViewModel_.FixingUnderlying_; //dao.FIXING_FLAG_ = generalScheduleDeatilViewModel_.InitialFixingFlag_; dao.ITEM_CODE_ = masterInformationViewModel.Item_code_; dao.ITEM_TYPE_ = masterInformationViewModel.Booking_type_; dao.ITEM_NAME_ = masterInformationViewModel.Item_name_; dao.REMAIN_NOTIONAL_ = masterInformationViewModel.Remain_notional_; }
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); } }
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 bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { throw new NotImplementedException(); }
public void setFromDAO(EVENT_INFO_Table_DAO dao) { // bussiness logic here try { this.event_code_ = dao.EVENT_CODE_; this.Event_date_ = DateTime.ParseExact(dao.EVENT_DATE_, "yyyyMMdd", null); this.event_type_ = dao.EVENT_TYPE_; this.event_subtype_ = dao.EVENT_SUBTYPE_; this.event_name_ = dao.EVENT_NAME_; this.event_description_ = dao.EVENT_DESCRIPTION_; this.currency_ = dao.CURRENCY_; this.notional_ = dao.NOTIONAL_; this.remain_notional_ = dao.REMAIN_NOTIONAL_; this.event_amount_ = dao.EVENT_AMOUNT_; this.counterparty_ = dao.COUNTERPARTY_; this.floating_flag_ = dao.FLOATING_FLAG_; this.calculation_type_ = dao.CALCULATION_TYPE_; this.fixing_underlyings_ = dao.FIXING_UNDERLYINGS_; this.fixing_observation_ = dao.FIXING_OBSERVATION_; this.fixing_flag_ = dao.FIXING_FLAG_; this.expired_flag_ = dao.EXPIRED_FLAG_; this.item_code_ = dao.ITEM_CODE_; this.item_type_ = dao.ITEM_TYPE_; this.item_name_ = dao.ITEM_NAME_; } catch (Exception ) { //OutputLogViewModel.addResult("event dao : " + e.Message + " " + item_code_ + " " + item_name_); } }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao) { dao.CALCULATION_TYPE_ = "vanilla floating Coupon"; dao.EVENT_AMOUNT_ = "unCalculated"; dao.EVENT_DATE_ = this.eventDate_.ToString(StringFormat.DbDateFormat_); dao.EVENT_DESCRIPTION_ = "floating coupon description"; dao.EVENT_NAME_ = "floating coupon name"; dao.EVENT_TYPE_ = "payment"; dao.EVENT_SUBTYPE_ = "floating_interest"; //dao.EXPIRED_FLAG_ = "false"; dao.FIXING_FLAG_ = "need calculation"; dao.FIXING_OBSERVATION_ = "undefined"; foreach (var item in excel_underlyingCalcIDViewModel_.Excel_selectedUnderlyingViewModel_) { if (item.Checked_) { dao.FIXING_UNDERLYINGS_ = item.NameTrans_.Value_ + ";"; } } dao.FLOATING_FLAG_ = "true"; //dao.NOTIONAL_ = this.excel_issueInfoViewModel_.Notional_; //dao.REMAIN_NOTIONAL_ = "undefined"; }
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO(); foreach (var item in this.excel_compositeOption_subtypeViewModelList_) { 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 abstract void bookingEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao);
public override void bookingEvent(MasterInformationViewModel masterInformationViewModel) { //this.excel_vanillaFloatingCouponScheduleListViewModel_.bookingEvent(masterInformationViewModel); foreach (var item in this.excel_vanillaFloatingCouponScheduleListViewModel_.Excel_vanillaFloatingCouponScheduleViewModel_) { 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 abstract void bookingDetailEvent(MasterInformationViewModel masterInformationViewModel, EVENT_INFO_Table_DAO dao);
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")); }