public IEnumerable <LmsCourseMeeting> GetByCompanyWithAudioProfiles(ILmsLicense lmsCompany)
{
if (lmsCompany == null)
{
throw new ArgumentNullException(nameof(lmsCompany));
}
// NOTE: check only licenses of the company with the same AC!!
var query = from c in this.Repository.Session.Query <LmsCompany>()
where c.CompanyId == lmsCompany.CompanyId
select new { c.Id, c.AcServer };
var currentLicenseAc = new Uri(lmsCompany.AcServer);
var companyLicenses = query.ToArray().Where(c => new Uri(c.AcServer).Host == currentLicenseAc.Host).Select(c => c.Id).ToArray();
LmsCourseMeeting x = null;
OfficeHours oh = null;
var defaultQuery = new DefaultQueryOver <LmsCourseMeeting, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.OfficeHours, () => oh, JoinType.LeftOuterJoin)
.WhereRestrictionOn(() => x.LmsCompanyId).IsIn(companyLicenses)
.And(() => x.AudioProfileId != null)
.TransformUsing(Transformers.DistinctRootEntity);
return(this.Repository.FindAll(defaultQuery));
}
public LmsCourseMeeting GetLtiCreatedByCompanyAndScoId(ILmsLicense lmsCompany, string scoId)
{
if (lmsCompany == null)
{
throw new ArgumentNullException(nameof(lmsCompany));
}
if (string.IsNullOrWhiteSpace(scoId))
{
throw new ArgumentException("scoId can not be empty", nameof(scoId));
}
// NOTE: check only licenses of the company with the same AC!!
var query = from c in this.Repository.Session.Query <LmsCompany>()
where c.CompanyId == lmsCompany.CompanyId
select new { c.Id, c.AcServer };
var currentLicenseAc = new Uri(lmsCompany.AcServer);
var companyLicenses = query.ToArray().Where(c => new Uri(c.AcServer).Host == currentLicenseAc.Host).Select(c => c.Id).ToArray();
// NOTE: return only not-reused meeting - created from LTI
LmsCourseMeeting x = null;
OfficeHours oh = null;
var defaultQuery = new DefaultQueryOver <LmsCourseMeeting, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.OfficeHours, () => oh, JoinType.LeftOuterJoin)
//.Clone()
.WhereRestrictionOn(() => x.LmsCompanyId).IsIn(companyLicenses)
.Where(() =>
(x.Reused == null || x.Reused == false)
&&
(((x.ScoId != null) && (x.ScoId == scoId)) ||
(x.OfficeHours != null && oh.ScoId == scoId)))
.Take(1);
return(this.Repository.FindOne(defaultQuery).Value);
}
public IEnumerable <SubModuleCategory> GetByUser(int userId)
{
var queryOver = new DefaultQueryOver <SubModuleCategory, int>().GetQueryOver()
.Where(x => x.User.Id == userId);
return(this.Repository.FindAll(queryOver));
}
private QueryOver <LmsCourseMeeting, LmsCourseMeeting> GetByCompanyAndScoIdQuery(ILmsLicense lmsCompany, string scoId, int excludedLmsCourseMeetingId)
{
if (lmsCompany == null)
{
throw new ArgumentNullException(nameof(lmsCompany));
}
if (string.IsNullOrWhiteSpace(scoId))
{
throw new ArgumentException("scoId can not be empty", nameof(scoId));
}
// NOTE: check only licenses of the company with the same AC!!
var query = from c in this.Repository.Session.Query <LmsCompany>()
where c.CompanyId == lmsCompany.CompanyId
select new { c.Id, c.AcServer };
var currentLicenseAc = new Uri(lmsCompany.AcServer);
var companyLicenses = query.ToArray().Where(c => new Uri(c.AcServer).Host == currentLicenseAc.Host).Select(c => c.Id).ToArray();
LmsCourseMeeting x = null;
OfficeHours oh = null;
QueryOver <LmsCourseMeeting, LmsCourseMeeting> defaultQuery = new DefaultQueryOver <LmsCourseMeeting, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.OfficeHours, () => oh, JoinType.LeftOuterJoin)
.WhereRestrictionOn(() => x.LmsCompanyId).IsIn(companyLicenses)
.And(() => x.Id != excludedLmsCourseMeetingId)
.And(() =>
((x.ScoId != null) && (x.ScoId == scoId)) ||
(x.OfficeHours != null && oh.ScoId == scoId))
.TransformUsing(Transformers.DistinctRootEntity);
return(defaultQuery);
}
public IEnumerable <Contact> GetAllExceptDeleted()
{
var deleted = ContactStatusEnum.Deleted;
var query = new DefaultQueryOver <Contact, int>().GetQueryOver().Where(x => x.Status != deleted);
return(this.Repository.FindAll(query));
}
public IFutureValue <SubModuleCategory> GetOneByLmsCourseIdAndCompanyLms(string lmsCourseId, int companyLmsId)
{
var query =
new DefaultQueryOver <SubModuleCategory, int>().GetQueryOver().Where(x => x.LmsCourseId == lmsCourseId && x.CompanyLmsId != null && x.CompanyLmsId == companyLmsId);
return(this.Repository.FindOne(query));
}
/// <summary>
/// The get one by moodle id.
/// </summary>
/// <param name="userId">
/// The user id.
/// </param>
/// <param name="lmsQuizId">
/// The lms quiz id.
/// </param>
/// <param name="companyLmsId">
/// The company Lms Id.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{Quiz}"/>.
/// </returns>
public IFutureValue <Quiz> GetOneByLmsQuizId(int userId, int lmsQuizId, int companyLmsId)
{
QueryOver <User, User> companyQuery =
new DefaultQueryOver <User, int>().GetQueryOver()
.Where(x => x.Id == userId)
.Select(res => res.Company.Id);
IFutureValue <int> id = this.userRepository.FindOne <int>(companyQuery);
Quiz q = null;
SubModuleItem smi = null;
SubModuleCategory smc = null;
User u2 = null;
var query =
new DefaultQueryOver <Quiz, int>().GetQueryOver(() => q)
.WhereRestrictionOn(x => x.LmsQuizId).IsNotNull
.And(x => x.LmsQuizId == lmsQuizId)
.JoinQueryOver(x => x.SubModuleItem, () => smi, JoinType.InnerJoin)
.JoinQueryOver(() => smi.SubModuleCategory, () => smc, JoinType.InnerJoin)
.Where(() => smc.CompanyLmsId != null && smc.CompanyLmsId == companyLmsId)
.JoinQueryOver(() => smi.CreatedBy, () => u2, JoinType.InnerJoin)
.Where(() => u2.Company.Id == id.Value && (int)u2.Status == 1)
.Take(1);
return(this.Repository.FindOne(query));
}
public IFutureValue <QuizResult> GetOneByGuid(Guid guid)
{
var query = new DefaultQueryOver <QuizResult, int>().GetQueryOver()
.Where(x => x.Guid == guid);
return(this.Repository.FindOne(query));
}
/// <summary>
/// The get all by session ids.
/// </summary>
/// <param name="sessionIds">
/// The session ids.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{SNSessionMember}"/>.
/// </returns>
public IEnumerable <SNMember> GetAllByACSessionIds(List <int> sessionIds)
{
var queryOver =
new DefaultQueryOver <SNMember, int>().GetQueryOver().WhereRestrictionOn(x => x.ACSessionId).IsIn(sessionIds);
return(this.Repository.FindAll(queryOver));
}
/// <summary>
/// The get shared for user surveys by user id.
/// </summary>
/// <param name="userId">
/// The user id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{SurveyFromStoredProcedureDTO}"/>.
/// </returns>
public IEnumerable <SurveyFromStoredProcedureDTO> GetSharedForUserSurveysByUserId(int userId)
{
var query =
new DefaultQueryOver <User, int>().GetQueryOver()
.Where(x => x.Id == userId)
.Select(res =>
res.Company.Id);
var id = this.userRepository.FindOne <int>(query);
Survey s = null;
SubModuleItem smi = null;
SubModuleCategory smc = null;
User u = null;
User u2 = null;
SurveyFromStoredProcedureExDTO dto = null;
var queryOver = new DefaultQueryOver <Survey, int>().GetQueryOver(() => s)
.JoinQueryOver(x => x.SubModuleItem, () => smi, JoinType.InnerJoin).Where(() => smi.IsActive == true && smi.IsShared == true)
.JoinQueryOver(() => smi.SubModuleCategory, () => smc, JoinType.InnerJoin).Where(() => smc.IsActive == true)
.JoinQueryOver(() => smc.User, () => u, JoinType.InnerJoin)
.JoinQueryOver(() => smi.CreatedBy, () => u2, JoinType.InnerJoin).Where(() => (int)u2.Status == 1)
.Where(() => u2.Id != userId && u2.Company.Id == id.Value)
.SelectList(res =>
res.Select(() => s.SurveyGroupingType.Id)
.WithAlias(() => dto.surveyGroupingTypeId)
.Select(() => s.Description)
.WithAlias(() => dto.description)
.Select(() => s.SurveyName)
.WithAlias(() => dto.surveyName)
.Select(() => s.LmsSurveyId)
.WithAlias(() => dto.lmsSurveyId)
.Select(() => s.Id)
.WithAlias(() => dto.surveyId)
.Select(() => u.LastName)
.WithAlias(() => dto.lastName)
.Select(() => u.FirstName)
.WithAlias(() => dto.firstName)
.Select(() => u.Id)
.WithAlias(() => dto.userId)
.Select(() => u2.LastName)
.WithAlias(() => dto.createdByLastName)
.Select(() => u2.FirstName)
.WithAlias(() => dto.createdByName)
.Select(() => smi.CreatedBy.Id)
.WithAlias(() => dto.createdBy)
.Select(() => smi.DateModified)
.WithAlias(() => dto.dateModified)
.Select(() => smi.Id)
.WithAlias(() => dto.subModuleItemId)
.Select(() => smc.CategoryName)
.WithAlias(() => dto.categoryName)
.Select(() => smc.Id)
.WithAlias(() => dto.subModuleCategoryId))
.TransformUsing(Transformers.AliasToBean <SurveyFromStoredProcedureExDTO>());
var result =
this.Repository.FindAll <SurveyFromStoredProcedureExDTO>(queryOver)
.ToList()
.Select(x => new SurveyFromStoredProcedureDTO(x));
return(result);
}
/// <summary>
/// The get all by session id.
/// </summary>
/// <param name="sessionId">
/// The session id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{SNSessionMember}"/>.
/// </returns>
public IEnumerable <SNMember> GetAllByACSessionId(int sessionId)
{
var queryOver =
new DefaultQueryOver <SNMember, int>().GetQueryOver().Where(x => x.ACSessionId == sessionId);
return(this.Repository.FindAll(queryOver));
}
public List <LmsCompany> GetEnabledForSynchronization(string consumerKey = null)
{
LmsCompany lc = null;
LmsCompanySetting lcs = null;
OfficeHours oh = null;
IList <LmsCourseMeeting> lcm = null;
//IList<LmsUserMeetingRole> lumr = null;
//IList<LmsUser> lu = null;
//LmsUser u = null;
var defaultQuery = new DefaultQueryOver <LmsCompany, int>()
.GetQueryOver(() => lc)
.Where(x => x.IsActive);
if (!string.IsNullOrEmpty(consumerKey))
{
defaultQuery = defaultQuery.Where(x => x.ConsumerKey == consumerKey);
}
defaultQuery = defaultQuery
.JoinAlias(() => lc.Settings, () => lcs)
.Where(() => lcs.Name == LmsLicenseSettingNames.UseSynchronizedUsers && lcs.Value == "True")
.JoinAlias(() => lc.LmsCourseMeetings, () => lcm)
.JoinAlias(() => lcm.First().OfficeHours, () => oh, JoinType.LeftOuterJoin)
// .JoinAlias(() => lcm.First().MeetingRoles, () => lumr)
// .Fetch(x => x.Settings).Eager
.Fetch(x => x.LmsCourseMeetings).Eager
.Fetch(x => x.LmsCourseMeetings.First().OfficeHours).Eager
// .Fetch(x => x.LmsCourseMeetings.First().MeetingRoles).Eager
.Fetch(x => x.AdminUser).Eager
.TransformUsing(Transformers.DistinctRootEntity);
return(this.Repository.FindAll(defaultQuery).ToList());
}
/// <summary>
/// The get all by session id.
/// </summary>
/// <param name="sessionId">
/// The session id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{SNSessionMember}"/>.
/// </returns>
public IFutureValue <SNGroupDiscussion> GetOneByACSessionId(int sessionId)
{
var queryOver =
new DefaultQueryOver <SNGroupDiscussion, int>().GetQueryOver().Where(x => x.ACSessionId == sessionId).Take(1);
return(this.Repository.FindOne(queryOver));
}
/// <summary>
/// The get quiz result by adobe connect session id.
/// </summary>
/// <param name="adobeConnectSessionId">
/// The adobe connect session id.
/// </param>
/// <param name="smiId">
/// The sub module item id.
/// </param>
/// <returns>
/// The <see cref="QuizResultDataDTO"/>.
/// </returns>
public SurveyResultDataDTO GetSurveyResultByACSessionId(int adobeConnectSessionId, int smiId)
{
var res = new SurveyResultDataDTO();
res.questions = this.Repository.StoreProcedureForMany <QuestionForAdminDTO>("getSurveyQuestionsForAdminBySMIId",
new StoreProcedureParam <int>("smiId", smiId),
new StoreProcedureParam <int>("acSessionId", adobeConnectSessionId)).ToArray();
res.players =
this.Repository.StoreProcedureForMany <SurveyPlayerFromStoredProcedureDTO>(
"getSurveyResultByACSessionId",
new StoreProcedureParam <int>("acSessionId", adobeConnectSessionId),
new StoreProcedureParam <int>("subModuleItemId", smiId))
.ToList()
.Select(x => new SurveyPlayerDTO(x))
.ToArray();
//saving the questions order
res.questions = res.questions.OrderBy(x => x.questionOrder).ToArray();
var questionIds = res.questions.Select(q => q.questionId).ToList();
var query = new DefaultQueryOver <SurveyQuestionResult, int>().GetQueryOver()
.WhereRestrictionOn(x => x.QuestionRef.Id).IsIn(questionIds)
.AndRestrictionOn(x => x.SurveyResult.Id).IsIn(res.players.Select(q => q.surveyResultId).ToList());
var distractorsQuery = new DefaultQueryOver <Distractor, int>().GetQueryOver()
.WhereRestrictionOn(x => x.Question.Id)
.IsIn(questionIds);
var surveyQuestionResults = this.surveyQuestionResultRepository.FindAll(query).ToList();
var distractors = this.distractorRepository.FindAll(distractorsQuery).ToList();
var xmlSurveyResultIds = new XElement("Ids", surveyQuestionResults.Select(q => new XElement("Id", q.Id)));
var answersQuery = this.Repository.Session.GetNamedQuery("getSurveyResultAnswers");
answersQuery.SetParameter("surveyResultIds", xmlSurveyResultIds.ToString(), NHibernateUtil.StringClob);
answersQuery = answersQuery.SetResultTransformer(new AliasToBeanResultTransformer(typeof(SurveyQuestionResultAnswerDTO)));
var answers = answersQuery.List <SurveyQuestionResultAnswerDTO>();
foreach (var questionForAdminDTO in res.questions)
{
questionForAdminDTO.questionResultIds = surveyQuestionResults
.Where(x => x.QuestionRef.Id == questionForAdminDTO.questionId)
.Select(x => x.Id)
.ToArray();
questionForAdminDTO.distractors = distractors
.Where(x => x.Question.Id == questionForAdminDTO.questionId)
.Select(x => new DistractorDTO(x))
.ToArray();
}
foreach (var surveyPlayerDTO in res.players)
{
var playerSurveyQuestionResultIds = surveyQuestionResults.Where(x => x.SurveyResult.Id == surveyPlayerDTO.surveyResultId).Select(x => x.Id).ToList();
surveyPlayerDTO.answers = answers.Where(x => playerSurveyQuestionResultIds.Contains(x.surveyQuestionResultId)).ToArray();
}
return(res);
}
/// <summary>
/// The get one by AC id course id and LMS user id.
/// </summary>
/// <param name="adobeConnectUserId">
/// The adobe connect user id.
/// </param>
/// <param name="lmsCourseId">
/// The LMS course id.
/// </param>
/// <param name="companyLmsId">
/// The company LMS Id.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{LmsUserParameters}"/>.
/// </returns>
public IFutureValue <LmsUserParameters> GetOneByAcIdCourseIdAndCompanyLmsId(string adobeConnectUserId, string lmsCourseId, int companyLmsId)
{
var queryOver = new DefaultQueryOver <LmsUserParameters, int>().GetQueryOver()
.Where(x => x.AcId == adobeConnectUserId && x.Course == lmsCourseId && x.CompanyLms.Id == companyLmsId).Take(1);
return(this.Repository.FindOne(queryOver));
}
public LmsCourseMeeting GetOneByCourseAndId(int companyLmsId, string courseId, long id)
{
if (companyLmsId <= 0)
{
throw new ArgumentOutOfRangeException(nameof(companyLmsId));
}
if (string.IsNullOrEmpty(courseId))
{
throw new ArgumentException(nameof(courseId));
}
if (id <= 0)
{
throw new ArgumentOutOfRangeException(nameof(id));
}
LmsCourseMeeting x = null;
//OfficeHours oh = null;
var defaultQuery = new DefaultQueryOver <LmsCourseMeeting, int>()
.GetQueryOver(() => x)
//.JoinAlias(() => x.OfficeHours, () => oh, JoinType.LeftOuterJoin)
.Where(() => x.Id == id && x.LmsCompanyId == companyLmsId && x.CourseId == courseId)
.Take(1);
return(this.Repository.FindOne(defaultQuery).Value);
}
public IFutureValue <LmsCourseMeeting> GetOneByUserAndType(int companyLmsId, string userId, LmsMeetingType type)
{
if (companyLmsId <= 0)
{
throw new ArgumentOutOfRangeException(nameof(companyLmsId));
}
if (string.IsNullOrWhiteSpace(userId))
{
throw new ArgumentException("userId can not be empty", nameof(userId));
}
if (type <= 0)
{
throw new ArgumentOutOfRangeException(nameof(type));
}
int typeValue = (int)type;
LmsCourseMeeting x = null;
OfficeHours oh = null;
LmsUser u = null;
var defaultQuery = new DefaultQueryOver <LmsCourseMeeting, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.OfficeHours, () => oh, JoinType.InnerJoin)
.JoinAlias(() => oh.LmsUser, () => u, JoinType.InnerJoin)
.Where(() => x.LmsCompanyId == companyLmsId &&
x.LmsMeetingType == typeValue &&
(x.OfficeHours != null && u.UserId == userId))
.Take(1);
return(this.Repository.FindOne(defaultQuery));
}
/// <summary>
/// The get one by user id.
/// </summary>
/// <returns>
/// The <see cref="IEnumerable{CompanyLicense}"/>.
/// </returns>
public IEnumerable <CompanyLicense> GetAllTrial()
{
var queryOver =
new DefaultQueryOver <CompanyLicense, int>().GetQueryOver().Where(x => x.LicenseStatus == CompanyLicenseStatus.Trial);
return(this.Repository.FindAll(queryOver));
}
/// <summary>
/// The get all by company id.
/// </summary>
/// <param name="firmId">
/// The company id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{Category}"/>.
/// </returns>
public IEnumerable <Category> GetAllByCompanyId(int firmId)
{
QueryOver <Category, Category> query =
new DefaultQueryOver <Category, int>().GetQueryOver().Where(x => x.Company.Id == firmId);
return(this.Repository.FindAll(query).ToList());
}
/// <summary>
/// The get one by id.
/// </summary>
/// <param name="id">
/// The id.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{Category}"/>.
/// </returns>
public override IFutureValue <Category> GetOneById(int id)
{
QueryOver <Category, Category> defaultQuery =
new DefaultQueryOver <Category, int>().GetQueryOver().Where(x => x.Id == id).Fetch(x => x.Company).Eager;
return(this.Repository.FindOne(defaultQuery));
}
/// <summary>
/// The get all.
/// </summary>
/// <returns>
/// The <see cref="IEnumerable{Category}" />.
/// </returns>
public override IEnumerable <Category> GetAll()
{
QueryOver <Category, Category> defaultQuery =
new DefaultQueryOver <Category, int>().GetQueryOver().Fetch(x => x.Company).Eager;
return(this.Repository.FindAll(defaultQuery));
}
/// <summary>
/// The get by sub module item id.
/// </summary>
/// <param name="id">
/// The id.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{AppletItem}"/>.
/// </returns>
public IFutureValue <AppletItem> GetOneBySMIId(int id)
{
QueryOver <AppletItem> queryOver =
new DefaultQueryOver <AppletItem, int>().GetQueryOver().Where(x => x.SubModuleItem.Id == id).Take(1);
return(this.Repository.FindOne(queryOver));
}
/// <summary>
/// The get all paged.
/// </summary>
/// <param name="searchPattern">
/// The name.
/// </param>
/// <param name="companyId">
/// The company Id.
/// </param>
/// <param name="pageIndex">
/// The page index.
/// </param>
/// <param name="pageSize">
/// The page size.
/// </param>
/// <param name="totalCount">
/// The total count.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{T}"/>.
/// </returns>
public IEnumerable <Category> GetAllByCompanyAndNamePaged(string searchPattern, int companyId, int pageIndex, int pageSize, out int totalCount)
{
var searchIds = new List <int>();
if (pageIndex <= default(int))
{
pageIndex = 1;
}
var queryOver = new DefaultQueryOver <Category, int>().GetQueryOver();
if (companyId != 0)
{
queryOver = queryOver.Where(x => x.Company.Id == companyId);
}
if (!string.IsNullOrWhiteSpace(searchPattern))
{
searchIds = this.fullTextModel.Search(searchPattern, typeof(Category), int.MaxValue).ToList();
queryOver = queryOver.AndRestrictionOn(x => x.Id).IsIn(searchIds);
}
QueryOver <Category, Category> rowCountQuery = queryOver.ToRowCountQuery();
totalCount = this.Repository.FindOne <int>(rowCountQuery).Value;
QueryOver <Category> pagedQuery = queryOver.OrderBy(x => x.CategoryName).Asc;
if (pageSize > 0)
{
pagedQuery = pagedQuery.Take(pageSize).Skip((pageIndex - 1) * pageSize);
}
return(searchIds.Any() ? this.Repository.FindAll(pagedQuery).ToList().OrderBy(x => searchIds.IndexOf(x.Id)) : this.Repository.FindAll(pagedQuery));
}
/// <summary>
/// The get one by name.
/// </summary>
/// <param name="companyName">
/// The company name.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{Company}"/>.
/// </returns>
public IFutureValue <Company> GetOneByName(string companyName)
{
var companyNameToLower = companyName.Return(x => x.ToLowerInvariant(), string.Empty);
var query = new DefaultQueryOver <Company, int>().GetQueryOver().WhereRestrictionOn(x => x.CompanyName).IsInsensitiveLike(companyNameToLower);
return(this.Repository.FindOne(query));
}
/// <summary>
/// The get all for user.
/// </summary>
/// <param name="userId">
/// The user id.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{Company}"/>.
/// </returns>
public IEnumerable <Company> GetAllForUser(int userId)
{
CompanyContact companyContact = null;
var query = new DefaultQueryOver <Company, int>().GetQueryOver().JoinQueryOver(x => x.CompanyContacts, () => companyContact).Where(() => companyContact.Contact.Id == userId);
return(this.Repository.FindAll(query));
}
public override IEnumerable <TimeZone> GetAll()
{
return(CacheUtility.GetCachedItem <List <TimeZone> >(_cache, CachePolicies.Keys.TimeZones(), () =>
{
var query = new DefaultQueryOver <TimeZone, int>().GetQueryOver().OrderBy(x => x.TimeZoneName).Asc;
return this.Repository.FindAll(query).ToList();
}));
}
/// <summary>
/// The get one by user id.
/// </summary>
/// <param name="userId">
/// The user id.
/// </param>
/// <param name="companyLmsId">
/// The company LMS Id.
/// </param>
/// <returns>
/// The <see cref="IFutureValue{LmsUser}"/>.
/// </returns>
public IFutureValue <LmsUser> GetOneByUserIdAndCompanyLms(string userId, int companyLmsId)
{
var queryOver = new DefaultQueryOver <LmsUser, int>()
.GetQueryOver()
.Where(u => u.LmsCompany.Id == companyLmsId && u.UserId == userId);
return(this.Repository.FindOne(queryOver));
}
/// <summary>
/// The get all by questions ids.
/// </summary>
/// <param name="questionIds">
/// The question ids.
/// </param>
/// <returns>
/// The <see cref="IEnumerable{Distractor}"/>.
/// </returns>
public IEnumerable <Distractor> GetAllByQuestionsIds(List <int> questionIds)
{
var queryOver = new DefaultQueryOver <Distractor, int>()
.GetQueryOver().Where(x => x.IsActive == true)
.AndRestrictionOn(x => x.Question.Id).IsIn(questionIds).Fetch(x => x.Image).Eager;
return(this.Repository.FindAll(queryOver));
}
public override IEnumerable <LmsQuestionType> GetAll()
{
return(CacheUtility.GetCachedItem(_cache, CachePolicies.Keys.LmsQuestionTypes(), () =>
{
var query = new DefaultQueryOver <LmsQuestionType, int>().GetQueryOver();
return this.Repository.FindAll(query).ToList();
}));
}
public override IEnumerable <SNMapProvider> GetAll()
{
return(CacheUtility.GetCachedItem <List <SNMapProvider> >(_cache, CachePolicies.Keys.SNMapProviders(), () =>
{
var query = new DefaultQueryOver <SNMapProvider, int>().GetQueryOver().OrderBy(x => x.MapProvider).Asc;
return this.Repository.FindAll(query).ToList();
}));
}
