public IEnumerable Select(int startRowIndex, int maxRows)
{
IStudyDeleteRecordEntityBroker broker = HttpContext.Current.GetSharedPersistentContext().GetBroker <IStudyDeleteRecordEntityBroker>();
StudyDeleteRecordSelectCriteria criteria = GetSelectCriteria();
criteria.Timestamp.SortDesc(0);
IList <StudyDeleteRecord> list = broker.Find(criteria, startRowIndex, maxRows);
_studies = CollectionUtils.Map(
list, (StudyDeleteRecord record) => DeletedStudyInfoAssembler.CreateDeletedStudyInfo(record));
// Additional filter: DeletedBy
if (String.IsNullOrEmpty(DeletedBy) == false)
{
_studies = CollectionUtils.Select(_studies, delegate(DeletedStudyInfo record)
{
if (String.IsNullOrEmpty(record.UserId) || String.IsNullOrEmpty(record.UserName))
{
return(false);
}
// either the id or user matches
return(record.UserId.ToUpper().IndexOf(DeletedBy.ToUpper()) >= 0 ||
record.UserName.ToUpper().IndexOf(DeletedBy.ToUpper()) >= 0);
});
}
return(_studies);
}
public int SelectCount()
{
StudyDeleteRecordSelectCriteria criteria = GetSelectCriteria();
IStudyDeleteRecordEntityBroker broker = HttpContext.Current.GetSharedPersistentContext().GetBroker <IStudyDeleteRecordEntityBroker>();
return(broker.Count(criteria));
}
public int SelectCount()
{
StudyDeleteRecordSelectCriteria criteria = GetSelectCriteria();
IStudyDeleteRecordEntityBroker broker = HttpContextData.Current.ReadContext.GetBroker <IStudyDeleteRecordEntityBroker>();
return(broker.Count(criteria));
}
private StudyDeleteRecordSelectCriteria GetSelectCriteria()
{
var criteria = new StudyDeleteRecordSelectCriteria();
QueryHelper.SetGuiStringCondition(criteria.AccessionNumber, AccessionNumber);
QueryHelper.SetGuiStringCondition(criteria.PatientId, PatientId);
QueryHelper.SetGuiStringCondition(criteria.PatientsName, PatientsName);
QueryHelper.SetGuiStringCondition(criteria.StudyDescription, StudyDescription);
if (StudyDate != null)
{
criteria.StudyDate.Like("%" + DateParser.ToDicomString(StudyDate.Value) + "%");
}
return(criteria);
}
