Example #1
0
        private void button4_Click(object sender, EventArgs e)
        {
            Form22 Form22 = new Form22();

            Form22.Show();
            this.Hide();
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = DBConnection.getConnection();

            string username = txtuname.Text.Trim();
            string password = txtpass.Text.Trim();
            string acctype  = cmbacctype.Text;


            try
            {
                if (cmbacctype.SelectedItem == "Admin")
                {
                    SqlCommand cmd = new SqlCommand("SELECT * FROM users WHERE username='******' AND password='******'", conn);

                    SqlDataAdapter adapt = new SqlDataAdapter(cmd);
                    DataSet        ds    = new DataSet();
                    adapt.Fill(ds);
                    int count = ds.Tables[0].Rows.Count;

                    if (count == 1)
                    {
                        Form23 ap = new Form23();
                        ap.Show();
                    }
                    else
                    {
                        MessageBox.Show("Invalid username or password");
                    }
                }
                else if (cmbacctype.SelectedItem == "Manager")
                {
                    SqlCommand cmd = new SqlCommand("SELECT username, password FROM users WHERE username='******' AND password='******'", conn);

                    SqlDataAdapter adapt = new SqlDataAdapter(cmd);
                    DataSet        ds    = new DataSet();
                    adapt.Fill(ds);
                    int count = ds.Tables[0].Rows.Count;

                    if (count == 1)
                    {
                        Form20 mm = new Form20();
                        mm.Show();
                    }
                    else
                    {
                        MessageBox.Show("Invalid username or password");
                    }
                }
                else if (cmbacctype.SelectedItem == "FrontOffice")
                {
                    SqlCommand cmd = new SqlCommand("SELECT username, password FROM users WHERE username='******' AND password='******'", conn);

                    SqlDataAdapter adapt = new SqlDataAdapter(cmd);
                    DataSet        ds    = new DataSet();
                    adapt.Fill(ds);
                    int count = ds.Tables[0].Rows.Count;

                    if (count == 1)
                    {
                        Form18 cm = new Form18();
                        cm.Show();
                    }
                    else
                    {
                        MessageBox.Show("Invalid username or password");
                    }
                }
                else if (cmbacctype.SelectedItem == "Doctor")
                {
                    SqlCommand cmd = new SqlCommand("SELECT username, password FROM users WHERE username='******' AND password='******'", conn);

                    SqlDataAdapter adapt = new SqlDataAdapter(cmd);
                    DataSet        ds    = new DataSet();
                    adapt.Fill(ds);
                    int count = ds.Tables[0].Rows.Count;

                    if (count == 1)
                    {
                        MessageBox.Show("Login Successful!");
                        this.Hide();
                        Form22 dm = new Form22();
                        dm.Show();
                    }
                    else
                    {
                        MessageBox.Show("Invalid username or password");
                    }
                }
                else
                {
                    MessageBox.Show("Login Failed");
                    this.txtuname.Text = "";
                    this.txtpass.Text  = "";
                }
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }