Adding Text Box and Writing to Database. (with C#, entityframework 6.1.3)

Question

I am doing a project in Visual Studio 2013, with Entityframework version 6.1.3, MVC 4.5.0.0 and using Viewmodel.

I am programming a page that is called payment condition. The creation page will have a text field nome, 2 radiobuttons: "the view" and "on time". If the user selects the view nothing will happen.

Now, if the radiobutton "In time" is selected, a button will appear to add textboxes of the days to be filled. I need to make this schedule to add the textboxes as you click the add days button and then make a function to record in the bank.

I think the function of the Add Days button I can do in Jquery, and then the creation button that will add a function in the database Controller.

I know jquery, add the text boxes, now I’m a little lost in the part of c#, the save in the bank made in Controller.

the code below is from my viewmodel:

    [Key]
    [DisplayName("Id")]
    public int CondicaoPagamentoId { get; set; }

    [Required(ErrorMessageResourceName = "PropertyValueRequired", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [MinLength(DataConfig.DATABASE_MIN_LENGTH_DEFAULT, ErrorMessageResourceName = "MinLengthAttribute_ValidationError", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [MaxLength(DataConfig.DATABASE_MAX_LENGTH_DEFAULT, ErrorMessageResourceName = "MaxLengthAttribute_ValidationError", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [DisplayName("Nome")]
    public string Nome { get; set; }

    [Required(ErrorMessageResourceName = "PropertyValueRequired", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [MinLength(DataConfig.DATABASE_MIN_LENGTH_DEFAULT, ErrorMessageResourceName = "MinLengthAttribute_ValidationError", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [MaxLength(DataConfig.DATABASE_MAX_LENGTH_DEFAULT, ErrorMessageResourceName = "MaxLengthAttribute_ValidationError", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [DisplayName("Tipo")]
    public bool Tipo { get; set; }

    [Required(ErrorMessageResourceName = "PropertyValueRequired", ErrorMessageResourceType = typeof(DataAnnotationsResources))]
    [DisplayName("Dias")]
    public int CondicaoPagamentoDiasId { get; set; }
    public virtual CondicaoPagamentoDiasViewModel CondicaoPagamentoDias { get; set; }
    public virtual IEnumerable<CondicaoPagamentoDiasViewModel> CondicaoPagamentoDiass { get; set; }

    [DisplayName("Cadastrado por")]
    public int UsuarioCadastroId { get; set; }
    public virtual UsuarioViewModel UsuarioCadastro { get; set; }

    [DisplayName("Data de Cadastro")]
    public DateTime DataCadastro { get; set; }

the addition is made by:

this.add(objeto)

Answer 1

Well, it’s all right for you to use the Begincollectionitem. Just implement now. My suggestion for the installments starts in the code of View down below:

<div class="condicoes-pagamento" id="condicoes-pagamento">
    @if (Model != null)
    {
        foreach (var condicoesPgto in Model.CondicaoPagamentoDiass)
        {
            @Html.Partial("_CondicoesPagamentoDia", condicoesPgto);
        }
    }
</div>

To Partial _CondicoesPagamentoDia would look like this:

@model MeuProjeto.ViewModels.CondicaoPagamentoDiasViewModel

@using (Html.BeginCollectionItem("CondicaoPagamentoDiass"))
{
    <div class="form-group">
        @Html.HiddenFor(model => model.CondicaoPagamentoDiaId)
        @Html.HiddenFor(model => model.CondicaoPagamentoId)

        <label class="col-md-1 control-label">Dia:</label>
        <div class="col-md-3">
            @Html.TextBoxFor(model => model.Dia, new { @class = "form-control" })
            @Html.ValidationMessageFor(model => model.Dia, "", new { @class = "text-danger" })
        </div>
        <div class="col-md-2">
            <a class="btn red" onclick="$(this).parent().parent().remove();">Excluir</a>
        </div>
    </div>
}

Note that the code already assumes a delete line button in Javascript. There is also an add button that can be implemented as follows:

        <script type="text/javascript">
            $("#adicionar-dia").click(function () {
                $.get('/SeuController/NovaLinhaDia', function (template) {
                    $("#condicoes-pagamento").append(template);
                });
            });
        </script>

Note that this code makes a call to a Controller. It doesn’t have to be that way. I use it this way to perform server-side validations. The code would look like this:

    public ActionResult NovaLinhaDia()
    {
        return PartialView("_CondicoesPagamentoDia", new CondicaoPagamentoDiasViewModel());
    }

Making the POST form, you will see that CondicaoPagamentoDiass you will receive all the rows completed on the form there at Action of Controller.

Answer 2

I believe you are doubtful in recovering the form data. Try the code below. Template:

  public ActionResult Gravar()
  {
    string[] chaves = Request.QueryString.AllKeys;
    Dictionary parametros = new Dictionary();
    foreach (string chave in chaves)
    {
      parametros[chave] = Request.QueryString[chave];
    }

    string nome = parametros["Nome"];
    string tipo = parametros["Tipo"];
    string dia2 = parametros["Dia1"];
    string dia1 = parametros["Dia2"];
    string diaN = parametros["DiaN"];

    // demais linhas de código.

    return View();
  }