private void eDITToolStripMenuItem_Click(object sender, EventArgs e)
{
string pro_id = contextMenuStrip1.Tag.ToString();
Inventory.ProductRow selected_row = invent.Product.FindByID(pro_id);
if (selected_row != null)
{
txtID.Text = selected_row.ID;
txtBarcode.Text = selected_row.Barcode;
txtName.Text = selected_row.Name;
cboCategory.SelectedValue = selected_row.CategoryID;
cboUnitType.SelectedValue = selected_row.UnitTypeID;
txtStockQty.Text = selected_row.StockQty.ToString();
txtStockLevel.Text = selected_row.StockLevel.ToString();
txtUnitPrice.Text = selected_row.UnitPrice.ToString();
txtDescription.Text = selected_row.Desc;
chkAvailableForSale.Checked = selected_row.IsForSale;
if (selected_row.Image != null)
{
pictureBox1.Image = ConvertBytesToImage(selected_row.Image);
}
}
Image ConvertBytesToImage(byte[] raw_img)
{
System.IO.MemoryStream memory = new System.IO.MemoryStream(raw_img);
Image img = Image.FromStream(memory);
return(img);
}
tabControl1.SelectedTab = tabPage1;
btnSave.Click -= btnSave_Click;
btnSave.Click += BtnSaveChange_Click;
}
private void BtnSaveChange_Click(object sender, EventArgs e)
{
Inventory.ProductRow row = invent.Product.FindByID(txtID.Text.Trim());
if (row != null)
{
row.Barcode = txtBarcode.Text.Trim();
row.Name = txtName.Text.Trim();
row.StockQty = Convert.ToInt32(txtStockQty.Text.Trim());
row.StockLevel = Convert.ToInt32(txtStockLevel.Text.Trim());
row.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text.Trim());
row.CategoryID = Convert.ToInt32(cboCategory.SelectedValue);
row.UnitTypeID = Convert.ToInt32(cboUnitType.SelectedValue);
row.Desc = txtDescription.Text.Trim();
row.IsForSale = chkAvailableForSale.Checked;
if (pictureBox1.Image != null)
{
row.Image = ConvertImageToBytes(pictureBox1.Image);
}
}
this.ClearForm();
btnSave.Click -= BtnSaveChange_Click;
btnSave.Click += btnSave_Click;
//
//pro_adapter.Update(invent.Product);
pro_adapter.Update(row);
}
private void dELETEToolStripMenuItem_Click(object sender, EventArgs e)
{
string pro_id = contextMenuStrip1.Tag.ToString();
Inventory.ProductRow selected_row = invent.Product.FindByID(pro_id);
if (selected_row != null)
{
selected_row.Delete();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Inventory.ProductRow row = invent.Product.NewProductRow();
row.ID = txtID.Text.Trim();
row.Barcode = txtBarcode.Text.Trim();
row.Name = txtName.Text.Trim();
row.CategoryID = Convert.ToInt32(cboCategory.SelectedValue);
row.UnitTypeID = (int)cboUnitType.SelectedValue;
row.StockQty = Convert.ToInt32(txtStockQty.Text.Trim());
row.StockLevel = Convert.ToInt32(txtStockLevel.Text.Trim());
row.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text.Trim());
row.Desc = txtDescription.Text.Trim();
row.IsForSale = chkAvailableForSale.Checked;
if (pictureBox1.Image != null)
{
row.Image = this.ConvertImageToBytes(pictureBox1.Image);
}
//
invent.Product.AddProductRow(row);
lblTotal.Text = "Total: " + invent.Product.Rows.Count;
//
this.ClearForm();
}
