//load tất cả sản phẩm trong giỏ hàng
public List <CartItemDTO> GetCartItemsByCartID(int cartID)
{
List <CartItemDTO> listCartItems = new List <CartItemDTO>();
string sql = "Select * From CartItem Where cartID = @cartID";
SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString);
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@cartID", cartID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
int productDetailID = (int)dr[1];
int quantity = (int)dr[2];
ProductDTO product = new ProductData().GetProductByProductDetailID(productDetailID);
double price = product.Price;
string color = product.Color;
string name = new ShoesData().GetShoesDetailByProductID(product.ProductId).Name;
double size = new ProductDetailData().GetSizeByProductDetailID(productDetailID);
CartItemDTO dto = new CartItemDTO {
ProductDetailId = productDetailID, Quantity = quantity, Price = (float)price, Color = color, Name = name, Size = size
};
dto.Image = new ProductImageData().GetImageByProductID(new ProductData().GetProductByProductDetailID(dto.ProductDetailId).ProductId);
listCartItems.Add(dto);
}
cnn.Close();
return(listCartItems);
}
private void DeleteCartItem(CartItemDTO cartItem)
{
string sql = "Delete From CartItem Where cartID = @cartID and productDetailID = @productDetailID";
SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString);
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@cartID", cartItem.CartId);
cmd.Parameters.AddWithValue("@productDetailID", cartItem.ProductDetailId);
cmd.ExecuteNonQuery();
}
//thêm sản phẩm mới vào giỏ hàng
public bool InsertNewItemToCart(CartItemDTO item)
{
bool result = false;
string sql = "Insert into CartItem values(@cartID, @productDetailID, @quantity)";
SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString);
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@cartID", item.CartId);
cmd.Parameters.AddWithValue("@productDetailID", item.ProductDetailId);
cmd.Parameters.AddWithValue("@quantity", item.Quantity);
if (cmd.ExecuteNonQuery() > 0)
{
result = true;
}
cnn.Close();
return(result);
}
