uiCartView.cs

using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;

namespace Shoppa
{
    public partial class uiCartView : UserControl
    {
        private SQL_Services mySqlServices = new SQL_Services();
        private string AccountID;
        private frmPayment frmPayment;

        public uiCartView()
        {
            InitializeComponent();
        }

        public void Initialize(string AccountID)
        {
            this.AccountID = AccountID;
            mySqlServices.AddParamater("@AccountID", AccountID);
            Load();
        }

        private void Cart_Checkout()
        {
            int total = 0;
            foreach (pnCartItem cartItem in flowLayoutPanel1.Controls)
            {
                int price = cartItem.Get_Price;
                int quantity = cartItem.Get_Quantity;
                int subtotal = price * quantity;
                total += subtotal;
            }

            lbPayment.Text = "Tổng: " + total.ToString("N0") + "₫";
        }

        private void Load()
        {
            flowLayoutPanel1.Controls.Clear();
            mySqlServices.GetCartID();
            DataTable dataTable = mySqlServices.ExecuteQueryTable("SELECT OrderDetail.ProductID, ProductName, Price, ProductImage, Quantity, QuantityInStock FROM OrderDetail\r\nJOIN Products ON Products.ProductID = OrderDetail.ProductID\r\nJOIN Orders ON Orders.OrderID = OrderDetail.OrderID\r\nWHERE Orders.OrderID = @CartID");

            if (dataTable.Rows.Count != 0)
            {
                foreach (DataRow row in dataTable.Rows)
                {
                    pnCartItem cartItem = new pnCartItem();

                    cartItem.Set_ProductID = row[0].ToString();
                    cartItem.Set_ProductName = row[1].ToString();
                    cartItem.Set_Price = row[2].ToString();
                    cartItem.Set_ProductImage = row[3].ToString();
                    cartItem.Set_Quantity = row[4].ToString();
                    cartItem.Set_QuantityInStock = row[5].ToString();
                    cartItem.QuantityChanged += cartItem_QuantityChanged;
                    cartItem.ClickOnDelete += cartItem_ClickOnDelete;

                    flowLayoutPanel1.Controls.Add(cartItem);
                }
            }
            Cart_Checkout();
        }

        private void cartItem_ClickOnDelete(object sender, string ProductID)
        {
            mySqlServices.AddParamater("@ProductID", ProductID);
            mySqlServices.ExecuteNonQuery("DELETE FROM OrderDetail\r\nWHERE OrderID = @CartID AND ProductID = @ProductID");
            pnCartItem cartItem = (pnCartItem)sender;
            flowLayoutPanel1.Controls.Remove(cartItem);
            Cart_Checkout();
        }

        private void cartItem_QuantityChanged(object sender, Tuple<string, string> e)
        {
            mySqlServices.AddParamater("@ProductID", e.Item1);
            mySqlServices.AddParamater("@Quantity", e.Item2);
            mySqlServices.ExecuteNonQuery("UPDATE OrderDetail\r\nSET Quantity = @Quantity\r\nWHERE OrderID = @CartID AND ProductID = @ProductID");
            Cart_Checkout();
        }

        private void btnPayment_Click(object sender, EventArgs e)
        {
            frmPayment = new frmPayment();
            frmPayment.Initialize(AccountID);
            frmPayment.ShowDialog();
            Load();
        }

        private void uiCartView_SizeChanged(object sender, EventArgs e)
        {
            btnPayment.Location = new Point(this.Size.Width - 216, btnPayment.Location.Y);
            flowLayoutPanel1.Size = new Size(this.Width, this.Height - 74);
        }
    }
}