private void WritePurchases()
{
for (var i = 0; i < ShoppingCart.Instance.ItemsToPurchase.Count; i++)
{
ItemToPurchase item = new ItemToPurchase();
item = (ItemToPurchase)ShoppingCart.Instance.ItemsToPurchase[i];
SqlCommand add = new SqlCommand("insert into TBLPURCHASES (ORDERNO,PRODUCTID,QTY,NAME,PICTURE) VALUES (@P1,@P2,@P3,@P4,@P5)", Connection.connect);
if (add.Connection.State != ConnectionState.Open)
{
add.Connection.Open();
}
add.Parameters.AddWithValue("@P1", Session.Instance.OrderNo);
add.Parameters.AddWithValue("@P2", item.Product.Id);
add.Parameters.AddWithValue("@P3", item.Quantity);
add.Parameters.AddWithValue("@P4", item.Product.Name);
add.Parameters.AddWithValue("@P5", item.Product.Picture);
add.ExecuteNonQuery();
SqlCommand decrease = new SqlCommand("update TBLPRODUCT SET QUANTITY=QUANTITY-@P1 where ID=" + item.Product.Id, Connection.connect);
decrease.Parameters.AddWithValue("@P1", item.Quantity);
decrease.ExecuteNonQuery();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
int found = 0;
if (item.Product.Name != "")
{
ItemToPurchase itemtoadd = new ItemToPurchase();
itemtoadd.Product = item.Product;
itemtoadd.Quantity = item.Quantity;
for (var i = 0; i < Classes.ShoppingCart.Instance.ItemsToPurchase.Count; i++)
{
Classes.ItemToPurchase listitem = new Classes.ItemToPurchase();
listitem = (Classes.ItemToPurchase)Classes.ShoppingCart.Instance.ItemsToPurchase[i];
if (listitem.Product.Id == itemtoadd.Product.Id)
{
listitem.Quantity += itemtoadd.Quantity;
item.Quantity = 1;
found = 1;
lblQty.Text = item.Quantity.ToString();
lblPrice.Text = "€" + (item.Quantity * item.Product.Price).ToString("0.00");
break;
}
}
if (found == 0)
{
ShoppingCart.Instance.AddProduct(itemtoadd);
item.Quantity = 1;
lblQty.Text = item.Quantity.ToString();
lblPrice.Text = "€" + (item.Quantity * item.Product.Price).ToString("0.00");
}
Alert.Create("Item Added To Cart", Alert.Type.Added);
}
}
catch (Exception) { };
}
private void LoadItems(bool clear = false)
{
if (clear)
{
pnlCart.Controls.Clear();
}
for (var i = 0; i < ShoppingCart.Instance.ItemsToPurchase.Count; i++)
{
ItemToPurchase item = (ItemToPurchase)ShoppingCart.Instance.ItemsToPurchase[i];
item = (ItemToPurchase)ShoppingCart.Instance.ItemsToPurchase[i];
Panel panel = new Panel
{
BackColor = Color.RoyalBlue,
Location = new Point(50, 50 + i * 150),
Name = "product-" + item.Product.Id.ToString(),
Size = new Size(1300, 100),
Dock = DockStyle.Top
};
PictureBox productPicture = new PictureBox
{
Anchor = AnchorStyles.None,
Location = new Point(330, 3),
Name = "productPicture-" + item.Product.Id.ToString(),
Image = Utils.Base64StringToBitmap(item.Product.Picture),
SizeMode = PictureBoxSizeMode.StretchImage,
Size = new Size(55, 60),
TabIndex = 0,
TabStop = false
};
Label productName = new Label
{
Anchor = AnchorStyles.None,
AutoSize = true,
Font = new Font("Century Gothic", 15.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))),
Location = new Point(463, 24),
MaximumSize = new Size(400, 0),
Name = "productName-" + item.Product.Id.ToString(),
Size = new Size(179, 24),
TabIndex = 2,
Text = item.Product.Name.ToString(),
ForeColor = Color.White
};
Label productPrice = new Label
{
Anchor = AnchorStyles.None,
AutoSize = true,
Font = new Font("Century Gothic", 15.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))),
Location = new Point(1000, 24),
Name = "productPrice-" + item.Product.Id.ToString(),
Size = new Size(83, 24),
TabIndex = 3,
Text = "€" + item.Product.Price.ToString("0.00"),
ForeColor = Color.White
};
Label productQuantity = new Label
{
Anchor = AnchorStyles.None,
AutoSize = true,
Font = new Font("Century Gothic", 15.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))),
Location = new Point(229, 24),
Name = "productQuantity-" + item.Product.Id.ToString(),
Size = new Size(22, 24),
TabIndex = 5,
Text = item.Quantity.ToString(),
ForeColor = Color.White
};
Button btnDelete = new Button
{
Cursor = Cursors.Hand,
Dock = DockStyle.Left,
FlatStyle = FlatStyle.Flat,
Font = new Font("Century Gothic", 12F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0))),
ForeColor = Color.White,
Image = Resources.trash,
Location = new Point(0, 0),
Name = "btnDelete-" + item.Product.Id.ToString(),
Size = new Size(51, 75),
TabIndex = 4,
TextImageRelation = TextImageRelation.ImageBeforeText,
UseVisualStyleBackColor = true
};
btnDelete.FlatAppearance.BorderSize = 0;
btnDelete.FlatAppearance.MouseOverBackColor = Color.Red;
btnDelete.Click += btnDelete_Click;
panel.Controls.Add(productPicture);
panel.Controls.Add(productName);
panel.Controls.Add(productPrice);
panel.Controls.Add(productQuantity);
panel.Controls.Add(btnDelete);
pnlCart.Controls.Add(panel);
}
pnlCart.Controls.Add(pnlHeaders);
pnlHeaders.Dock = DockStyle.Top;
lblTotal.Text = "€" + (ShoppingCart.Instance.PaymentAmount).ToString("0.00");
}
