Esempio n. 1
0
        protected override void PrepareParameters(SqlParameterCollection parameters)
        {
            Check.NotNull(parameters, "The base class guarantees that the parameter is not null.");

            parameters.AddParameterUnsafe("@email_address", SqlDbType.NVarChar, Email);
            parameters.AddParameterUnsafe("@password", SqlDbType.NVarChar, Password);
        }
        protected override void PrepareParameters(SqlParameterCollection parameters)
        {
            Check.NotNull(parameters, "The base class guarantees that the parameter is not null.");

            parameters.AddParameterUnsafe("@designer", SqlDbType.NVarChar, _designerKey.Value);
            parameters.AddParameterUnsafe("@language", SqlDbType.Char, _culture.TwoLetterISOLanguageName);
        }
Esempio n. 3
0
        protected override void PrepareParameters(SqlParameterCollection parameters)
        {
            Check.NotNull(parameters, "The base class guarantees that the parameter is not null.");

            parameters.AddParameterUnsafe("@designer", SqlDbType.NVarChar, DesignerKey.Value);
            parameters.AddParameterUnsafe("@reference", SqlDbType.NVarChar, Reference);
            parameters.AddParameterUnsafe("@version", SqlDbType.NVarChar, Variant);
        }
Esempio n. 4
0
        protected override void PrepareParameters(SqlParameterCollection parameters)
        {
            Check.NotNull(parameters, "The base class guarantees that the parameter is not null.");

            parameters.AddParameterUnsafe("@designer", SqlDbType.NVarChar, DesignerKey.Value);
            parameters.AddParameterOrNullUnsafe("@published", SqlDbType.Bit, Published);
            parameters.AddParameterOrNullUnsafe("@category", SqlDbType.NVarChar, CategoryKey, !String.IsNullOrEmpty(CategoryKey));
        }
Esempio n. 5
0
        protected override void AddParameters(SqlParameterCollection parameters, NewMemberParameters values)
        {
            Require.NotNull(values, "values");
            Check.NotNull(parameters, "The base class guarantees that the parameter is not null.");

            parameters.AddParameterUnsafe("@email_address", SqlDbType.NVarChar, values.Email);
            parameters.AddParameterUnsafe("@firstname", SqlDbType.NVarChar, values.FirstName);
            parameters.AddParameterUnsafe("@lastname", SqlDbType.NVarChar, values.LastName);
            parameters.AddParameterUnsafe("@company_name", SqlDbType.NVarChar, values.CompanyName);
            parameters.AddParameterUnsafe("@password", SqlDbType.NVarChar, values.EncryptedPassword);
            parameters.AddParameterUnsafe("@newsletter", SqlDbType.Bit, values.NewsletterChecked);
        }