public List <UserDetailSuperiorResult> GetAllUserDetailBySuperior(string superiorID)
{
string qry = string.Format(@"SELECT
o.ID ID
,o.Employee_ID EmployeeID
,Name = u.FullName
,Position=o.Position_JobDescription
,SupEmployeeID=o.IS_ID
FROM [dbo].[uvw_EmployeeMasterCoaching] o (NOLOCK)
INNER JOIN [dbo].[uvw_EmployeeMasterTableGrow] u (NOLOCK) ON u.[User_ID]=o.Employee_ID
WHERE o.IS_ID='{0}'" , superiorID);
List <UserDetailSuperiorResult> userDetails = new List <UserDetailSuperiorResult>();
userDetails = new EPMSContext().GetList <UserDetailSuperiorResult>(qry);
return(userDetails);
}
public List <UserDetailResult> GetAllUserDetail()
{
string qry = @"SELECT
ID
,Employee_ID EmployeeID
,LastName
,MiddleName
,FirstName
,Position_JobDescription JobDescription
,Campaign
,LOB LoB
,CampaignCategory
,Location
,[Site]
,IS_ID ISID
,IS_LastName ISLastName
,IS_FirstName ISFirstName
,Coach_ID CoachID
,Coach_Name CoachName
,QA_ID QAID
,QA_Name QAName
,Trainer_ID TrainerID
,Trainer_Name TrainerName
,Operations_Manager OperationsManager
,Senior_Operations_Manager SeniorOperationsManager
,[Status]
,Department
,Status_Approval StatusApproval
FROM [dbo].[uvw_EmployeeMasterCoaching] (NOLOCK) " ;
List <UserDetailResult> userDetails = new List <UserDetailResult>();
userDetails = new EPMSContext().GetList <UserDetailResult>(qry);
return(userDetails);
}
public PersonalScheduleService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public AdminService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public SalaryService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public ProductService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public DepartmentService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public StaffInfoService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public PositionService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public AttendanceService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public CompanyScheduleService(EPMSContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
