public LineItem ToLineItem(TblCartItem item)
{
VariantService variantService = new VariantService();
LineItem lineItem = new LineItem();
lineItem.Quantity = item.NumberVariant;
lineItem.Price = item.Variant.VariantPrice == null ? 0 : item.Variant.VariantPrice.Value;
lineItem.ProductID = item.Variant.ProductID;
lineItem.SKU = item.Variant.VariantSKU;
lineItem.ProductName = item.Variant.Product == null ? "" : item.Variant.Product.ProductName;
lineItem.VariantID = item.VariantID;
lineItem.OrderID = item.OrderID;
lineItem.ShippingStatus = null;
List <Variant> variantsOfProduct = variantService.GetByProductID(item.Variant.ProductID);
if (variantsOfProduct != null && variantsOfProduct.Count > 0)
{
if (variantsOfProduct.Count == 1 && variantsOfProduct[0].Option1 == "Default Title")
{
lineItem.VariantName = "Default Title";
}
else
{
lineItem.VariantName = item.Variant.VariantTittle;
}
}
return(lineItem);
}
public int addVariantToCart(int variantID, int numberVariant)
{
try
{
string cookieID = retrieveCookie();
TblCart cart = cartService.GetByCookieID(cookieID);
if (cart == null)
{
cart = new TblCart();
cart.CookieID = cookieID;
cart.CreatedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
cart.CartID = cartService.Insert(cart);
}
cart.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
Variant variant = variantService.GetByPrimaryKey(variantID);
if (variant != null)
{
string where = string.Format("CartID={0} and VariantID={1}", cart.CartID, variantID);
List <TblCartItem> cartItems = cartItemService.GetByWhere(where);
if (cartItems == null || cartItems.Count == 0)
{
TblCartItem cartItem = new TblCartItem();
cartItem.CartID = cart.CartID;
cartItem.VariantID = variantID;
cartItem.NumberVariant = numberVariant;
cartItem.CreatedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
cartItemService.Insert(cartItem);
}
else
{
cartItems[0].NumberVariant++;
cartItemService.Update(cartItems[0]);
}
cartService.UpdateTotalPrice(cart.CartID);
cartItems = cartItemService.GetByCartID(cart.CartID);
if (cartItems != null)
{
return(cartItems.Count);
}
}
return(0);
}
catch (Exception ex)
{
LogService.WriteException(ex);
throw;
}
}
public TblCartItem GetByPrimaryKey(int cartItemID)
{
try
{
string query = "select * from TblCartItem where CartItemID = " + SNumber.ToNumber(cartItemID);
TblCartItem cart = connect.Query <TblCartItem>(query).FirstOrDefault <TblCartItem>();
return(cart);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public bool Update(TblCartItem cart)
{
try
{
string query = "update TblCartItem set VariantID=@VariantID,NumberVariant=@NumberVariant,ModifiedDateTime=@ModifiedDateTime,CartID=@CartID" +
" where CartItemID=@CartItemID ";
return(0 < connect.Execute(query, new
{
cart.VariantID,
cart.NumberVariant,
cart.ModifiedDateTime,
cart.CartID,
cart.CartItemID
}));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public int Insert(TblCartItem cartItem)
{
try
{
string query = "insert into TblCartItem (VariantID,NumberVariant,CreatedDateTime,CartID)" +
" values (@VariantID,@NumberVariant,@CreatedDateTime,@CartID)" +
" SELECT @@IDENTITY";
int productID = connect.Query <int>(query, new
{
cartItem.VariantID,
cartItem.NumberVariant,
cartItem.CreatedDateTime,
cartItem.CartID
}).Single();
return(productID);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public string Remove()
{
int cartid = int.Parse(Request["cart_id"]);
int deviceid = int.Parse(Request["device_id"]);
int amount = int.Parse(Request["amount"]);
TblCartItem usersItem = null;
foreach (TblCartItem item in storeDB.TblCartItems)
{
if (item.CartId == cartid && item.DeviceId == deviceid)
{
usersItem = item;
break;
}
}
string response_amount = "";
if (usersItem.Amount > amount)
{
usersItem.Amount -= amount;
response_amount = "" + usersItem.Amount;
storeDB.SaveChanges();
}
else
{
storeDB.TblCarts.Find(cartid).TblCartItems.Remove(usersItem);
storeDB.TblCartItems.Remove(usersItem);
storeDB.SaveChanges();
response_amount = "0";
}
storeDB.TblDevices.Find(deviceid).Quantity += amount;
storeDB.SaveChanges();
return(response_amount);
}
public ActionResult removeCartItem(int id)
{
try
{
TblCartItem cartItem = cartItemService.GetByPrimaryKey(id);
if (cartItem != null)
{
TblCart cart = cartService.GetByPrimaryKey(cartItem.CartID);
if (cart != null)
{
cartItemService.DeleteByPrimary(id);
cartService.UpdateTotalPrice(cart.CartID);
return(RedirectToAction("index", new { message = "delete1" }));
}
}
return(RedirectToAction("index", new { message = "delete0" }));
}
catch (Exception ex)
{
LogService.WriteException(ex);
throw;
}
}
public string Add()
{
int id = int.Parse(Request["id"]);
int amount = int.Parse(Request["amount"]);
TblCart usersCart = null;
foreach (TblCart cart in storeDB.TblCarts)
{
if (cart.UserId == (Session["user"] as TblUser).UserId)
{
usersCart = cart;
break;
}
}
if (usersCart == null)
{
usersCart = new TblCart();
usersCart.UserId = (Session["user"] as TblUser).UserId;
storeDB.TblCarts.Add(usersCart);
storeDB.SaveChanges();
}
TblCartItem usersCartItem = null;
foreach (TblCartItem item in usersCart.TblCartItems)
{
if (item.DeviceId == id)
{
usersCartItem = item;
break;
}
}
if (usersCartItem == null)
{
usersCartItem = new TblCartItem();
usersCartItem.DeviceId = id;
usersCartItem.Amount = amount;
usersCartItem.CartId = usersCart.CartId;
usersCart.TblCartItems.Add(usersCartItem);
storeDB.SaveChanges();
}
else
{
usersCartItem.Amount += amount;
storeDB.SaveChanges();
}
string response_amount = "";
foreach (TblDevice device in storeDB.TblDevices)
{
if (device.DeviceId == id)
{
device.Quantity -= amount;
response_amount = "" + device.Quantity;
break;
}
}
storeDB.SaveChanges();
return(response_amount);
}
