private void buttonSearchProduct_Click(object sender, EventArgs e) { string[] productInformation; SearchProduct searchProd = new SearchProduct(); searchProd.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { //display product information productId = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; productInformation = filterFunc.fetchProductInformation(productId); if (productInformation != null) { textBoxProductName.Text = productInformation[1]; textBoxModel.Text = productInformation[2]; textBoxDescription.Text = productInformation[3]; textBoxBrand.Text = productInformation[4]; textBoxUnit.Text = productInformation[5]; textBoxSize.Text = productInformation[6]; textBoxColor.Text = productInformation[7]; textBoxCategory.Text = productInformation[8]; textBoxSubCategory.Text = productInformation[9]; textBoxSpecialFeature.Text = productInformation[10]; textBoxCurrentQuantity.Text = productInformation[11]; formChanges = true; } } }
private void button4_Click(object sender, EventArgs e) { SearchProduct spf = new SearchProduct(); //spf.MdiParent = this.MdiParent; spf.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { productID = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; //display product information to the input boxes conn = new SqlConnection(gd.ConString); conn.Open(); strSelect = "SELECT Product_Name, Model, Brand, Special_Feature, Description, Unit, Size, " + "Color, Sub_Category_Name, Category_Name FROM View_Product_List where ID = @productID"; cmd = new SqlCommand(strSelect, conn); cmd.Parameters.Add(new SqlParameter("productID", (object)productID)); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { textBoxProductName.Text = dr["Product_Name"].ToString(); textBoxModel.Text = dr["Model"].ToString(); textBoxBrand.Text = dr["Brand"].ToString(); textBoxSpecialFeature.Text = dr["Special_Feature"].ToString(); textBoxDescription.Text = dr["Description"].ToString(); textBoxUnit.Text = dr["Unit"].ToString(); textBoxSize.Text = dr["Size"].ToString(); textBoxColor.Text = dr["Color"].ToString(); textBoxSubCategory.Text = dr["Sub_Category_Name"].ToString(); textBoxCategory.Text = dr["Category_Name"].ToString(); formChanges = true; } dr.Close(); } conn.Close(); } else { GlobalVariables.productID = ""; } }
private void button4_Click(object sender, EventArgs e) { SearchProduct spf = new SearchProduct(); //spf.MdiParent = this.MdiParent; spf.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { productID = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; //display product information to the input boxes conn = new SqlConnection(gd.ConString); conn.Open(); strSelect = "SELECT Product_Name, Model, Brand, Special_Feature, Description, Unit, Size, " + "Color, Sub_Category_Name, Category_Name FROM View_Product_List where ID = @productID"; cmd = new SqlCommand(strSelect, conn); cmd.Parameters.Add(new SqlParameter("productID", (object)productID)); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { textBoxProductName.Text = dr["Product_Name"].ToString(); textBoxModel.Text = dr["Model"].ToString(); textBoxBrand.Text = dr["Brand"].ToString(); textBoxSpecialFeature.Text = dr["Special_Feature"].ToString(); textBoxDescription.Text = dr["Description"].ToString(); textBoxUnit.Text = dr["Unit"].ToString(); textBoxSize.Text = dr["Size"].ToString(); textBoxColor.Text = dr["Color"].ToString(); textBoxSubCategory.Text = dr["Sub_Category_Name"].ToString(); textBoxCategory.Text = dr["Category_Name"].ToString(); formChanges = true; } dr.Close(); } conn.Close(); } else { GlobalVariables.productID = ""; } }
private void button4_Click(object sender, EventArgs e) { SearchProduct spf = new SearchProduct(); //spf.MdiParent = this.MdiParent; spf.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { productID = Convert.ToInt16(GlobalVariables.productID); //display product information to the input boxes conn = new SqlConnection(gd.ConString); conn.Open(); strSelect = "SELECT Product_Name, Model, Brand, Special_Feature, Description, Unit, Size, " + "Color, Sub_Category_name, Category FROM View_Product_List where ID = @productID"; cmd = new SqlCommand(strSelect, conn); cmd.Parameters.Add(new SqlParameter("productID", (object)productID)); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { } dr.Close(); } MessageBox.Show(Convert.ToString(productID)); conn.Close(); GlobalVariables.productID = ""; } else { GlobalVariables.productID = ""; } }
private void button4_Click(object sender, EventArgs e) { SearchProduct spf = new SearchProduct(); //spf.MdiParent = this.MdiParent; spf.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { productID = Convert.ToInt16(GlobalVariables.productID); //display product information to the input boxes conn = new SqlConnection(gd.ConString); conn.Open(); strSelect = "SELECT Product_Name, Model, Brand, Special_Feature, Description, Unit, Size, " + "Color, Sub_Category_name, Category FROM View_Product_List where ID = @productID"; cmd = new SqlCommand(strSelect, conn); cmd.Parameters.Add(new SqlParameter("productID", (object)productID)); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { } dr.Close(); } MessageBox.Show(Convert.ToString(productID)); conn.Close(); GlobalVariables.productID = ""; } else { GlobalVariables.productID = ""; } }
private void buttonSearchProduct_Click(object sender, EventArgs e) { string[] productInformation; SearchProduct search = new SearchProduct(); search.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { //display product information productId = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; productInformation = filter.fetchProductInformation(productId); if (productInformation != null) { textBoxProductName.Text = productInformation[1]; textBoxModel.Text = productInformation[2]; textBoxDescription.Text = productInformation[3]; textBoxBrand.Text = productInformation[4]; textBoxUnit.Text = productInformation[5]; textBoxSize.Text = productInformation[6]; textBoxColor.Text = productInformation[7]; textBoxCategory.Text = productInformation[8]; textBoxSubCategory.Text = productInformation[9]; textBoxSpecialFeature.Text = productInformation[10]; textBoxQuantityOnHand.Text = productInformation[11]; //display current quantity on warehouse textBoxCurrentQuantity.Text = Convert.ToString(filter.fetchCurrentQuantityOnWarehouse(comboBoxWarehouse.SelectedItem.ToString(), productId)); } } else { GlobalVariables.productID = ""; } }
private void buttonSearchProduct_Click(object sender, EventArgs e) { string[] productInformation; SearchProduct search = new SearchProduct(); search.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { //display product information productId = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; productInformation = filter.fetchProductInformation(productId); if (productInformation != null) { textBoxProductName.Text = productInformation[1]; textBoxModel.Text = productInformation[2]; textBoxDescription.Text = productInformation[3]; textBoxBrand.Text = productInformation[4]; textBoxUnit.Text = productInformation[5]; textBoxSize.Text = productInformation[6]; textBoxColor.Text = productInformation[7]; textBoxCategory.Text = productInformation[8]; textBoxSubCategory.Text = productInformation[9]; textBoxSpecialFeature.Text = productInformation[10]; textBoxQuantityOnHand.Text = productInformation[11]; //display current quantity on warehouse textBoxCurrentQuantity.Text = Convert.ToString(filter.fetchCurrentQuantityOnWarehouse(comboBoxWarehouse.SelectedItem.ToString(), productId)); } } else { GlobalVariables.productID = ""; } }
private void buttonSearchProduct_Click(object sender, EventArgs e) { string[] productInformation; SearchProduct searchProd = new SearchProduct(); searchProd.ShowDialog(); if (GlobalVariables.productID != "" && GlobalVariables.productID != null) { //display product information productId = Convert.ToInt16(GlobalVariables.productID); GlobalVariables.productID = ""; productInformation = filterFunc.fetchProductInformation(productId); if (productInformation != null) { textBoxProductName.Text = productInformation[1]; textBoxModel.Text = productInformation[2]; textBoxDescription.Text = productInformation[3]; textBoxBrand.Text = productInformation[4]; textBoxUnit.Text = productInformation[5]; textBoxSize.Text = productInformation[6]; textBoxColor.Text = productInformation[7]; textBoxCategory.Text = productInformation[8]; textBoxSubCategory.Text = productInformation[9]; textBoxSpecialFeature.Text = productInformation[10]; textBoxCurrentQuantity.Text = productInformation[11]; formChanges = true; } } }