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()); }