How to a . (period) in a http bind variable[Answered] RSS

• • Reply
  adenjones@gm...

  Member

  1 Points

  7 Posts

  How to a . (period) in a http bind variable

  Apr 01, 2020 12:27 AM|adenjones@gmail.com|LINK

  I have been working with C# MVC for while now but hadn't come across this scenario because my original project utilised database first development. 

  I have the following:

  Model Class:

  public partial class QuestionType : EntityBase
  {
  public string Type { get; set; }
  }

  public partial class Question : EntityBase
  {

  public string QuestionText { get; set; }

  public virtual QuestionType QuestionType { get; set; }
  
  }

  public class EntityBase
  {
  [Key]
  [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
  public int Id { get; set; }
  [Display(Name = "Created")]
  [DisplayFormat(DataFormatString = "{0:dd MMM yyyy h:m:s tt}")]
  [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
  public DateTime Created { get; set; }
  [Display(Name = "Last Updated")]
  [DisplayFormat(DataFormatString = "{0:dd MMM yyyy h:m:s tt}")]
  [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
  public DateTime LastUpdated { get; set; }
  }

  In the contrtoller:

  public IActionResult Create()
  {
  ViewBag.questionTypes = _context.QuestionTypes.ToList();

  return View();
  }

  In the view:

  <form asp-action="Create">
  <div asp-validation-summary="ModelOnly" class="text-danger"></div>
  <div class="form-group">
  <label asp-for="QuestionText" class="control-label"></label>
  <input asp-for="QuestionText" class="form-control" />
  <span asp-validation-for="QuestionText" class="text-danger"></span>
  </div>
  <div class="form-group">
  <label asp-for="QuestionType.Id" class="control-label"></label>
  
  <select asp-for="QuestionType.Id" asp-items="@(new SelectList(ViewBag.questionTypes,"Id","Type"))">
  <option>Question Type:</option>
  </select>
  <span asp-validation-for="QuestionType.Id" class="text-danger"></span>
  </div>
  <div class="form-group">
  <input type="submit" value="Create" class="btn btn-primary" />
  </div>
  </form>

  And when collecting:

  [HttpPost]
  [ValidateAntiForgeryToken]
  public async Task<IActionResult> Create([Bind("QuestionText,QuestionType.Id")] Question question)
  {

  ViewBag.questionTypes = _context.QuestionTypes.ToList();

  if (ModelState.IsValid)
  {
  
  }
  return View(question);
  }

  Now this all works fine if I just use Id instead of QuestionType.Id but that would be leveraging the Id of the Question not the QuestionType and wouldn't work if there were numerous drop down lists. So how do I access the sub member "QuestionType.Id" because it doesn't bind when I reference it in the second create method.

  Thanks in advance.

• • Reply
  bruce (sqlwo...

  All-Star

  58174 Points

  15647 Posts

  Re: How to a . (period) in a http bind variable

  Apr 01, 2020 03:46 PM|bruce (sqlwork.com)|LINK

  the Bind attribute does not support dot notation. the Prefix may work for you, but this is the wrong approach. you should have a post back model with the correct binding attributes on each property, rather than try to override the attributes  in the action parameters.

  bruce (sqlwork.com)
• • Reply
  adenjones@gm...

  Member

  1 Points

  7 Posts

  Re: How to a . (period) in a http bind variable

  Apr 01, 2020 10:59 PM|adenjones@gmail.com|LINK

  I don't think I understand your response and if I did understand it I probably wouldn't have needed to ask the question in the first place. I believe I have used the correct binding attribute as, if you look at my model, the Id is a property of the QuestionType and I am using the appropriate dot notation to refer to it.

• • Reply
  Sherry Chen

  Contributor

  2070 Points

  606 Posts

  Re: How to a . (period) in a http bind variable

  Apr 02, 2020 06:18 AM|Sherry Chen|LINK

  Hi adenjones@gmail.com ,

  Bind attribute specifies which properties of a model should be included in model binding. In your code , you include the  "QuestionType.Id" in the model binding, but there is no property named "QuestionType.Id" in Question model . 

  For binding the id of QuestionType , I suggest you add a  foreign key property in Question model

  public partial class Question : EntityBase
  {
        public string QuestionText { get; set; }
  
        public int QuestionTypeId { get; set; }
        public virtual QuestionType QuestionType { get; set; }
  
  }

  Create

  [HttpPost]
  [ValidateAntiForgeryToken]
  public async Task<IActionResult> Create([Bind("QuestionText,QuestionTypeId")] Question question)
  {}

  View

  <div class="form-group">
       <label asp-for="QuestionTypeId" class="control-label"></label>
  
       <select asp-for="QuestionTypeId" asp-items="@(new SelectList(ViewBag.questionTypes,"Id","Type"))">
          <option>Question Type:</option>
       </select>
       <span asp-validation-for="QuestionTypeId" class="text-danger"></span>
  </div>

  Best Regards,

  Sherry

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
  
• • Reply
  adenjones@gm...

  Member

  1 Points

  7 Posts

  Re: How to a . (period) in a http bind variable

  Apr 03, 2020 07:30 AM|adenjones@gmail.com|LINK

  QuestionType is a class which has an Id attribute. I was trying to reference the encapsulated classes field. 

• • Reply
  adenjones@gm...

  Member

  1 Points

  7 Posts

  Re: How to a . (period) in a http bind variable

  Apr 05, 2020 05:44 AM|adenjones@gmail.com|LINK

  Thanks Sherry I have added the property and it works fine now