public ActionResult ViewCart()
{
ViewCartModel vcm = new ViewCartModel();
ViewCartDTO vcdto = new ViewCartDTO();
Guid userId = new Guid(Session["UserID"].ToString());
vcdto = cdc.viewCart(userId);
vcm = cartMapper.Map <ViewCartDTO, ViewCartModel>(vcdto);
return(View(vcm));
}
//function to view the cart according to the user...
public ViewCartDTO viewCart(Guid userId)
{
ViewCartDTO viewcartdto = cartdatabaseobject.viewCart(userId);
double result = new double();
foreach (var i in viewcartdto.CartProduct)
{
result = result + i.SellingPrice;
}
viewcartdto.Total = result;
return(viewcartdto);
}
public void update(ViewCartDTO vcdto)
{
foreach (var iter in vcdto.CartProduct)
{
dbContext.Variant.SingleOrDefault(cad => cad.ID == iter.Variant_ID).QuantitySold += 1;
Variant vd = dbContext.Variant.Where(abc1 => abc1.ID == iter.Variant_ID).First();
Product pd = dbContext.Product.Where(ds => ds.ID == vd.ProductID).FirstOrDefault();
Category cat1 = dbContext.Category.Where(re => re.ID == pd.CategoryID).FirstOrDefault();
dbContext.Category.SingleOrDefault(c => c.ID == cat1.ID).ProductsSold += 1;
dbContext.SaveChanges();
}
}
public void addOrderProduct(Order order, ViewCartDTO vcdto)
{
foreach (var cartItem in vcdto.CartProduct)
{
OrderProduct op = new OrderProduct();
op.VariantID = cartItem.Variant_ID;
op.SellingPrice = cartItem.SellingPrice;
op.OrderID = order.ID;
op.ID = Guid.NewGuid();
op.Qty = 1;
dbContext.OrderProduct.Add(op);
dbContext.SaveChanges();
}
}
public bool AddAddress(AddressDTO od, Guid userid)
{
Guid addressid = orderDBObject.AddAddress(od, userid);
ViewCartDTO vdto = cartdatabaseobject.viewCart(userid);
CartDetailContext cdc = new CartDetailContext();
double result = new double();
foreach (var i in vdto.CartProduct)
{
result = result + i.SellingPrice;
}
vdto.Total = result;
orderDBObject.PlaceOrder(userid, vdto, addressid);
cartdatabaseobject.EmptyCart(userid);
return(true);
}
//function to display all the cart items according to the user...currently logged in ID of the User is userID
public ViewCartDTO viewCart(Guid userID)
{
ViewCartDTO viewcdto = new ViewCartDTO();
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
viewcdto.CartProduct = (from p in dbContext.Cart.Where(cdd => cdd.UserID == userID)
join vari in dbContext.Variant on p.VariantID equals vari.ID
join im in dbContext.VariantImage on vari.ID equals im.VariantID
join prod in dbContext.Product on vari.ProductID equals prod.ID
select new CartProductsDTO()
{
SellingPrice = p.SellingPrice,
ID = p.ID,
Name = prod.Name,
Url = im.ImageURL,
Variant_ID = p.VariantID
});
return(viewcdto);
}
public void PlaceOrder(Guid userid, ViewCartDTO vcdto, Guid addressid)
{
Order order = new Order();
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
order.ID = Guid.NewGuid();
categorydb.update(vcdto);
// var ab = cat.ProductsSold;
order.DeliveryAddressID = addressid;
order.TotalAmount = vcdto.Total;
order.UserID = userid;
order.OrderDate = DateTime.Now;
order.DeliveryDate = DateTime.Now.AddDays(2);
order.isCancelled = "N";
dbContext.Order.Add(order);
dbContext.SaveChanges();
categorydb.addOrderProduct(order, vcdto);
}
