Passing information from view to different models

Hi,

I need show a registration form where information will be taken from two tables, users and address. Information from these two tables should be presented to the user in one view, I have some idea on how to do that just looking for the best way.

1) I can have a class that contain information from those two tables and pass it to the controller then to the view

is this the best way?

2) Now the user has filled the form I need to post it back to those two tables

Thanks for your help

Schleid

I don't really understand. What does public Address address{get;set;} do?

Here is what I have come up as a solution, I am expecting someone to tell me if it is a good way of doing that

Here is the structure of the two table in my database

table Employee

EmployeeID int not null

FirstName nchar(25) not null

and so one

Table Address

AddressID int not null

EmployeeID int not null

Address nchar(50)

City nchar(30)

State nchar(20)

Country nchar(30)

Now I create a the employeeDetails class

public int employeeid {get; set;}

public int addressID {get; set;}

public string FirstName {get; set;}

public string LastName {get; set;}

public string address {get; set;}

public string City{get; set;}

Public string State{get; set;}

public String Country {get; set;}

I have a procedure saying like this

select

employee.EmployeeId,

employee.firstname,

employee.lastname,

address.address,

address.city,

address.state,

address.country

from employee

right outer join

address.employeeid on address.employeeid = employee.employeeid

then I create a methode the method

public employedetails getemployedetails

where I call the store proc to return and the employee information and address information

Thank you for your time

public Class User
{
public string UserName{get;set;}
public String Somethingvalue {get;set;}
public Address address{get;set;}
}
public class Address
{
public Local_Address {get;set;}
public Permanent_Address {get;set;}
}

I am trying to understand why a list of address when each user has a unique address?

Thank you for helping

Hi Schleid Alex,

you need the One user class and List

for example like that.

public Class User
{
public string UserName{get;set;}
public String Somethingvalue {get;set;}
public List
LstAddress{get;set;}
}
public class Address
{
public LocalAddress {get;set;}
public PermanentAddress {get;set;}
}

I hope u understand, what's going in above class.

Thanks

Joginder Singh

I found this article my only problem is I am not dealing with a list of user but just one user and his address information, how can I adapt the code in this article

https://www.aspsnippets.com/Articles/Pass-Send-Multiple-Models-to-one-View-in-ASPNet-MVC-Razor.aspx

Laxmidhar, I don't understand.

You are in the write direction

8 Replies

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

Schleid Alex6y ago
Nobody has an idea?
0
Schleid Alex6y ago
I don't really understand. What does public Address address{get;set;} do?
Here is what I have come up as a solution, I am expecting someone to tell me if it is a good way of doing that
Here is the structure of the two table in my database
table Employee
EmployeeID int not null
FirstName nchar(25) not null
and so one

Table Address
AddressID int not null
EmployeeID int not null
Address nchar(50)
City nchar(30)
State nchar(20)
Country nchar(30)

Now I create a the employeeDetails class
public int employeeid {get; set;}
public int addressID {get; set;}
public string FirstName {get; set;}
public string LastName {get; set;}
public string address {get; set;}
public string City{get; set;}
Public string State{get; set;}
public String Country {get; set;}

I have a procedure saying like this

select
employee.EmployeeId,
employee.firstname,
employee.lastname,
address.address,
address.city,
address.state,
address.country
from employee
right outer join
address.employeeid on address.employeeid = employee.employeeid

then I create a methode the method

public employedetails getemployedetails
where I call the store proc to return and the employee information and address information

Thank you for your time
0
Joginder Banger6y ago
1. public Class User
2. {
3. public string UserName{get;set;}
4. public String Somethingvalue {get;set;}
6. public Address address{get;set;}
8. }
10. public class Address
11. {
13. public Local_Address {get;set;}
14. public Permanent_Address {get;set;}
17. }
Okay if you think user has a unique address, but i believe user have multiple address. So I added the list of address in user class.
Change the class structure as per the require.