Edit two tables simultaneously in an "Edit" view

Question

Edit two tables simultaneously in an "Edit" view

Asked 9 years, 2 months ago

Viewed 122 times

2

I have two tables: Pessoa and Catequizando, with a 1:1 ratio and want to make a "Get" to the data of the two tables, both "id s" are equal, so I did the

Catequizando catequizando = db.Catequizando.Find(id);
Pessoa pessoa = db.Pessoa.Find(id);

I don’t know how to do the return view of the 2 tables.

Controller:

  public ActionResult Edit(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Catequizando catequizando = db.Catequizando.Find(id);
            Pessoa pessoa = db.Pessoa.Find(id);
            if (catequizando == null)
            {
                return HttpNotFound();
            }

            ViewBag.CatequizandoID = new SelectList(db.Pessoa, "PessoaID", "Nome", catequizando.CatequizandoID);
            return View(catequizando);
        }

Unfortunately you didn’t answer my question, I can do @create between 2 models in the view, using a viewmodel, but I can’t "get" the data from 2 tables in Edit.

– Simão Lopes

2015/08/27 at 16:48
I think I got it, your problem is in . Find(id) ? because in the question you put "I don’t know how to do the 2 tables' view." ?

– Brunno

2015/08/27 at 16:58
@Brunno Why did you erase your answer?

– Leonel Sanches da Silva

2015/08/27 at 17:00
@I think I ran away from what he was asking

– Brunno

2015/08/27 at 17:00
@Brunno did not run away no. This is the right way. Only a few things are missing.

– Leonel Sanches da Silva

2015/08/27 at 17:04

1 answer

Browser other questions tagged c# asp.net-mvc

You are not signed in. Login or sign up in order to post.

by Brunno • **3,531** points · Answer 1 · 2015-08-27T16:45:33+00:00

You can create an intermediate class (view model), where you will have two attributes, one of the type Catechizing and Person example:

public class CadastroViewModel
{
    public Catequizando catequizando { get; set; }        
    public Pessoa pessoa { get; set; }
}

Now pass this class in your view model, and then get it in your controller. To access the attributes in the view just do the normal process:

@model caminho.CadastroViewModel

@Html.EditorFor(model => model.catequizando.SEUATRIBUTO)
@Html.EditorFor(model => model.pessoa.SEUATRIBUTO)

In your case it would look like this:

public ActionResult Edit(int? id)
{
    if (id == null)
    {
        return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
    }

    Catequizando catequizando = db.Catequizando.Find(id);
    Pessoa pessoa = db.Pessoa.Find(id);

    CadastroViewModel cadastro = new CadastroViewModel();
    cadastro.catequizando = catequizando;
    cadastro.pessoa = pessoa;

    if (catequizando == null)
    {
        return HttpNotFound();
    }

    ViewBag.CatequizandoID = new SelectList(db.Pessoa, "PessoaID", "Nome", catequizando.CatequizandoID);
    return View(cadastro);
}