//lấy danh sách bình luận theo từng block
public static List<BinhLuan> GetBinhluans(int BlockNumber, int BlockSize, int KhachSan)
{
int startIndex = (BlockNumber - 1) * BlockSize;
using (var _context = new PortalEntities())
{
var _dsBinhluan = (from p in _context.BinhLuan where p.KhachSan == KhachSan select p).
OrderByDescending(p => p.Id).
Skip(startIndex).
Take(BlockSize).ToList();
if (_dsBinhluan != null)
return _dsBinhluan;
else
return null;
}
}
//lấy danh sách khách sạn theo từng block
public static List<KhachSan> GetHotels(int BlockNumber, int BlockSize, string ThanhPho, string SapXep)
{
int startIndex = (BlockNumber - 1) * BlockSize;
var _dsKhachSan = new List<KhachSan>();
using(var _context = new PortalEntities())
{
switch (SapXep)
{
case "Name": //tên theo alphabet
_dsKhachSan = (from p in _context.KhachSan where p.ThanhPho == ThanhPho select p).
OrderBy(p => p.TenKhachSan).
Skip(startIndex).
Take(BlockSize).ToList();
break;
case "Price": //giá thấp -> cao
_dsKhachSan = (from p in _context.KhachSan where p.ThanhPho == ThanhPho select p).
OrderBy(p => p.GiaTien).
Skip(startIndex).
Take(BlockSize).
ToList();
break;
case "Rating": //rating từ cao -> thấp
_dsKhachSan = (from p in _context.KhachSan where p.ThanhPho == ThanhPho select p).
OrderByDescending(p => p.DanhGia).
Skip(startIndex).
Take(BlockSize).ToList();
break;
case "Category": //hạng khách sạn từ cao -> thấp
_dsKhachSan = (from p in _context.KhachSan where p.ThanhPho == ThanhPho select p).
OrderByDescending(p => p.HangKhachSan).
Skip(startIndex).Take(BlockSize).
ToList();
break;
}
}
if (_dsKhachSan == null){
//throw here
}
return _dsKhachSan;
}