private void FrmMorbiditySupplyForecastAdj_Load(object sender, EventArgs e) { p = new ProductQuantityInStock(_forecast); p.Dock = DockStyle.Fill; this.panel1.Controls.Add(p); }
private void btnPrint_Click(object sender, EventArgs e) { //variables; string ProductName; string ProductType; int ProductQuantityInStock; decimal ProductPrice; SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString); sqlcon.Open(); string cmd = "Select ProductName, ProductType, ProductQuantityInStock, ProductPrice FROM Products"; SqlCommand sqlcom = new SqlCommand(cmd, sqlcon); SqlDataReader reader; reader = sqlcom.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ProductName = (reader["ProductName"].ToString()); ProductType = (reader["ProductType"].ToString()); ProductQuantityInStock = Convert.ToInt32((reader["ProductQuantityInStock"])); ProductPrice = Convert.ToDecimal((reader["ProductPrice"])); Details += "\n" + "Product Name:" + " " + ProductName + "\n" + "Product Type:" + " " + ProductType + "\n" + "Quantity in Stock:" + " " + ProductQuantityInStock.ToString() + "\n" + "Price:" + " " + ProductPrice.ToString() + "\n"; } } reader.Close(); sqlcon.Close(); SqlConnection sqlcon2 = new SqlConnection(Globals_Class.ConnectionString); sqlcon2.Open(); string cmd2 = "SELECT SUM(ProductQuantityInStock) as Total FROM Products;"; SqlCommand sqlcom2 = new SqlCommand(cmd2, sqlcon2); SqlDataReader dr; dr = sqlcom2.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { TotalQinStock = Convert.ToInt32((dr["Total"])); } } dr.Close(); sqlcon2.Close(); documentWriter(); }