Attribute in Dataannotations for Currency

Question

I would like to format with Dataannotation currency but standard

in the model:

[Column("cur_mensalidade")]
[DataType(DataType.Currency)]
[DisplayFormat(DataFormatString = "{0:C0}")]
public decimal? Mensalidade { get; set; }

but does not accept the comma. even in web.config

 <system.web>
    <globalization uiCulture="pt" culture="pt-BR" enableClientBasedCulture="false" />

I have tried creating a regular expression to format

[RegularExpression(@"^\d+(\.|\,)\d{2}$", ErrorMessage = "{0} valor incorreto.")]

Answer 1

You can implement a ModelBinder for that reason.

public class DecimalModelBinder : DefaultModelBinder
{
    public override object BindModel(ControllerContext controllerContext,
                                     ModelBindingContext bindingContext)
    {
        object result = null;

        // Don't do this here!
        // It might do bindingContext.ModelState.AddModelError
        // and there is no RemoveModelError!
        // 
        // result = base.BindModel(controllerContext, bindingContext);

        string modelName = bindingContext.ModelName;
        string attemptedValue =
            bindingContext.ValueProvider.GetValue(modelName).AttemptedValue;

        // Depending on CultureInfo, the NumberDecimalSeparator can be "," or "."
        // Both "." and "," should be accepted, but aren't.
        string wantedSeperator = NumberFormatInfo.CurrentInfo.NumberDecimalSeparator;
        string alternateSeperator = (wantedSeperator == "," ? "." : ",");

        if (attemptedValue.IndexOf(wantedSeperator) == -1
            && attemptedValue.IndexOf(alternateSeperator) != -1)
        {
            attemptedValue =
                attemptedValue.Replace(alternateSeperator, wantedSeperator);
        }

        try
        {
            if (bindingContext.ModelMetadata.IsNullableValueType
                && string.IsNullOrWhiteSpace(attemptedValue))
            {
                return null;
            }

            result = decimal.Parse(attemptedValue, NumberStyles.Any);
        }
        catch (FormatException e)
        {
            bindingContext.ModelState.AddModelError(modelName, e);
        }

        return result;
    }
}

And in his Global.asax in the Application_Start() just add the DecimalModelBinder:

ModelBinders.Binders.Add(typeof(decimal), new DecimalModelBinder());
ModelBinders.Binders.Add(typeof(decimal?), new DecimalModelBinder());

References:

• How to set decimal separators in ASP.NET MVC controllers?
• Accept comma and dot as decimal separator

Answer 2

According to the image, who is validating the input is the browser, and not your app. See and it did not create a <input type="number" />. Because if it is, it is out of your control to format, as it will depend on the culture of the browser, and maybe Windows.

In this case, you will have to manually create the HTML input field, such as <input type="text" /> and then format it in another way - javascript or backend, as you prefer.

I’ve used the jQuery Mkoneymask. A lib jQuery made by a brazuca. Gives a bizú and see if it solves your need.

Answer 3

This validation should be done via jquery. Create a jquery.validade.ptbr.js file

$.validator.methods.range = function (value, element, param) {
var globalizedValue = value.replace(",", ".");
return this.optional(element) || (globalizedValue >= param[0] && globalizedValue <= param[1]);}$.validator.methods.number = function (value, element) { return this.optional(element) || /^-?(?:\d+|\d{1,3}(?:[\s\.,]\d{3})+)(?:[\.,]\d+)?$/.test(value);}

And put it on the view. In dataannotation, as globalization is already set to en-br not need to put all this information, I only leave as decimal? and it works.

But in your case, the problem is the validation in the client does not even enter the controller. That’s why you have to solve the javascript.