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 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 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)
{
//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 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 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를 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 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"));
}