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;
}
