private void AddTypeButton_Click(object sender, EventArgs e) { if (ValidateInvestmentType()) { try { InvestmentType type = new InvestmentType() { InvName = this.TypeNameTextBox.Text }; type = SqlConnector.CreateInvestmentType(type); availableInvestmentTypes.Add(type); InitializeLists(); } catch (MySql.Data.MySqlClient.MySqlException) { MessageBox.Show("This investemnt type already exists", "Duplicate error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Incorret data! Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.TypeNameTextBox.Text = ""; }
private void CreateInvestmentbutton_Click(object sender, EventArgs e) { if (ValidateInvestment()) { try { Investment investment = new Investment(); investment.InvName = this.NameTextBox.Text; InvestmentType t = (InvestmentType)this.InvestemntTypeComboBox.SelectedItem; investment.IdInvestmentType = t.IdInvestmentType; investment.DataSource = this.DataSourceTextBox.Text; Currency c = (Currency)this.CurrencyComboBox.SelectedItem; investment.IdCurrency = c.IdCurrency; investment.InitializeValue(); investment = SqlConnector.CreateInvestment(investment); availableInvestments.Add(investment); InitializeLists(); } catch (MySql.Data.MySqlClient.MySqlException) { MessageBox.Show("This investemnt already exists", "Duplicate error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Incorret data! Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.NameTextBox.Text = ""; this.DataSourceTextBox.Text = ""; this.InvestemntTypeComboBox.SelectedItem = ""; }
public static InvestmentType CreateInvestmentType(InvestmentType investemntType) { using (IDbConnection connection = new MySqlConnection(GetConnectionString(ConnectionName))) { var p = new DynamicParameters(); p.Add("invName", investemntType.InvName); p.Add("id", 0, DbType.Int32, ParameterDirection.Output); connection.Execute("addInvestmentType", p, commandType: CommandType.StoredProcedure); investemntType.IdInvestmentType = p.Get <int>("id"); return(investemntType); } }