private void dgvProduct_Click(object sender, EventArgs e)
{
try
{
dt = ClassManagmentReport.displayAllIMGForPro(int.Parse(dgvProduct.CurrentRow.Cells[0].Value.ToString()));
byte[] arr = (byte[])(dt.Rows[0][1]);
MemoryStream ms = new MemoryStream(arr);
pic1.Image = Image.FromStream(ms);
}
catch (Exception) { pic1.Image = null; }
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassProduct.insertIMG(arr, int.Parse(ProID));
dt = ClassManagmentReport.displayAllIMGForPro(int.Parse(ProID));
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtIMGid.Text.Equals(""))
{
picImage.Image = null;
}
else
{
int delImage = ClassManagmentReport.deleteIMG(int.Parse(txtIMGid.Text));
dt = ClassManagmentReport.displayAllIMGForPro(int.Parse(ProID));
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
public FRM_UpdateProduct(string s)
{
InitializeComponent();
ProID = int.Parse(s);
DataTable dt = ClassManagmentReport.selectOneProID(int.Parse(s));
txtname.Text = dt.Rows[0][1].ToString();
txtbarcode.Text = dt.Rows[0][2].ToString();
txtCategory.Text = dt.Rows[0][3].ToString();
txtCountry.Text = dt.Rows[0][4].ToString();
txtcity.Text = dt.Rows[0][5].ToString();
txtCompany.Text = dt.Rows[0][6].ToString();
//txtcost.Text = dt.Rows[0][7].ToString();
//txtgroup.Text = dt.Rows[0][8].ToString();
//txtone.Text = dt.Rows[0][9].ToString();
rtxtdiscrp.Text = dt.Rows[0][10].ToString();
rtxtnote.Text = dt.Rows[0][11].ToString();
}
public Frm_ProductImage(string s, string rep)
{
InitializeComponent();
ProID = s;
if (rep.Equals("Normal"))
{
btnExport.Visible = btnSave.Visible = btnSelectOne.Visible = btnDelete.Visible = false;
}
dt = ClassManagmentReport.displayAllIMGForPro(int.Parse(s));
numOfImag = dt.Rows.Count;
try
{
txtIMGid.Text = dt.Rows[0][0].ToString();
byte[] arr = (byte[])(dt.Rows[0][1]);
MemoryStream ms = new MemoryStream(arr);
picImage.Image = Image.FromStream(ms);
}
catch (Exception) { MessageBox.Show("No Image Found !!!"); }
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals(""))
{
MessageBox.Show("Please Select One By Double Click. .");
}
else
{
string proDI = txtID.Text;
DialogResult result = MessageBox.Show("Are You Sure IF You Want To Delete This Product ?", "Warnning", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (result == DialogResult.Yes)
{
int delImg = ClassManagmentReport.deleteAllIMGProduct(int.Parse(proDI));
int delPro = ClassManagmentReport.deletePro(int.Parse(proDI));
txtID.Text = txtName.Text = txtBarcode.Text = "";
displayPro();
MessageBox.Show("Done ...");
}
else
{
return;
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Please insert product name .");
}
else
{
DataTable ProName = ClassProduct.selectOnePro(txtbarcode.Text);
if (ProName.Rows.Count > 0 && !ProName.Rows[0][0].ToString().Equals(ProID.ToString()))
{
found = 1; MessageBox.Show("This Product or Barcode Already Exist . .");
}
}
if (found == 0)
{
int i = ClassManagmentReport.updatePro(ProID, txtname.Text, txtbarcode.Text, txtCategory.Text, txtCountry.Text, txtcity.Text, txtCompany.Text, "0", "0", "0", rtxtdiscrp.Text, rtxtnote.Text);
txtname.Text = txtbarcode.Text = txtCategory.Text = txtCountry.Text = txtcity.Text = txtCompany.Text = rtxtdiscrp.Text = rtxtnote.Text = "";
MessageBox.Show("Done. .");
}
this.Close();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvProduct.DataSource = ClassManagmentReport.searchForPro(txtSearch.Text);
}
void displayPro()
{
dgvProduct.DataSource = ClassManagmentReport.displayAllPro();
}
