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

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -