Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2003-05-23 : 14:39:02
|
| Has anyone ever implimented some sort of "Promo Code" or discount type system? Are there any "gotchas" that I should be aware of? Anyone know of any samples out on the web?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-23 : 15:04:13
|
| Not sure what you mean.I implemented a telecoms billing system that included discounts, promotions and weird and wonderful things depending on the customers rate card, how much they spent in the previous 3 months, which countries they called, how quickly they paid, ....The problems were some promotions were on the total monthly bill, some on the first n minutes to various countries for various time dependant rates.Basically find out as much as possible about the types of discounts/promos you need to cater for. You will always be asked to do something different though so make it as flexible as possible.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-05-23 : 15:10:33
|
| NR, yeah that's the kind of stuff I'm running into.Different ways to discount different entities at different times.I think I'm going to make the system semi flexible. Like, every time we run billing, we look at the codes. The codes have a "% discount", some sort of unit and a valid to/from. That way you can have things like"the first 5 get X% off""everything this month is 100% off"things like thatWhat do you think about that?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-23 : 17:41:22
|
| Depending on how much time you have and how many rules there are and how often they change you may want to think about implementing this in vb/c++/c#/java into a middle layer like COM objects. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-23 : 17:56:48
|
quote:
Depending on how much time you have and how many rules there are and how often they change you may want to think about implementing this in vb/c++/c#/java into a middle layer like COM objects.
COM? C'mon guys, it's all .Net (ball bearings) nowadays  I would think this should almost certainly be in a middle tier layer.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-23 : 18:29:18
|
| Still alot of people using COM/COM+/DCOM.I do agree that .NET Remoting is much easier to implement, it's straight forward, the code is cleaner and much easier to understand and has benefits like different communication protocols and channels.Edited by - ValterBorges on 05/23/2003 18:57:43 |
|
|
|
|
|
|
|
|
Promo Code