public ProductsPageModel GetProductsByCata(int catagoryID) { ProductsPageDAL dal = new ProductsPageDAL(); DataTable dt = dal.getProductByCatagorie(catagoryID); // converting from a DataTable to a Product Object! ProductsPageModel d = new ProductsPageModel(); string CDescription = ""; List <ProductModel> products = new List <ProductModel>(); foreach (DataRow dr in dt.Rows) { ProductModel product = new ProductModel(); product.ProductID = (int)dr["ProductID"]; product.ProductName = dr["ProductName"].ToString(); product.ProductImage = dr["ProductImage"].ToString(); product.ProductPrice = (int)dr["ProductPrice"]; product.ShipperID = dr["ShipperID"].ToString(); product.ProductDescription = dr["ProductDescription"].ToString(); product.CategoryId = catagoryID; products.Add(product); product.CatagoryDescription = dr["CatagoryDescription"].ToString(); product.CatagoryName = dr["CatagoryName"].ToString(); CDescription = product.CatagoryDescription; } d.Products = products; d.CatagoryDescription = CDescription; return(d); }
public ActionResult Index(ProductsPageModel c) { CustomersRepository p = new CustomersRepository(); p.InsertPotinoalCustomers(c); return(RedirectToAction("Index", "Home")); }
public void InsertPotinoalCustomers(ProductsPageModel c) { var query = string.Format(@"INSERT INTO PotentialCustomers (FullName, CompanyName, PhoneNumber) VALUES ('{0}', '{1}', '{2}')", c.PotionalCustomerName, c.PotionalCustomerCompany, c.PotionalCustomerPhone ); _dbHeloer.ExecuteNonQuery(query); }
public ActionResult Index() { var model = new ProductsPageModel(); model.Products = ProductHandler.Instance.GetAllProducts().Products.ToList(); return(View(model)); }
// GET: ProductDetails public ActionResult ProductDetails(int id) { ProductBLL bll = new ProductBLL(); ProductsPageModel prod = bll.getProductById(id); prod.Products = bll.CommonProductsId(id); ViewBag.Message = prod; return(View(prod)); }
public ProductsPageModel SearchProducts(string productName) { ProductsPageDAL dal = new ProductsPageDAL(); DataTable dt = dal.GetProductByName(productName); ProductsPageModel d = new ProductsPageModel(); d.Products = GetProducts(dt); return(d); }
public IActionResult GetProducts() { // ViewBag.Products = dbContext.Products.ToList(); Console.WriteLine(" Passing at Products - HttpGet ------"); ProductsPageModel prod = new ProductsPageModel(); prod.Products = dbContext.Products.ToList(); return(View("Products", prod)); }
public async Task <ActionResult> AddProduct(Product product) { await ProductHandler.Instance.AddProduct(product); var model = new ProductsPageModel(); model.Products = ProductHandler.Instance.GetAllProducts().Products.ToList(); model.Product = null; return(View("Index", model)); }
public ActionResult ProductsPage(int id, int?productId) { if (productId.HasValue) { AddProductToCart(productId.Value); } var products = _productsService.GetProductsByCata(1); ProductsPageModel model = GetModel(products.Products); return(View(model)); }
// GET: ProductDetails public ActionResult ProductDetails(int id) { ProductBLL bll = new ProductBLL(); ProductsPageModel prod = bll.getProductById(id); object myObject = TempData["ListProduts"]; TempData.Keep(); List <ProductModel> list = ((IEnumerable)myObject).Cast <ProductModel>().ToList(); prod.CommonProducts = bll.CommonProductsId(id, list); ViewBag.Message = prod; return(View(prod)); }
public IActionResult AddProduct(ProductsPageModel prod) { //in this list we add the new product, then redirect to the products page again if (ModelState.IsValid) { dbContext.Products.Add(prod.OneProduct); dbContext.SaveChanges(); return(Redirect("Products")); } else { prod.Products = dbContext.Products.ToList(); Console.WriteLine(" Passing at Products - Error in model state ------"); return(View("Products", prod)); } }
private ProductsPageModel GetModel(List <ProductModel> products) { ProductsPageModel model = new ProductsPageModel(); string CDescrip = ""; model.Products = new List <ProductModel>(); foreach (var product in products) { model.Products.Add(new ProductModel() { ProductID = product.ProductID, ProductName = product.ProductName, ProductImage = product.ProductImage, ProductPrice = product.ProductPrice }); } model.CatagoryDescription = CDescrip; return(model); }
public object LoadModel(int?categoryId, int?page) { string papeUrl = this.GetTargetPageUrl("Products.aspx"); if (this.IsStyle2) { // Style2 风格下,页面不需要绑定数据。数据由JS通过AJAX方式获取 return(new PageResult(papeUrl, null)); } ProductsPageModel result = new ProductsPageModel(); result.Categories = BllFactory.GetCategoryBLL().GetList(); if (result.Categories.Count == 0) { return(new RedirectResult("/Pages/Categories.aspx")); } // 获取当前用户选择的商品分类ID ProductSearchInfo info = new ProductSearchInfo(); info.CategoryId = categoryId.HasValue ? categoryId.Value : 0; if (info.CategoryId == 0) { info.CategoryId = result.Categories[0].CategoryID; } info.PageIndex = page.HasValue ? page.Value - 1 : 0; info.PageSize = AppHelper.DefaultPageSize; result.ProductInfo = new ProductInfoModel( result.Categories, new Product { CategoryID = info.CategoryId }); result.PagingInfo = info; result.CurrentCategoryId = info.CategoryId; result.RequestUrlEncodeRawUrl = HttpUtility.UrlEncode(this.HttpContext.Request.RawUrl); // 加载商品列表 result.Products = BllFactory.GetProductBLL().SearchProduct(info); return(new PageResult(papeUrl, result)); }
public ActionResult Index(int?productId) { if (productId.HasValue) { AddProductToCart(productId.Value); RedirectToAction("CartView", "ShoppingCart"); } ProductsPageModel model = new ProductsPageModel(); List <ProductModel> products = _productsService.GetProductsList().Products; int[] arr = _productsService.MostPopularProducts(); List <ProductModel> productsPopular = new List <ProductModel>(); for (int i = 0; i < arr.Length; i++) { ProductModel c = products.Find(product => product.ProductID == arr[i]); productsPopular.Add(c); } model.Products = productsPopular; return(View(model)); }
public ProductsPageModel GetProductsList() { ProductsPageDAL dal = new ProductsPageDAL(); DataTable dt = dal.getProducts(); // converting from a DataTable to a Product Object! ProductsPageModel d = new ProductsPageModel(); List <ProductModel> products = new List <ProductModel>(); foreach (DataRow dr in dt.Rows) { ProductModel product = new ProductModel(); product.ProductID = (int)dr["ProductID"]; product.ProductName = dr["ProductName"].ToString(); product.ProductImage = dr["ProductImage"].ToString(); product.ProductPrice = (int)dr["ProductPrice"]; product.ProductDescription = dr["ProductDescription"].ToString(); products.Add(product); } d.Products = products; return(d); }
public ProductsPageModel getProductById(int id) { ProductDAL dal = new ProductDAL(); DataTable dt = dal.getProduct(id); // converting from a DataTable to a Product Object! ProductsPageModel prod = new ProductsPageModel(); List <ProductModel> products = new List <ProductModel>(); foreach (DataRow dr in dt.Rows) { ProductModel product = new ProductModel(); product.ProductID = id; product.ProductName = dr["ProductName"].ToString(); product.ProductImage = dr["ProductImage"].ToString(); product.ProductPrice = (int)dr["ProductPrice"]; product.ProductDescription = dr["ProductDescription"].ToString(); product.CatagoryName = dr["CatagoryName"].ToString(); product.CategoryId = (int)dr["CatagoryId"]; products.Add(product); } prod.Products = products; return(prod); }