asp.net - Fill DataGrid according to logged in user -
itemprop = "text">
Itemprop = "text">
Hello my scenario is that if the employees believe that 1 had created 3 clients and Employee 2 had created 4 clients, What should the 1 employee should have to see only that detail of the customer he had built. Please guide me how to proceed, how to create a table structure and get filter criteria, a little confused about this.
Thank you
First of all, you need a login, so that the staff will Can log in to the site. Otherwise, you do not know which employee created the customer.
Again, you need business logic, in which the employee can only recover his / her client.
In the database,
employee table
employee ID | Username Password ----------- + --------------------- 1 Jondo | Hash 2 Married Palm
role table
RoleId | Name ------- + -------------- 1 | Administrator 2 | Employee
employee intrant table
employee ID | RoleId ----------- + -------- 1 | 2 2 | 2
client table
ClientId | Employee ID. Some other data --------- + ------------ + ----------------- 1. 1 | ... 2 | 1 | ...
Comments
Post a Comment