private void btnAdd_Click(object sender, EventArgs e)
{
ImageConverter converter = new ImageConverter();
PictureBox pbHelper = new PictureBox();
byte[] rowData;
if (pictureBox3.Image != null)
{
pbHelper.Image = pictureBox3.Image;
pbHelper.Image.Save("DecresResolution.png", System.Drawing.Imaging.ImageFormat.Png);
pbHelper.Load("DecresResolution.png");
pbHelper.Image.Save("DecresResolution.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
pbHelper.Load("DecresResolution.jpg");
rowData = (byte[])converter.ConvertTo(pbHelper.Image, typeof(byte[]));
}
else
{
rowData = null;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
MySqlParameter paraImage = new MySqlParameter();
paraImage.MySqlDbType = MySqlDbType.Blob;
paraImage.Direction = System.Data.ParameterDirection.Input;
paraImage.Value = rowData;
paraImage.ParameterName = "P_image";
string strStat = "insert into pi_documents values((select ifnull(max(b.pkid),0)+1 from pi_documents b)" +
",'فعال'" +
",sysdate()" +
"," + glb_function.glb_strUserId +
"," + strHeader_id +
",'" + txtImgDescription.Text.Trim() + "'" +
",@P_image" +
")";
int icheck = cnn.InsertDataWithBlob(strStat, paraImage, null, null);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء ادخال المستند");
return;
}
cnn.glb_commitTransaction();
pbHelper.Dispose();
pbHelper = null;
txtImgDescription.Text = "";
pictureBox3.Image = null;
GetData();
}