public USSER Checktrangthai(int id) { using (Shopbanhang db = new Shopbanhang()) { USSER user = (from p in db.USSERs where p.ID == id select p).FirstOrDefault(); return(user); } }
public List <DonHangModel> xemdonhang(long MAKH) { using (Shopbanhang db = new Shopbanhang()) { List <DonHangModel> listdh = new List <DonHangModel>(); db.DONHANGs.AsNoTracking(); var danhsach = from p in db.DONHANGs where p.MAKH == MAKH select p; foreach (var item in danhsach.ToList()) { USSER user = (from p in db.USSERs where p.ID == MAKH select p).FirstOrDefault(); listdh.Add(new DonHangModel() { donhang = item, nguoimua = user, tinhtrangdh = gettinhTrangDH(item.TINHTRANGDH) }); } return(listdh); } }