private void btnDelete_Click(object sender, EventArgs e) { if (txtIMGid.Text.Equals("")) { picImage.Image = null; } else { if (ComImgBC.Equals("Company Image")) { int delImage = ClassManagment.deleteComImage(int.Parse(txtIMGid.Text)); dt = ClassManagment.selectAllIMGOneCompany(int.Parse(ComID)); } else if (ComImgBC.Equals("Business Card")) { int delImage = ClassManagment.DeleteBCCompany(int.Parse(txtIMGid.Text)); dt = ClassManagment.selectAllComBCImage(int.Parse(ComID)); } MessageBox.Show("Done . ."); txtIMGid.Text = ""; picImage.Image = null; } numOfImag = dt.Rows.Count; btnFirstIMG_Click(null, null); }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtIMGid.Text.Equals("") && picImage.Image != null) { if (ComImgBC.Equals("Company Image")) { int addIMG = ClassSetting.sp_AddcompanyIMG(arr, int.Parse(ComID)); dt = ClassManagment.selectAllIMGOneCompany(int.Parse(ComID)); } else if (ComImgBC.Equals("Business Card")) { int addBC = ClassSetting.sp_AddcompanyBCard(arr, int.Parse(ComID)); dt = ClassManagment.selectAllComBCImage(int.Parse(ComID)); } MessageBox.Show("Done . ."); numOfImag = dt.Rows.Count; btnFirstIMG_Click(null, null); } } catch (Exception) { } }
public FRM_Com_Image(string s) { InitializeComponent(); ComID = s; if (ComImgBC.Equals("Company Image")) { dt = ClassManagment.selectAllIMGOneCompany(int.Parse(s)); } else if (ComImgBC.Equals("Business Card")) { dt = ClassManagment.selectAllComBCImage(int.Parse(ComID)); } 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 !!!"); } }