public ActionResult DeleteCart(int id)
{
uid = id;
tblCart tb = _db.tblCarts.Where(u => u.CartId == id).FirstOrDefault();
return(View(tb));
}
public HttpResponseMessage removeFromCart(int cartid, int productid)
{
tblCart result = db.tblCarts.Find(cartid, productid);
db.tblCarts.Remove(result);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
public ActionResult DeleteCart()
{
tblCart tb = _db.tblCarts.Where(u => u.CartId == uid).FirstOrDefault();
_db.tblCarts.Remove(tb);
_db.SaveChanges();
return(RedirectToAction("Cart", "Home"));
}
public HttpResponseMessage InsertCart(string useremail, int productid, int cartquantity)
{
tblCart cart = new tblCart()
{
useremail = useremail,
productid = productid,
cartquantity = cartquantity
};
db.tblCarts.Add(cart);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
public string InsertProduct(tblCart cart)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
db.tblCarts.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + " was successfully inserted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public ActionResult AddToCart(int id)
{
tblCart tc = new tblCart();
tc.ProductId = id;
tblUser ur = _db.tblUsers.Where(m => m.Email == User.Identity.Name).FirstOrDefault();
if (ur == null)
{
return(RedirectToAction("Login", "Account"));
}
tc.UserId = ur.UserId;
_db.tblCarts.Add(tc);
_db.SaveChanges();
tc = _db.tblCarts.Where(m => m.UserId == ur.UserId).FirstOrDefault();
return(RedirectToAction("Cart", "Home"));
}
public ActionResult AddCart(tblModel TestRoute1)
{
tblCart cart = new tblCart();
cart.CusId = 3;
cart.ModelId = TestRoute1.ModelId;
cart.PurcharseDate = TestRoute1.PurcharseDate;
if (ModelState.IsValid)
{
db.tblCarts.Add(cart);
db.SaveChanges();
TempData["AlertMessage"] = "my alert message";
return(RedirectToAction("index", "product"));
}
return(RedirectToAction("index", new { id = "1" }));
}
public string DeleteProduct(int id)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
tblCart cart = db.tblCarts.Find(id);
db.tblCarts.Attach(cart);
db.tblCarts.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + " was successfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string Remove(int CartId) //This method is used for removing a book from the cart.
{
string message;
try
{
using (var db = new Orchard9Entities())
{
tblCart a1 = db.tblCarts.Find(CartId);
db.tblCarts.Remove(a1);
db.SaveChanges();
message = CartId + " removed from cart";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
string clientId = "-1";
int id = Convert.ToInt32(Request.QueryString["id"]);
int amount = Convert.ToInt32(ddlAmount.SelectedValue);
tblCart cart = new tblCart
{
Amount = amount,
ClientID = clientId,
DatePurchased = DateTime.Now,
IsInCart = true,
ProductID = id
};
CartModel model = new CartModel();
lblResult.Text = model.InsertProduct(cart);
}
}
public string UpdateProduct(int id, tblCart cart)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
//Fetch object from db
tblCart p = db.tblCarts.Find(id);
p.DatePurchased = cart.DatePurchased;
p.ClientID = cart.ClientID;
p.Amount = cart.Amount;
p.IsInCart = cart.IsInCart;
p.ProductID = cart.ProductID;
db.SaveChanges();
return(cart.DatePurchased + " was successfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public ActionResult AddToCart(int id, int uID, decimal qty, string size)
{
try
{
string usrID = uID.ToString();
decimal quantity = qty;
using (linqDBContext db = new linqDBContext())
{
var cartQty = (from us in db.tblCarts
where us.userMob == usrID &&
us.itemID == id &&
us.size == size
select us).FirstOrDefault();
if (cartQty != null)
{
quantity += cartQty.itemQty.Value;
}
//Availibity
var chkAvailibity = (from us in db.Inventory_Latest
where us.itemId == id &&
us.network == 3 &&
us.localID == 0 &&
us.size == size
select us).FirstOrDefault();
if (quantity > chkAvailibity.qty)
{
if (chkAvailibity.qty == 0)
{
return(Json(new { status = "error", Data = size + " size if out of stock." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "error", Data = "Inventory has only " + chkAvailibity.qty + " " + size + " items left." }, JsonRequestBehavior.AllowGet));
}
}
var q = (from us in db.tblCarts
join item in db.tblItems on us.itemID equals item.id
where us.userMob == usrID &&
us.itemID == id &&
us.size == size
select new { us, item }).FirstOrDefault();
if (q != null)
{
if (qty < 0)
{
if ((q.us.itemQty == null) || (q.us.itemQty == 1))
{
return(Json(new { status = "error", Data = "Cannot remove further." }, JsonRequestBehavior.AllowGet));
}
}
if (q.us.itemQty != null)
{
q.us.itemQty += qty;
q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value);
db.SaveChanges();
}
else
{
q.us.itemQty = qty;
q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value);
db.SaveChanges();
}
return(Json(new { status = "success", Data = GetItem(q.us.id, usrID).ToList() }, JsonRequestBehavior.AllowGet));
}
else
{
var itemPrice = (from us in db.tblItems
where us.id == id
select us.netPrice.Value).FirstOrDefault();
//Add
tblCart c = new tblCart();
c.userMob = usrID;
c.itemQty = qty;
c.itemID = id;
c.size = size;
c.Price = Convert.ToDecimal(qty * itemPrice);
db.tblCarts.Add(c);
db.SaveChanges();
return(Json(new { status = "success", Data = GetItem(c.id, usrID).ToList() }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
