public bool saveActivity(InvestorActivity activity) { DataSource dataSource = DataSource.instance; string query = "INSERT INTO investors_activity(id_investor,type_activity, amount, date, description) " + $"VALUES('{activity.idInvestor}','{activity.activity}'," + $"'{activity.amount}','{activity.date}','{activity.description}');"; bool success = dataSource.save(query); return(success); }
private void buttonInvest_Click(object sender, EventArgs e) { if (isInputOk(textBoxInvertir.Text)) { } string desc = getDescription(); int idInvestor = ((Investor)comboBoxInversores.SelectedItem).id; InvestorActivity activity = new InvestorActivity(idInvestor, model.enums.Activity.INVERSION , Int32.Parse(textBoxInvertir.Text), Utils.getCurrentDateTime(), desc); presenter.saveActivity(activity); }
public void saveActivity(InvestorActivity activity) { InvestorActivityDAO activityDao = new MySqlInvestorActivityDao(); bool success = activityDao.saveActivity(activity); if (success) { form.displayMessage("Activity saved successfully"); form.clearTextFields(); } else { form.displayMessage("Something went wrong, try again later"); } }
private InvestorActivity getActivity(MySqlDataReader data) { int id = (int)data["id"]; int idInvestor = (int)data["id_investor"]; string activityString = (string)data["type_activity"]; Activity activity = (Activity)Enum.Parse(typeof(Activity), activityString); string description = (string)data["description"]; string date = ((DateTime)data["date"]).ToString("dd/MM/yyyy HH:mm:ss"); int amount = (int)data["amount"]; InvestorActivity investorActivity = new InvestorActivity(id, activity, amount, date, description); investorActivity.id = id; return(investorActivity); }
public InvestorActivity getActivity(int activityId) { InvestorActivity activity = null; DataSource dataSource = DataSource.instance; string query = "SELECT * FROM investors_activity " + $"WHERE id = '{activityId}';"; MySqlDataReader data = dataSource.select(query); if (data.Read()) { activity = getActivity(data); } if (data != null) { data.Close(); } return(activity); }