public ModelPagedList <ModelQualifications> Query([FromBody] QueryQualifications param)
{
int page = 1;
int pageSize = 5;
var query = DB.Qualifications.AsNoTracking().AsQueryable();
if (param != null)
{
page = param.PageIndex;
pageSize = param.PageSize;
if (!string.IsNullOrWhiteSpace(param.Name))
{
query = query.Where(x => x.name.Contains(param.Name));
}
if (!string.IsNullOrWhiteSpace(param.Qualification))
{
query = query.Where(x => x.auth.Contains(param.Qualification));
}
if (!string.IsNullOrWhiteSpace(param.Location))
{
query = query.Where(x => x.location.Contains(param.Location));
}
//if (param.Periods.HasValue)
// query = query.Where(x=>x.)
}
query = query.OrderBy(x => x.date);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelQualifications>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelQualifications()
{
id = x.id,
name = x.name,
auth = x.auth,
date = x.date,
institution = x.institution,
location = x.location,
Periods = 3, //temp
}).ToList()
};
return(model);
}
public ModelPagedList <ModelCourse> MyCourse(int page = 1)
{
int pageSize = 6;
var paidOrderQuery = DB.MyOrder.AsNoTracking().Where(x => x.CUSTOMER_ID == AuthCustomer.CustomerId && x.PAYMWNT_STATUS == ConstValue.OrderStatus.Paid);
paidOrderQuery = paidOrderQuery.OrderByDescending(x => x.DATE);
var result = paidOrderQuery.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelCourse>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelCourse(x.OnlineCourse)).ToList()
};
return(model);
}
public ModelPagedList <ModelCourse> MyFavorite(int page = 1)
{
int pageSize = 6;
var query = DB.Favorite.AsNoTracking().Where(x => x.customerId == AuthCustomer.CustomerId);
query = query.OrderBy(x => x.OnlineCourse.publishedTime);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelCourse>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelCourse(x.OnlineCourse)).ToList()
};
return(model);
}
public ModelPagedList <ModelMessage> MyMessage(int page = 1)
{
int pageSize = 10;
var query = DB.MyMessage.AsNoTracking().Where(x => x.customerId == AuthCustomer.CustomerId);
query = query.OrderByDescending(x => x.createTime);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelMessage>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelMessage(x)).ToList()
};
return(model);
}
public ModelPagedList <ModelSiteMessage> SiteMessage(int page = 1)
{
int pageSize = 10;
var query = DB.SiteMessage.AsNoTracking().AsQueryable();
query = query.OrderByDescending(x => x.createdTime);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelSiteMessage>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelSiteMessage(x)).ToList()
};
return(model);
}
public ModelPagedList <ModelReview> GetReview([FromUri] int courseId, int page = 1)
{
int pageSize = 5;
var query = DB.Review.AsNoTracking().AsQueryable();
query = query.Where(x => x.courseId == courseId);
query = query.OrderByDescending(x => x.up).ThenByDescending(x => x.createdTime);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelReview>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelReview(x)).ToList()
};
return(model);
}
public ModelPagedList <ModelNews> List([FromUri] int page = 1)
{
int pageSize = 5;
var query = DB.News.AsNoTracking().AsQueryable().OrderBy(x => x.publishDate);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelNews>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelNews()
{
id = x.id,
title = x.title,
publishDate = x.publishDate
}).ToList()
};
return(model);
}
public ModelPagedList <ModelDocument> List([FromUri] string key = null, int page = 1)
{
int pageSize = 5;
var query = DB.Document.AsNoTracking().AsQueryable();
if (!string.IsNullOrWhiteSpace(key))
{
query = query.Where(x => x.title.Contains(key) || x.intro.Contains(key));
}
query = query.OrderBy(x => x.id);
var result = query.ToPagedList(page, pageSize);
var model = new ModelPagedList <ModelDocument>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelDocument(x, AuthCustomer)).ToList()
};
return(model);
}
public ModelPagedList <ModelCourse> Query([FromBody] QueryCourse param)
{
int page = 1;
int pageSize = 6;
var query = DB.OnlineCourse.AsNoTracking().AsQueryable();
if (param != null)
{
page = param.PageIndex;
pageSize = param.PageSize;
if (!string.IsNullOrWhiteSpace(param.categoryA))
{
query = query.Where(x => x.categoryA == param.categoryA);
}
if (!string.IsNullOrWhiteSpace(param.categoryB))
{
query = query.Where(x => x.categoryB == param.categoryB);
}
if (!string.IsNullOrWhiteSpace(param.key))
{
query = query.Where(x => x.name.Contains(param.key));
}
if (param.minPrice.HasValue)
{
query = query.Where(x => x.price >= param.minPrice);
}
if (param.maxPrice.HasValue)
{
query = query.Where(x => x.price <= param.maxPrice);
}
if (param.age.HasValue)
{
query = query.Where(x => x.fromAge <= param.age && x.toAge >= param.age);
}
}
int order = 1;
int orderAsc = 2;
if (param != null)
{
if (param.order.HasValue)
{
order = param.order.Value;
}
if (param.orderAsc.HasValue)
{
orderAsc = param.orderAsc.Value;
}
}
if (orderAsc == 1)
{
if (order == 1)
{
query = query.OrderBy(x => x.viewCount);
}
else if (order == 2)
{
query = query.OrderBy(x => x.publishedTime);
}
else
{
query = query.OrderBy(x => x.price);
}
}
else
{
if (order == 1)
{
query = query.OrderByDescending(x => x.viewCount);
}
else if (order == 2)
{
query = query.OrderByDescending(x => x.publishedTime);
}
else
{
query = query.OrderByDescending(x => x.price);
}
}
var result = query.ToPagedList(page, pageSize);
List <Favorite> favs = new List <DAL.Favorite>();
if (User.Identity.IsAuthenticated)
{
if (AuthCustomer != null)
{
var ids = result.Select(x => x.courseId).ToList();
favs = DB.Favorite.AsNoTracking().Where(x => x.customerId == AuthCustomer.CustomerId && ids.Contains(x.courseId)).ToList();
}
}
var model = new ModelPagedList <ModelCourse>()
{
Pagination = new Pagination(result),
List = result.Select(x => new ModelCourse(x)).ToList()
};
foreach (var m in model.List)
{
if (favs.Any(x => x.courseId == m.id))
{
m.IsFavorite = true;
}
}
return(model);
}
