Saas Question #9902

4 Answer(s)

• 

  0

  zony created 4 years ago

  Support Team

  Hi christianharo,
  I think this is a typical data permission use case.
  This is a business scenario of a specific domain. You can create three static roles (teacher, parent, student). In this scenario, the teacher and students have a one-to-many relationship, and parents and students have a one-to-many relationship.
  When querying specific data, different query statements need to be constructed according to three different roles. For example, if a teacher wants to view the test scores of his own students, he needs to get the teacher's Id from ICurrentUser, and then query the associated student ID collection. Finally, LINQ JOIN test scores are obtained for all students.

  var students = _studentTeacherRep.GetAll().Where(st => st.TeacherId == CurrentUser.Id);
  var scores = _scoreRep.GetAll()
      .Join(students, score => score.StudentId, student => student.StudentId, (score, student) => score)
      .ToList();
  

  (Organization Unit Management may help you.)

  Save Cancel
• 

  0

  christianharo created 4 years ago

  Hi Zony,

  Thansk for your answer however i was looking for something a little structured like DataFilters, as you Said Organization managment will be a good place , are there implemented filters or custom data filters I could use for the organizaiton Unit ?

  Save Cancel
• 

  1

  ismcagdas created 4 years ago

  Support Team

  Hi @christianharo,

  If you want to use this approach in a limited number of pages, you can directly filter data using a LINQ where clasue. If you want to do this in the entire app, you can define a data filter as explained in the below tutorial;

  https://aspnetboilerplate.com/Pages/Documents/Articles\How-To\add-custom-data-filter-ef-core

  Save Cancel
• 

  1

  christianharo created 4 years ago

  Thank you. This is what I was looking for appreciate your help.

  Save Cancel