Part 6: Using Data Annotations for Model Validationhttp://asp.netSat, 08 Dec 2012 22:58:39 GMTumbracoComments for Part 6: Using Data Annotations for Model ValidationenComment Posted by myshadowhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Tue, 13 Jul 2010 22:19:33 GMT00000000-0000-0000-000000009439Thanks very much for this tutorial. It was a bit frustrating at times to work through it, but most definitely worth the effort. Learned a lot!

]]>Comment Posted by sasiatiahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Tue, 04 Jan 2011 09:55:12 GMT00000000-0000-0000-0000000011409:) I'm happy

]]>Comment Posted by CFonsecahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Mon, 18 Apr 2011 14:15:46 GMT00000000-0000-0000-0000000012855I was having trouble with the decimal separator for the Price field, but found the solution and i post it here for people having the same problem.

The problem i was having was related with having the comma or a point as the decimal separator. I discovered that putting a globalization statment in the web.config for the aplication solved the problem.

<system.web>

<globalization culture ="en-US" />

.

.

.

Hope migh help someone

]]>Comment Posted by arrow3215http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sun, 01 May 2011 07:39:30 GMT00000000-0000-0000-0000000013044I found, that due to the

[Bind(Exclude = "AlbumId")]

in the Album model the HTTPOST - "Edit" - Action not working anymore.

Adding

public ActionResult Edit(Album album, int id)

{

if (ModelState.IsValid)

{

album.AlbumId = id;

helped.

]]>Comment Posted by rob graingerhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Thu, 05 May 2011 19:20:13 GMT00000000-0000-0000-0000000013083@arrow3215

Thanks for posting that - may have saved me some work.

]]>Comment Posted by inmykingdomhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sun, 22 May 2011 10:46:32 GMT00000000-0000-0000-0000000013240I think an explanation on why AlbumId is excluded from the binding model but added as scaffoldcolumn would be interesting. Seeing that it would without this, it's unclear what the goal is of adding these attributes.

]]>Comment Posted by dtaurhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Fri, 03 Jun 2011 07:44:54 GMT00000000-0000-0000-0000000013377I've found out that AlbumId is 0 on Edit POST and it fails. Now I see I'm not the only one. I agree with inmykindom that it would be nice to know what was the reason of putting [Bind(Exclude = "AlbumId")] attribute.

]]>Comment Posted by darkrider23http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Fri, 03 Jun 2011 08:50:18 GMT00000000-0000-0000-0000000013378I think the reason AlbumId is exluded is because you could potentially change the AlbumId through the url

]]>Comment Posted by KimMogensenhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Fri, 22 Jul 2011 15:26:44 GMT00000000-0000-0000-0000000013814@arrow3215: also thanks from me...

]]>Comment Posted by Fermathttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Thu, 01 Sep 2011 07:04:39 GMT00000000-0000-0000-0000000014100isn't it a way to mix Model stuff with View stuff? I don't think is good to have some 'invasive' properties there (like DisplayMessage)... Just only think in localization issues...

]]>Comment Posted by garysevenhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 21 Sep 2011 10:10:43 GMT00000000-0000-0000-0000000014233arrow3215, thanks for the fix!

]]>Comment Posted by samarmirhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Thu, 06 Oct 2011 15:23:14 GMT00000000-0000-0000-0000000014349Thanks again for another part.

And thanks to the users that are correcting the errors in this part and explaining the not so clear things

Mohammad

]]>Comment Posted by TheGDizzohttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 02 Nov 2011 13:57:43 GMT00000000-0000-0000-0000000014547NOTE: I don't know if it's because of updates to EF 4.1 or the model binder... but including the Data Annotation of:

[Bind(Exclude = "AlbumId")]

In Models\Album.cs ended-up causing the value of AlbumID to be returned as 0 (zero) in the Album Entity returned in the HTTPPOST'd Edit method in the StoreManagerController.cs in the next tutorial. Which threw up an exception.

What I am not 100% sure on is if this behavior started when I changed my connectionString's in web.config such that VWD2010 Express would now be storing the data onto my SQL Server 2008 R2 rather than SQl Compact 4.0.

The other goofy issue I'm experiencing, which might also be related to now using 2008 R2 - rather than - Sql Server Compact 4.0... is that Album.Price amounts are only getting stored as whole dollar amounts. Even when I tried to go directly into SSMS and execute an UPDATE statement on the record directly... which showed the 1 rows affected.. when I would go back to another open query showing the top 1000 rows... when I would re-execute that query I could see where I updated the Title text... (both Price and Title were updated within the same update statement to provide me a visual tattle-tale) but the Price amount was still showing as a whole dollar figure??

Can somebody tell me if this is happening because this is VWD2010 >>>EXPRESS<<< perhaps? Maybe this is Microsoft's behind-the-scenes way of ensuring developers go purchase the full-blown?? This behaviour is soo bizarre I'm hoping this is the reason why.

P.S. - Please see my comments posted on the next tutorial for more insight and information into these findings.

]]>Comment Posted by TheGDizzohttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 02 Nov 2011 14:04:30 GMT00000000-0000-0000-0000000014548@arrow315 - Great Minds my friend, Great minds =) I'm upset with myself that I didn't think of just taking that "id" value and stuffing it back into the album.AlbumId field.

]]>Comment Posted by nightzeushttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sat, 05 Nov 2011 02:23:55 GMT00000000-0000-0000-0000000014562@arrow3215

Thanks. :) I hate when tutorials send you on a wild goose chase and you end up spending more time debugging the author's mistake(s).

]]>Comment Posted by Eileithyiahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Tue, 15 Nov 2011 14:55:03 GMT00000000-0000-0000-0000000014634@nightzeus, yeah the author failed. Thanks to arrow3215. Also there are many part that is very hard to understand. More explanation would help alot. I kind of want to know the "why", instead of "how"

]]>Comment Posted by michaelpower17http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Thu, 24 Nov 2011 19:32:14 GMT00000000-0000-0000-0000000014687Think I somehow pasted code with a different version of jquery than that in my project.

View/Shared/_Layout.cshtml

<!DOCTYPE html>

<html>

<head>

<title>@ViewBag.Title</title>

<link href="@Url.Content("~/Content/Site.css")"

rel="stylesheet" type="text/css" />

<script src="@Url.Content("~/Scripts/jquery-1.4.4.min.js")"

Had to change the last line to jquery-1.5.1.min.js

Then it works :)

]]>Comment Posted by bartowjhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Fri, 01 Jun 2012 16:27:24 GMT00000000-0000-0000-0000000015644Jon,

I have a really simple use case with just one foreign key in a 1 to 0..1 "vertical inheritance" relationship between only two tables with a total of 4 properties/fields in the entire solution that your tutorial doesn't address. Can you provide some insight into how to get this to work. Do I need to use a ViewModel?

stackoverflow.com/

]]>Comment Posted by Richard Scannellhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 06 Jun 2012 06:52:41 GMT00000000-0000-0000-0000000015693Hi Jon,

How would we implement more complex model validation ? EG date x must be greater than date y, or that the amount entered into the payment field of a shopping cart equals the sum of all items bought, plus shipping & taxes, minus any discounts..

]]>Comment Posted by superandihttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sun, 17 Jun 2012 06:01:17 GMT00000000-0000-0000-0000000015790If you want the "," as a decimal seperator (not using the workaround from CFonseca), have a look at www.andreas#comment-409 . It is German, though.. basically, it describes how an application localization can be properly changed (if you don't do it, client- and serverside validation seem to be different languages/cultures, meaning that both "6.66" adn "6,66" will not be accepted - once by client-side and the other time by server-side).

Also, there seemed to be a problem with the "Create", anyone else noticed? I changed it to DB-generated and everything worked (the AlbumID).

[ScaffoldColumn(false)]

[DatabaseGenerated(System.ComponentModel.DataAnnotations.DatabaseGeneratedOption.Identity)]

public int AlbumId { get; set; }

]]>Comment Posted by eradwenhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 08 Aug 2012 16:28:14 GMT00000000-0000-0000-0000000016137Thank you @CFonseca for this quick fix and thanks to @arrow3215 for making the edit form work again! I wish the author had explained the purpose of [Bind(Exclude = "AlbumId")]

]]>Comment Posted by cmarekhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sun, 19 Aug 2012 22:34:43 GMT00000000-0000-0000-0000000016212I got to part 6 in the MvcMusicStore tutorial. Then my data disapeared! I can not seem to recover the data back into my dataBase. I would very much like to finish this tutorial. Any help would be greatly appreciated

]]>Comment Posted by cmarekhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Tue, 21 Aug 2012 00:58:20 GMT00000000-0000-0000-0000000016230Never mind my complaint. I caused the problem myself! As I made my way thru the tutorial I was adding many of my own comments in the code, and somewhere along the way I have corrupted my code. I know this is likely because I decided to start over from scratch but added no comments (too tired too) and now I am having no trouble this second time.

]]>Comment Posted by scorpio62http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Wed, 05 Dec 2012 07:19:46 GMT00000000-0000-0000-0000000016938If you are using Visual Studio 2012 with MVC 4, the client side validation still not works,

That the client side validation works you have do add following:

1) Add with NuGet Package Manager "jQuery Unobtrusive Validation".

2) Add in Views/StoreManager/Create.cshtml following after the <h2>Create</h2>:

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")"></script>

<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")"></script>

]]>Comment Posted by sabinpradhanhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6Sat, 08 Dec 2012 22:58:39 GMT00000000-0000-0000-0000000016966Thanks @arrow3215 for solving error of edit action and as other say it will be great if author explained the purpose of [Bind(Exclude = "AlbumId")]

]]>