How to implement digital signature on each transaction?

Question

0.00/5 (No votes)

See more:

1)The signature must be recorded in the electronic journal with a direct link to the full record of the original receipt.

2. The signature must be created for all transactions that are reported in cashtransaction. This includes all receipts that are given a transaction number, and normally comprises transactions that influence sales.

3. It must be recorded which version of the private or secret key that was used to generate the signature of the receipt.

4

What I have tried:

i know how to crate digital signature. I need to hash the value first then encrypt it with public key. Then to see that value i need to decrypt with private key and then re hash and i will get value.

But question is that in POS i have saved data in tables and in different tabel for example detal of all items in one table and for that recipt no i saved detail of payment in another table . how i can implement digital signature on it and save it in database, I can crate digital signature on one field what how i can implement on row og database?

Posted 18-Feb-18 4:12am

Member 12545398

Add a Solution

1 solution

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)

alexrait1 · Answer 1 · 2018-02-18T05:06:00

Solution 1

It seems that you not fully understand what a digital signature is.
For a signature you should encrypt with your private key and allow everybody to decrypt with the public key.

First you need to figure our for yourself on where are you going to keep the private key and actually preform the digital signing.
E.g. on MSSQL you can create the key as a DB object and do everything including verification from the T-SQL.
Or you can create a .NET stored procedures and do it from there or use an external signing from a windows service e.t.c

Posted 18-Feb-18 5:06am

alexrait1

Comments

Member 12545398 18-Feb-18 17:38pm

Hi Alexrait ! Thanks for answer. I am new to digital signature. I have created private key and public key by using RSACryptoServiceProvider. I have function where i can encrypt using private key and decrypt by public key.

Thing that i do not under stand is that:
1. Do i need to encrpt using my private key every field of table
e.g
Table :
NORMAL TABLE
ID EmpName Salary
1 johan 20000
2 Tom 10222

with DIGITAL SIG
ID EmpName Salary
1 dfdse34 hh434f34
2 b97987 tytytu