public override void setFromSerial(FpmlSerializedCSharp.ISerialized serial_Class)
{
FpmlSerializedCSharp.Excel_couponSchedule serial_Excel_couponSchedule = serial_Class as FpmlSerializedCSharp.Excel_couponSchedule;
FpmlSerializedCSharp.Excel_multiCondi_multiRng_structuredAccrualCouponSchedule serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule = serial_Excel_couponSchedule.Excel_multiCondi_multiRng_structuredAccrualCouponSchedule_;
this.eventDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.EventDate_.ValueStr);
this.payoffDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.PayoffDate_.ValueStr);
this.calculationStartDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.CalculationStartDate_.ValueStr);
this.calculationEndDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.CalculationEndDate_.ValueStr);
this.description_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Description_.ValueStr;
this.vba_description_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Vba_description_.ValueStr;
List <FpmlSerializedCSharp.Excel_multi_rangeND> serial_excel_multi_rangeND = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Excel_multi_rangeND_;
this.excel_multi_rangeNDViewModel_ = new ObservableCollection <Excel_multi_rangeNDViewModel>();
foreach (var item in serial_excel_multi_rangeND)
{
string type = item.Excel_type_.ValueStr;
Excel_multi_rangeNDViewModel viewModel = Excel_multi_rangeNDViewModel.CreateExcel_multi_rangeND(type);
viewModel.setFromSerial(item);
this.excel_multi_rangeNDViewModel_.Add(viewModel);
}
List <FpmlSerializedCSharp.Excel_returnCalcInfo> serial_excel_returnCalcInfo = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Excel_returnCalcInfo_;
this.excel_returnCalcInfoViewModel_ = new ObservableCollection <Excel_returnCalcInfoViewModel>();
foreach (var item in serial_excel_returnCalcInfo)
{
string type = item.Excel_type_.ValueStr;
Excel_returnCalcInfoViewModel viewModel = Excel_returnCalcInfoViewModel.CreateExcel_returnCalcInfo(type);
viewModel.setFromSerial(item);
this.excel_returnCalcInfoViewModel_.Add(viewModel);
}
this.dayCounter_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.DayCounter_.ValueStr;
this.detailScheduleType_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.DetailScheduleType_.ValueStr;
}
public override void setFromSerial(FpmlSerializedCSharp.ISerialized serial_Class)
{
FpmlSerializedCSharp.Excel_couponSchedule serial_Excel_couponSchedule = serial_Class as FpmlSerializedCSharp.Excel_couponSchedule;
FpmlSerializedCSharp.Excel_multiCondi_multiRng_structuredAccrualCouponSchedule serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule = serial_Excel_couponSchedule.Excel_multiCondi_multiRng_structuredAccrualCouponSchedule_;
base.setFromSerial(serial_Excel_couponSchedule.Excel_additionalOption_);
this.eventDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.EventDate_.ValueStr);
this.payoffDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.PayoffDate_.ValueStr);
this.calculationStartDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.CalculationStartDate_.ValueStr);
this.calculationEndDate_ = StringConverter.xmlDateToDateTime(serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.CalculationEndDate_.ValueStr);
this.description_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Description_.ValueStr;
this.vba_description_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Vba_description_.ValueStr;
List<FpmlSerializedCSharp.Excel_multi_rangeND> serial_excel_multi_rangeND = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Excel_multi_rangeND_;
this.excel_multi_rangeNDViewModel_ = new ObservableCollection<Excel_multi_rangeNDViewModel>();
foreach (var item in serial_excel_multi_rangeND)
{
Excel_multi_rangeNDViewModel viewModel = new Excel_multi_rangeNDViewModel();
viewModel.setFromSerial(item);
this.excel_multi_rangeNDViewModel_.Add(viewModel);
}
List<FpmlSerializedCSharp.Excel_returnCalcInfo> serial_excel_returnCalcInfo = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.Excel_returnCalcInfo_;
this.excel_returnCalcInfoViewModel_ = new ObservableCollection<Excel_returnCalcInfoViewModel>();
foreach (var item in serial_excel_returnCalcInfo)
{
string type = item.Excel_type_.ValueStr;
Excel_returnCalcInfoViewModel viewModel = Excel_returnCalcInfoViewModel.CreateExcel_returnCalcInfo(type);
viewModel.setFromSerial(item);
this.excel_returnCalcInfoViewModel_.Add(viewModel);
}
this.dayCounter_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.DayCounter_.ValueStr;
this.detailScheduleType_ = serial_Excel_multiCondi_multiRng_structuredAccrualCouponSchedule.DetailScheduleType_.ValueStr;
}
public string addSingleConditionDualRangAccrualFixedCoupon(DateTime calculationStartDate,
DateTime calculationEndDate,
DateTime payoffDate,
List<double> lowerRngList,
List<string> referenceUnderCodeList,
List<double> upperRngList,
double fixedRate)
{
try
{
#region CheckParameter
if (calculationStartDate >= calculationEndDate)
throw new Exception("startDate must be earlier than endDate");
//// check underlying
//if ( !this.hasUnderlyings(underlyings))
// throw new Exception(underlyings + " does not exist. add underlying first.");
#endregion
Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel e_mc_mr_sacsvm
= new Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel();
e_mc_mr_sacsvm.EventDate_ = payoffDate;
e_mc_mr_sacsvm.CalculationStartDate_ = calculationStartDate;
e_mc_mr_sacsvm.CalculationEndDate_ = calculationEndDate;
e_mc_mr_sacsvm.PayoffDate_ = payoffDate;
int rangeCount = lowerRngList.Count;
Excel_multi_rangeNDViewModel e_m_rngNDVM = new Excel_multi_rangeNDViewModel();
for (int i = 0; i < rangeCount; i++)
{
Range1DViewModel accRng1D = new Range1DViewModel();
accRng1D.LowerBound_ = lowerRngList[i].ToString();
DateTime effDate = this.InstVM_.Excel_interfaceViewModel_.Excel_issueInfoViewModel_.EffectiveDate_;
//this.addUnderlying(Excel_loaderViewModel.loadUnderInfo2(effDate, referenceUnderCodeList[i]));
this.addUnderlying(referenceUnderCodeList[i]);
Excel_choiceUnderlyingCalcIDViewModel choiceUnderCalcIDVM = new Excel_choiceUnderlyingCalcIDViewModel();
choiceUnderCalcIDVM.EventDate_ = payoffDate;
Excel_selectedUnderlyingViewModel selectedUnder = new Excel_selectedUnderlyingViewModel();
selectedUnder.Code_ = referenceUnderCodeList[i];
selectedUnder.NameTrans_ = new NameTrans(referenceUnderCodeList[i]);
selectedUnder.Checked_ = true;
choiceUnderCalcIDVM.Excel_selectedUnderlyingViewModel_.Add(selectedUnder);
accRng1D.UpperBound_ = upperRngList[i].ToString();
e_m_rngNDVM.Range1DViewModel_.Add(accRng1D);
e_m_rngNDVM.Excel_underlyingCalcIDViewModel_.Add(choiceUnderCalcIDVM);
}
e_mc_mr_sacsvm.Excel_multi_rangeNDViewModel_.Add(e_m_rngNDVM);
Excel_constReturnCalViewModel e_crcvm = new Excel_constReturnCalViewModel();
e_crcvm.ConstReturn_ = fixedRate.ToString();
e_mc_mr_sacsvm.Excel_returnCalcInfoViewModel_.Add(e_crcvm);
//e_mc_sacsvm.FixedRate_ = fixedRate.ToString();
Excel_structuredBondViewModel e_sbvm = this.InstVM_.Excel_interfaceViewModel_ as Excel_structuredBondViewModel;
e_sbvm.Excel_couponScheduleListViewModel_.Excel_couponScheduleViewModel_.Add(e_mc_mr_sacsvm);
//this.instVM_.Excel_interfaceViewModel_ = e_sbvm;
return "OK";
}
catch (Exception)
{
return "singleConditionDualRangAccrualFixedCoupon Add Fail";
}
}
public void addSingleConditionDualRangAccrualFixedCoupon(DateTime calculationStartDate,
DateTime calculationEndDate,
DateTime payoffDate,
List<double> lowerRngList,
List<string> referenceUnderCodeList,
List<double> upperRngList,
double fixedRate)
{
Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel e_mc_mr_sacsvm
= new Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel();
e_mc_mr_sacsvm.EventDate_ = payoffDate;
e_mc_mr_sacsvm.CalculationStartDate_ = calculationStartDate;
e_mc_mr_sacsvm.CalculationEndDate_ = calculationEndDate;
e_mc_mr_sacsvm.PayoffDate_ = payoffDate;
int rangeCount = lowerRngList.Count;
Excel_multi_rangeNDViewModel e_m_rngNDVM = new Excel_multi_rangeNDViewModel();
for (int i = 0; i < rangeCount; i++)
{
Range1DViewModel accRng1D = new Range1DViewModel();
accRng1D.LowerBound_ = lowerRngList[i].ToString();
DateTime effDate = this.instVM_.Excel_interfaceViewModel_.Excel_issueInfoViewModel_.EffectiveDate_;
//this.addUnderlying(Excel_loaderViewModel.loadUnderInfo2(effDate, referenceUnderCodeList[i]));
this.addUnderlying(effDate, referenceUnderCodeList[i]);
Excel_choiceUnderlyingCalcIDViewModel choiceUnderCalcIDVM = new Excel_choiceUnderlyingCalcIDViewModel();
choiceUnderCalcIDVM.EventDate_ = payoffDate;
Excel_selectedUnderlyingViewModel selectedUnder = new Excel_selectedUnderlyingViewModel();
selectedUnder.Code_ = referenceUnderCodeList[i];
selectedUnder.NameTrans_ = new NameTrans(referenceUnderCodeList[i]);
selectedUnder.Checked_ = true;
choiceUnderCalcIDVM.Excel_selectedUnderlyingViewModel_.Add(selectedUnder);
accRng1D.UpperBound_ = upperRngList[i].ToString();
e_m_rngNDVM.Range1DViewModel_.Add(accRng1D);
e_m_rngNDVM.Excel_underlyingCalcIDViewModel_.Add(choiceUnderCalcIDVM);
}
e_mc_mr_sacsvm.Excel_multi_rangeNDViewModel_.Add(e_m_rngNDVM);
Excel_constReturnCalViewModel e_crcvm = new Excel_constReturnCalViewModel();
e_crcvm.ConstReturn_ = fixedRate.ToString();
e_mc_mr_sacsvm.Excel_returnCalcInfoViewModel_.Add(e_crcvm);
//e_mc_sacsvm.FixedRate_ = fixedRate.ToString();
Excel_structuredBondViewModel e_sbvm = this.instVM_.Excel_interfaceViewModel_ as Excel_structuredBondViewModel;
e_sbvm.Excel_couponScheduleListViewModel_.Excel_couponScheduleViewModel_.Add(e_mc_mr_sacsvm);
//this.instVM_.Excel_interfaceViewModel_ = e_sbvm;
}
public void addSingleConditionDualRangAccrualFixedCoupon(DateTime calculationStartDate,
DateTime calculationEndDate,
DateTime payoffDate,
List <double> lowerRngList,
List <string> referenceUnderCodeList,
List <double> upperRngList,
double fixedRate)
{
Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel e_mc_mr_sacsvm
= new Excel_multiCondi_multiRng_structuredAccrualCouponScheduleViewModel();
e_mc_mr_sacsvm.EventDate_ = payoffDate;
e_mc_mr_sacsvm.CalculationStartDate_ = calculationStartDate;
e_mc_mr_sacsvm.CalculationEndDate_ = calculationEndDate;
e_mc_mr_sacsvm.PayoffDate_ = payoffDate;
int rangeCount = lowerRngList.Count;
Excel_multi_rangeNDViewModel e_m_rngNDVM = new Excel_multi_rangeNDViewModel();
for (int i = 0; i < rangeCount; i++)
{
Range1DViewModel accRng1D = new Range1DViewModel();
accRng1D.LowerBound_ = lowerRngList[i].ToString();
DateTime effDate = this.instVM_.Excel_interfaceViewModel_.Excel_issueInfoViewModel_.EffectiveDate_;
//this.addUnderlying(Excel_loaderViewModel.loadUnderInfo2(effDate, referenceUnderCodeList[i]));
this.addUnderlying(effDate, referenceUnderCodeList[i]);
Excel_choiceUnderlyingCalcIDViewModel choiceUnderCalcIDVM = new Excel_choiceUnderlyingCalcIDViewModel();
choiceUnderCalcIDVM.EventDate_ = payoffDate;
Excel_selectedUnderlyingViewModel selectedUnder = new Excel_selectedUnderlyingViewModel();
selectedUnder.Code_ = referenceUnderCodeList[i];
selectedUnder.NameTrans_ = new NameTrans(referenceUnderCodeList[i]);
selectedUnder.Checked_ = true;
choiceUnderCalcIDVM.Excel_selectedUnderlyingViewModel_.Add(selectedUnder);
accRng1D.UpperBound_ = upperRngList[i].ToString();
e_m_rngNDVM.Range1DViewModel_.Add(accRng1D);
e_m_rngNDVM.Excel_underlyingCalcIDViewModel_.Add(choiceUnderCalcIDVM);
}
e_mc_mr_sacsvm.Excel_multi_rangeNDViewModel_.Add(e_m_rngNDVM);
Excel_constReturnCalViewModel e_crcvm = new Excel_constReturnCalViewModel();
e_crcvm.ConstReturn_ = fixedRate.ToString();
e_mc_mr_sacsvm.Excel_returnCalcInfoViewModel_.Add(e_crcvm);
//e_mc_sacsvm.FixedRate_ = fixedRate.ToString();
Excel_structuredBondViewModel e_sbvm = this.instVM_.Excel_interfaceViewModel_ as Excel_structuredBondViewModel;
e_sbvm.Excel_couponScheduleListViewModel_.Excel_couponScheduleViewModel_.Add(e_mc_mr_sacsvm);
//this.instVM_.Excel_interfaceViewModel_ = e_sbvm;
}
