private void ButtonSubmit_Click(object sender, EventArgs e) { TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook); Currency currency = new Currency(textBoxCurrency.Text); Fund newFund = new Fund(textBoxFundName.Text, textBoxIsin.Text, textBoxCustodyNr.Text, currency); tableUtility.CreateMissingTable(currency); tableUtility.CreateMissingTable(newFund); List <string> currencyData = new List <string>() { currency.IsoCode }; tableUtility.InsertTableRow(currency, currencyData); List <string> fundData = new List <string>() { newFund.Name, newFund.CustodyAccountNumber, newFund.Isin, currency.GetIndex().ToString() }; tableUtility.InsertTableRow(newFund, fundData); fundBindingSource.Add(newFund); }
public void OnSubmit(Country obj) { TableUtility tableUtility = new TableUtility(); tableUtility.InsertTableRow(obj); FormUtility.GetBindingSource(dataGridView).Add(obj); }
private void InitializeCustomComponents() { dataGridFunds = FormUtility.CreateDataGridView(typeof(Fund), 80, 580); ToolStripMenuItem itemDelete = FormUtility.CreateContextMenuItem("Löschen", DeleteFundClick); ToolStripMenuItem itemEditFund = FormUtility.CreateContextMenuItem("Fonds bearbeiten", EditFundClick); FormUtility.AddContextMenu(dataGridFunds, itemDelete, itemEditFund); FormUtility.GetBindingSource(dataGridFunds).Clear(); FormUtility.AddValidation(buttonSubmit, textBoxCurrency, () => { TableUtility tableUtility = new TableUtility(); List <Range> currencyRange = tableUtility.ReadTableRow(Currency.GetDefaultValue(), new Dictionary <string, string> { { "IsoCode", textBoxCurrency.Text.ToUpper() } }, QueryOperator.OR); if (currencyRange.Count == 0 || currencyRange.Count > 1) { return(false); } Currency currency = tableUtility.ConvertRangesToObjects <Currency>(currencyRange)[0]; Fund newFund = new Fund(textBoxFundName.Text, textBoxIsin.Text, textBoxCustodyNr.Text, currency); tableUtility.InsertTableRow(newFund); FormUtility.GetBindingSource(dataGridFunds).Add(newFund); return(true); }); FormUtility.AddControlsToForm(this, dataGridFunds); }
private void RowValidatedRatings(object sender, DataGridViewCellEventArgs e) { if (currentRatingAgency == null) { return; } TableUtility tableUtility = new TableUtility(); Rating newRating = dataGridViewRatingCodes.Rows[e.RowIndex].DataBoundItem as Rating; if (newRating == null) { return; } newRating.Agency = currentRatingAgency; if (newRating.Index == 0) { tableUtility.InsertTableRow(newRating); return; } if (currentRow == null) { return; } if (!currentRow.Equals(newRating)) { tableUtility.MergeTableRow(newRating); } }
/// <summary> /// Implementation of <see cref="IPassedObject{T}"/> /// /// Takes the newly created <see cref="DurationRecord"/>, persists it and adds it to the DataGridView. /// </summary> /// <param name="obj">Passed DurationRecord</param> public void OnSubmit(DurationRecord obj) { TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(DurationRecord.GetDefaultValue()); tableUtility.InsertTableRow(obj); FormUtility.GetBindingSource(dataGridView).Add(obj); }
public Rule InvokeSubmission(RuleKind ruleKind) { Rule rule = new Rule(ruleKind, textBoxName.Text); TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(rule); tableUtility.InsertTableRow(rule); return(rule); }
public void OnSubmit(List<string> passedValue, string reference) { TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook); RatingAgency ratingAgency = new RatingAgency(passedValue[0]); tableUtility.CreateMissingTable(RatingAgency.GetDefaultValue()); tableUtility.InsertTableRow(ratingAgency, new List<string> { passedValue[0] }); ratingAgencyBindingSource.Add(ratingAgency); }
private void AddCurrency(string currencyIsoCode) { TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(Currency.GetDefaultValue()); Currency currency = new Currency { IsoCode = currencyIsoCode }; tableUtility.InsertTableRow(currency); FormUtility.GetBindingSource(dataGridViewCurrencies).Add(currency); }
private void AddAssetClass(string assetClassName) { TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(AssetClass.GetDefaultValue()); AssetClass assetClass = new AssetClass { Name = assetClassName }; tableUtility.InsertTableRow(assetClass); FormUtility.GetBindingSource(dataGridViewAssetClasses).Add(assetClass); }
public void OnSubmit(List <string> passedValue, string reference) { dataGridViewRatingAgencies.ClearSelection(); TableUtility tableUtility = new TableUtility(); RatingAgency ratingAgency = new RatingAgency(passedValue[0]); tableUtility.InsertTableRow(ratingAgency); int index = FormUtility.GetBindingSource(dataGridViewRatingAgencies).Add(ratingAgency); dataGridViewRatingAgencies.Rows[index].Selected = true; currentRatingAgency = ratingAgency; ratingAgenciesRowIndex = index; LoadRatings(ratingAgenciesRowIndex); }
private bool MergeAssetAllocation() { TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(AssetAllocationEntry.GetDefaultValue()); CalcTotals(); if (totalRow != 100 || totalCol != 100) { MessageBox.Show("Gesamttotal muss 100% sein."); return(false); } for (int col = 1; col < tableLayoutPanelAA.ColumnCount - 1; col++) { for (int row = 1; row < tableLayoutPanelAA.RowCount - 1; row++) { FlowLayoutPanel panel = tableLayoutPanelAA.GetControlFromPosition(col, row) as FlowLayoutPanel; double[] assetAllocationRange = new double[3]; for (int i = 0; i < 3; i++) { bool parsingSuccessful = double.TryParse(panel.Controls[i].Text, out double value); if (!parsingSuccessful) { value = 0; } assetAllocationRange[i] = value; } try { AssetAllocationEntry entry = panel.DataBindings[0].DataSource as AssetAllocationEntry; tableUtility.MergeTableRow(entry); } catch (ArgumentOutOfRangeException) { AssetAllocationEntry assetAllocationEntry = new AssetAllocationEntry { AssetClass = tableLayoutPanelAA.GetControlFromPosition(col, 0).DataBindings[0].DataSource as AssetClass, Currency = tableLayoutPanelAA.GetControlFromPosition(0, row).DataBindings[0].DataSource as Currency, StrategicMinValue = assetAllocationRange[0], StrategicOptValue = assetAllocationRange[1], StrategicMaxValue = assetAllocationRange[2], Fund = fund }; tableUtility.InsertTableRow(assetAllocationEntry); } } } return(true); }
private void AddCurrency(string currencyIsoCode) { TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook); tableUtility.CreateMissingTable(Currency.GetDefaultValue()); Currency currency = new Currency { IsoCode = currencyIsoCode }; tableUtility.InsertTableRow(currency, new List <string>() { currency.IsoCode }); currencyBindingSource.Add(currency); }
private void AddAssetClass(string assetClassName) { TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook); tableUtility.CreateMissingTable(AssetClass.GetDefaultValue()); AssetClass assetClass = new AssetClass { Name = assetClassName }; tableUtility.InsertTableRow(assetClass, new List <string>() { assetClass.Name }); assetClassBindingSource.Add(assetClass); }
public void OnSubmit(List <string> passedValue = null, string reference = null) { TableUtility tableUtility = new TableUtility(); switch (reference) { case "asset_kind": tableUtility.CreateTable(AssetKind.GetDefaultValue()); AssetKind newAssetKind = new AssetKind(passedValue[0]); tableUtility.InsertTableRow(newAssetKind); FormUtility.GetBindingSource(dataGridView).Add(newAssetKind); break; case "asset_kind_edit": selectedAssetKind.Description = passedValue[0]; tableUtility.MergeTableRow(selectedAssetKind); break; } }
public Rule InvokeSubmission(RuleKind ruleKind) { if (passedRule != null) { passedRule.Name = ruleName.Text; BindingList <AssetKind> changedBanList = (BindingList <AssetKind>)FormUtility.GetBindingSource(dataGridView).List; passedRule.Banned = changedBanList.ToList(); return(passedRule); } BanList <AssetKind> newBanList = new BanList <AssetKind>(RuleKind.RESTRICTED_INSTRUMENT_TYPE, ruleName.Text); foreach (DataGridViewRow row in dataGridView.Rows) { newBanList.Banned.Add(row.DataBoundItem as AssetKind); } TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(newBanList); tableUtility.InsertTableRow(newBanList); return(newBanList); }
/// <summary> /// Implementation of <see cref="IRuleUserControl"/> /// </summary> /// <param name="ruleKind">Selected <see cref="RuleKind"/></param> /// <returns>Newly created rule, in that case an <see cref="AllowList"/></returns> public Rule InvokeSubmission(RuleKind ruleKind) { if (passedRule != null) { passedRule.Name = ruleName.Text; BindingList <Asset> changedAllowList = (BindingList <Asset>)FormUtility.GetBindingSource(dataGridView).List; passedRule.Allowed = changedAllowList.ToList(); return(passedRule); } AllowList newAllowList = new AllowList(RuleKind.RULE_EXCEPTION, ruleName.Text); foreach (DataGridViewRow row in dataGridView.Rows) { newAllowList.Allowed.Add(row.DataBoundItem as Asset); } TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(newAllowList); tableUtility.InsertTableRow(newAllowList); return(newAllowList); }
/// <summary> /// Implementation of <see cref="IRuleUserControl"/>. This method is called by the parent form /// for invoking the addition of a new rule. /// </summary> /// <param name="ruleKind"><see cref="RuleKind"/></param> /// <returns>New <see cref="Rule"/></returns> public Rule InvokeSubmission(RuleKind ruleKind) { bool parsingSuccessful = double.TryParse(textBoxValue.Text, out double value); if (!parsingSuccessful) { MessageBox.Show("Bitte eine gültige Zahl eingeben."); return(null); } if (passedRule != null) { passedRule.Name = textBoxDescription.Text; passedRule.NumericValue = value; return(passedRule); } TableUtility tableUtility = new TableUtility(); Rule newRule = new NumericRule(value, ruleKind, textBoxDescription.Text); tableUtility.CreateTable(newRule); tableUtility.InsertTableRow(newRule); return(newRule); }
private void RowValidatedRatings(object sender, DataGridViewCellEventArgs e) { if (currentRatingAgency == null) { return; } TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook); tableUtility.CreateMissingTable(Rating.GetDefaultValue()); Rating newRating = dataGridViewRatingCodes.Rows[e.RowIndex].DataBoundItem as Rating; if (newRating == null) { return; } if (newRating.Index == 0) { tableUtility.InsertTableRow(newRating, new List<string> { newRating.RatingCode, newRating.RatingNumericValue.ToString(), currentRatingAgency.Index.ToString() }); return; } if (!currentRow.RatingCode.Equals(newRating.RatingCode)) { TableUpdateWrapper update = new TableUpdateWrapper(currentRow.Index, "rating_code", newRating.RatingCode); tableUtility.UpdateTableRow(currentRow, update); } if (currentRow.RatingNumericValue != newRating.RatingNumericValue) { TableUpdateWrapper update = new TableUpdateWrapper(currentRow.Index, "numeric_value", newRating.RatingNumericValue.ToString()); tableUtility.UpdateTableRow(currentRow, update); } }
public Rule InvokeSubmission(RuleKind ruleKind) { bool parsingSuccessfulRatingClass = double.TryParse(textBoxRatingClass.Text, out double ratingClass); bool parsingSuccessfulNumericValue = double.TryParse(textBoxNumericValue.Text, out double numericValue); if (!parsingSuccessfulNumericValue || !parsingSuccessfulRatingClass) { MessageBox.Show("Bitte eine gültige Zahl eingeben."); return(null); } if (passedRule != null) { passedRule.Name = textBoxName.Text; passedRule.MaxRatio = numericValue; passedRule.RatingClass = ratingClass; return(passedRule); } RatingQuoteRule newRatingQuoteRule = new RatingQuoteRule(ratingClass, numericValue, RuleKind.MAX_RATING_RATIO, textBoxName.Text); TableUtility tableUtility = new TableUtility(); tableUtility.CreateTable(newRatingQuoteRule); tableUtility.InsertTableRow(newRatingQuoteRule); return(newRatingQuoteRule); }