March 1, 2006 at 11:32 am
Hi!
I need to do a program something like a credit or debit card process.
They will live me a txt file in one directory with the information of the client ID and the amount to be charge.
I have to return in another text file the autorization or denied of the transaction.
And finally I have to update the balance client if everything goes ok.
The problem here is that I don't have any idea about how to read this txt files that they will put in some folder and do the transaction with sqlserver data base. (Well I'm confuse I don't have any clear idea)
I don't know what is the best way to pass and return the txt file ( if exist a special txt format to do the transaction faster) to the server.
The POS will generate the txt file then put it in a computer that will have windows, this computer is the one that have to lauch the txt to the sqlserver data base.
1.POS --->2.PC---->3.DB
6.POS<---5.PC<----
1.The poin of sale will read the card, generate a txt with the basic information, the amount of the transaccion and the ID of the card.
2.The txt is copy to another PC, and this PC copy the txt to the sqlserver database computer.
3.In some way the sqlserver computer have to detect the txt file, read the information, generate another txt with the answer, and if the transaccion have sucess update the client balance.
5.The server have to return the txt to the PC
6. The PC have to return the txt to the POS.
If you are question why the PC is because the POS doesn't have windows , so that is why we need the PC with windows to comunicate with the central server that will have the information of the data base.
Any help will be very wellcome.
March 1, 2006 at 12:35 pm
in .NET you could make a filewatcher that reads the txt,execute
a stored proc with parameter idcard, amount,...
which checks validity & does the transaction when necessary
and returns the result to the same program / or puts it in another table for further retrieval.
*here is a page connecting to sql server from unix asuming POS is POSUNIX?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply