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
}
