public Tuple <string, IEnumerable <object> > Select(Interface.APIExpression expression)
{
IMongoQuery mQuery = null;
List <object> patViews = new List <object>();
List <SelectExpression> selectExpressions = expression.Expressions.ToList();
selectExpressions.Where(s => s.GroupID == 1).OrderBy(o => o.ExpressionOrder).ToList();
SelectExpressionGroupType groupType = SelectExpressionGroupType.AND;
if (selectExpressions.Count > 0)
{
IList <IMongoQuery> queries = new List <IMongoQuery>();
for (int i = 0; i < selectExpressions.Count; i++)
{
groupType = selectExpressions[0].NextExpressionType;
IMongoQuery query = SelectExpressionHelper.ApplyQueryOperators(selectExpressions[i].Type, selectExpressions[i].FieldName, selectExpressions[i].Value);
if (query != null)
{
queries.Add(query);
}
}
mQuery = SelectExpressionHelper.BuildQuery(groupType, queries);
}
using (PatientMongoContext ctx = new PatientMongoContext(_dbName))
{
List <MECohortPatientView> cpvs = ctx.CohortPatientViews.Collection.Find(mQuery).ToList();
if (cpvs != null)
{
cpvs.ForEach(cpv =>
{
patViews.Add(new CohortPatientViewData
{
Id = cpv.Id.ToString(),
LastName = cpv.LastName,
PatientID = cpv.PatientID.ToString(),
SearchFields = PatientsUtils.GetSearchFields(cpv.SearchFields),
Version = cpv.Version
});
});
}
}
return(new Tuple <string, IEnumerable <object> >(expression.ExpressionID, patViews));
}
public List <PatientData> Select(string query, string[] filterData, string querySort, int skip, int take)
{
#region commented code
/* Query without filter:
* { sf: { $elemMatch : {'val':'528a66f4d4332317acc5095f', 'fldn':'Problem', 'act':true}}}
*
* Query with single field filter:
* { $and : [
* { sf: { $elemMatch : {'val':'528a66f4d4332317acc5095f', 'fldn':'Problem', 'act':true}}},
* { $or : [
* { sf: { $elemMatch : {'val':/^<Single Field Text Here>/i, 'fldn':'FN'}}},
* { sf: { $elemMatch : {'val':/^<Single Field Text Here>/i, 'fldn':'LN'}}},
* { sf: { $elemMatch : {'val':/^<Single Field Text Here>/i, 'fldn':'PN'}}}
* ]
* }
* ]
* }
*
* Query with double field filter:
* { $and : [
* { sf: { $elemMatch : {'val':'528a66f4d4332317acc5095f', 'fldn':'Problem', 'act':true}}},
* { $and : [
* { $or : [
* { sf : { $elemMatch: {'val':/^<First Field Text Here>/i, 'fldn':'FN'}}},
* { sf : { $elemMatch: {'val':/^<First Field Text Here>/i, 'fldn':'PN'}}}
* ]
* },
* { sf: { $elemMatch : {'val':/^<Second Field Text Here>/i, 'fldn':'LN'}}}
* ]
* }
* ]
* }
*
*/
#endregion
try
{
string jsonQuery = string.Empty;
string queryName = "TBD"; //Pass this into the method call
string redisKey = string.Empty;
if (filterData[0].Trim() == string.Empty)
{
jsonQuery = query;
redisKey = string.Format("{0}{1}{2}", queryName, skip, take);
}
else
{
if (filterData[1].Trim() == string.Empty)
{
redisKey = string.Format("{0}{1}{2}{3}", queryName, filterData[0].Trim(), skip, take);
jsonQuery = "{ $and : [ ";
jsonQuery += string.Format("{0}, ", query);
jsonQuery += "{ $or : [ ";
jsonQuery += "{ sf: { $elemMatch : {'val':/^";
jsonQuery += string.Format("{0}/i, ", filterData[0].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'FN'}}}, ";
jsonQuery += "{ sf: { $elemMatch : {'" + SearchField.ValueProperty + "':/^";
jsonQuery += string.Format("{0}/i, ", filterData[0].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'LN'}}}, ";
jsonQuery += "{ sf: { $elemMatch : {'" + SearchField.ValueProperty + "':/^";
jsonQuery += string.Format("{0}/i, ", filterData[0].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'PN'}}}]}]}";
}
else
{
redisKey = string.Format("{0}{1}{2}{3}{4}", queryName, filterData[0].Trim(), filterData[1].Trim(), skip, take);
jsonQuery = "{ $and : [ ";
jsonQuery += string.Format("{0}, ", query);
jsonQuery += "{ $and : [ ";
jsonQuery += "{ $or : [ ";
jsonQuery += "{ sf : { $elemMatch: {'" + SearchField.ValueProperty + "':/^";
jsonQuery += string.Format("{0}/i, ", filterData[0].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'FN'}}}, ";
jsonQuery += "{ sf : { $elemMatch: {'" + SearchField.ValueProperty + "':/^";
jsonQuery += string.Format("{0}/i, ", filterData[0].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'PN'}}} ";
jsonQuery += "]}, ";
jsonQuery += "{ sf: { $elemMatch : {'" + SearchField.ValueProperty + "':/^";
jsonQuery += string.Format("{0}/i, ", filterData[1].Trim());
jsonQuery += "'" + SearchField.FieldNameProperty + "':'LN'}}}]}]}}";
}
}
string redisClientIPAddress = System.Configuration.ConfigurationManager.AppSettings.Get("RedisClientIPAddress");
List <PatientData> cohortPatientList = new List <PatientData>();
ServiceStack.Redis.RedisClient client = null;
//TODO: Uncomment the following 2 lines to turn Redis cache on
//if(string.IsNullOrEmpty(redisClientIPAddress) == false)
// client = new ServiceStack.Redis.RedisClient(redisClientIPAddress);
//If the redisKey is already in Cache (REDIS) get it from there, else re-query
if (client != null && client.ContainsKey(redisKey))
{
//go get cohortPatientList from Redis using the redisKey now
cohortPatientList = client.Get <List <PatientData> >(redisKey);
}
else
{
using (PatientMongoContext ctx = new PatientMongoContext(_dbName))
{
BsonDocument searchQuery = BsonSerializer.Deserialize <BsonDocument>(jsonQuery);
QueryDocument queryDoc = new QueryDocument(searchQuery);
SortByBuilder builder = PatientsUtils.BuildSortByBuilder(querySort);
List <MECohortPatientView> meCohortPatients = ctx.CohortPatientViews.Collection.Find(queryDoc)
.SetSortOrder(builder).SetSkip(skip).SetLimit(take).Distinct().ToList();
if (meCohortPatients != null && meCohortPatients.Count > 0)
{
meCohortPatients.ForEach(delegate(MECohortPatientView pat)
{
if (!pat.DeleteFlag)
{
PatientData cohortPatient = new PatientData();
cohortPatient.Id = pat.PatientID.ToString();
foreach (SearchField sf in pat.SearchFields)
{
cohortPatient.FirstName = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.FN).FirstOrDefault()).Value;
cohortPatient.LastName = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.LN).FirstOrDefault()).Value;
cohortPatient.Gender = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.G).FirstOrDefault()).Value;
cohortPatient.DOB = CommonFormatter.FormatDateOfBirth(((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.DOB).FirstOrDefault()).Value);
cohortPatient.MiddleName = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.MN).FirstOrDefault()).Value;
cohortPatient.Suffix = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.SFX).FirstOrDefault()).Value;
cohortPatient.PreferredName = ((SearchField)pat.SearchFields.Where(x => x.FieldName == Constants.PN).FirstOrDefault()).Value;
}
cohortPatientList.Add(cohortPatient);
}
});
}
}
//put cohortPatientList into cache using redisKey now
if (client != null)
{
client.Set <List <PatientData> >(redisKey, cohortPatientList);
}
}
return(cohortPatientList);
}
catch (Exception)
{
throw;
}
}
