private void button1_Click(object sender, EventArgs e) { Quotes = new ObservableCollection<Quote>(); db = new DBAccess(); //Some example tickers Quotes.Add(new Quote(textBox1.Text.ToUpper())); //get the data YahooStockEngine.Fetch(Quotes); try { db.insert_stock(textBox1.Text.ToUpper(), Quotes[0].LastUpdate, Quotes[0].DividendShare, Quotes[0].Name, Quotes[0].StockExchange, Quotes[0].ChangeInPercent, Quotes[0].LastTradePrice, Quotes[0].Volume, Quotes[0].YearlyHigh, Quotes[0].YearlyLow, Quotes[0].DailyHigh, Quotes[0].DailyLow, Quotes[0].PeRatio); db.insert_stockhistory(DateTime.Now, "BUY", decimal.Parse(textBox2.Text), acct, db.select_stock(textBox1.Text.ToUpper())); } catch { Console.WriteLine("error"); } this.Close(); }
public Form1(int user_id1, int account_id1) { db = new DBAccess(); user_id = user_id1; account_id = account_id1; this.contructors(); }
public Add_User() { InitializeComponent(); db = new DBAccess(); DataTable dt = db.select_allquestions(); foreach (DataRow dr in dt.Rows) { comboBox1.Items.Add(dr[0].ToString()); } }
public accounts(string username1, string password1) { db = new DBAccess(); username = username1; password = password1; InitializeComponent(); DataTable dt=db.select_allaccountid(username, password); foreach (DataRow dr in dt.Rows) { comboBox1.Items.Add(dr[1].ToString() + ":" + dr[0].ToString()); } user_id = db.select_userid(username, password); }
public newaccounts(int user_id) { InitializeComponent(); db = new DBAccess(); user_id1 = user_id; }
public forgotpassword() { InitializeComponent(); db = new DBAccess(); }
public Bonds(int account_id1) { account_id = account_id1; InitializeComponent(); db = new DBAccess(); }
public loginbox() { InitializeComponent(); db = new DBAccess(); }
public investment(int account_id1) { account_id = account_id1; InitializeComponent(); db = new DBAccess(); }
public Cash(int acctid) { InitializeComponent(); accountid = acctid; db = new DBAccess(); }
public CD(int account_id1) { account_id = account_id1; InitializeComponent(); db = new DBAccess(); }