Exemplo n.º 1
0
        public void Update(Framework.DataServices.Model.EntityBaseData entry, string compareQuery, object objToCompare)
        {
            int    errorNumber      = 0;
            string errorDescription = null;

            bool result = _daoBase.Update(
                _currentUser, entry, out errorNumber, out errorDescription);

            if (result == false)
            {
                throw new AssertTestException("Couldn't update the item");
            }

            if (errorNumber != 0)
            {
                throw new AssertTestException("There is an error number = " + errorNumber);
            }

            if (!string.IsNullOrEmpty(errorDescription))
            {
                throw new AssertTestException("There is an error description = " + errorDescription);
            }


            object objResult = _commonDatabase.ExecuteScalar(
                System.Data.CommandType.Text, compareQuery, false, _currentUser);


            if (string.Compare(objToCompare.ToString(), objResult.ToString()) != 0)
            {
                throw new AssertTestException("Incompatible results between database and object.");
            }
        }
Exemplo n.º 2
0
        public void ExecuteStoredProcedureToScalarWithoutParameters()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);

            object objResult = commonDatabase.ExecuteScalar(
                CommandType.StoredProcedure,
                "sp_select_users_scalar", false, CurrentUser);
        }
Exemplo n.º 3
0
        public void ExecuteTextToScalarWithoutParameters()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);

            object objResult = commonDatabase.ExecuteScalar(
                CommandType.Text,
                "SELECT count(*) FROM Users", false, CurrentUser);
        }
Exemplo n.º 4
0
        public void ExecuteStoredProcedureToScalarWithIntParameters()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);

            object objResult = commonDatabase.ExecuteScalar(
                CommandType.StoredProcedure,
                "sp_select_users_scalar", false, CurrentUser,
                commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1));
        }
Exemplo n.º 5
0
        public void FailedToExecutStoredProcedureToScalarInWrongStoredProcedure()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);

            object objResult = commonDatabase.ExecuteScalar(
                CommandType.StoredProcedure,
                "sp_select_users_fail", false, CurrentUser,
                commonDatabase.Parameters.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now),
                commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1));
        }
Exemplo n.º 6
0
        public void ExecuteTextToScalarWithIntParameters()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);


            Framework.DataServices.ParameterConfiguration parameterConfig =
                new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider());


            object objResult = commonDatabase.ExecuteScalar(
                CommandType.Text,
                "SELECT count(*) FROM Users WHERE Children > @Children", false, CurrentUser,
                parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 0));
        }
Exemplo n.º 7
0
        public void ExecuteTextToScalarWithDataParameters()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);


            Framework.DataServices.ParameterConfiguration parameterConfig =
                new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider());


            object objResult = commonDatabase.ExecuteScalar(
                CommandType.Text,
                "SELECT COUNT(*) FROM Users WHERE BirthDate < @BirthDate", false, CurrentUser,
                parameterConfig.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now));
        }
Exemplo n.º 8
0
        public void Update(BolaoNet.Business.IBusinessBase entry, string compareQuery)
        {
            bool result = entry.Update();

            if (result == false)
            {
                throw new AssertTestException("It was not possible to update the object.");
            }

            object objResult = _commonDatabase.ExecuteScalar(
                System.Data.CommandType.Text, compareQuery, false, _currentUser);


            //if (string.Compare(((Model.Campeonato)entry).Descricao, objResult.ToString()) != 0)
            //    throw new AssertTestException("Incompatible results between database and object.");
        }
Exemplo n.º 9
0
        public void FailedToExecuteTextToScalarInWrongFieldName()
        {
            Framework.DataServices.CommonDatabase commonDatabase =
                new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);


            Framework.DataServices.ParameterConfiguration parameterConfig =
                new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider());


            object objResult = commonDatabase.ExecuteScalar(
                CommandType.Text,
                "SELECT count(*) FROM Users_Fail " +
                " WHERE Children > @Children " +
                "   AND BirthDateFail < @BirthDate ", false, CurrentUser,
                parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 1),
                parameterConfig.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now));
        }
Exemplo n.º 10
0
        public void FindUsersByEmail()
        {
            int totalRecords = -1;

            MembershipProvider provider = new Framework.Security.Business.UserManagerService();

            MembershipUserCollection list = provider.FindUsersByEmail(DataAccess.UserManagerDao.EmailToMatch,
                                                                      DataAccess.UserManagerDao.PageIndex, DataAccess.UserManagerDao.PageSize, out totalRecords);


            Assert.IsNotNull(list);

            Assert.AreNotEqual(totalRecords, -1);

            Assert.AreEqual(totalRecords, list.Count);


            object result = _commonDatabase.ExecuteScalar(CommandType.Text,
                                                          "SELECT Count(*) FROM " + Framework.Dao.Constants.DefaultTableUsers
                                                          + " WHERE email = '" + DataAccess.UserManagerDao.EmailToMatch + "'",
                                                          true, Framework.Tests.DataServices.CommonDatabase.CurrentUser);

            Assert.AreEqual(result, totalRecords);
        }