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

Question

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

Vincent Maverick Durano · 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 Toros · Answer

Thank you Vincent I will open another quesiton for the PartialViews. I need someting more on this subject. Kind Regerds

Vincent Maverick Durano · Answer

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 Toros · Answer

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 Toros · Answer

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 to Edit | 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 Durano · Answer

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/