private static CartDetails Read(SqlDataReader rd)
{
string idStr = rd["Id"].ToString();
int id = Convert.ToInt32(idStr);
string cusername = rd["Username"].ToString();
string name = rd["NAME"].ToString();
string image = rd["IMAGE"].ToString();
string quantityStr = rd["QUANTITY"].ToString();
int quantity = Convert.ToInt32(quantityStr);
string priceStr = rd["PRICE"].ToString();
double price = Convert.ToDouble(priceStr);
string total = rd["TOTAL"].ToString();
CartDetails cd = new CartDetails
{
Id = id,
Name = name,
Image = image,
Quantity = quantity,
Price = price,
Total = total,
Username = cusername
};
return(cd);
}
void BindAlbumGrid()
{
int k = GridView1.PageCount;
GridView1.Controls.Clear();
//gridpageIndex = 0;
CartDetails cartbll = new CartDetails();
dt = cartbll.SelectUserCartDetails(Convert.ToInt32(Session["UserId"].ToString()));
lblCart.Text = dt.Rows.Count.ToString() + " Items in Your Cart";
if (dt.Rows.Count > 0)
{
decTotalPrice = 0;
tblAdpost.Visible = true;
tblAmount.Visible = true;
tblBuy.Visible = true;
if (dt.Rows.Count > 4)
{
decimal dPageSize = (dt.Rows.Count / 4M);
//GridView1.PagerSettings.PageButtonCount = Convert.ToInt32(Math.Floor(dPageSize));
//GridView1.PageSize = Convert.ToInt32(Math.Ceiling(dPageSize));
}
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
else
{
tblAdpost.Visible = false;
tblAmount.Visible = false;
tblBuy.Visible = false;
}
}
public List <CartDetails> SelectAll(string username)
{
List <CartDetails> cdList = new List <CartDetails>();
string connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(connStr);
string sqlStmt = "Select * from Cart where Username = @paraUsername";
SqlCommand cmd = new SqlCommand(sqlStmt, myConn);
cmd.Parameters.AddWithValue("@paraUsername", username);
myConn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CartDetails cd = Read(dr);
cdList.Add(cd);
}
myConn.Close();
return(cdList);
}
public bool AddDetail(CartDetails cartdetail, UserAccount user)
{
try
{
using (var db = new DBContext())
{
var receipt = db.Receipts.FirstOrDefault(x => x.Email == user.Email);
double total = Int32.Parse(cartdetail.price.Replace(".", "").Replace("đ", "")) * cartdetail.Quantity;
if (receipt != null)
{
ReceiptDetail detail = new ReceiptDetail()
{
ReceiptId = receipt.ReceiptId,
Name = cartdetail.Name,
Type = cartdetail.type,
Quantity = cartdetail.Quantity,
Price = cartdetail.price,
Total = total
};
var cartid = cartdetail.CartId;
var cartdelete = db.CartDetails.FirstOrDefault(x => x.CartId == cartid);
db.CartDetails.Remove(cartdelete);
db.ReceiptDetails.Add(detail);
db.SaveChanges();
return(true);
}
}
}
catch (Exception e) { }
return(false);
}
/// <summary>
/// Invoked when an item is selected.
/// </summary>
/// <param name="obj">The Object</param>
private void RemoveClicked(object obj)
{
if (obj is Product product)
{
CartDetails.Remove(product);
}
}
public int Delete(CartDetails cd)
{
int result = 0;
SqlCommand sqlCmd = new SqlCommand();
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
// Step 2 - Instantiate SqlCommand instance to add record
// with INSERT statement
string sqlStmt = "DELETE Cart where Id = @paraID ";
sqlCmd = new SqlCommand(sqlStmt, myConn);
// Step 3 : Add each parameterised variable with value
sqlCmd.Parameters.AddWithValue("@paraID", cd.Id);
//sqlCmd.Parameters.AddWithValue("@paraName", up.Name);
//sqlCmd.Parameters.AddWithValue("@paraDesc", up.Desc);
//sqlCmd.Parameters.AddWithValue("@paraPrice", up.Price);
// Step 4 Open connection the execute NonQuery of sql command
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
// Step 5 :Close connection
myConn.Close();
return(result);
}
public async Task <bool> RemoveFromCart(int cartDetailsId)
{
try
{
CartDetails cartDetails = await _db.CartDetails
.FirstOrDefaultAsync(u => u.CartDetailsId == cartDetailsId);
int totalCountOfCartItems = _db.CartDetails
.Where(u => u.CartHeaderId == cartDetails.CartHeaderId).Count();
_db.CartDetails.Remove(cartDetails);
if (totalCountOfCartItems == 1)
{
var cartHeaderToRemove = await _db.CartHeaders
.FirstOrDefaultAsync(u => u.CartHeaderId == cartDetails.CartHeaderId);
_db.CartHeaders.Remove(cartHeaderToRemove);
}
await _db.SaveChangesAsync();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public void it_should_update_disconected_cart()
{
Customer customer = null;
CartDetails item = null;
using (var context = new UnitOfWork(new CustomerOrderContext("Northwind")))
{
var repository = new Repository <Customer>(context);
customer = repository.GetAll().Single(x => x.Email == CustomerEmail);
item = customer.Cart.First(x => x.ProductId == _viewModel.Id);
}
var quantity = item.Quantity;
item.Quantity += 1;
using (var context = new UnitOfWork(new CustomerOrderContext("Northwind")))
{
var repository = new Repository <Customer>(context);
repository.Update(customer);
// customer = repository.GetAll().Single(x => x.Email == CustomerEmail);
repository.Save();
}
Assert.Greater(item.Quantity, quantity);
}
public int Update(CartDetails cd)
{
int result = 0;
SqlCommand sqlCmd = new SqlCommand();
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
// Step 2 - Instantiate SqlCommand instance to add record
// with INSERT statement
string sqlStmt = "UPDATE Cart SET QUANTITY = @paraQuantity, TOTAL = @paraTotal where Id = @paraId ";
sqlCmd = new SqlCommand(sqlStmt, myConn);
// Step 3 : Add each parameterised variable with value
sqlCmd.Parameters.AddWithValue("@paraQuantity", cd.Quantity);
sqlCmd.Parameters.AddWithValue("@paraId", cd.Id);
sqlCmd.Parameters.AddWithValue("@paraTotal", cd.Total);
// Step 4 Open connection the execute NonQuery of sql command
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
// Step 5 :Close connection
myConn.Close();
return(result);
}
public Cart GetFilledCard()
{
Cart obj = new Cart();
obj.Id = 1;
obj.SubTotal = 0;
obj.NetTotal = 0;
obj.Items = new List <CartDetails>();
for (int i = 0; i < 4; i++)
{
CartDetails details = new CartDetails();
details.Id = i;
details.image = imageList["img" + i.ToString()];
details.Pro_Name = "Product " + i.ToString();
details.Cprice = random.Next(10, 100);
details.Qty = random.Next(1, 10);
details.Total = details.Cprice * details.Qty;
obj.SubTotal += details.Total;
obj.Items.Add(details);
}
obj.NetTotal = obj.SubTotal;
return(obj);
}
public ActionResult DeleteConfirmed(long id)
{
CartDetails cartDetails = db.CartDetails.Find(id);
db.CartDetails.Remove(cartDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int GetNumberOfCartDetailsRows()
{
var rows = CartDetails.FindElement(By.TagName("tbody"))
.FindElements(By.TagName("tr"))
.Count;
return(rows);
}
public CartDetails UpdateCartDetail(CartDetails model)
{
var cartDetail = _context.CartDetails.Find(model.Id);
_context.CartDetails.Update(cartDetail);
_context.SaveChanges();
return(cartDetail);
}
public void CreateCartDetails(CartDetails cartDetail)
{
if (cartDetail == null)
{
throw new ArgumentNullException(nameof(cartDetail));
}
_context.CartDetails.Add(cartDetail);
SaveChanges();
}
public CartDetails GetCartDetails(int cartId)
{
var cartDetails = new CartDetails();
cartDetails.CartItems = cartDAL.GetCart(cartId);
cartDetails.Tax = cartDAL.GetCart(cartId);
cartDetails.Total = cartDAL.GetCart(cartId);
return(cartDetails);
}
public ActionResult AddToCart(string ItemNum)
{
//psudocode
if (Session["Prof"] == null)
{
Session["prof"] = Cart;
}
//Check if item is already in cart
bool found = false;
int indexOfFound = -1;
for (int i = 0; i < Cart.getItems().Count; i++)
{
CartDetails p = Cart.getItems()[i];
if (p.ItemNumber.Equals(ItemNum, StringComparison.Ordinal))
{
found = true;
indexOfFound = i;
break;
}
}
//if not, add to card
//Else increase quantity by ones
if (found)
{
Cart.incrementQuantity(indexOfFound);
//Cart.getTotal();
}
else
{
CartDetails product = new CartDetails();
Products item = productInfo.getProInfo(ItemNum);
product.ItemNumber = item.ItemNumber;
product.productName = item.ProductName;
product.Description = item.ProductDiscription;
product.Quantity = 1;
product.subTotal = item.ProPrice;
product.total = Cart.getTotal();
Cart.addProduct(product);
ViewBag.MyCarts = Cart.catDetails.Count();
Session["prof"] = Cart.catDetails;
}
var list = Session["cart"] as CartItems;
return(View("Product"));
}
public void AddCart(Carts cart)
{
var idProduct = _context.Products.FirstOrDefault(c => c.Name == cart.ProductName).Id;
detail = new CartDetails()
{
IdCart = cart.Id, IdProduct = idProduct, IdCustomer = cart.IdCustomer, BuyDate = DateTime.Now, IdCartNavigation = cart
};
_context.CartDetails.Add(detail);
_context.SaveChanges();
}
public CartDetails DeleteCartDetail(int id)
{
CartDetails deletedCartDetails = _context.CartDetails.Find(id);
if (deletedCartDetails != null)
{
_context.CartDetails.Remove(deletedCartDetails);
_context.SaveChanges();
}
return(deletedCartDetails);
}
public async Task <IActionResult> Index()
{
CartB cartB = new CartB(_context, this.HttpContext);
var cartDetails = new CartDetails()
{
CartElements = await cartB.GetCartElements(),
CartSum = await cartB.GetCartSum()
};
return(View(cartDetails));
}
public ActionResult Add_To_Cart(CartDetails cartDetails)
{
AddtoCart addcart = new AddtoCart();
addcart.BookId = cartDetails.BookId;
addcart.Quantity = cartDetails.Quantity;
addcart.CustomerEmail = TempData.Peek("CustomerEmail").ToString();
db.AddtoCarts.Add(addcart);
db.SaveChanges();
ViewBag.Message = "Added Successfully";
return(View());
}
public ActionResult Edit([Bind(Include = "Id,Quantity,CartsId,ProductId")] CartDetails cartDetails)
{
if (ModelState.IsValid)
{
db.Entry(cartDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CartsId = new SelectList(db.Carts, "Id", "Id", cartDetails.CartsId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", cartDetails.ProductId);
return(View(cartDetails));
}
// GET: AddToCart
public ActionResult Add()
{
QuenchData quenchData = new QuenchData();
List <CartDetails> cartlist = null;
if (Session["cartlist"] == null)
{
cartlist = new List <CartDetails>();
}
else
{
cartlist = (List <CartDetails>)Session["cartlist"];
}
CartDetails cart;
Product product;
int productId = Convert.ToInt32(Request.QueryString["productId"].ToString());
int res_id = Convert.ToInt32(Session["res_id"].ToString());
cart = cartlist.Where(x => x.productId == productId).FirstOrDefault();
if (cart != null)
{
cart.qty += 1;
cart.price += cart.price;
}
else
{
product = quenchData.getProduct(productId);
cart = new CartDetails()
{
productId = product.id,
prodductName = product.Name,
productDes = product.Description,
price = Convert.ToInt32(double.Parse(product.Price)),
disCountPrice = product.discountPrice,
qty = 1
};
cartlist.Add(cart);
}
Session["cartlist"] = cartlist;
string userId = User.Identity.GetUserName();
if (Session["cart"] == null)
{
Session["cart"] = 1;
}
else
{
Session["cart"] = Convert.ToInt32(Session["cart"]) + 1;
}
return(Redirect("~/Home/RestaurantsMenu?res_id=" + res_id));
}
// GET: CartDetails/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CartDetails cartDetails = db.CartDetails.Find(id);
if (cartDetails == null)
{
return(HttpNotFound());
}
return(View(cartDetails));
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
CartDetails objCart = new CartDetails();
string sCartId = GridView1.DataKeys[e.RowIndex].Value.ToString();
objCart.CartDetailDelete(Convert.ToInt32(sCartId));
BindAlbumGrid();
if (ddlDeliType.SelectedIndex != 0)
{
ddlDeliType_SelectedIndexChanged(sender, e);
}
}
protected void btnAddCart_Click(object sender, EventArgs e)
{
if (Session["UserId"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
CartDetails objCart = new CartDetails();
objCart.CreateUserCart(0, Convert.ToInt32(Session["UserId"].ToString()), Convert.ToInt32(strAdId));
Response.Redirect("MyCartDetail.aspx?uid=" + Session["UserId"].ToString());
}
}
public void UpdateCartDetails(string customerName, CartDetails cartDetail)
{
var customerCartDetails = GetCartDetails(customerName);
if (customerCartDetails == null)
{
_logger.LogInformation("No cart details available");
}
var updateCartDetailsText = "Update dbo.CartDetails SET ProductID = @ProductID, ProductCount = @ProductCount, DateofPurchase = @DateofPurchase, Active = @Active Where CustomerName = @CustomerNameParam";
var productID = new SqlParameter("@ProductID", cartDetail.ProductID);
var productCount = new SqlParameter("@ProductCount", cartDetail.ProductCount);
var dateofPurchase = new SqlParameter("@DateofPurchase", cartDetail.DateofPurchase);
var active = new SqlParameter("@Active", cartDetail.Active);
var nameOfCustomer = new SqlParameter("@CustomerNameParam", cartDetail.CustomerName);
int noOfRowUpdated = _context.Database.ExecuteSqlCommand(updateCartDetailsText, productID, productCount, dateofPurchase, active, nameOfCustomer);
}
private CartDetails CalculateCartDetails(ICollection <OrderedDish> orderedDishes)
{
var cartDetails = new CartDetails
{
Items = orderedDishes.Count,
TotalPrice = orderedDishes.Sum(od => od.Price),
};
foreach (var orderedDish in orderedDishes)
{
cartDetails.BaseDishesPrice += _context.BaseDishes.SingleOrDefault(bd => bd.BaseDishId == orderedDish.BaseDishId).Price;
}
cartDetails.AddedIngredientsPrice = cartDetails.TotalPrice - cartDetails.BaseDishesPrice;
return(cartDetails);
}
// GET: CartDetails/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CartDetails cartDetails = db.CartDetails.Find(id);
if (cartDetails == null)
{
return(HttpNotFound());
}
ViewBag.CartsId = new SelectList(db.Carts, "Id", "Id", cartDetails.CartsId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", cartDetails.ProductId);
return(View(cartDetails));
}
public IActionResult EditQty(string json)
{
EditQuantityPost data = JsonConvert.DeserializeObject <EditQuantityPost>(json);
int newQty = data.newQty;
String cartDetailsId = data.cartDetailsId;
CartDetails cart = dbcontext.CartDetails.Find(cartDetailsId);
var oldQty = cart.Qty;
cart.Qty = newQty;
dbcontext.Update(cart);
if (newQty == 0)
{
dbcontext.Remove(cart);
}
dbcontext.SaveChanges();
var cartItems = HttpContext.Session.GetString("cartItems");
if (String.IsNullOrEmpty(cartItems))
{
cartItems = "0";
}
int parsed = int.Parse(cartItems);
parsed += newQty - oldQty;
HttpContext.Session.SetString("cartItems", parsed.ToString());
string UserId = HttpContext.Session.GetString("UserId");
var Cart = dbcontext.Cart.Where(x => x.UserId == UserId).FirstOrDefault();
List <CartDetails> CartDetails = dbcontext.CartDetails.Where(x => x.CartId == Cart.Id).ToList();
//Get products in cart
double productQty;
double productPx;
double totalAmt = 0;
foreach (CartDetails item in CartDetails)
{
var productincart = dbcontext.Products.Where(x => x.Id == item.ProductId).FirstOrDefault();
productQty = item.Qty;
productPx = productincart.Price;
totalAmt += (productQty * productPx);
}
return(Ok(totalAmt));
}
public ActionResult RemoveItemFromCart()
{
int itemId = Convert.ToInt32(Request.QueryString["itemId"].ToString());
int res_id = Convert.ToInt32(Session["res_id"].ToString());
checkout.resProducts = quenchData.getTopProduects(res_id);
if (Session["cartlist"] != null)
{
cartlist = (List <CartDetails>)Session["cartlist"];
CartDetails cartItem = cartlist.Find(x => x.productId == itemId);
cartlist.Remove(cartItem);
checkout.cartList = cartlist;
checkout.cartTotal = cartlist.Sum(x => x.disCountPrice);
Session["cartlist"] = cartlist;
Session["cart"] = Convert.ToInt32(Session["cart"]) - 1;
}
return(View("cart", checkout));
}
