public static IList <FutureStatus> GetFutureStatus(long RequestId) { using (var context = new SalesReturndbEntities()) { var fut = context.SP_GetFutureStatusDetails(RequestId).ToList(); IList <FutureStatus> list = null; list = fut.Select(s => new FutureStatus() { Status = s.Status, EmployeeCode = s.EMP_CODE }).ToList(); //var reqdata = context.TblRequestHeaders.Where(x => x.RequestHeaderId == RequestId).FirstOrDefault(); //var CheckIF = context.TblApproverHeaders.Where(x => x.Request_Id == RequestId).FirstOrDefault(); //var checkReqStatus = context.TblFutureStatus.Where(x => x.Request_ID == RequestId).FirstOrDefault(); return(list); } }