private void AddWalletBtn_Click(object sender, EventArgs e)
{
AddWalletForm frm = new AddWalletForm();
if (frm.ShowDialog(this) == DialogResult.OK)
{
WalletModel wallet = new WalletModel(frm.wallet);
string insertString = $"INSERT INTO wallets VALUES (" +
$"'{this.user.Username}'," +
$"'{wallet.WalletName}'," +
$"{wallet.Amount}," +
$"@ICON)";
try
{
Connection.Connect();
SqlCommand cmd = new SqlCommand(insertString, Connection.conn);
SqlParameter imageParameter = new SqlParameter("@ICON", SqlDbType.Image);
imageParameter.Value = wallet.Icon;
cmd.Parameters.Add(imageParameter);
cmd.ExecuteNonQuery();
Connection.Close();
WalletShowContent();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
private void WalletShowContent()
{
this.WalletContainer.Controls.Clear();
WalletContainer.AutoScroll = false;
WalletContainer.HorizontalScroll.Enabled = false;
WalletContainer.HorizontalScroll.Visible = false;
WalletContainer.HorizontalScroll.Maximum = 0;
WalletContainer.AutoScroll = true;
Connection.Connect();
SqlDataReader reader = Connection.Select($"SELECT * FROM wallets WHERE username = '******'");
try
{
while (reader.Read())
{
WalletModel wallet = new WalletModel((string)reader["walletName"],
(double)reader["amount"],
(byte[])reader["icon"]);
Wallet w = new Wallet();
w.WName = wallet.WalletName;
w.Amount = wallet.Amount;
w.Icon = wallet.Icon;
w.User = this.user;
w.MouseClick += ModifyWallet;
this.WalletContainer.Controls.Add(w);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Connection.Close();
}
private void SubmitBtn_Click(object sender, EventArgs e)
{
if (valid())
{
this.wallet = new WalletModel(this.WalletName.Text, (double)this.Amount.Value, ImageProccess.ImageToByte(icon));
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.None;
}
}
public WalletModel(WalletModel w)
{
this.walletName = w.walletName;
this.amount = w.amount;
this.icon = w.icon;
}
