MVC :: How To Create A Controller And View With Data Coming From Seprate Tables Associated With Foreign Key

Mar 8, 2011

I am using Entity Frameowrk as the ORM. I am new to MVC and trying to develop a samll module as a learning project.

Now I am stuck with an issue for which I can't seem to find out answer on web. The issue is :

I have two tables mapped as entities - Tenant_Definition and Contact

Tenant_Definition { Tenant_ID , Desc, Contact_ID}

Contact {Contact_ID, Company_Name,Company_Address,Person_Name, Person_Phone_Mobile}

My View has to present a form that shows Tenant Desc and Contact related fields. The index view works fine and shows the desired values.

But, the create view isn't working out. In the create view, i am planning to do -

1. creating a new contact entity instance and saving it in db

2. Then creating a new tenant entity instance using the new contact_id and save it to the DB.

However, the code doesn't seem to be inserting any value inside Contacts table. It inserts null value.Below is the code snippet of my Create Controller -

[HttpPost]
public ActionResult Create(FormCollection collection)
{
var newContact = new Contact();[code]....

View 6 Replies


Similar Messages:

MVC :: Create A Partial View And A Controller That Will Feed Data To the View?

Jan 27, 2010

Can i create a partial view and a controller that will feed data to the view, and if i render that partial in a Master page, the Data will show on whatever URL i am?

Or is there another way of showing content from database on every page(view)?

View 2 Replies

How To Load Foreign Key Referenced Tables Data Also In Entity Framework

May 3, 2010

I developed and entity framework (.edmx) application in 4.0 in that i got all the data of my querying table and its foreign key referenced tables data also. but when i change my project to 3.5 i am unable to get the data of foreign key referenced tables data.

View 2 Replies

Adding Data Into Tables Includes Foreign Keys But Which New Row Created Entity Framework

Apr 6, 2010

Adding data into kartlar table (RehberID,KampanyaID,BrimID) is ok. But which Kart'ID created? I need to learn which Id created after adding data (RehberID,KampanyaID,BrimID) into Kartlar?

[code]...

How can I do that? I want to get data from Kartlar which data I added?

View 1 Replies

MVC :: Create A Link In A Webform To Controller-View?

May 25, 2010

I want to link to a MVC View from my code-behind in a Webform, but I can't figure out how to do it and I have googled for an eternity :(

View 3 Replies

JavaScript Parameters Coming From View's Model Data?

Jul 29, 2010

I've seen/read plenty advocating "unobtrusive" JavaScript contained in separate files. I'm preparing to combine all my JavaScript from three partial views into a single file that I will then reference somewhere in my master.

My question is: is there any type of JavaScript that should remain behind in the html? One example that seems to me may present a problem would be something like:

<script type="text/javascript">
$(document).ready(function () {
$('#newQuoteLink').click(function () {[code]...

Am I correct in assuming this script would not work if loaded from a separate file?I mostly wanted to check if there were any caveats or other considerations prior to combining everything into this lone, separate file.

View 2 Replies

DataSource Controls :: How To Create View In SQL Sever That References Oracle DB Tables

Jun 29, 2010

how to create a view in SQL server that references tables in an oracle db?

View 2 Replies

SQL Server :: Foreign Key On Multiple Tables?

Jan 30, 2011

I have four tables namely tblStudent, tblParent, tblEmployee and tblUnwantedVisitor.

tblUnwantedVisitor should get the primary key from the three tables, which is the visitor ID, tblStudent visitor ID starts from 10000, tblEmployee from 20000 and tblEmployee from 30000.

I used foreign key from one to one table only, so I don't know if my approach for the database is wrong or foreign key for multiple tables, which is somehow unlikely, is necessary.

View 14 Replies

Forms Data Controls :: Display Foreign Key Value In Grid View?

Aug 14, 2010

I have a search button ..The result will be displayed in grid view if the button is pressed .. i am able to do it

But now i want to do like this ..that is my grid view is only displaying the ResultId .. I want to display the ResultName rather than resultID in the table

View 5 Replies

DataSource Controls :: Dml For Primary And Foreign Key Tables?

Jun 3, 2010

how i insert,update and delete data in multiple table .such tables in which primary and foreign key constraint are

View 1 Replies

Forms Data Controls :: VS 2008 Cannot Insert Foreign Key Value In Form View?

Jul 26, 2010

I have a database with a 1 to many relationship in SQL Server 2008. I have created a formview in VS2008 to insert records into the child table. However I can't set the foreign key to automatically insert this value. If I manually type in a value the insert works but I need it to pick up the fk ID automatically from the master table. How can I do this?

The master table: tblTopic has ID int auto increment primary key and the child table has ID int auto increment primary key and TopicID int allow duplicates no nulls, foreign key. I have set updates to cascade in the relationship.

My insert statement is INSERT INTO tblTopic (TopicID, Comment, SubmittedBy) VALUES (@TopicID, @Comment,@SubmittedBy). The TopicID keeps throwing the error, this is the foreign key.

This is the first time I have tried to do this, so apologies if it's really obvious but I'm on a bit of learning curve.

View 10 Replies

SQL Server :: Is It Possible One Foreign Key Referenced By Two Primary Keys From Different Tables

Dec 15, 2010

i'll make a simple website. in my website i have two kind of products to sell

1. Projects

2. Documents

These Tables are available in my database :

[code]...

now i will make an order table. should i make differentt order table?

or i could save order information of both tables in one table?

View 6 Replies

C# - Foreign Key Constraint Issue When Deleting From Multiple Tables Using Linq To Sql?

Feb 27, 2011

I have two tables with a foreign key constraint how can I delete rows from both of them in one transaction? linq to SQL seems to call my deletes in the wrong order. Is there somewhere I can check and make sure the constraint is recognized properly by linq to SQL??

DataContext.OtherImages.DeleteOnSubmit(myOtherImage);
DataContext.Images.DeleteOnSubmit(myImage);
DataContext.SubmitChanges();

The Foreign key constraint is on OtherImages.

View 2 Replies

MVC :: Pass Parameter From Controller To View And Back To Another Controller?

Aug 16, 2010

I have a simple model where a Person has Gifts. I have a view which is a list of Gifts belonging to one Person.

My problem is with the Create action for a new Gift. I want it to default to the PersonID that we are already viewing the list of Gifts for. I tried simply passing the last PersonID (they are all the same)

Html.ActionLink("Create New", "Create", new { id = Model.Last().PersonID }) which works fine if there is already at least one Gift for that person but if this is the first Gift I don't have a value.

My Gift List controller knows the PersonID I want to pass but the view doesn't.

How do I pass this PersonID from my Gift List controller to my Gift Create controller via the Gift List view? Or is there a better way to do this?

View 2 Replies

MVC :: Get Some Data From One Controller To Other's One View?

Jan 18, 2011

I have a website. there's master page with a menu implemented as a partial view Menu.ascx. This menu is a list of available categories which can be choosen. There's a separate controller for this view. the controller just gets all available categories from database and passes to the view as a list. here's the view's code

[Code]....

and controller for this view

[Code]....

there's other controller which is responsible to retrieve data for content page when one of categories is seletced.

[Code]....

So, i want somehow to get the current category in Menu.ascx.

View 3 Replies

MVC :: Post Data From View To Controller?

Mar 24, 2010

I'm a php programmer (code igniter) but interested in learning ASP.net MVC, I have a few question regarding this new exciting framework In php codeigniter's controller I can easily catch a post variable using

[Code]....

In comparison in ASP.net MVC we can create an action method that will accept post variable (but the parameter can get very crowded if we're passing a lot)

[Code]....

Or using FormCollection

[Code]....

Is there a way to catch post variable in ASP.net that looks like php's codeigniter? I mean not by adding the parameter, because I wanted a controller method that is flexible in receiving post request A controller that can accept and process any post request like in php (where we don't have to put that parameter to the controller method, we just call them

[Code]....

View 3 Replies

MVC :: Passing Data From Controller To View

Nov 16, 2010

I have setup an httppost that sends a string into my controller, searches for some results using linq, and then sends the results to a view. In debug stepping through the code I can see the data that I am looking for being passed into the return view statement, but the page just appears to refresh (it doesn't render the view as expected with the result). why my controller fails to redender the view? (note: I didn't include the view because I can send a ToList() to it without an issue. For example, return View(_entities.Persons.ToList());

[HttpPost]
public ActionResult RenderSearch(string usersearchtext)
{
if (usersearchtext != null)
{
var search_results = from s in _entities.Persons
where s.Description.Contains(usersearchtext)
select s;
return View("SearchResult", search_results.ToList());
}
else
{
throw new NotImplementedException();
}
}

View 8 Replies

MVC :: Data From Action In Controller To View

Jan 19, 2011

So I have a dropdown in a form which when at item is selected postback to database and get some values which I am now storing in an object. I need to get the values from this object into textboxes on the form in the view..how can I do this???

View 2 Replies

Passing Data From A View To A Controller In MVC?

Apr 22, 2010

I have a dictionary I'm passing to a View. I want to be able to pass the values of that dictionary back to a Controller action from this same View. Is there anyway this can be accomplished without using a form? The situation is that I need to be able to pass these back to a controller action that is called when a user clicks an ActionLink from the View, and in my experience an ActionLink cannot be used to submit a values of a form, i.e. I've only been able to submit values of a form using the form's submit button. Unless there's a way to use an ActionLink to submit values in a form.Controller Action passes Dictionary to Controller in ViewData:

public ActionResult ModifyNewCrossListing(FormCollection form)
{
Dictionary<int, string> prefixlist = new Dictionary<int, String>();

[code]...

View 1 Replies

MVC :: Passing Data From View To The Controller With Dropdownlist

Jul 14, 2010

I have a table with a ID, CodeID,LibelleID field. I am using oracle connection. i want to display in a drop downlist (textfield) CodeID+LibelleID for exemple "100-SalaryBase" where CodeID=100 and LibelleID="SalaryBase" is it possible to obtain it if the user selects an element from the dropdownlist how to post both the codeID and ID to the controller

View 4 Replies

MVC :: Posting Data From Partial View To Controller

Jan 13, 2011

Im having trouble with posting data from a view that also contains a partialview. Im using a viewmodel that has 2 objects in it. The data that comes from the view is correct and fine, but the data that im trying to get from the partialview is null, or rather the object is null. The partialview doesnt contain that much, the user can check/uncheck some checkboxes and thats it. Heres how the partialview looks like

[Code]....

And heres the View

[Code]....

View 3 Replies

MVC :: Passing Data From View Back To Controller

Sep 23, 2010

I have following situation - I am pasing user info object from Controller to View. It contains GUID UserID, which i dont want to be seen on page. So I removed every Html.LabelFor(model => model.UserID), Html.TextBoxFor(model => model.UserID) etc... from generated View source. And because of this when Html.BeginForm() returns that object back to Controller all values is there but UserID is lost??

If I leave Html.LabelFor(model => model.UserID), Html.TextBoxFor(model => model.UserID) etc.. in View everything is fine. But I dont want to show UserID? Where is the problem here?

<%= Html.LabelFor(model => model.C__User_Id) %>

View 6 Replies

MVC :: Data Lost In Transition From View - Controller

Sep 28, 2010

MVC basics or looks like I am doing something terribly wrong, but have not slightly idea what is it? Want to delete user from MVC Framework's Built in Security Module. So first I define Delete() in AccountController:

[Code]....

and this works fine. Second: I added view (for delete) DeleteUser.aspx

<h3>Are you sure you want to delete this?</h3>
<fieldset>
<legend>Fields</legend>
<div class="display-label">UserId</div>
<div class="display-field"><%= Html.Encode(Model.UserId) %></div>
<div class="display-label">UserName</div>
<div class="display-field"><%= Html.Encode(Model.UserName) %></div>
<div class="display-label">LoweredUserName</div>
<div class="display-field"><%= Html.Encode(Model.LoweredUserName) %></div>
.... etc
And this works fine.
And then finaly when I submit this values for delete, and run back to the Controller and DeleteUser:
[Authorize]
[HttpPost]
public ActionResult DeleteUser(aspnet_Users inUser)
{
...

It is a problem. Not a single value from View are pased?? For example:

inUser.UserName is null,
inUser.UserId 00000000-0000-0000-0000-000000000000,
... etc.

All values form view are losted? Why and how this can be?

View 4 Replies

MVC :: Passing ViewModel With Data From View To Controller

Dec 13, 2010

I am trying to pass a view model of mine, which has multiple list in it, to my view. Then in my view i need to edit the different list. Then on my post i need to save the edits. Although, when i pass my viewmodel back to my post, it is empty! Can somebody explain what i am doing wrong? Controller

[Code]....
here is my View

[Code]....

NewsViewModel

[Code]....

View 2 Replies

MVC :: Debugging Controller / View Data Flow

Feb 23, 2010

I've started using ASP.NET MVC on a project and have gotten a few working pages, but I recently ran into a problem where data I was carrying through a hidden field didn't carry for some reason. I can think of a couple of possible reasons and I could try things until something works but I prefer to work on observable empirical data. Thus the point of this inquiry.

I've got a controller (several), a model (several), a view (several), and data in the browser for the JavaScript to chew on. I can unit test my JavaScript code. The browser / view interactions go over the wire, and I can capture that either with Firebug or (if I want to punish myself) Ethereal. I can write unit tests for the controller and for components of the model. The thing that appears to happen in a pure "black box" is the mapping between the model objects and the view form fields. Somewhere in that process, it tries to map data from form fields into model objects before it hands a request to the controller and it tries to map data from the model objects to form fields when it processes the response. Even with the helpers in play, this is a source of bugs. There can be spelling disconnects, or a page might be inadvertently missing one of the fields of a model object because it didn't use it. It would be nice to know if a field didn't map and why.

Since it is happening on the server, this seems like the handoffs should be unit testable or at least loggable. The problem seems pretty bounded. I can't be the first person to have run into this question. Are there any hooks I can use for this? What are the best observation points in the framework to tap the process, both incoming and outgoing?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved