Link relationship between Model, VIew and Control

Guest User

6y1.1k.NET

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.

6 Replies

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

Guest User6y ago
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;
0
Ashutosh Gupta6y ago
this may help
https://www.c-sharpcorner.com/article/dynamically-bind-the-dropdownlist-on-change-event-in-asp-net-mvc-5/
0
Guest User6y ago
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.
0

Rupesh Kahane6y ago

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 User6y ago
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.
0
Rupesh Kahane6y ago
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/
0