private void WithdrawalButton_Click(object sender, EventArgs e) { if (ValidateTextBox()) { String name = (String)this.CurrentInvestmentsDataGridView.CurrentRow.Cells["Name"].Value; Investment selectedInvestment = SqlConnector.GetInvestment(name); UserInvestment ui = SqlConnector.GetUserInvestment(user.idUser, selectedInvestment.IdInvestment); double tempVal = Double.Parse(this.ValueToWithdrawTextBox.Text); if (ui.ValuePLN == tempVal) { SqlConnector.FinishInvestment(ui.IdUserInvestment); } else if (tempVal > 0 && tempVal < ui.ValuePLN) { double am = tempVal / selectedInvestment.Value; SqlConnector.AddHistoryInvestment(ui, tempVal, am); SqlConnector.WithdrawPartOfInvestment(ui.IdUserInvestment, tempVal); } else { MessageBox.Show("Incorret data! Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } InitializeList(); } else { MessageBox.Show("Incorret data! Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void UpdateDifference(UserInvestment ui) { using (IDbConnection connection = new MySqlConnection(GetConnectionString(ConnectionName))) { var p = new DynamicParameters(); p.Add("id", ui.idUser); p.Add("investmentID", ui.IdInvestment); p.Add("amount", ui.Amount); connection.Execute("updateDifference", p, commandType: CommandType.StoredProcedure); } }
public static void EditUserInvestment(UserInvestment ui) { using (IDbConnection connection = new MySqlConnection(GetConnectionString(ConnectionName))) { var p = new DynamicParameters(); p.Add("idInv", ui.IdInvestment); p.Add("valPLN", ui.ValuePurcharsed); p.Add("am", ui.Amount); p.Add("valP", ui.ValuePLN); connection.Execute("EditUserInvestment", p, commandType: CommandType.StoredProcedure); } }
public static void AddHistoryInvestment(UserInvestment ui, double vPLN, double am) { using (IDbConnection connection = new MySqlConnection(GetConnectionString(ConnectionName))) { var p = new DynamicParameters(); p.Add("idU", ui.idUser); p.Add("idInv", ui.IdInvestment); p.Add("valPLN", ui.ValuePLN); p.Add("fullAmount", ui.Amount); p.Add("valS", vPLN); p.Add("am", am); p.Add("dateP", ui.DatePurchased); connection.Execute("addHistoryInvestment", p, commandType: CommandType.StoredProcedure); } }
public static UserInvestment AddUserInvestment(UserInvestment UserInvestment) { using (IDbConnection connection = new MySqlConnection(GetConnectionString(ConnectionName))) { var p = new DynamicParameters(); p.Add("idUser", UserInvestment.idUser); p.Add("idInvestment", UserInvestment.IdInvestment); p.Add("datePurchased", UserInvestment.DatePurchased); p.Add("valPurchased", UserInvestment.ValuePurcharsed); p.Add("Amount", UserInvestment.Amount); p.Add("valPLN", UserInvestment.ValuePLN); p.Add("id", 0, DbType.Int32, ParameterDirection.Output); connection.Execute("addUserInvestment", p, commandType: CommandType.StoredProcedure); UserInvestment.IdUserInvestment = p.Get <int>("id"); return(UserInvestment); } }
private void AddInvestmentButton_Click(object sender, EventArgs e) { if (ValidateUserInvestment()) { try { Investment i = (Investment)this.NameComboBox.SelectedItem; UserInvestment ui = new UserInvestment(); ui.IdInvestment = i.IdInvestment; ui.idUser = this.user.idUser; ui.ValuePLN = Double.Parse(this.InvValueTextBox.Text); ui.ValuePurcharsed = Double.Parse(this.RateTextBox.Text); ui.Amount = Double.Parse(this.AmountTextBox.Text); ui.DatePurchased = this.InvestDateTimePicker.Value; if (!FindInvestment(i.IdInvestment)) { ui = SqlConnector.AddUserInvestment(ui); } else { SqlConnector.EditUserInvestment(ui); } } catch (Exception) { MessageBox.Show("Something went wrong", "Duplicate error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Incorret data! Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.InvValueTextBox.Text = ""; this.RateTextBox.Text = ""; this.AmountTextBox.Text = ""; this.InvestDateTimePicker.Value = DateTime.Today; }