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