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);
}
