private void btnAddProduct_Click(object sender, EventArgs e)
{
if (state == "add")
{
MemoryStream ms = new MemoryStream();
pictureBoxProduct.Image.Save(ms, pictureBoxProduct.Image.RawFormat);
byte[] byteImage = ms.ToArray();
int CAT_ID = Convert.ToInt32(cmbCategories.SelectedValue);
int xQty = Convert.ToInt32(txtProductQty.Text);
prd.ADD_PRODUCT(CAT_ID, txtDescription.Text, txtRef.Text, xQty, txtProductPrice.Text, byteImage);
MessageBox.Show("Product Added Successfully", "Add Product", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MemoryStream ms = new MemoryStream();
pictureBoxProduct.Image.Save(ms, pictureBoxProduct.Image.RawFormat);
byte[] byteImage = ms.ToArray();
int CAT_ID = Convert.ToInt32(cmbCategories.SelectedValue);
int xQty = Convert.ToInt32(txtProductQty.Text);
prd.UpdateProduct(CAT_ID, txtDescription.Text, txtRef.Text, xQty, txtProductPrice.Text, byteImage);
MessageBox.Show("Product Updated Successfully", "Edit Product", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
FRM_PRODUCTS.getMainForm.dataGridView1.DataSource = prd.GetAllProducts();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (state == "add")
{
MemoryStream ms = new MemoryStream();
pbox.Image.Save(ms, pbox.Image.RawFormat);
byte[] byteImage = ms.ToArray();
prd.ADD_PRODUCT(Convert.ToInt32(cmbCategories.SelectedValue), txtDes.Text
, txtRef.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
MessageBox.Show("تمت الإضافة بنجاح", "عملية الإضافة", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MemoryStream ms = new MemoryStream();
pbox.Image.Save(ms, pbox.Image.RawFormat);
byte[] byteImage = ms.ToArray();
prd.UPDATE_PRODUCT(Convert.ToInt32(cmbCategories.SelectedValue), txtDes.Text
, txtRef.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
MessageBox.Show("تم التعديل بنجاح", "عملية التعديل", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
FRM_PRODUCTS.getMainForm.dataGridView1.DataSource = prd.GET_ALL_PRODUCTS();
}
private void btn_SAVE_PRODUCT_Click(object sender, EventArgs e)
{
var EXPIRE_DATE = dateTimePicker_EXPIREDATE.Value;
if (CheckInputs())
{
if (stat == "add")
{
MemoryStream ms = new MemoryStream();
pictureBox_PRODUCTS.Image.Save(ms, pictureBox_PRODUCTS.Image.RawFormat);
byte[] ImageByte = ms.ToArray();
prd.ADD_PRODUCT(int.Parse(ID_PRODUCT.Text), int.Parse(comboBox_CATEGORIES.SelectedValue.ToString()), textBox_BARCODE.Text, textBox_LABEL.Text, ImageByte, EXPIRE_DATE);
MessageBox.Show("تمت عملية الحفظ بنجاح", "SAVE");
Clear_Function();
}
else
{
MemoryStream ms = new MemoryStream();
pictureBox_PRODUCTS.Image.Save(ms, pictureBox_PRODUCTS.Image.RawFormat);
byte[] ImageByte = ms.ToArray();
prd.UPDATE_PRODCUT(int.Parse(comboBox_CATEGORIES.SelectedValue.ToString()), textBox_BARCODE.Text, textBox_LABEL.Text, ImageByte, ID_PRODUCT.Text, EXPIRE_DATE);
MessageBox.Show("تمت عملية التعديل بنجاح", "UPDATE");
FORM_MNG_PRODUCTS.getMainForm.GridControl_PRODUCTS.DataSource = prd.GET_ALL_PRODUCTS();
this.Close();
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (state == "add")
{
if (txtDes.Text == "" || txtRef.Text == "" || txtQte.Text == "" || txtPrice.Text == "")
{
MessageBox.Show("Entrer Tous Les Information", "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
MemoryStream ms = new MemoryStream();
pbox.Image.Save(ms, pbox.Image.RawFormat);
byte[] byteImage = ms.ToArray();
prd.ADD_PRODUCT(Convert.ToInt32(cmbCategories.SelectedValue), txtDes.Text
, txtRef.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
MessageBox.Show("Ajouté Avec Succée", "L'ajout", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
byte[] byteImage;
byteImage = new byte[0];
prd.ADD_PRODUCT(Convert.ToInt32(cmbCategories.SelectedValue), txtDes.Text
, txtRef.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
MessageBox.Show("Ajouté Avec Succée", "L'ajout", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MemoryStream ms = new MemoryStream();
pbox.Image.Save(ms, pbox.Image.RawFormat);
byte[] byteImage = ms.ToArray();
prd.UPDATE_PRODUCT(Convert.ToInt32(cmbCategories.SelectedValue), txtDes.Text
, txtRef.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
MessageBox.Show("Modifié", " Modification", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
A1_form refrch = new A1_form();
refrch.button12_Click(sender, e);
}
/* private void button1_Click(object sender, EventArgs e)
* {
* OpenFileDialog OFD = new OpenFileDialog();
* OFD.Filter = "SAWIRADA |*.jpg;*.png;*.gif;*.bmp";
* if (OFD.ShowDialog() == DialogResult.OK)
* {
* pbox.Image = Image.FromFile(OFD.FileName);
* }
* }
*/
private void btnOk_Click(object sender, EventArgs e)
{
try{
if (txtCost.Text == string.Empty || txtPrice.Text == string.Empty || txtCode.Text == string.Empty)
{
MessageBox.Show("BUUXI XOGTA MUHIMKA AH", "ISKA JIR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (State == "add")
{
MemoryStream ms = new MemoryStream();
// pbox.Image.Save(ms, pbox.Image.RawFormat);
// byte[] byteImage = ms.ToArray();
// prd.ADD_PRODUCT(Convert.ToInt32(cmbcategories.SelectedValue), txtDec.Text, txtID.Text, Convert.ToInt32(txtQte.Text), txtPrice.Text, byteImage);
prd.ADD_PRODUCT(txtCode.Text, txtName.Text, txtDec.Text, txtCost.Text, txtPrice.Text, txtQte.Text, txtCat.Text);
MessageBox.Show("WAA LAGU GUULEESTAY KU DARIDA", "KU DARID", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{ /*
* MemoryStream ms = new MemoryStream();
* pbox.Image.Save(ms, pbox.Image.RawFormat);
* byte[] byteImage = ms.ToArray();*/
prd.UPDATE_PRDUCT(txtCode.Text, txtName.Text, txtDec.Text, txtCost.Text, txtPrice.Text, txtQte.Text, txtCat.Text);
MessageBox.Show("WAA LAGU GUULEESTAY BADALIDA", "BADALID", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (fl == 2)
{
FRM_PRODUCTS.getMainForm.dataGridView1.DataSource = prd.GET_ALL_PRODUCTS();
}
clearData();
}
catch
{
return;
}
}
private void ok_Click(object sender, EventArgs e)
{
if (state == "add")
{
if (txtref.Text == string.Empty)
{
MessageBox.Show("يرجي التاكد من كتابه اسم الصنف ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtdes.Text == string.Empty)
{
MessageBox.Show("يرجي التاكد من كتابه وصف الصنف ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtqte.Text == string.Empty)
{
MessageBox.Show("يرجي التاكد من كتابه كميه الصنف الموجوده ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtprice.Text == string.Empty)
{
MessageBox.Show("يرجي التاكد من كتابه سعر الصنف الحالي ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
byte[] byteImage;
if (pictureBox1.Image == null)
{
byteImage = new byte[0];
prd.ADD_PRODUCT(
Convert.ToInt32(cmbcategories.SelectedValue)
, txtdes.Text
, txtref.Text
, txtqte.Text
, txtprice.Text
, byteImage
, "withoutimage");
MessageBox.Show("تمت الاضافه بنجاح", "عمليه الاضافه", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byteImage = ms.ToArray();
prd.ADD_PRODUCT(
Convert.ToInt32(cmbcategories.SelectedValue)
, txtdes.Text
, txtref.Text
, txtqte.Text
, txtprice.Text
, byteImage
, "withimage");
MessageBox.Show("تمت الاضافه بنجاح", "عمليه الاضافه", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (txtdes.Text == string.Empty || txtprice.Text == string.Empty || txtqte.Text == string.Empty || txtref.Text == string.Empty)
{
MessageBox.Show("ينبغي تسجيل المعلومات المطلوبه ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
byte[] byteImage;
if (pictureBox1.Image == null)
{
byteImage = new byte[0];
prd.UPDATE_PRODUCT(
Convert.ToInt32(cmbcategories.SelectedValue)
, txtref.Text
, txtdes.Text
, txtqte.Text
, txtprice.Text
, byteImage
, "withoutimage");
MessageBox.Show("تمت التعديل بنجاح", "عمليه التعديل", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byteImage = ms.ToArray();
prd.UPDATE_PRODUCT(
Convert.ToInt32(cmbcategories.SelectedValue)
, txtref.Text
, txtdes.Text
, txtqte.Text
, txtprice.Text
, byteImage
, "withimage");
MessageBox.Show("تمت التعديل بنجاح", "عمليه التعديل", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
txtref.Clear();
txtqte.Clear();
txtdes.Clear();
txtprice.Clear();
pictureBox1.Image = null;
txtref.Focus();
FRM_PRODUCTS.getmainform.dataGridView1.DataSource = prd.GET_ALL_PRODUCT();
}
private void btnAddProd_Click(object sender, EventArgs e)
{
if (
String.IsNullOrEmpty(txtPName.Text) ||
String.IsNullOrEmpty(txtPPrice.Text) ||
String.IsNullOrEmpty(txtPQuant.Text) ||
String.IsNullOrEmpty(txtSELL_PRICE.Text) ||
String.IsNullOrEmpty(txtProdCode.Text)
)
{
MessageBox.Show("رجاء اضافة كل الحقول");
}
else
{
//MessageBox.Show("now can ADD or update ");
if (form_state == "add")
{
DataTable Dt = new DataTable();
Dt = prod.CHECK_IS_PRODUCT_TYPE(Convert.ToString(txtPName.Text), Convert.ToString(txtProdCode.Text), is_item_inner_add_prod);
if (Dt.Rows.Count > 0)
{
MessageBox.Show(" المنتج موجود...");
}
else
{
DataTable nameDt = new DataTable();
nameDt = prod.CHECK_IS_PRODUCT_TYPE_AND_NAME(Convert.ToString(txtPName.Text), is_item_inner_add_prod);
if (nameDt.Rows.Count > 0)
{
MessageBox.Show(" اسم الصنف موجود");
txtPName.Focus();
txtPName.SelectionStart = 0;
txtPName.SelectionLength = txtPName.TextLength;
}
else
{
DataTable codeDt = new DataTable();
codeDt = prod.CHECK_IS_PRODUCT_TYPE_AND_CODE(Convert.ToString(txtProdCode.Text), is_item_inner_add_prod);
if (codeDt.Rows.Count > 0)
{
MessageBox.Show("كود الصنف موجود");
txtProdCode.Focus();
txtProdCode.SelectionStart = 0;
txtProdCode.SelectionLength = txtProdCode.TextLength;
}
else
{
// add product method
prod.ADD_PRODUCT(
Convert.ToString(txtPName.Text), //name
Convert.ToDouble(txtPPrice.Text), // price
Convert.ToDouble(txtSELL_PRICE.Text), //s_price
Convert.ToInt32(txtPQuant.Text), // quantatiy
Convert.ToString(txtDesk.Text), // deskreption
Convert.ToString(txtProdCode.Text), // barcode
Convert.ToInt32(comCategory.SelectedValue), // category id
Convert.ToBoolean(rdoBTN_INNER.Checked) // boolean value
);
this.Close();
MessageBox.Show("تمت اضافه الصنف بنجاح....");
DASHBOARD.getDASHBOARD.dataGridViewProdsStats.DataSource = prod.GET_PRODUCTS_STATISTICS();
DASHBOARD.getDASHBOARD.is_item_inner = Convert.ToBoolean(rdoBTN_INNER.Checked);
DASHBOARD.getDASHBOARD.dataGridViewPROD.DataSource = prod.GET_ALL_PRODUCTS(is_item_inner_add_prod);
} // end of CHECK_IS_PRODUCT_TYPE_AND_CODE
} // end of CHECK_IS_PRODUCT_TYPE_AND_NAME
} // end of CHECK_IS_PRODUCT_TYPE
}
else
{
DataTable nameDt = new DataTable();
nameDt = prod.CHECK_IS_PRODUCT_TYPE_AND_NAME(Convert.ToString(txtPName.Text), is_item_inner_add_prod);
if (nameDt.Rows.Count > 0 && product_id != 0 && Convert.ToUInt32(nameDt.Rows[0][0]) != product_id)
{
MessageBox.Show(" اسم الصنف موجود");
txtPName.Focus();
txtPName.SelectionStart = 0;
txtPName.SelectionLength = txtPName.TextLength;
}
else
{
DataTable codeDt = new DataTable();
codeDt = prod.CHECK_IS_PRODUCT_TYPE_AND_CODE(Convert.ToString(txtProdCode.Text), is_item_inner_add_prod);
if (codeDt.Rows.Count > 0 && product_id != 0 && Convert.ToUInt32(codeDt.Rows[0][0]) != product_id)
{
MessageBox.Show("كود الصنف موجود");
txtProdCode.Focus();
txtProdCode.SelectionStart = 0;
txtProdCode.SelectionLength = txtProdCode.TextLength;
}
else
{
prod.UPDATE_PRODUCT(
Convert.ToInt32(product_id),
Convert.ToString(txtPName.Text),
Convert.ToDouble(txtPPrice.Text),
Convert.ToDouble(txtSELL_PRICE.Text),
Convert.ToInt32(txtPQuant.Text),
Convert.ToString(txtDesk.Text),
Convert.ToString(txtProdCode.Text),
Convert.ToInt32(comCategory.SelectedValue),
Convert.ToBoolean(rdoBTN_INNER.Checked));
this.Close();
MessageBox.Show("تمت تعديل الصنف بنجاح....");
DASHBOARD.getDASHBOARD.dataGridViewProdsStats.DataSource = prod.GET_PRODUCTS_STATISTICS();
DASHBOARD.getDASHBOARD.is_item_inner = Convert.ToBoolean(rdoBTN_INNER.Checked);
DASHBOARD.getDASHBOARD.dataGridViewPROD.DataSource = prod.GET_ALL_PRODUCTS(is_item_inner_add_prod);
}
}
}
} // end of all txtbox have value
}
