// GET: Details of individual Product
public ActionResult Show(int?id)
{
//if id is equal to NULL then, return BadRequest
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// Pet pet = db.Pets.Find(id); //EF 6 technique
Product product = db.Products.SqlQuery("select * from Products where ProductId=@ProductId", new SqlParameter("@ProductId", id)).FirstOrDefault();
//if there is no product then, return HttpNotFound
if (product == null)
{
return(HttpNotFound());
}
//get information about the list of categories associated with that product
string query = "select * from Categories inner join CategoryProducts on Categories.CategoryId = CategoryProducts.Category_CategoryId where Product_ProductId = @id";
SqlParameter param = new SqlParameter("@id", id);
List <Category> CategoryProducts = db.Categories.SqlQuery(query, param).ToList();
List <Category> all_catgories = db.Categories.SqlQuery("select * from Categories").ToList();
ShowProduct viewmodel = new ShowProduct();
viewmodel.product = product;
viewmodel.categories = CategoryProducts;
viewmodel.all_categories = all_catgories;
return(View(viewmodel));
}
public ActionResult Products(int?page)
{
var pageNumber = page ?? 1;
var product = new ShowProduct().products();
return(PartialView(product.ToPagedList(pageNumber, 12)));
}
public ActionResult SearchPrice(int price, int?page)
{
var pageNumber = page ?? 1;
var product = new ShowProduct().SearchProductPrice(price);
return(PartialView(product.ToPagedList(pageNumber, 12)));
}
public static void OnProductShowing(Product product)
{
ProductVM productVM = new ProductVM(product, true);
if (ShowProduct != null)
{
ShowProduct.Invoke(productVM);
}
}
//Thêm mới sản phẩm
public ActionResult AddItem(int productID, int Quantity, int sizeID)
{
var size = new Models.DAO.Category().SizeID(sizeID);
var product = new ShowProduct().ProductDetail(productID);
var Cart = Session[CartSession];
if (Cart != null)
{
var list = (List <CartItem>)Cart;
if (list.Exists(x => x.Product.ID == productID))
{
foreach (var item in list)
{
if (item.Product.ID == productID)
{
item.Quantity += Quantity;
}
}
}
else
{
var item = new CartItem();
item.Product = product;
item.Quantity = Quantity;
item.Size = size;
list.Add(item);
}
Session[CartSession] = list;
}
else
{
var item = new CartItem();
item.Product = product;
item.Quantity = Quantity;
item.Size = size;
var list = new List <CartItem>();
list.Add(item);
Session[CartSession] = list;
}
return(RedirectToAction("Index"));
}
//formcollection dùng cho search form lấy dữ liệu khi nhập vào ô textbox
public ActionResult Product(string meta, int?id, int?page, FormCollection fc)
{
var pid = id ?? 1;
var pageNumber = page ?? 1;
string name = fc["search-product"];
if (name != null)
{
var product = new ShowProduct().SearchProduct(name);
return(View(product.ToPagedList(pageNumber, 12)));
}
else
{
var products = new ShowProduct().Product(pid);
return(View(products.ToPagedList(pageNumber, 12)));
}
}
/// <summary>
/// To gather information of particular product with selected product ID
/// </summary>
/// <param name="id">ProductID</param>
/// <returns>Return information about slected ProductID. </returns>
// GET: Product/Details/5
public ActionResult Details(int id)
{
ShowProduct ViewModel = new ShowProduct();
string findproducturl = "productdata/findproduct/" + id;
HttpResponseMessage findproductResponse = client.GetAsync(findproducturl).Result;
if (findproductResponse.IsSuccessStatusCode)
{
//Sending findproductResponse request to product data controller,
//if request send succeed (status code 200), get this product information (based on ProductDto.)
//If failed, direct to Error action (View)
ProductDto SelectedProduct = findproductResponse.Content.ReadAsAsync <ProductDto>().Result;
ViewModel.product = SelectedProduct;
return(View(ViewModel));
}
else
{
return(RedirectToAction("Error"));
}
}
private void InitialData()
{
_store = (STORE)Session["store"];
txtStoreCode.Text = _store.STORE_CODE;
txtStoreName.Text = _store.STORE_NAME;
var cmdCat = new CategoryService();
var list = cmdCat.GetALL();
foreach (var item in list)
{
ddlCategory.Items.Add(new ListItem(item.CATEGORY_NAME, item.CATEGORY_ID.ToString()));
}
var cmd = new ProductService();
DataSouce = cmd.GetALLInclude().Where(x => x.PRODUCT_TYPE_CODE == 1).ToList();
DataSouceShowProduct = new List <ShowProduct>();
foreach (PRODUCT pro in DataSouce)
{
ShowProduct tmp = new ShowProduct();
tmp.PRODUCT_ID = pro.PRODUCT_ID;
tmp.PRODUCT_CODE = pro.PRODUCT_CODE;
tmp.PRODUCT_NAME = pro.PRODUCT_NAME;
tmp.PRICE = pro.PRODUCT_PRICELIST.Where(x => x.PRODUCT_ID == pro.PRODUCT_ID && x.ZONE_ID == _store.ZONE_ID).FirstOrDefault()
!= null ? (decimal)pro.PRODUCT_PRICELIST.Where(x => x.PRODUCT_ID == pro.PRODUCT_ID && x.ZONE_ID == _store.ZONE_ID).FirstOrDefault().PRODUCT_PRICE : 0;
tmp.CATEGORY_ID = pro.CATEGORY_ID;
DataSouceShowProduct.Add(tmp);
}
gridProduct.DataSource = DataSouceShowProduct;
gridProduct.DataBind();
if (lstOrderDetail.Count > 0)
{
lblPrice.Text = lstOrderDetail.Select(x => x.PRODUCT_TOTAL).Sum().ToString();
linkToOrder.Visible = true;
}
}
//Product
public ActionResult Product()
{
var Prod = new ShowProduct().ProductHot();
return(PartialView(Prod));
}
public IEnumerable <Detail> Del_now([FromBody] ShowProduct data)
{
return(repository.Del_now(data));
}
//Show new products
public ActionResult newProducts()
{
var _newProduct = new ShowProduct().newProduct();
return(PartialView(_newProduct));
}
public ActionResult PartialProduct(int id)
{
var p = new ShowProduct().Product(id);
return(PartialView(p));
}
public ActionResult ProductDetail(string metatitle, int ID)
{
var prodDetail = new ShowProduct().ProductDetail(ID);
return(View(prodDetail));
}
