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