Model validation using db value in Range

Question

I have two tables, Campaign and Advert with a one to many relationship. During Advert creation, the user selects a pre-defined Campaign to which the Advert will belong. A Campaign has an RRP money field and the Advert has a SalePrice money field. What I'm after is a way to ensure that the submitted Advert.SalePrice is >= the chosen Campaigns RRP.

Can this be done in the model? Something along the lines of this in the Advert_Validation? Is it even possible to fill the values of a Range with method calls?

[Range(0, getCampaignRRP(), ErrorMessage = "Value must be equal or greater than the Campaign RRP")]
public double SalePrice { get; set; }

Or do I need to check at the Controller level? All help appreciated!

Thanks all,

Jay

lancscoder · Accepted Answer · 2011-02-09 17:08:15Z

2

You can use the new Remote attribute. Basically it calls an action and returns true or false. Here's a link to an example.

answered Feb 9, 2011 at 17:08

lancscoder

8,7888 gold badges50 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sarvesh · Accepted Answer · 2011-02-09 18:08:24Z

0

You can inherit the RangeAttribute class and use that instead.

public class MyRange: RangeAttribute
    {
        public override bool IsValid(object value)
        {
            //Your validation here.
            return MyValidateRange(value, 0, getCampaignRRP());
        }
    }

[MyRange(0, 0, ErrorMessage = "Value must be equal or greater than the Campaign RRP")]
public double SalePrice { get; set; }

answered Feb 9, 2011 at 18:08

sarvesh

2,7411 gold badge20 silver badges30 bronze badges

Collectives™ on Stack Overflow

Model validation using db value in Range

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related