Debit/Credit Card Management System

Project Detail:- It's a desktop application which have two modules 1) Client (Front End) 2) Server (Back End) Its an application through which membership cards (here we will say Debit Cards) are created and stored in databases. Before creating Cards, members are created in the database. Later on Each members are assign Cards. These cards can be RFID or magnetic Strip Cards. So, each members have a cards ID assigned or attached to them. One members can have few cards. Administrator will upload credits (money) in each cards. The customers or clients will use this cards to purchase items in the departmental store. So the application will have front end and backend. The front end will be used at the counter (POS). The front end application will be used to deduct the credit whenever items are purchased. There is separate pos application application purchase i.e departmental store application. After total purchase is made via that application. The employee will just note the total amount and after that will use our front end application and then swap our cards to deduct the credit from the client card. All the cards will be password protected. That is when the card is swapped then it will prompt for password. After the successful transaction then two receipts will be printed. One receipt is signed by client and its kept by employee and another one is client's copy. There will be a backend to managed all these transactions ## Deliverables The backend will be used by administrator or management staff to upload credits, Check reports, create clients, create cards or edit all of them. There will also be module to create/add/modify coupons cards. So, they can distribute/sell coupons to clients. Clients can use these coupons to get discounts or some bonus. When clients do the purchase they also get the points. i.e when the money is deducted from their cards they get the points accordingly. The point are given on the based of products they have purchased. They can use these points to exchange goods in future. So, there should be a module in the software to handle this function too. This is just a simple description of the application . Detail will be given afterward. * * *This broadcast message was sent to all bidders on Saturday Oct 30, 2010 11:33:40 PM: Project Detail:- Debit/Credit Card Management It’s a desktop application which has two modules 1) Client (Front End) 2) Server (Back End) It’s an application through which membership cards (here we will say Debit Cards) are created and stored in databases. Before creating Cards, members are created in the database. Later on each member is assigned Cards. These cards can be RFID or magnetic Strip Cards. So, each member has a cards ID assigned or attached to them. One member can have few cards. Administrator will upload credits (money) in each card. The customers or clients will use these cards to purchase items in the departmental store. So the application will have front end and backend. The front end will be used at the counter (POS). The front end application will be used to deduct the credit whenever items are purchased. There is separate pos application purchase i.e. departmental store application. After total purchase is made via that application. The employee will just note the total amount and after that will use our front end application and then swap our cards to deduct the credit from the client card. All the cards will be password protected. That is when the card is swapped then it will prompt for password. After the successful transaction then two receipts will be printed. One receipt is signed by client and it’s kept by employee and another one is client’s copy. The backend will be used by administrator or management staff to upload credits, Check reports, creates clients, create cards or edit all of them. There will also be module to create/add/modify coupons cards. So, they can distribute/sell coupons to clients. Clients can use these coupons to get discounts or some bonus. When clients do the purchase they also get the points. I.e. when the money is deducted from their cards they get the points accordingly. The point are given on the based of products they have purchased. They can use these points to exchange goods in future. So, there should be a module in the software to handle this function too. In detail: It’s just an application that will be used by a departmental store. The departmental store wants to create their own card (membership card) where they will upload the money for them. Or member will buy the card (its kind of recharge card). So basically it’s just an application that is used by departmental store for their personal use. It not connected to any bank or any payment gateway, We already have Point of Sales application. So, after the client does the purchase using point of Sale application, the total amount is noted by the counter employee manually. Then they will use another application (our application) to deduct the credit from client’s membership card. So while doing this the verification (password check, enough balance in card, activated/blocked status, expired or not, flagged or not etc). After the card is swapped (membership card can be RFID, Magnetic strip or just a card with number), certain accumulation point is awarded for the client. They can use this point to exchange items in future. All these things should be managed using Back-end like creating/editing cards, members, coupon cards, reports. Etc The application will be handling three kinds of cards 1) Debit cards (the card I have mentioned earlier) where credit will be uploaded by the administrator via backend and clients will us it to purchase items and the accumulation point will also be awarded to them 3) Credit card (it’s a bank card or real credit card) - Client will be able to make the purchase using their own credit card using real payment gateway. This module we will not do it now but there should be possibility in our application for future upgrade 4) Coupon Cards: These are like bonus or cards or tickets that are distributed by the company to the customers. Clients can use this to get discounts or buy products. The coupons can also be distributed free. Clients will be awarded points even if they use the coupon. Let’s take an example of KFC. Some time they have some kind of coupon, you can use it to get discount or get burgers. It’s the same thing. For all different cards I have mentioned there should also be batch operation for creating/ activating /deleting or flagging the cards. I.e. multiple cards can be done at one time. There should be an option where accumulation points are managed. When clients exchange their point with items then those points will be deducted from client’s accounts. Sometime company creates special promotion for accumulation point, for example they can ask clients to exchange their point with items before some date so that they can get special items. Etc. There should be a very good reporting system so that each and every thing can be easily checked and print. Note: the application can be in different language. So the user interface should take its setting from some Ini or xml file or in application user should able to change language Detail about Accumulation point Lets take an example the department store have many departments 1) Supermarket 2) Clothing department 3) Kitchenware ETC These department will have their one Point of Sale system. i.e they will have their own pc to deal with client but all of them are connected to same SQL. Each department gives different Accumulation points to clients on the each sales Lets say 1)supermarket give 1 point for each 1 $ sale 2) Clothing Department 2 point for each 1 $ sale 3) Kitchenware gives 4 point for each 1 $ sale So for example one client goes to supermarket and make a total purchase of $300. When he will make the payment using our Debit card then $300 will be deducted from his total balance and he will be awarded 300 points for his purchase. If the same client to to Kitchen ware an make a purchase of lets say 150$ then $150 will be deducted from his debit card and he will be awarded 4x150= 600 points for his purchase. 1) Clients will have RFID card, or Magnetic Strip cards just like bank card. Each counter will have RFID reader or Magnetic Strip card reader. The client will just swap the card and the information will come on the software screen. He will be asked to enter the password. After the authentication is done then all the details can be seen and the transaction can be processed. Also if after some time (lets say after few months) clients can use his total point to exchange goods from the store. There should also be an option where we can specify that if client don’t come to claim his points for exchange for certain time then his point to rest to 0