public HttpResponseMessage GetCategory(int CategoryID) { using (WebsiteEntities dc = new WebsiteEntities()) { ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.CategoryID == CategoryID); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, cate); return(response); } }
public HttpResponseMessage GetCategory(int CategoryID) { using (WebsiteEntities dc = new WebsiteEntities()) { ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.CategoryID == CategoryID); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, cate); return response; } }
public HttpResponseMessage GetProductDetail(int ProductID) { using (WebsiteEntities db = new WebsiteEntities()) { Product product = db.Products.FirstOrDefault(x => x.ProductID == ProductID); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, product); return response; } }
public HttpResponseMessage GetProductDetail(int ProductID) { using (WebsiteEntities db = new WebsiteEntities()) { Product product = db.Products.FirstOrDefault(x => x.ProductID == ProductID); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, product); return(response); } }
public HttpResponseMessage GetMenuCategory() { using (WebsiteEntities dc = new WebsiteEntities()) { List<ProductCategory> Listcategory = new List<ProductCategory>(); string UK = "MainCategory"; ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.KeyWord == UK); Listcategory = dc.ProductCategories.Where(x => x.ParentID == cate.CategoryID).OrderBy(x => x.SortOrder).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Listcategory); return response; } }
public HttpResponseMessage GetMenuCategory() { using (WebsiteEntities dc = new WebsiteEntities()) { List <ProductCategory> Listcategory = new List <ProductCategory>(); string UK = "MainCategory"; ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.KeyWord == UK); Listcategory = dc.ProductCategories.Where(x => x.ParentID == cate.CategoryID).OrderBy(x => x.SortOrder).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Listcategory); return(response); } }
public HttpResponseMessage GetCategoryList(String KeyWord) { using (WebsiteEntities dc = new WebsiteEntities()) { ProductCategory mainCate = dc.ProductCategories.SingleOrDefault(cate => cate.KeyWord == KeyWord); List<ProductCategory> list =(from cate in dc.ProductCategories where cate.ParentID==mainCate.CategoryID select cate).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, list); return response; } }
public HttpResponseMessage GetCategoryList(String KeyWord) { using (WebsiteEntities dc = new WebsiteEntities()) { ProductCategory mainCate = dc.ProductCategories.SingleOrDefault(cate => cate.KeyWord == KeyWord); List <ProductCategory> list = (from cate in dc.ProductCategories where cate.ParentID == mainCate.CategoryID select cate).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, list); return(response); } }
public HttpResponseMessage GetProduct(int CategoryID) { using (WebsiteEntities dc = new WebsiteEntities()) { List<Product> Products = new List<Product>(); Products = (from c in dc.ProductCategories from p in dc.Products from pc in dc.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == CategoryID && p.Status == true select p).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return response; } }
public HttpResponseMessage GetProduct(int CategoryID) { using (WebsiteEntities dc = new WebsiteEntities()) { List <Product> Products = new List <Product>(); Products = (from c in dc.ProductCategories from p in dc.Products from pc in dc.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == CategoryID && p.Status == true select p).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return(response); } }
public HttpResponseMessage GetProduct(string UK) { using (WebsiteEntities dc = new WebsiteEntities()) { List<Product> Products = new List<Product>(); ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.KeyWord == UK); Products = (from c in dc.ProductCategories from p in dc.Products from pc in dc.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == cate.CategoryID && p.Status == true select p).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return response; } }
public HttpResponseMessage GetProduct(string UK) { using (WebsiteEntities dc = new WebsiteEntities()) { List <Product> Products = new List <Product>(); ProductCategory cate = dc.ProductCategories.SingleOrDefault(a => a.KeyWord == UK); Products = (from c in dc.ProductCategories from p in dc.Products from pc in dc.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == cate.CategoryID && p.Status == true select p).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return(response); } }
public HttpResponseMessage GetProductRelated(int ProductRelatedID) { using (WebsiteEntities db = new WebsiteEntities()) { List<Product> Products = new List<Product>(); ProductToCategory pc1 = db.ProductToCategories.First(a => a.ProductID == ProductRelatedID); ProductCategory cate = db.ProductCategories.SingleOrDefault(a => a.CategoryID == pc1.CategoryID); Products = (from c in db.ProductCategories from p in db.Products from pc in db.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == cate.CategoryID && p.Status == true && p.ProductID != ProductRelatedID select p).Take(4).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return response; } }
public HttpResponseMessage GetProductRelated(int ProductRelatedID) { using (WebsiteEntities db = new WebsiteEntities()) { List <Product> Products = new List <Product>(); ProductToCategory pc1 = db.ProductToCategories.First(a => a.ProductID == ProductRelatedID); ProductCategory cate = db.ProductCategories.SingleOrDefault(a => a.CategoryID == pc1.CategoryID); Products = (from c in db.ProductCategories from p in db.Products from pc in db.ProductToCategories where c.CategoryID == pc.CategoryID && pc.ProductID == p.ProductID && c.CategoryID == cate.CategoryID && p.Status == true && p.ProductID != ProductRelatedID select p).Take(4).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Products); return(response); } }