Application scenario: is this possible #8687

12 Answer(s)

• 

  0

  ismcagdas created 4 years ago

  Support Team

  Hi @zimplerconsulting

  Yes, you can definitely use Roles to separete Teachers and Students.

  Each teacher could have one or more students Each student could have one ore more teachers.

  You have to create a relation entity (table) between Users to achieve this.

  Save Cancel
• 

  0

  zimplerconsulting created 4 years ago

  Hi @ismcagdas,

  Thanks for the follow up. Could you eleborate a bit more on this relation entity? If I can make a User a 'Teacher or Student or Both' based on Roles, why would I need a relation? And between which entities you mean?

  Hope you can help me some more.

  Thanks, Daniel

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  @zimplerconsulting

  Sorry I got it wrong. I thougt Students can have Teachers and vice versa but tou were talking about Schools having Users and Teachers.

  Save Cancel
• 

  0

  zimplerconsulting created 4 years ago

  Yes. That is correct.

  So I guess a School can be just the Tenant.

  Every User inside the Tenant can be either a Teacher, a Student or both. But indeed, now I think about it: a Student could have one or more Teachers and a Teacher could have one or more Students.

  So yeah, do I need multiple entities for this or can I re-use the Users for this and extend that entity?

  Best, Daniel

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  If you want to have a relation between Student and Teacher, then as I said before, you can create a relation entity. It is better to keep track for such relation.

  Save Cancel
• 

  0

  zimplerconsulting created 4 years ago

  OK, but do I need to create separate Entities for Students and Teachers? I mean, can I re-use the Users from a Tenant for this? Because a User can login to a Tenant app.

  If I need the same functionality for a Student or Teacher, it seems a bit overkill to create exactly the same Entities.

  But maybe I don't get the concept of a relation entity. What is it?

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  OK, but do I need to create separate Entities for Students and Teachers? I mean, can I re-use the Users from a Tenant for this? Because a User can login to a Tenant app.

  Yes, you can use User entity for that, sure.

  Save Cancel
• 

  0

  zimplerconsulting created 4 years ago

  Thanks! Ehm... any example on this? How would you do this in AspnetZero?

  Sorry, it's just not quite clear :(

  Save Cancel
• 

  0

  musa.demir created 4 years ago

  Hi @zimplerconsulting

  Your application has students and teachers who are users basically. So a user can be a student or teacher or whatever(maybe admin or something). You can create a roles 'Teacher' and 'Student', and grant those roles to your users. Then when a user logged in you can check if the student/teacher role granted to the user and then you can run your logic.

  You can check these: https://aspnetboilerplate.com/Pages/Documents/Authorization, https://aspnetboilerplate.com/Pages/Documents/Zero/Permission-Management

  ---

  For the second part of your requirement, a student can have teachers, and teachers can have student. It means you need many to many relations. Basically you can create an entity something like,

  [Table("TeachersAndStudents")]
  public class TeachersAndStudents : Entity, IMayHaveTenant
  {
      public long StudentId { get; set; }    
      public long TeacherId { get; set; }     
      public int? TenantId { get; set; }
      
      [ForeignKey("StudentId")]
      public virtual User Student { get; set; }
      
      [ForeignKey("TeacherId")]
      public virtual User Teacher { get; set; }   
      ...
  }
  

  then you can use

  //add teacher 2 to student 1, in other words, add student1 to teacher2
  (IRepository<TeachersAndStudents>).Insert(new TeachersOfStudent {
  StudentId = 1,
  TeacherId = 2,
  TenantId = AbpSession.TenantId
  })
  

  then you can query them with something like

  var teachersOfStudent = (IRepository<TeachersAndStudents>).GetAll().Where(x=>x.StudentId == 1).Tolist();
  
  var studentsOfTeacher =  (IRepository<TeachersAndStudents>).GetAll().Where(x=>x.TeacherId == 2).Tolist();
  

  Save Cancel
• 

  0

  zimplerconsulting created 4 years ago

  Ah ok. I see. That makes sense. Thanks!

  And it would be possible to extend the User screens with e.g. possibilites to select teachers or students? (e.g. with a dropdown or so). I don't know if there are any examples for such a case like this? Or any other many-to-many examples?

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  Yes, that is possible but there is no example in the default template. You need to implement it yourself.

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  @zimplerconsulting please reopen this issue if you face any problems.

  Save Cancel