Write to BD without mask applied by jQuery

Question

I am doing a project in MVC and with the use of jQuery I made CPF mask as below:

$(document).ready(function()
{
    $(".cpf").mask("999.999.999-99");
    $(".cpf").addClass("form-control");
});

Follow my div:

<div class="form-group">
    @Html.LabelFor(model => model.Cliente_CPF, htmlAttributes: new { @class = "control-label" })
    <div>
        @Html.EditorFor(model => model.Cliente_CPF, new { htmlAttributes = new { @class = "cpf" } })
        @Html.ValidationMessageFor(model => model.Cliente_CPF, "", new { @class = "text-danger" })
    </div>
</div>

The mask is working properly, but I need this information to be recorded in my BD without the mask! Just the CPF numbers.

Like I should do?

Answer 1

I see two options: (1) treat client-side value with Javascript (2) treat server-side value with C#. For full guarantee, you can implement both forms.

Javascript

With Javascript, you can assign a role to the event submit form and in this function remove all characters that are not CPF digits.

$(document).ready(function()
{
    $(".cpf").mask("999.999.999-99");
    $(".cpf").addClass("form-control");

    // vvvvv--- Lembre-se de colocar o seletor correto para o seu caso:
    $("#form").submit(function () {
        var cpfValue = $(".cpf").val();

        // Remove os caracteres que não são dígitos:
        cpfValue = cpfValue.replace(/\D/g, '');

       // Atualiza o valor no campo do formulário:
       $(".cpf").val( cpfValue );
    });
});

This way, the value sent will only be numerical.

C#

This language is not my area, but a quick search I saw that you can do something like:

string cpfOnlyDigits = Regex.Replace(cpf, "[^\d]", "");

So in the database, instead of saving the value of cpf, which would be the value received in the HTTP request, you would save the value of cpfOnlyDigits, the value being filtered, with only digits.