private void loginTrader_Click(object sender, RoutedEventArgs e) { Login_Trader lTrader = new Login_Trader(); lTrader.Show(); this.Close(); }
private void LogoutButton_Click(object sender, RoutedEventArgs e) { Login_Trader exp = new Login_Trader(); exp.Show(); this.Close(); Global.uname = ""; }
private void Login_Click(object sender, RoutedEventArgs e) { Login_Trader logintrader = new Login_Trader(); logintrader.Show(); Close(); }
private void confirmOrder_Click(object sender, RoutedEventArgs e) { string security = labelSecurity.Content.ToString(); string company = labelcompany.Content.ToString(); string tradetype = labeltype.Content.ToString(); char tradetypechar = tradetype[0]; int quantity; Int32.TryParse(labelquantity.Content.ToString(), out quantity); double price; double.TryParse(labelPrice.Content.ToString(), out price); double value; double.TryParse(labelValue.Content.ToString(), out value); string date = labeltime.Content.ToString(); Login_Trader obj = new Login_Trader(); // string uname = obj.userName.Text; string tradertype; SqlConnection con1 = new SqlConnection(@"Data Source=GRAD89-HP;Integrated Security = SSPI;Initial Catalog=front_running"); con1.Open(); SqlCommand cmd1 = new SqlCommand($"SELECT TRADERTYPE FROM TABLE_FOR_TC WHERE USERNAME='******'", con1); tradertype = (string)cmd1.ExecuteScalar(); char tradertypechar = tradertype[0]; //cmd1.Parameters.AddWithValue("@TRADERTYPE", ); //using (SqlDataReader reader = cmd1.ExecuteReader()) //{ // tradertype = String.Format("{0}", reader["TRADERTYPE"]); //} string today = DateTime.Today.ToString("yyyy-MM-dd"); string todaytime = DateTime.Now.ToString("HH:mm:ss"); SqlConnection con = new SqlConnection(@"Data Source=GRAD89-HP;Integrated Security = SSPI;Initial Catalog=front_running"); con.Open(); SqlCommand cmd = new SqlCommand($"Insert into DATABASE_FOR_ORDERS (USERNAME, TRADERTYPE, SECURITY, TRADE_DATE, TRADE_TIME, TRADE_TYPE, SECURITY_TYPE, QUANTITY, PRICE, VALUE) values('{Global.uname}','{tradertypechar}','{company}','{today}','{todaytime}','{tradetypechar}','{security}','{quantity}','{price}','{value}')", con); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Your order has been placed successfully"); Welcome w = new Welcome(); w.Show(); this.Close(); }