Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            Form ersFrom = new PersFrom(PersFrom.id_p, PersFrom.id_d);

            ersFrom.Show();
            this.Hide();
        }
Example #2
0
        private void EnterToSystem(SqlConnection con)
        {
            bool   yap   = false;
            string Login = textBoxLogin.Text;
            string Parol = textBoxPassword.Text;

            scomand = new SqlCommand(sc_getPers, con);
            using (DbDataReader reader = scomand.ExecuteReader())
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        if (Login == reader.GetString(10) && Parol == reader.GetString(11))
                        {
                            yap     = true;
                            id_dolj = reader.GetInt32(2);
                            id_pers = reader.GetInt32(0);
                        }
                    }
                    if (yap == true)
                    {
                        reader.Close();
                        Form main = new PersFrom(id_pers, id_dolj);
                        main.Show();
                        this.Hide();
                        yap = false;
                    }
                    else
                    {
                        MessageBox.Show("Пользователь с таким логином и/или паролем не найден", "Ошибка", MessageBoxButtons.OK);
                        reader.Close();
                    }
                }
            }
        }