public int Create(DONHANG order)
{
connect.SendPostRequest <DONHANG>(order, "api/DONHANG/");
db.DONHANG = connect.DeserializeObject <List <DONHANG> >("api/DONHANG/");
int id = db.DONHANG.Max(x => x.ID);
return(id);
}
public List <HOMELOAISP> GetNewProduct()
{
db.SANPHAM = connect.DeserializeObject <List <SANPHAM> >("api/SANPHAM/").ToList();
db.HANGSX = connect.DeserializeObject <List <HANGSX> >("api/HANGSX/").ToList();
db.LOAISP = connect.DeserializeObject <List <LOAISP> >("api/LOAISP/").ToList();
db.PRICE = connect.DeserializeObject <List <PRICE> >("api/PRICE/").ToList();
db.DONHANG = connect.DeserializeObject <List <DONHANG> >("api/DONHANG").ToList();
db.Users = connect.DeserializeObject <List <User> >("api/NGUOIDUNG").ToList();
db.CHITIETDONHANG = connect.DeserializeObject <List <CHITIETDONHANG> >("api/CHITIETDONHANG").ToList();
var product = (from p in db.LOAISP.OrderByDescending(x => x.NGAYTAO)
where p.TRANGTHAI == "Đang bán"
select new HOMELOAISP()
{
ID = p.ID,
TEN = p.TEN,
MOTA = p.MOTA,
ANH = p.ANH,
NGAYTAO = p.NGAYTAO,
HANGSX = ((from z in db.HANGSX
where z.ID == p.HANGSX_ID
select new
{
z.TEN
}).FirstOrDefault().TEN),
GIA = (from x in db.PRICE
from y in db.SANPHAM
where y.LOAISP_ID == p.ID && x.SANPHAM_ID == y.ID
orderby x.GIABAN
select new
{
x.GIABAN
}).FirstOrDefault().GIABAN,
//SOSAO = (from x in db.BINHLUAN
// join y in db.SANPHAM on x.SANPHAM_ID equals y.ID
// where y.LOAISP_ID == p.ID
// group x.SOSAO by x.SANPHAM_ID into g
// select new
// {
// t = g.Key
// }).FirstOrDefault().t
}).ToList();
var model = product.ToList().Take(7);
return(model.ToList());
}
