Beispiel #1
0
        public void Save(long contactID)
        {
            //
            // Create a command object to invoke the stored procedure
            //
            SqlCommand cmd = new SqlCommand("net_contact_email_save", ConnectionManager.GetConnection());

            cmd.Transaction = ConnectionManager.GetTransaction();
            cmd.CommandType = CommandType.StoredProcedure;

            //
            // Input parameters
            //
            cmd.Parameters.Add(new SqlParameter("@contactID", SqlDbType.BigInt)).Direction = ParameterDirection.Input;
            cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, UDDI.Constants.Lengths.Email)).Direction     = ParameterDirection.Input;
            cmd.Parameters.Add(new SqlParameter("@useType", SqlDbType.NVarChar, UDDI.Constants.Lengths.UseType)).Direction = ParameterDirection.Input;

            //
            // Set parameter values
            //
            SqlParameterAccessor parmacc = new SqlParameterAccessor(cmd.Parameters);

            parmacc.SetLong("@contactID", contactID);
            parmacc.SetString("@email", Value);
            parmacc.SetString("@useType", UseType);

            cmd.ExecuteNonQuery();
        }