Databases
StackOverflow2013
Postsdbo
POValidate Vat number in C#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POValidate Vat number in C#
    primarykey
    data
    text
    <p>VAT numbers are not randomly or sequentially generated but are based on a formula that can be checked to see if the number is valid. If a VAT number is invalid a business cannot re-claim the VAT.</p> <p>To validate a UK VAT number manually you can perform the following exercise:</p> <p>Excluding the first 2 letters, list the numbers vertically and multiply each by a value starting with 8 and ending with 2. Then add up all the sums you have and deduct 97 from the sum until the answer is negative. The negative sum should be equal to the last 2 digits of the VAT number. </p> <p>So for example, the VAT number for <code>BLABLA</code> is GB 815382334 the calculation is:</p> <pre><code>8 x 8 = 64 1 x 7 = 7 5 x 6 = 30 3 x 5 = 15 8 x 4 = 32 2 x 3 = 6 3 x 2 = 6 </code></pre> <p>The total of the above calculation is <code>64 + 7 + 30 + 15 + 32 + 6 + 6 = 160</code> Deduct 97 from this until the result is negative, the result is <code>160 – 97 - 97= -34</code> which is the same as the last two digits: so the VAT number is valid.</p> <p>I want to write a C# application that takes a UK VAT Number as input, calculates the checksum using the above formula, and indicates if the number is valid or invalid.</p> <p>This is for me an exercise in algorithm's. I have found vat checkers online but I don't understand how they are working, so I was hoping some one could give some simple answers to the above problem with good explanations?</p> <p><strong>Update</strong>:</p> <pre><code> public static bool isValidVATNumber(string theVATNumber) { string startChar = "^"; string endChar = "$"; bool rtn = false; int i = 8; string valString; int sum = 0; // Check that the string matches the requirements rtn = Regex.IsMatch(theVATNumber, (startChar + ("(([1-9]d{8})|([1-9]d{11}))" + endChar)), RegexOptions.Multiline); if (rtn) { // Perform the validation valString = theVATNumber; if (Regex.IsMatch(valString, (startChar + "[A-Z]{2}"), RegexOptions.Multiline)) { valString = valString.Substring(2); } while ((i &gt;= 2)) { sum = (sum + (i * int.Parse(valString.Substring(0, 1)))); valString = valString.Substring(1); i--; } while ((sum &gt; 0)) { sum -= 97; } rtn = ((sum * -1) == int.Parse(valString)); } return rtn; } </code></pre> <p>Note the above method does not work and for me more difficult to understand, I started with my own method that I find much easier to work with but yet to finish it (please note it is embarrassing)</p> <pre><code> List&lt;int&gt; integerList = new List&lt;int&gt;(); int b = 8; for (int a = 0; a &lt; textBox1.Text.Length; a++) { integerList.Add(int.Parse(textBox1.Text[a].ToString())); } foreach (int item in integerList) { listBox1.Items.Add(item * b); --b; } </code></pre> <p>I still have to take the sum of the list and do the rest of the calculations and was hoping to pick some peoples brains as to other ways it might be done (easier ways).</p> <p>Update on my own method and abit of thanks to Pax below:</p> <pre><code> List&lt;int&gt; integerList = new List&lt;int&gt;(); List&lt;int&gt; sumList = new List&lt;int&gt;(); int b = 8; // Will be 8 for the first multiplication. for (int a = 0; a &lt;= 6; a++) { integerList.Add(int.Parse(textBox1.Text[a].ToString())); } foreach (int item in integerList) // Loop once per input digit. { //listBox1.Items.Add(item * b); sumList.Add(item * b); --b; } listBox1.DataSource = sumList; int sum = sumList.Sum(); while (sum &gt; 0) { sum = sum - 97; } int myInt = System.Math.Abs(sum); label1.Text = Convert.ToString(myInt); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKirsty White
    1. USKirsty White
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POValidate Vat number in C#
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POValidate Vat number in C#
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POValidate Vat number in C#
      1. This table or related slice is empty.
      1. VTDownMod
    1. COIt's an interesting problem, but what have you tried and what is your level of understanding of C# ? The algorithm should be rather straight forward if you have a basic understanding. A tip would be to look at getting a string representation of the VAT number, and use an array operator to get the value of it, char by char ...
      singulars
      1. POValidate Vat number in C#
      1. USRuss Clarke
    2. CO@KirstyWhite And to get better you keep on trying, you let people see what you've done (even if you think it's embarassingly wrong), you take advice and constructive criticism, you ignore the trolls and the doubts and all those things that tell you you're useless at it and you never give up. Part of the reason places like this exist, to allow people to try and improve.
      singulars
      1. POValidate Vat number in C#
      1. USAdrian
    3. CO@Russ C: or the more math solution - to use `%`
      singulars
      1. POValidate Vat number in C#
      1. USzerkms
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload