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