Thread: Is it possible to offer discounts based on Email server or domain?

I've seen a few sites offering automatic discounts if users are registered using *@something.edu email address. I was wondering if its possible to do something similar with ASPDNSF?

Thanks

Using MS 9.1.0.1

Not done this before, but I would imagine one way to achieve this would be through customer levels and automatically assigning them those levels when they register. To perform this automatically I would put a trigger on the customer table to detect a registration, match their domain and update their customerlevelid.

Hi esedirect,

Thanks for your suggestion. I was also thinking that customer levels are probably the way to go but didn't know how a customer would be automatically added. My experience with SQL is very basic... I'll try to look up SQL Triggers. Would I need access to full source code to do this or is this something that can be accomplished without access to the full code?

No you don't need source code. The beauty of this suggestion is that it works on the database and not through .Net code. Some people find triggers confusing, but this is quit a simple solution so shouldn't be a problem.

Code:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[tr_Customer] ON [dbo].[Customer]
WITH EXECUTE AS CALLER
AFTER INSERT, UPDATE
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	-- Do something if the customer actually registers
	IF UPDATE(IsRegistered)
	BEGIN
		-- your code here
		UPDATE Customer
		SET CustomerLevelID=x
		FROM inserted AS i
		WHERE [Customer].[CustomerID] = [i].[CustomerID]
		AND [i].[IsRegistered] = 1
		AND [i].[Email] LIKE '%.edu'
	END
END

This trigger will work on customer records only when they are being inserted/updated, that's the "AFTER INSERT, UPDATE" clause. And since there is the "IF UPDATE(IsRegistered)" test, it only acts on the customer record when IsRegistered is being changed.

I've given an example of what you might want within test, which will need to be enhanced by yourself and thoroughly tested, for .edu and non-.edu customers alike.

Great! Thanks for all the help! I'll try it out.