Edit missing the fk value while saving in asp.net mvc

Question

0.00/5 (No votes)

See more:

Hi,

I have a table called contract, has following fields

Id(uniqueidentifier),contractno(int), personname(varchar(50)),NationalityId(fk,uniqueidentifier),
OccupationId(FK,uniqueidentifier), SalaryId(fk,Uniqueidentifier).

Salary has been defined in the salarydetails table with the following fields based on occupation and nationality

Id(pk,unique identifier),OccupationId(fkuniqueidentifier,ud),NationalityId(fk,uniqueidentifier),salary(int)

I am using asp.net mvc to create a contract, which is working fine

but the problem is in edit, which loads the data, but while saving salary id is missing, so model.isvalid is becomes false

The code in the view is given below

HTML

<div class="editor-field">
         @Html.TextBoxFor(model => model.SalaryDetail.Salary)
         @Html.ValidationMessageFor(model => model.SalaryId)
</div>

Instead of salarydetail.salary, if I put SalaryId then the edit form loads the id instead of salary value from the table, in the case its working but i supposed to display the salary not the id

Your help will be much appreciated.

[Edit]Code block added[/Edit]

Posted 10-Mar-13 7:55am

Ahamed Azeem

Updated 10-Mar-13 8:01am

Thomas Daniels

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2013-03-10T08:05:00

Solution 1

It depends on your model too. But I suppose you don't want the user to enter GUID's, and you won't be able to make editor for a referenced fields - it is not in the scope of your edited model instance (you could however display it). It looks to me that you need to use a DropDownList there. There are several alternatives how to populate it, look here for one of them: http://odetocode.com/blogs/scott/archive/2010/01/18/drop-down-lists-and-asp-net-mvc.aspx[^]

Posted 10-Mar-13 8:05am

Zoltán Zörgő

Comments

Ahamed Azeem 10-Mar-13 14:12pm

yes I suppose dont want the user to enter guids but so what can i do is i can disable the textbox so the value cannot be changed but user can just see it. The problem is only if I put the guid value on the textbox its inserted otherwise its not, i suppose not to display the guid but to display the value associated with the guid

Zoltán Zörgő 10-Mar-13 16:58pm

Simply use @model.SalaryDetail.Salary. Or build a field on it manually. And use an input model for editing, not the original data model - it is also a security consideration.