private void button1_Click(object sender, EventArgs e) { String conString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString; SqlConnection con = new SqlConnection(conString); con.Open(); String query = String.Format(@"Select * from [User] where login = '******' and password = '******'", textBox1.Text, textBox2.Text); SqlCommand cmd = new SqlCommand(query, con); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { bool mngr = rdr.GetBoolean(3); bool recep = rdr.GetBoolean(4); if (mngr) { this.Hide(); Manager m = new Manager(); m.Show(); } else if (recep) { this.Hide(); Receptionist r = new Receptionist(); r.Show(); } } else { MessageBox.Show("Wrong username/Password"); } con.Close(); }
private void button4_Click(object sender, EventArgs e) { this.Hide(); Receptionist r = new Receptionist(); r.Show(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\ME\Downloads\RMS\RMS\Database1.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); if (textBox1.Text == "Manager" || textBox1.Text == "manager") { string query = "Select Count(*) From Manager where mgr_pswd ='" + textBox2.Text + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); sda.SelectCommand.ExecuteNonQuery(); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { this.Hide(); Manager m = new Manager(); m.Show(); } else { MessageBox.Show("Try Again"); } } else if (textBox1.Text == "Receptionist" || textBox1.Text == "receptionist") { string query = "Select Count(*) From Receptionist where recep_pswd ='" + textBox2.Text + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); sda.SelectCommand.ExecuteNonQuery(); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { this.Hide(); Receptionist r = new Receptionist(); r.Show(); } else { MessageBox.Show("Try Again"); } } else if (textBox1.Text == "Customer" || textBox1.Text == "customer" && textBox2.Text == "123") { this.Hide(); Customer cust = new Customer(); cust.Show(); } else { MessageBox.Show("Invalid Id or Password"); } con.Close(); }