6
Answers

ASP.NET Core Razor - cascade dropdown from 4 tables

Marius Vasile

Marius Vasile
4y
608
1
The problem is I have 4 tables, Table 1, Table 2, Table 3 and Table 4. Table 1 has one-to-many relations with Table-2, Table 2 one-to-many to Table 3 and so on. all are similar on content, tables content below
 
  1. public class HazardsClass  
  2.     {  
  3.         [Key]  
  4.         public int IdHC { get; set; }  
  5.         public string HazClass { get; set; }  
  6.         public ICollection<HazardsDetail> HazardsDetails { get; set; }  
  7.     }  
  8.   
  9.     public class HazardsDetail  
  10.     {  
  11.         [Key]  
  12.         public int IdH { get; set; }  
  13.         public string HazDetail { get; set; }  
  14.         public int IdHC { get; set; }  
  15.         [ForeignKey("IdHC")]  
  16.         public HazardsClass HazardsClass { get; set; }  
  17.   
  18.         public ICollection<HazardsPMClass> HazardsPMClasses { get; set; }  
  19.     }  
  20.   
  21.     public class HazardsPMClass  
  22.     {  
  23.         [Key]  
  24.         public int IdPMC { get; set; }  
  25.         public string HazPMClass { get; set; }  
  26.         public int IdH { get; set; }  
  27.         [ForeignKey("IdH")]  
  28.         public HazardsDetail HazardsDetail { get; set; }  
  29.         public ICollection<HazardsPMDetail> HazardsPMDetails { get; set; }  
  30.     }  
  31.   
  32.     public class HazardsPMDetail  
  33.     {  
  34.         [Key]  
  35.         public int IdPM { get; set; }  
  36.         public string HazPMDetail { get; set; }  
  37.         public int IdPMC { get; set; }  
  38.         [ForeignKey("IdPMC")]  
  39.         public HazardsPMClass HazardsPMClass { get; set; }  
  40.     }  
My problem is to view the information in dropdown lists, ex. First I choose a HazClass then from the list I choose a HazDetails and so on.  
 
 How do I do that?
Answers (6)
Next Recommended Forum