public List <Product> MagazineLoader() ///dergilerin listesi, yuklemesi yapilir { List <Product> magazinelist = new List <Product>(); db.connection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM [dbo].[MAGAZINE]", connection); SqlDataReader reader = command.ExecuteReader(); Magazine mg; while (reader.Read()) { mg = new Magazine(); mg.ProductID = (int)reader["ID"]; mg.name = (string)reader["NAME"]; mg.Description = (string)reader["DESCRIPTION"]; mg.Issue = "Issue: " + reader["ISSUE"]; mg.price = Convert.ToDouble(reader["PRICE"]); mg.Sale = Convert.ToDouble(reader["SALE"]); mg.Category = (string)reader["TYPE"]; if (mg.Sale <= 0 || mg.Sale >= 100) { mg.discountedPrice = mg.price; } else { mg.discountedPrice = mg.price - (mg.price * mg.Sale) / 100; } try { mg.image = Image.FromFile(Application.StartupPath + @"\Resources\MagazinePictures\" + (string)reader["IMAGEDEST"] + ".png"); } catch (Exception) { mg.image = Properties.Resources.dasdas; } magazinelist.Add(mg); } db.connection.Close(); return(magazinelist); }
public MagazinePanel(Magazine item) ///sergilenen tum dergileri belirli bir standartta sergilemek icin olusturulan paneldir { magazine = item; this.BackColor = Color.Transparent; this.Size = new Size(350, 190); this.BorderStyle = BorderStyle.FixedSingle; picBox = new PictureBox(); picBox.Size = new Size(105, 160); picBox.BackgroundImage = item.image; picBox.BackgroundImageLayout = ImageLayout.Zoom; magnifier = new PictureBox(); magnifier.Size = new Size(32, 32); magnifier.BackgroundImage = Properties.Resources.magnifier; magnifier.BackgroundImageLayout = ImageLayout.Zoom; magnifier.Cursor = Cursors.Hand; magnifier.Click += new EventHandler(magnifierClick); picAdd = new PictureBox(); picAdd.Size = new Size(32, 32); picAdd.BackgroundImage = Properties.Resources.cart; picAdd.BackgroundImageLayout = ImageLayout.Zoom; picAdd.Cursor = Cursors.Hand; picAdd.Click += new EventHandler(addCart); name = new Label(); name.AutoSize = true; name.Text = item.name; name.TextAlign = ContentAlignment.MiddleLeft; name.Font = new Font("Century Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(162))); this.Controls.Add(name); Issue = new Label(); Issue.AutoSize = true; Issue.Text = item.Issue; Issue.Font = new Font("Century Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(162))); this.Controls.Add(Issue); Type = new Label(); Type.AutoSize = true; Type.Text = item.Category; Type.Font = new Font("Century Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(162))); Type.ForeColor = Color.Black; this.Controls.Add(Type); Price1 = new Label(); Price1.AutoSize = true; if (item.Sale > 0 && item.Sale < 100) { Price1.Text = item.price + "TL %" + item.Sale; } else { Price1.Text = ""; } Price1.Font = new Font("Century Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(162))); Price1.ForeColor = Color.Black; this.Controls.Add(Price1); Price2 = new Label(); Price2.AutoSize = true; Price2.Text = item.discountedPrice + " TL"; Price2.Font = new Font("Century Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(162))); this.Controls.Add(Price2); this.Controls[0].Location = new Point(125, 20); /// Name label this.Controls[0].BringToFront(); this.Controls[1].Location = new Point(125, 50); /// Author label this.Controls[1].BringToFront(); this.Controls[2].Location = new Point(125, 80); /// Publisher label this.Controls[2].BringToFront(); this.Controls[3].Location = new Point(125, 110); /// Price1 label this.Controls[3].BringToFront(); this.Controls[4].Location = new Point(210, 110); /// Price2 label this.Controls[4].BringToFront(); this.Controls.Add(picBox); this.Controls[5].Location = new Point(10, 15); /// Item image this.Controls.Add(magnifier); this.Controls[6].Location = new Point(170, 140); /// Magnifier image this.Controls.Add(picAdd); this.Controls[7].Location = new Point(225, 140); /// Add to cart image }