public DataSourceResult GetAll(DataSourceRequest request) { var caseTypelist = from m in _unitOfWork.FacilityRepository.Query() join p in _unitOfWork.FacilityContractRepository.Query() on m.fac_key equals p.fct_key into facilites from p in facilites.DefaultIfEmpty() join n in GetUclData(UclTypes.State) on m.fac_stt_key equals n.ucd_key into FacilityStates from state in FacilityStates.DefaultIfEmpty() orderby m.fac_key descending select new { m.fac_key, m.fac_name, timezone = m.fac_timezone, m.fac_address_line1, m.fac_address_line2, m.fac_city, fac_state = state != null ? state.ucd_title : "", m.fac_zip, m.fac_is_active, m.fac_go_live, serviceType = p.fct_service_calc }; return(caseTypelist.ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter)); }
public DataSourceResult GetAll(DataSourceRequest request) { var query = from m in _unitOfWork.PhysicianLicenseRepository.Query() join n in GetUclData(UclTypes.State) on m.phl_license_state equals n.ucd_key into FacilityStates from state in FacilityStates.DefaultIfEmpty() where m.phl_is_active select new { m.phl_key, m.phl_license_number, phl_issued_date = DBHelper.FormatDateTime(m.phl_issued_date, false), phl_expired_date = DBHelper.FormatDateTime(m.phl_expired_date, false), m.phl_is_active, m.phl_user_key, m.phl_license_state, phl_state = state != null ? state.ucd_title : "", m.phl_created_date }; foreach (var filter in request.Filter.Filters) { if (filter.Value != null) { if (!string.IsNullOrEmpty(filter.Value?.ToString())) { query = query.WhereEquals(filter.Field, filter.Value); } } } return(query.OrderByDescending(m => m.phl_state).ToDataSourceResult(request.Take, request.Skip, request.Sort, null)); }
public DataSourceResult GetPhysicianFacilitiesForPhy(DataSourceRequest request) { var caseTypelist = from m in _unitOfWork.FacilityPhysicianRepository.Query() join n in GetUclData(UclTypes.State) on m.facility.fac_stt_key equals n.ucd_key into FacilityStates from state in FacilityStates.DefaultIfEmpty() where //(m.fap_is_on_boarded == true || m.facility.fac_go_live == true) //&& m.fap_is_active == true && m.fap_start_date != null && m.fap_end_date != null && m.fap_hide == false orderby m.facility.fac_name select new { m.facility.fac_name, m.facility.fac_city, stt_code = state != null ? state.ucd_title : "", m.facility.fac_zip, m.facility.fac_timezone, m.fap_key, m.fap_fac_key, fap_user_key = m.fap_user_key, m.fap_is_active, m.fap_start_date, m.fap_end_date, m.fap_is_on_boarded, m.fap_onboarding_complete_provider_active_date, m.fap_onboarded_date, m.fap_onboarded_by_name, m.fap_hide }; return(caseTypelist.ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter)); }