Answers

• sanderk Posts: 26Questions: 4Answers: 1

  September 2020

  C#

  [HttpGet]
          [HttpPost]
          public ActionResult HuurdersTable([FromForm]string GebouwID = "-1")
          {
  
              using (var db = new Database("azure", _configuration.GetConnectionString("DataContext")))
              {
                  var editor = new Editor(db, "Huurders", "id")
                      .Model<HuurderViewModel>("Huurders")
                      .Field(new Field("NaamHuurder")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "De naam van de huurder is verplicht." }))
                       )
                      .Field(new Field("Huisnummer")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Het huisnummer is verplicht." }))
                       )
                      .Field(new Field("StartDatumContract")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een geldige datum in." }))
                          .GetFormatter(Format.DateSqlToFormat("dd-MM-yyyy"))
                          .SetFormatter(Format.DateFormatToSql("dd-MM-yyyy"))
                       )
                      .Field(new Field("EindDatumContract")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een geldige datum in." }))
                          .GetFormatter(Format.DateSqlToFormat("dd-MM-yyyy"))
                          .SetFormatter(Format.DateFormatToSql("dd-MM-yyyy"))
                       )
                      .Field(new Field("Opzegtermijn")
                         .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een getal in." }))
                          .Validator(Validation.Numeric("nl-NL", new ValidationOpts { Message = "Voer een getail in." }))
                       )
                      .Field(new Field("AantalM2VVO")
                           .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een getal in." }))
                          .Validator(Validation.Numeric("nl-NL", new ValidationOpts { Message = "Voer een getail in." }))
                          .SetFormatter((val, data) => val.ToString().Replace(",", "."))
                          .GetFormatter((val, data) => val.ToString().Replace(".", ","))
                       )
                      .Field(new Field("AantalM2BVO")
                           .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een getal in." }))
                          .Validator(Validation.Numeric("nl-NL", new ValidationOpts { Message = "Voer een getail in." }))
                          .SetFormatter((val, data) => val.ToString().Replace(",", "."))
                          .GetFormatter((val, data) => val.ToString().Replace(".", ","))
                       )
                      .Field(new Field("GebouwId")
                          .SetValue(GebouwID)
                       )
                      .Where("GebouwId", GebouwID)
                      .MJoin(new MJoin("HuurderExtraEigenschappen")
                          .Link("Huurders.id", "HuurderExtraEigenschappen.HuurderId")
                          .Field(new Field("id"))
                      )
                      ;
  
                  editor.PostCreate += (sender, e) => _LogChange(db, "Huurders", "create", e.Id, e.Values);
                  editor.PostEdit += (sender, e) => _LogChange(db, "Huurders", "edit", e.Id, e.Values);
                  editor.PostRemove += (sender, e) => _LogChange(db, "Huurders", "remove", e.Id, e.Values);
  
                  var response = editor.Process(Request).Data();
  
                  return Json(response);
              }
          }
  
          [HttpGet]
          [HttpPost]
          public ActionResult HuurderExtraEigenschappenTable([FromForm]string HuurderId = "-1")
          {
  
              using (var db = new Database("azure", _configuration.GetConnectionString("DataContext")))
              {
                  var editor = new Editor(db, "HuurderExtraEigenschappen", "Id")
                      .Model<HuurderExtraEigenschapViewModel>("HuurderExtraEigenschappen")
                      .Model<HuurderViewModel>("Huurders")
                      .Model<HuurderEigenschapType>("HuurderEigenschapTypen")
                      .Field(new Field("HuurderExtraEigenschappen.Ingangsdatum")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een geldige datum in." }))
                          .GetFormatter(Format.DateSqlToFormat("dd-MM-yyyy"))
                          .SetFormatter(Format.DateFormatToSql("dd-MM-yyyy"))
                       )
                      .Field(new Field("HuurderExtraEigenschappen.Waarde")
                          .Validator(Validation.NotEmpty(new ValidationOpts { Message = "Voer een getal in." }))
                          .Validator(Validation.Numeric("nl-NL", new ValidationOpts { Message = "Voer een getal in." }))
                          .SetFormatter((val, data) => val.ToString().Replace(",", "."))
                          .GetFormatter((val, data) => val.ToString().Replace(".", ","))
                       )
                       .Field(new Field("HuurderExtraEigenschappen.HuurderId")
                          .Options(new Options()
                              .Table("Huurders")
                              .Value("id")
                              .Label("NaamHuurder")
                          )
                          .Validator(Validation.DbValues(new ValidationOpts { Empty = false }))
                      )
                       .Field(new Field("HuurderExtraEigenschappen.HuurderEigenschapTypeId")
                          .Options(new Options()
                              .Table("HuurderEigenschapTypen")
                              .Value("Id")
                              .Label("Naam")
                          )
                          .Validator(Validation.DbValues(new ValidationOpts { Empty = false }))
                      )
                      .LeftJoin("Huurders", "Huurders.id", "=", "HuurderExtraEigenschappen.HuurderId")
                      .LeftJoin("HuurderEigenschapTypen", "HuurderEigenschapTypen.Id", "=", "HuurderExtraEigenschappen.HuurderEigenschapTypeId")
                      .Where("HuurderId", HuurderId);
  
                  editor.PostCreate += (sender, e) => _LogChange(db, "HuurderExtraEigenschappen", "create", e.Id, e.Values);
                  editor.PostEdit += (sender, e) => _LogChange(db, "HuurderExtraEigenschappen", "edit", e.Id, e.Values);
                  editor.PostRemove += (sender, e) => _LogChange(db, "HuurderExtraEigenschappen", "remove", e.Id, e.Values);
  
  
                  return Json(editor.Process(Request).Data());
              }
          }
  
• allan Posts: 61,660Questions: 1Answers: 10,094 Site admin

  September 2020

  var selectedHuurderrow = huurderTable.row({ selectedHuurderrow: true });

  that isn't going to work - selectedHuurderrow is not a selector modifier that DataTables will understand. Try:

  var selectedHuurderrow = huurderTable.row({ selected: true });
  

  Also, since you are using server-side processing, instead of:

  huurderExtraEigenschappenTable.ajax.reload();

  Use:

  huurderExtraEigenschappenTable.draw();
  

  If they don't resolve the issue, can you link to the page please.

  Thanks,
  Allan
• sanderk Posts: 26Questions: 4Answers: 1

  September 2020

  Hi,

  Thank you so much.

  It resolves almost everything. However,

  The edit and remove buttons also don't work for the child table. I cannot select a row.

  And

   huurderExtraEigenschappenEditor
              .field('HuurderExtraEigenschappen.HuurderId')
              .def(huurderTable.row({ selected: true }).data().id);
      });
  

  Doesn't seem to work. The select menu doesn't have the right option selected when I press new
• allan Posts: 61,660Questions: 1Answers: 10,094 Site admin

  September 2020

  I don't see anything in the code above that would cause the rows in the child row not to be selectable. Does the huurderExtraEigenschappenTable table exist in the document when that code is executed? I'm guessing so, since I don't see anything that is inserting it. If it doesn't though, then you need to call $.fn.DataTable.select.init(huurderExtraEigenschappenTable); since it needs to be in the document for Select to be automatically initialised.

  If that doesn't help, I'd need a link to the page showing the issue to be able to help and debug it.

  Thanks,
  Allan
• sanderk Posts: 26Questions: 4Answers: 1

  September 2020

  The row in the child table was not selectable because of the [ ]

  select: [{
              style: 'single'
          }],
  

  should be

  select: {
              style: 'single'
          },
  
• allan Posts: 61,660Questions: 1Answers: 10,094 Site admin

  September 2020

  That would do it - well spotted.

  Allan