/*
* public DataResponse<EntityList<EntitySelectItem>> GetProvidersByServiceId(int serviceId, int? currentBusinessId)
* {
* var response = new DataResponse<EntityList<EntitySelectItem>>();
* try
* {
* base.DBInit();
*
* var query = DBEntity.ReportMasters.Where(a => a.ServiceId == serviceId && a.BusinessId == currentBusinessId)
* .Select(s => new EntitySelectItem
* {
* Id = s.Provider.Id,
* Value = s.Provider.FirstName + " " + s.Provider.MiddleName + " " + s.Provider.LastName + " (" + s.Provider.NPI + ")"
* }).OrderBy(o => o.Value).DistinctBy(a => a.Id);
*
* response = GetList(query, 0, 100);
* }
* catch (Exception ex)
* {
* ex.Log();
* }
* finally
* {
* base.DBClose();
* }
* return response;
* }
*/
public DataResponse <EntityList <EntitySelectItem> > GetAllTaskTypes(int?currentBusinessId)
{
var response = new DataResponse <EntityList <EntitySelectItem> >();
try
{
var cachedResponse = response.GetCached <EntityList <EntitySelectItem> >(CacheKeys.TaskType + currentBusinessId);
if (cachedResponse.IsOk())
{
return(cachedResponse);
}
base.DBInit();
var query = DBEntity.LookupTaskTypes.Where(a => a.BusinessId == currentBusinessId).Select(s => new EntitySelectItem
{
Id = s.Id,
Value = s.TaskType
}).OrderBy(o => o.Value);
response = GetList <EntitySelectItem>(query, 0, 100);
response.CacheIt <EntityList <EntitySelectItem> >(CacheKeys.TaskType + currentBusinessId);
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public DataResponse <EntityList <EntitySelectItem> > GetPracticeTypes()
{
var response = new DataResponse <EntityList <EntitySelectItem> >();
try
{
var cachedData = response.GetCached <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes);
if (cachedData.IsOk())
{
return(cachedData);
}
base.DBInit();
var query = DBEntity.LookupPracticeTypes.Where(s => s.IsActive == true).Select(s => new EntitySelectItem
{
Id = s.Id,
Value = s.PracticeType
}).OrderBy(o => o.Value);
response = GetList <EntitySelectItem>(query, 0, 100);
if (response.IsOk())
{
response.CacheIt <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes);
}
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}