private ExternalShiftEmployeeIndexDTO ExternalShiftEpmloyee(OpenShiftDTO location, string distance)
        {
            var email = HttpContext.Current.User.Identity.Name;
            ExternalShiftEmployeeIndexDTO retVal = new ExternalShiftEmployeeIndexDTO();

            retVal.ExternalShits = GetExternalShiftsList(location, distance);

            var empExternalShiftRequests = from sr in db.ExternalShiftRequests
                                           where sr.CreatedBy.Email == email &&
                                           sr.Type == ExternalShiftRequestType.TakeExternalShift
                                           select sr.ExternalShiftBroadcast.Id;

            retVal.ExternalShiftRequests = empExternalShiftRequests.AsEnumerable();
            return(retVal);
        }
        public ExternalShiftEmployeeIndexDTO GetEmployeeExternalShift()
        {
            var email = HttpContext.Current.User.Identity.Name;
            ExternalShiftEmployeeIndexDTO result = new ExternalShiftEmployeeIndexDTO();
            var dtNow = WebUI.Common.Common.DateTimeNowLocal();

            result.ExternalShits = GetExternalShifts(email);

            var empExternalShiftRequests = from sr in db.ExternalShiftRequests
                                           where sr.CreatedBy.Email == email &&
                                           sr.Type == ExternalShiftRequestType.TakeExternalShift
                                           select sr.ExternalShiftBroadcast.Id;

            result.ExternalShiftRequests = empExternalShiftRequests.AsEnumerable();
            return(result);
        }