private void button1_Click(object sender, EventArgs e) { this.Hide(); user_interface ui = new user_interface(customer_id); ui.Show(); }
private void button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connString); con.Open(); if (con.State == System.Data.ConnectionState.Open) { string username = textBox1.Text; string password = textBox2.Text; if (username == string.Empty || password == string.Empty) { MessageBox.Show("Username or Password can not be empty."); } String sql = "SELECT* FROM Login_Info WHERE Username = '******' AND Password = '******'"; SqlCommand sq = new SqlCommand(sql, con); SqlDataAdapter sda = new SqlDataAdapter(sq); DataTable dt = new DataTable(); sda.Fill(dt); String s = "SELECT* FROM User_Info WHERE User_Name = '" + username + "'"; SqlCommand aa = new SqlCommand(s, con); SqlDataAdapter sd = new SqlDataAdapter(aa); DataTable d = new DataTable(); sd.Fill(d); string customer_id = d.Rows[0][0].ToString(); if (dt.Rows.Count > 0) { String userRole; userRole = dt.Rows[0][2].ToString(); if (userRole == "Customer") { user_interface us = new user_interface(customer_id); this.Hide(); us.Show(); con.Close(); } else { Admin a = new Admin(); this.Hide(); a.Show(); con.Close(); } } else { MessageBox.Show("Username or Password incorrect."); } con.Close(); } }