Last post Oct 01, 2010 02:28 AM by Nick Asiimwe
Oct 01, 2010 12:51 AM|pactools|LINK
I am working on Employee activity project developing in ASP.net3.5-MySql Database, every end of the day employee will upload his day activity(on which job worked,howmany hours he spent....) i need to provide manageral access of all his employee,
which means when manager login in to system only managers allow to view and edit his employees inputs of last 7 days records,other managers should not view the other group employees. employee table having following columns.
Please Guide me how to approach on this.
Oct 01, 2010 02:04 AM|Alpesh Patel|LINK
Please use the Id of Logged In manager and use that ID to filter all record or employee or else in each and every page.
Oct 01, 2010 02:20 AM|pactools|LINK
Thanks can please eloberate it, you want me to do provide username itself as ID to managers....
Oct 01, 2010 02:28 AM|Nick Asiimwe|LINK
I guess then you also have a Managers table with something like a ManagerID column. You might consider adding a foreign key to the fields above. some thing like EMPID,
ManagerID, Employee,DateWorked,hours,ActivityType,JobRefNo,Comments,Rate,previousmodifieddate such that when a manager logs in, you get their ManagerID
value and return matching records.