public void Execute(int pasportNumber, int age, string adres, int accsesLevel)
        {
            string       cmdText = $"INSERT INTO Employees ([Логин], [Пароль], [Должность], [Полное имя], [Номер паспорта], [Возраст], [Адрес], [Уровень доступа]) VALUES ('" + Login + "', '" + Password + "', '" + Position + "', '" + FullName + "', '" + pasportNumber + "', '" + age + "','" + adres + "','" + accsesLevel + "')";
            OleDbCommand cmd     = new OleDbCommand(cmdText, OleDbConnect);

            OleDbConnect.Open();
            cmd.ExecuteNonQuery();
            OleDbConnect.Close();
        }
Exemple #2
0
        public void Execute()
        {
            OleDbConnect.Open();

            string       query   = $"SELECT * FROM Employees WHERE Логин = '{Login}' AND Пароль = '{Password}'";
            OleDbCommand command = new OleDbCommand(query, OleDbConnect);

            OleDbDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                loadLogin = reader.GetString(0);
                Position  = reader.GetString(2);
                FullName  = reader.GetString(3);
            }

            OleDbConnect.Close();
            reader.Close();
        }