/// <summary>
/// 课程中心-课程列表（加载课程列表）
/// </summary>
/// <param name="search">筛选条件、分页信息</param>
/// <returns></returns>
public JsonResult GetCourses(CourseSearch search)
{
CourseBll bll = new CourseBll();
DtoCourseSelectCondition condition = new DtoCourseSelectCondition();
condition.Grade = search.Grade;
condition.CourseType = search.CourseType;
condition.OrderBy = (DtoCourseSelectCondition.DtoCourseSelectOrderEnum)search.OrderBy;
condition.StudentId = GetCurrentUser().StudentId;
PagingObject paging = search.Pagination;
//是否包含价格
bool includePrice = false;
List <DtoSelectCenterResult> entities = bll.GetCourseForSelectCenter(condition, paging, out includePrice);
IEnumerable <CourseViewModel> list = entities.Select(s => {
var model = s.ConvertTo <CourseViewModel>();
if (string.IsNullOrEmpty(model.CourseImage))
{
model.CourseImage = defaultCourseImg;
}
return(model);
});
bool hasMore = paging.TotalCount > search.Pagination.PageIndex * search.Pagination.PageSize;
return(Json(new JsonResponse <CourseSet> {
State = true, ErrorCode = 0, ErrorMsg = "", Data = new CourseSet()
{
DataList = list, HasMore = hasMore, IncludePrice = includePrice
}
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 课程中心-课程列表
/// </summary>
/// <returns></returns>
// GET: Course/Select
public ActionResult Select()
{
CourseSearch search = new CourseSearch()
{
Grade = 0,
CourseType = 0,
OrderBy = 1,
Pagination = new PagingObject()
{
PageIndex = 1, PageSize = 9
},
HasMore = true
};
AdvertisingBll bll = new AdvertisingBll();
//广告列表
List <DtoAdvertisingIndex> AdvertisingList = bll.GetAdvertisingForIndex();
CourseSelectViewModel model = new CourseSelectViewModel()
{
StudentId = GetCurrentUser().StudentId,
SearchInfo = JsonConvert.SerializeObject(search),
AdvertisingList = AdvertisingList?.Select(a => new CourseSelectAdvertisingViewModel()
{
ImageUrl = a.Bad_ImageUrlShow,
LinkUrl = a.Bad_ReferId == 0 ? a.Bad_Url : Url.Action("Detail", "Course", new { id = a.Bad_ReferId, aid = a.Bad_Id }),
CourseId = a.Bad_ReferId,
Ad_Id = a.Bad_Id
}).ToList()
};
return(View(model));
}
void Awake()
{
if (instance != null)
{
Destroy(gameObject);
return;
}
instance = this;
offerings = new List <CourseOffering>();
}
public async Task OnSearchCourse()
{
if (String.IsNullOrEmpty(CourseSearch) || String.IsNullOrWhiteSpace(CourseSearch))
{
await _confirmationDialogHelper.ErrorWindowShow("Veuillez remplir le champ de recherche.");
}
else
{
Courses.Clear();
if (firstNameOrLastName.IsMatch(CourseSearch))
{
for (int i = 0; i < GetCourses.Count; i++)
{
if (GetCourses[i].CodeCourse.ToLower().Contains(CourseSearch.ToLower()))
{
Courses.Add(GetCourses[i]);
}
else if (GetCourses[i].NameCourse.ToLower().Contains(CourseSearch.ToLower()))
{
Courses.Add(GetCourses[i]);
}
}
}
else if (fullNameRx.IsMatch(CourseSearch))
{
var word = CourseSearch.Split(' ');
var countWord = word.Length;
foreach (var course in GetCourses)
{
int i = 0;
var fullname = course.NameCourse;
do
{
if (fullname.ToLower().Contains((word[i]).ToLower()))
{
if (i == countWord - 1)
{
Courses.Add(course);
}
i++;
}
else
{
break;
}
} while (i < countWord);
}
}
}
}
public ActionResult Index(string searchText)
{
//SolrHelper.ReIndexAllCourses();
ViewBag.SearchText = searchText;
CourseSearch search = new CourseSearch();
CourseQuery query = new CourseQuery();
query.Query = searchText;
var model = search.DoSearch(query);
return(View(model));
}
public PagedResponse <CourseDto> Execute(CourseSearch search)
{
var query = context.Courses.AsQueryable();
if (!string.IsNullOrEmpty(search.Name) || !string.IsNullOrWhiteSpace(search.Name))
{
query = query.Where(x => x.Name.ToLower().Contains(search.Name.ToLower()));
}
if (search.CategoryId > 0)
{
query = query.Where(x => x.CategoryId == search.CategoryId);
}
var skipCount = search.PerPage * (search.Page - 1);
//Page == 1
var reponse = new PagedResponse <CourseDto>
{
CurrentPage = search.Page,
ItemsPerPage = search.PerPage,
TotalCount = query.Count(),
Items = query.Skip(skipCount).Take(search.PerPage).AsEnumerable().Select(item => mapper.Map <Course, CourseDto>(item)).ToList()
/* Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new CourseDto
* {
* Id = x.Id,
* Name = x.Name,
* Description = x.Description,
* VideoLink = x.VideoLink,
* Image = x.Image,
* CategoryId = x.CategoryId,
* Duration = x.Duration,
* TeacherId = x.TeacherId,
*
*
* //Lectures=x.Lectures,
* //UserCourses=x.UserCourses
*
*
* //}).ToList()*/
};
// var result = mapper.Map<IEnumerable<ReadOrderDto>>(orders.ToList());
return(reponse);
}
//[Authorize]
public IActionResult Get([FromQuery] CourseSearch search, [FromServices] IGetCourseQuery query)
{
return(Ok(executor.ExecuteQuery(query, search)));
}
/// <summary>
/// 搜索课程信息
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="keyword"></param>
/// <param name="subjectId"></param>
/// <param name="status"></param>
/// <returns></returns>
public PagerModel <Course> Search(int pageSize, int pageIndex, string keyword, long?subjectId, int?status)
{
CourseSearch search = new CourseSearch(pageIndex, pageSize, keyword, subjectId, status);
return(search.Search());
}
