private void btnprod_update_Click(object sender, EventArgs e) { if (validateUpdateProducts()) { Buisness_Logic.product prd = new Buisness_Logic.product(); int newq = (string.IsNullOrEmpty(txtp2Newqty.Text) ? 0 : int.Parse(txtp2Newqty.Text)) + int.Parse(txtp2_availableqty.Text); prd.name = txtp2name.Text; prd.make = txtp2_make.Text; prd.productType = cmbp2ProdType.SelectedItem.ToString(); prd.qty = newq; prd.buying_price = double.Parse(txtp2_bprice.Text); prd.selling_Price = double.Parse(txtp2_sellingprice.Text); prd.productID = int.Parse(txtp2_prodID.Text); MemoryStream ms = new MemoryStream(); picbox_editProd.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] photo_prod = ms.ToArray(); prd.photo = photo_prod; Buisness_Logic.productRepository prep = new Buisness_Logic.productRepository(); if (prep.updateProduct(prd)) { MessageBox.Show("Record update succesfull.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); txtp2_availableqty.Text = prd.qty.ToString(); } } }
private void btnprod_search_Click(object sender, EventArgs e) { if (validateProduct_search()) { Buisness_Logic.product prd = new Buisness_Logic.product(); Buisness_Logic.productRepository prp = new Buisness_Logic.productRepository(); bool x = prp.searchProduct((string.IsNullOrEmpty(txtp2_prodID.Text) ? 0 : int.Parse(txtp2_prodID.Text)), txtp2name.Text.ToString(), prd); if (x) { MessageBox.Show("Record found.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); txtp2name.Text = prd.name; txtp2_availableqty.Text = prd.qty.ToString(); txtp2_bprice.Text = prd.buying_price.ToString(); txtp2_make.Text = prd.make.ToString(); txtp2_sellingprice.Text = prd.selling_Price.ToString(); cmbp2ProdType.SelectedItem = prd.productType; txtp2_prodID.Text = prd.productID.ToString(); picbox_editProd.SizeMode = PictureBoxSizeMode.StretchImage; MemoryStream ms = new MemoryStream(prd.photo); ms.Read(prd.photo, 0, prd.photo.Length); picbox_editProd.Image = Image.FromStream(ms); } else { MessageBox.Show("No record found.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnPopulate_Click(object sender, EventArgs e) { Buisness_Logic.productRepository pr = new Buisness_Logic.productRepository(); var dt_pr = pr.searchProducts_for_dataGrid(); dataGridCART.DataSource = dt_pr; this.dataGridCART.Columns[7].Visible = false; }
private void btnprod_delete_Click(object sender, EventArgs e) { int pid; pid = int.Parse(txtp2_prodID.Text); Buisness_Logic.productRepository pa = new Buisness_Logic.productRepository(); if (pa.deleteProduct(pid)) { MessageBox.Show("Record delete succesfull.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Record deletion failed.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void mtrtil1splmnt_save_Click(object sender, EventArgs e) { try { if (validateProduct()) { Buisness_Logic.product prd = new Buisness_Logic.product(); prd.name = txtAddp_name.Text; prd.qty = int.Parse(txtadd_qty.Text); prd.make = txtAddp_make.Text; prd.buying_price = double.Parse(txtAddp_bprice.Text); prd.selling_Price = double.Parse(txtAddp_sell_price.Text); prd.productType = cmb_addproduct_type.SelectedItem.ToString(); MemoryStream ms = new MemoryStream(); picBox1_addproduct.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] pic = ms.ToArray(); prd.photo = pic; Buisness_Logic.productRepository prorep = new Buisness_Logic.productRepository(); if (prorep.save_Product(prd)) { txtAddp_ID.Text = prd.productID.ToString(); MessageBox.Show("Poduct saved.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Failed.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception expropd) { MessageBox.Show(expropd.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } }
private void salesManagement_Load(object sender, EventArgs e) { Buisness_Logic.productRepository prep = new Buisness_Logic.productRepository(); dataGridPriducts.DataSource = prep.searchProducts_for_dataGrid(); this.dataGridPriducts.Columns[7].Visible = false; }