Reward Points Accumulation & Redumption

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

This is My Mini Project

I am working on Reward points management where i need to check every users actions for which they are awarded points actions like spending some amount of money ears few points etc..., if points are consumed they need to be deducted from the card of the specific user.

I have done with Giving points to particular game
please give me some ideas to track these actions

Thanks In Advance

Posted 18-Oct-10 3:49am

anupama962010

Updated 18-Oct-10 3:53am

v2

Add a Solution

3 solutions

Solution 2

As Simon, you need to store all in database.
first, of all you need to define what all action can be taken by a User and then define the no of points earn/redeem by user on every action.

Now whenever user takes a action, first of all make a entry in the database, that what action is taken,at what time, how many points earned/redeemed and other information according to your requirement.
Also add/substarct the points from the total point.

Now whenever you want to see/track the user actions, you can get from database according to your need.

This is the basic idea, you can change it according to your requirement.

Hope this help you.

Posted 18-Oct-10 6:18am

Brij

Solution 4

If you dont want to use a database, you can store your data in a text file. However, if the number of users are excpected to be large this is NOT a recommended idea.

Storing in a file can only be a mini-solution (for a small number of users).

Posted 18-Oct-10 6:46am

Abhinav S

Updated 18-Oct-10 6:47am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Simon_Whale · Accepted Answer · 2010-10-18T04:02:00

Solution 1

you will need to store these in a database

for each action they do on (I assume) a particular job, record the action they have completed and the points associated with that action into a database.

Posted 18-Oct-10 4:02am

Simon_Whale