How to Create a Master-Detail like Customer & Order Details

Niyazi Toros

10y1.4k.NET

Hi,

I want to create a Master Detail (ex: Customer & Order Details) MVC 5 page. My problem is that I have to use only VS2015 Community edition and I am not allow to use any js for this project.

I red few articles that I can create what I want as long as I am using SQL SP. Some kind of web api they used.

I am using asp.net 4.5 and MVC 5. Does anyone have any quick solution for this? Or how can I use SQL SP to build master detail MVC 5 page?

As shown below, simply is that in OrderDetailsTable I need "SELECT" button next to Edit, Details and Delete as: Select | Edit | Details | Delete

When I press the select button than opens the Order Details table. The Order Details Table must have only Edit | Details | Delete buttons.

Then my View I need to show Customer Table and below I need to show my Order Details Table.

Here is my sample table.

CustomerTable

CustomerId
Name
Surname
DateOfBirth

OrderDetails Table

OrderId
CustomerId
ProductName
Price
Unit
Total

Kind Regards

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano10y ago
Accepted answer
adding a select link is pretty much the same to adding links to your edit and details link. You can simply add an ActionLink to your grid like:
@Html.ActionLink("Select","OrderDetails",new{id=item.CustomerID})
If you are new to ASP.NET MVC then I would suggest you to learn the basics on how MVC works because even if i give you chunks of code it will just confuse you and you will not be able to connect the dots in the picture. You can start learning at the official ASP.NET site to learn about CRUD operations in MVC:http://www.asp.net/mvc/overview/getting-started/introduction/examining-the-edit-methods-and-edit-view
You can also download my ebook for ASP.NET MVC 5 that is targeted for beginners.
http://www.c-sharpcorner.com/ebooks/asp-net-mvc-5-a-beginner-s-guide
Niyazi Toros10y ago
Thank you Vincent,
I will open another quesiton for the "PartialViews". I need someting more on this subject.
Kind Regerds
Vincent Maverick Durano10y ago
To open a different View in the same page then you would need to use PartialViews since you can't use JavaScript to hide/show a div element.
A partial view is kind of a mini-view where you can inject it to your main view to display different results.
Niyazi Toros10y ago
Thank you Vincent,
@Html.ActionLink("Select","OrderDetails",new{id=item.CustomerID})
the line of code is okay for me. I did very basic MVC and I have a 'upper :) ' basic understanding in MVC. But I don't have intermediate level understanding. I cannot use any js because my assigmnet said so :(
Also can you post some code for how to open another view in same page with MVC 5?
Thank you very much for e-book.
Kind Regards,
Niyazi Toros10y ago
Hi Vincent,
Do you have any source code for the link that you provided? Also in link there is no SELECT action? So how can I add Select acction to my Customer Index.cshtml page
so I can open second view in same page but below Customer View for Order Details?
What I need is that in Custmer.cshtml pageI need alse Select button next toEdit | Details | Delete buttons. And when I click the Select buttons in below it will open a Order Details View. In Order Details View I can click the Create New button to enter new order details for that custmer.
How can I do that?
Kind Regards
Vincent Maverick Durano10y ago
Is there any particular reasons why you can't use JavaScript? I mean majority of the website today relies heavily on JavaScript.
If you don't want to use JavaScript then you would need two Views that will act as master-details. The first View will display the the Customer table info and then you second View displays your OrderDetails. Here's an example that may help you to get started:http://www.c-sharpcorner.com/UploadFile/4b0136/perform-crud-functionality-in-Asp-Net-mvc-5/