Link relationship between Model, VIew and Control

Question

Hi Team I need some help, i want to create simple dashbaord, that will allow me to show training details(fiels been mapped from my sql server database), generate advert(dont know how to do this). Need to have a category(all types for my registration linked to my database table fields name). Some examples will enlightned me more please. Please assist team, thanks.

Guest User · Answer

Hi Team On my View Folder, file "_Layout.cshtml" i am experience this exception The value cannot be null, parameter name 'virtualPath'. How can i solve this @{ var controller = HttpContext.Current.Request.RequestContext.RouteData.Values["Controller"].ToString(); string layout = ""; if(controller == "Admin") { Layout = "~/Views/Shared/_Layout.cshtml"; }else { Layout = "~/Views/Shared/_MainLayout.cshtml"; } Layout = layout;

Ashutosh Gupta · Answer

this may help https://www.c-sharpcorner.com/article/dynamically-bind-the-dropdownlist-on-change-event-in-asp-net-mvc-5/

Guest User · Answer

Hi Rupesh I am using MVC and not using Entity framework to access the scheman from application. Interface yes is used on my folder "Repository" and configuring web.config the datasource for my sql server database with table columns. The question is to find a way in between, yes when i am done hopefully Monday, will send the UI on the same topic for you have an overview.

Rupesh Kahane · Answer

Hi Is it possible to show some sample properties or any dummy UI? Example Their is an company which having some classes & relationship in between all as below class Company { EmployeeId int , Name string } class Department { DeptId int , DeptName string } class EmployeeMapping { Id int , EmployeeId int , DeptId int } Their will be a mapping between each employee & department Suppose our database contains values in employee, department & employee detail table like each EmployeeId Name DeptId DeptName Id EmployeeId DeptId 1000 Sam 100 Computer 1 1000 100 1001 John 102 Electronics 2 1001 102 Now we can create an MVC project which contains controllers, view & model. To perform CRUD operation their are many ways 1) Normal ADO.Net connection & store procedure 2) Database first approach using entity framework 3) Using interface, repository pattern & entity framework Optional - for better UI design you can use Bootstrap libraby . So we can create a relationship in between all & achieve our development easily. I have following questions. If you provide me some input then I will help you or anyone can help you easily 1) I have not too much idea how much you are awar about the MVC. 2) If you are new in MVC then you will get interest while creating an application. 3) Let me know which approach would you like to use to perform CRUD operation (see the above points) Their are so many articles & videos available online in free to expore MVC. Hope so this will helps you. :) (Y)

Guest User · Answer

Hi Rupesh How does the dropdownlist works, does it sinks with your database? Of cause silly question i guess you do configuration on your web.config calling your datasource. I need a way around when selecting from the dropdown this must reference, of cause in both your model and controller, you mapp this using an interface either on your Repository file and assemblies. I hope you understand what i am trying to accomplish here, please so if i dont to support me with more relevant link or sources to this issue mates.

Rupesh Kahane · Answer

refer link https://www.c-sharpcorner.com/article/dynamically-bind-the-dropdownlist-on-change-event-in-asp-net-mvc-5/ http://www.c-sharpcorner.com/article/crud-operation-using-repository-unit-of-work-pattern/