public void addToCart(int productId, decimal unitPrice, string productName, float productWeight)
{
// Get the matching cart and product instances
if (items.Count() != 0)
{
var currentNode = items.First;
while (currentNode != null)
{
if (currentNode.Value.productId == productId)
{
currentNode.Value.count++;
currentNode.Value.setTotalPriceAndWeight();
break;
}
else
{
currentNode = currentNode.Next;
if (currentNode == null)
{
CartItem newItem = new CartItem(productId, unitPrice, productName, productWeight);
newItem.setTotalPriceAndWeight();
items.AddFirst(newItem);
break;
}
}
}
}
else
{
CartItem newItem = new CartItem(productId, unitPrice, productName, productWeight);
newItem.setTotalPriceAndWeight();
items.AddFirst(newItem);
}
}
public void completeOrderProductContent(CartItem item)
{
using (MySqlConnection con = new MySqlConnection(con_str))
{
con.Open();
using (MySqlCommand cmd = new MySqlCommand("completeOrderProduct", con))
{
cmd.CommandType = CommandType.StoredProcedure;
//Get TIMEstamp
cmd.Parameters.AddWithValue("@timeStamper", timeStamp);
//params for orderProduct
cmd.Parameters.AddWithValue("@product_productId", item.productId);
cmd.Parameters.AddWithValue("@units", item.count);
cmd.Parameters.AddWithValue("@price", item.totalPrice);
cmd.Parameters.AddWithValue("@weight", item.totalWeight);
cmd.Parameters.AddWithValue("@Shippers_shippersId", shippersId);
cmd.ExecuteNonQuery();
con.Close();
}
}
}