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; }