public ActionResult PlusProduct(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product pp = db.t_product.Find(id);
ListCart.Instance.AddItem(pp);
Item foundItem = null;
foreach (Item a in ListCart.Instance.Items)
{
if (a.Prod.productId == pp.productId)
{
foundItem = a;
}
}
var results = new
{
ct = 1,
Total = ListCart.Instance.GetSubTotal(),
Quatite = foundItem.Quantity,
TotalRow = foundItem.TotalPrice
};
return(Json(results));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
t_product t_product = await db.t_product.FindAsync(id);
db.t_product.Remove(t_product);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <bool> ExistProduct(string product_name)
{
string sql_select = g_sqlMaker.Select <t_product>(s => new
{
s.id
})
.Where("product_name", "=", "@product_name").And("state", "=", "@state")
.ToSQL();
t_product product = await g_dbHelper.QueryAsync <t_product>(sql_select, new { product_name, state = (int)EnumState.Normal });
return(product != null);
}
public async Task <ActionResult> Create([Bind(Include = "productId,productName,productDescription,sellerPrice,subcategory_subcategoryId,quantityAvailable,productImage,isDisabledByAdmin,isDisabledBySeller,subcategoryAttributesAndValues,seller_youBayUserId")] t_product t_product)
{
if (ModelState.IsValid)
{
db.t_product.Add(t_product);
await db.SaveChangesAsync();
return(RedirectToAction("ListForManager"));
}
ViewBag.subcategory_subcategoryId = new SelectList(db.t_subcategory, "subcategoryId", "categoryName", t_product.subcategory_subcategoryId);
return(View(t_product));
}
public async Task <ActionResult> DetailsForUser(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product products = await db.t_product.FindAsync(id);
if (products == null)
{
return(HttpNotFound());
}
return(View(products));
}
// GET: Product/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product t_product = await db.t_product.FindAsync(id);
if (t_product == null)
{
return(HttpNotFound());
}
return(View(t_product));
}
public ActionResult AddProduct(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product pp = db.t_product.Find(id);
ListCart.Instance.AddItem(pp);
ViewBag.List = ListCart.Instance.Items;
ViewBag.total = ListCart.Instance.GetSubTotal();
return(View());
}
// GET: Product/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product t_product = await db.t_product.FindAsync(id);
if (t_product == null)
{
return(HttpNotFound());
}
ViewBag.subcategory_subcategoryId = new SelectList(db.t_subcategory, "subcategoryId", "categoryName", t_product.subcategory_subcategoryId);
return(View(t_product));
}
public ActionResult DeleteProduct(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product pp = db.t_product.Find(id);
ListCart.Instance.RemoveItem(pp);
var results = new
{
Total = ListCart.Instance.GetSubTotal(),
};
return(Json(results));
}
public void SetItemQuantity(t_product Product, int quantity)
{
if (quantity == 0)
{
RemoveItem(Product);
return;
}
foreach (Item a in Items)
{
if (a.Prod.productId == Product.productId)
{
a.Quantity = quantity;
return;
}
}
}
public void RemoveItem(t_product Product)
{
Item t = null;
foreach (Item a in Items)
{
if (a.Prod.productId == Product.productId)
{
t = a;
}
}
if (t != null)
{
Items.Remove(t);
}
}
public ActionResult LessProduct(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_product pp = db.t_product.Find(id);
ListCart.Instance.SetLessOneItem(pp);
Item trouve = null;
foreach (Item a in ListCart.Instance.Items)
{
if (a.Prod.productId == pp.productId)
{
trouve = a;
}
}
if (trouve != null)
{
var results = new
{
Total = ListCart.Instance.GetSubTotal(),
Quatite = trouve.Quantity,
TotalRow = trouve.TotalPrice,
ct = 1
};
return(Json(results));
}
else
{
var results = new
{
ct = 0
};
return(Json(results));
}
return(null);
}
public void SetLessOneItem(t_product produit)
{
foreach (Item a in Items)
{
if (a.Prod.productId == produit.productId)
{
if (a.Quantity <= 0)
{
RemoveItem(a.Prod);
return;
}
else
{
a.Quantity--;
return;
}
}
}
}
public async Task <Result> DeleteProduct(reqmodel <int> reqmodel)
{
Result result = new Result {
code = ErrorCodeConst.ERROR_100, status = ErrorCodeConst.ERROR_403
};
string sql_update = g_sqlMaker.Update <t_product>(u => new { u.state }).Where($"id", "=", "@id").And("state", "=", "@state").ToSQL();
t_product product_model = new t_product
{
id = reqmodel.Data,
state = (int)EnumState.Delete
};
bool update_flag = await g_dbHelper.ExecAsync(sql_update, product_model) > 0;
if (!update_flag)
{
result.code = ErrorCodeConst.ERROR_1034;
return(result);
}
result.status = ErrorCodeConst.ERROR_200;
result.code = ErrorCodeConst.ERROR_1033;
return(result);
}
public void AddItem(t_product prod)
{
Boolean iswhat = false;
// Create a new item to add to the cart
foreach (Item a in Items)
{
if (a.Prod.productId == prod.productId)
{
a.Quantity++;
iswhat = true;
return;
}
}
if (iswhat == false)
{
Item newItem = new Item(prod);
newItem.Quantity = 1;
Items.Add(newItem);
}
}
public Item(t_product p)
{
this.Prod = p;
}
