private void btnVizitator_Click(object sender, EventArgs e)
        {
            Auxiliare.UtilizatorLogat = 3;
            this.Close();
            frmLimba flb = new frmLimba();

            flb.Close();
        }
        private void btnLogare_Click(object sender, EventArgs e)
        {
            if (txtNumeLogare.Text != "" && txtParolaLogare.Text != "")
            {
                using (SqlConnection con = new SqlConnection(sirConectare))
                {
                    string     sirSQL = "SELECT * FROM Utilizatori WHERE NumeUtilizatorDB = @numeUtilizator and ParolaDB = @parola";
                    SqlCommand cmd    = new SqlCommand(sirSQL, con);
                    cmd.Parameters.AddWithValue("@numeUtilizator", txtNumeLogare.Text);
                    cmd.Parameters.AddWithValue("@parola", txtParolaLogare.Text);
                    con.Open();

                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataSet        ds = new DataSet();
                    da.Fill(ds);
                    //con.Close();

                    int count = ds.Tables[0].Rows.Count;
                    //If count is equal to 1, than show frmMain form
                    if (count == 1)
                    {
                        if (ds.Tables[0].Rows[0][4].ToString() == "A")
                        {
                            Auxiliare.UtilizatorLogat = 1;
                        }
                        else
                        {
                            Auxiliare.UtilizatorLogat = 2;
                        }
                        //MessageBox.Show("Nr inregistrari: " + count.ToString() + " utilizator de tip: " + Auxiliare.UtilizatorLogat.ToString());

                        this.Close();
                        frmLimba flb = new frmLimba();
                        flb.Close();
                        // Form1 fa = new Form1();
                        //fa.ShowDialog();
                    }
                    else
                    {
                        if (Auxiliare.Limba == 2)
                        {
                            MessageBox.Show("Failed to autentificate. Username or password incorrect. Please retry.");
                        }
                        else
                        {
                            MessageBox.Show("Autentificare nereusita. Nume sau parola eronata");
                        }
                        txtNumeLogare.Clear();
                        txtParolaLogare.Clear();
                        txtNumeLogare.Focus();
                    }
                }
            }
            else
            {
                if (Auxiliare.Limba == 2)
                {
                    MessageBox.Show("You must fill the Username and Password fields!");
                }
                else
                {
                    MessageBox.Show("Campurile Nume utilizator si Parola sunt obligatorii!");
                }
                txtNumeLogare.Focus();
                txtParolaLogare.Clear();
            }
        }