在控制器中接收表单数据时出现问题。C# - MVC

Question

朋友们，我有三张桌子。人，学生和地址。人是一个通用的表格，有姓名、电子邮件、电话等字段。我有一个地址表来保存学生的地址。我在动态地从地址字段中获取信息和完成新的学生注册时遇到了困难，我很感谢任何人都能分析。

这是我的代码:我创建了一个AddressViewModel类来加入person和address字段。AddressViewModel.cs

public class AddressViewModel
    {

        public string PES_NAME { get; set; }
        public string PHONE { get; set; }
        public string PES_EMAIL { get; set; }
.
.
        //Address
        public string STREET { get; set; }
        public string CITY { get; set; }
        public string STATE{ get; set; }
.
.
    }

AddressContext.cs

public class AddressContext : DbContext
    {
        /*
         * EF Core - ORM
         * ORM -> Bibliteca mapear Objetos para Banco de Dados Relacionais
         */
        public AddressContext(DbContextOptions<AddressContext> options) : base(options)
        {
            
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Person>()
                .HasOne<Address>(s => s.Address)
                .WithOne(ad => ad.Person)
                .HasForeignKey<Address>(ad => ad.PES_COD);

            modelBuilder.Entity<Person>()
                .HasOne<Aluno>(s => s.Student)
                .WithOne(ad => ad.Person)
                .HasForeignKey<Student>(ad => ad.PersonID);

        }
        public DbSet<Person> Person { get; set; }
        public DbSet<Student> Student { get; set; }
        public DbSet<Address> Address { get; set; }
    }
}

在这里，我不知道该怎么做才能以正确的方式将表单数据：

PersonRepository.cs

 public void create(Person person)
        {
            _banco.Add(person);
            
            Student student = new Student();
            student.Status = "A";
            student.DataCadastro = "10/10/2020";
            student.noFormularioRenach = "1010101";
            student.CodSetor = 10;
            student.PersonID = person.PES_COD;

            _banco.Student.Add(student);

            Address address = new Address();
            address.STREET = ????????;
            address.CITY = ????????;

            _banco.Address.Add(address);

            _banco.SaveChanges();
        }

在学生的情况下，信息是插入银行，因为我直接通知代码，但学生的地址，我不知道如何从表格！

我自动生成的表单如下：

@model LojaVirtual.Models.ViewModels.Student.AddressViewModel

@{
    ViewData["Title"] = "Add";
}

<hr />
<div class="row">
    <div class="col-md-4">
        <form asp-action="Add">
            <div asp-validation-summary="ModelOnly" class="text-danger"></div>
            <div class="form-group">
                <label asp-for="PES_NAME" class="control-label"></label>
                <input asp-for="PES_NAME" class="form-control" />
                <span asp-validation-for="PES_NAME" class="text-danger"></span>
            </div>
.
.
.
          
            <div class="form-group">
                <label asp-for=PHONE" class="control-label"></label>
                <input asp-for="PHONE" class="form-control" />
                <span asp-validation-for="PHONE" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="PES_EMAIL" class="control-label"></label>
                <input asp-for="PES_EMAIL" class="form-control" />
                <span asp-validation-for="PES_EMAIL" class="text-danger"></span>
            </div>


.
.
            <div class="form-group">
                <label asp-for="CITY" class="control-label"></label>
                <input asp-for="CITY" class="form-control" />
                <span asp-validation-for="CITY" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="STATE" class="control-label"></label>
                <input asp-for="STATE" class="form-control" />
                <span asp-validation-for="STATE" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="STREET" class="control-label"></label>
                <input asp-for="STREE" class="form-control" />
                <span asp-validation-for="STREE" class="text-danger"></span>

.
.
.
.
            </div>
            <div class="form-group">
                <input type="submit" value="Create" class="btn btn-default" />
            </div>
        </form>
    </div>
</div>

<div>
    <a asp-action="Index">Back to List</a>
</div>

PersonController.cs

public IActionResult Add([FromForm]Models.Person person, string returnUrl = null)
        {
            if (ModelState.IsValid)
            {
                _clienteRepository.Add(person);
                _loginCliente.Login(person);

                TempData["MSG_S"] = "Success";

                if (returnUrl == null)
                {
                    return RedirectToAction("Index", "Home", new { area = "" });
                }
                else
                {
                    return LocalRedirectPermanent(returnUrl);
                }
            }
            return View();
        }

如果有人能帮忙我很感激！

Answer 1

Person具有要寻址的导航属性和映射的“学生实体”。查询数据库时，使用Linq利用地址/学生实体对Person实体的关系。

Person.cs应该如下所示：

public Address Address {get;set;}
public Student Student {get;set;}

人口实体：

public void Add(Person person)
{
     //instead initialize person.Student if the form doesn't pass this object
      person.Student = new Student();
        student.Status = "A";
        student.DataCadastro = "10/10/2020";
        student.noFormularioRenach = "1010101";
        student.CodSetor = 10;
        student.PersonID = person.PES_COD;
        //same thing with address
        person.Address = new Address();
        address.STREET = "123 street dr";
        address.CITY = "toronto";

        _context.SaveChanges();
}

然后，当检索person对象并需要填充外部实体时，应该如下所示：

using System.Linq;

_context.Person
.Include(x => x.Student)
.Include(x => x.Address)
.Where(x => x.Id == PersonId)
.FirstOrDefault();

表单应该是与您的人几乎相同的视图模型(DTO)：

@model Person


<input asp-for="Address.Street" type="text"/>
<input asp-for"Student.Name" type="text" />

中填充外键属性