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.
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.
--------------------------------------------------
Sincerely,
Nick
ASP.NET, SQL Server [Database Engine, SSIS & SSRS],Entity Framework, C# and VB.NET
Member
56 Points
358 Posts
how to obtain all employees under any specific manager
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.
EMPID,Employee,DateWorked,hours,ActivityType,JobRefNo,Comments,Rate,previousmodifieddate.
Please Guide me how to approach on this.
Thanks.
asp .NET
Member
310 Points
152 Posts
Re: how to obtain all employees under any specific manager
Oct 01, 2010 02:04 AM|Alpesh Patel|LINK
Hi,
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.
Alpesh Patel
http://www.radhesoftech.com
Member
56 Points
358 Posts
Re: how to obtain all employees under any specific manager
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....
Member
667 Points
616 Posts
Re: how to obtain all employees under any specific manager
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.
Sincerely,
Nick
ASP.NET, SQL Server [Database Engine, SSIS & SSRS],Entity Framework, C# and VB.NET