コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            MeniMedSesTeh meni = new MeniMedSesTeh();

            meni.ShowDialog();
            this.Close();
        }
コード例 #2
0
ファイル: Prijava.cs プロジェクト: developeramarish/EMR
        private void button1_Click(object sender, EventArgs e)
        {
            if (vrsta_kor == 0)
            {
                //               Console.WriteLine("admiiiiiiiiin");
                string connectionString = DBConnection.GetConnectionString();
                using (OracleConnection connection = new OracleConnection())
                {
                    connection.ConnectionString = connectionString;
                    connection.Open();
                    string sql = "";
                    // string idodel = "";

                    sql = "SELECT * FROM ADMINZK WHERE USERA='" + tbUser.Text + "' AND PASSA='" + tbPass.Text + "'";
                    OracleCommand command = new OracleCommand(sql);
                    command.Connection = connection;
                    OracleDataReader reader = command.ExecuteReader();



                    if (reader.Read())
                    {
                        MeniAdmin rp = new MeniAdmin();
                        this.Opacity = .70;
                        DialogResult dr = rp.ShowDialog();
                        if (dr == DialogResult.Cancel)
                        {
                            this.Close();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Neispravni podaci");
                    }
                    this.Opacity = 1;

                    // label6.Text = sql;
                    connection.Close();
                    //this.DialogResult = DialogResult.OK;
                }
            }
            else if (vrsta_kor == 1)
            {
                string connectionString = DBConnection.GetConnectionString();
                using (OracleConnection connection = new OracleConnection())
                {
                    connection.ConnectionString = connectionString;
                    connection.Open();
                    string sql = "";

                    sql = "SELECT * FROM REGISTRACIJA WHERE VRSTAKOR='" + vrsta + "' AND USERZAP='" + tbUser.Text + "' AND SIFRAZAP='" + tbPass.Text + "'";
                    OracleCommand command = new OracleCommand(sql);
                    command.Connection = connection;
                    OracleDataReader reader = command.ExecuteReader();



                    if (reader.Read())
                    {
                        if (reader["SIFRAZAP"].Equals("DZNS"))
                        {
                            IzmenaLozinke rp = new IzmenaLozinke(reader["IMEZAP"].ToString(), reader["PRZZAP"].ToString(), reader["IDZAP"].ToString());
                            this.Opacity = .70;
                            DialogResult dr = rp.ShowDialog();
                            if (dr == DialogResult.Cancel)
                            {
                                this.Opacity = 1;
                            }
                        }
                        else
                        {
                            MeniLekOpste meni = new MeniLekOpste(reader["IDZAP"].ToString());
                            meni.ShowDialog();
                            this.Close();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Neispravni podaci");
                    }
                    this.Opacity = 1;

                    // label6.Text = sql;
                    connection.Close();
                    //this.DialogResult = DialogResult.OK;
                }
            }
            else if (vrsta_kor == 2)
            {
            }
            else if (vrsta_kor == 3)
            {
                string connectionString = DBConnection.GetConnectionString();
                using (OracleConnection connection = new OracleConnection())
                {
                    connection.ConnectionString = connectionString;
                    connection.Open();
                    string sql = "";

                    sql = "SELECT * FROM REGISTRACIJA WHERE VRSTAKOR='" + vrsta + "' AND USERZAP='" + tbUser.Text + "' AND SIFRAZAP='" + tbPass.Text + "'";
                    OracleCommand command = new OracleCommand(sql);
                    command.Connection = connection;
                    OracleDataReader reader = command.ExecuteReader();



                    if (reader.Read())
                    {
                        if (reader["SIFRAZAP"].Equals("DZNS"))
                        {
                            IzmenaLozinke rp = new IzmenaLozinke(reader["IMEZAP"].ToString(), reader["PRZZAP"].ToString(), reader["IDZAP"].ToString());
                            this.Opacity = .70;
                            DialogResult dr = rp.ShowDialog();
                            if (dr == DialogResult.Cancel)
                            {
                                this.Opacity = 1;
                            }
                        }
                        else
                        {
                            MeniMedSesTeh meni = new MeniMedSesTeh();
                            meni.ShowDialog();
                            this.Close();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Neispravni podaci");
                    }
                    this.Opacity = 1;

                    // label6.Text = sql;
                    connection.Close();
                    //this.DialogResult = DialogResult.OK;
                }
            }
            else if (vrsta_kor == 4)
            {
            }
        }