private void btndisplayimage_Click(object sender, EventArgs e)
{
byte[] arr = CLASSPRODUCT.SP_PRODUCTGETIMAGE(int.Parse(dgvproduct.SelectedRows[0].Cells[0].Value.ToString()));
MemoryStream ms = new MemoryStream(arr);
FRM_PRODUCTIMAGE PI = new FRM_PRODUCTIMAGE();
PI.PicImage.Image = Image.FromStream(ms);
PI.ShowDialog();
}
private void btnDelete_Click(object sender, EventArgs e)
{
id = int.Parse(dgvproduct.SelectedRows[0].Cells[0].Value.ToString());
DialogResult dr = MessageBox.Show(" هل تريد حذف المنتج المحدد", "تحذير", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
int i = CLASSPRODUCT.SP_ProducrDelete(id);
MessageBox.Show("تم الحذف بنجاح");
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
DataTable dt = CLASSPRODUCT.SP_PRODUCTSEARCH(txtSearch.Text);
dgvproduct.Rows.Clear();
foreach (DataRow dr in dt.Rows)
{
dgvproduct.Rows.Add(dr[0], dr[1], dr[2], dr[3],
dr[4], dr[5], dr[6], dr[7], dr[8], dr[9]);
}
}
private void btnSelectAll_Click(object sender, EventArgs e)
{
DataTable dt = CLASSPRODUCT.SP_PRODECUTSELECT();
// dgvproduct.DataSource = dt;//not recommanded here
dgvproduct.Rows.Clear();
foreach (DataRow dr in dt.Rows)
{
dgvproduct.Rows.Add(dr[0], dr[1], dr[2], dr[3],
dr[4], dr[5], dr[6], dr[7], dr[8], dr[9]);
}
}
public FRM_AddNewProduct(bool Isupdate)
{
InitializeComponent();
this._isupdate = Isupdate;
DataTable dtcat = CLASSPRODUCT.SP_FILLCATCMB();
cmbcatogary.DataSource = dtcat;
cmbcatogary.DisplayMember = "Cat_Name";
cmbcatogary.ValueMember = "Cat_ID";
DataTable dtam = CLASSPRODUCT.SP_FILLAMCMB();
cmbAMName.DataSource = dtam;
cmbAMName.DisplayMember = "Am_Name";
cmbAMName.ValueMember = "Am_ID";
DataTable dtsn = CLASSPRODUCT.SP_FILLSNCMB();
cmbSnName.DataSource = dtsn;
cmbSnName.DisplayMember = "Sn_Name";
cmbSnName.ValueMember = "Sn_ID";
if (_isupdate == true)
{
this.Text = "تعديل بيانات المنتج";
btnAdd.Text = "تعديل ";
DataTable dt = CLASSPRODUCT.SP_GETSELECTEDPRODUCT(FRM_ProductManagment.id);
foreach (DataRow dr in dt.Rows)
{
cmbcatogary.Text = dr["Cat_Name"].ToString();
txtproductname.Text = dr["P_Name"].ToString();
txtPDescription.Text = dr["P_Description"].ToString();
txtBuyPrice.Text = dr["buyPrice"].ToString();
txtSellPrice.Text = dr["SelPrice"].ToString();
cmbAMName.Text = dr["Am_Name"].ToString();
cmbSnName.Text = dr["Sn_Name"].ToString();
txtbarcode.Text = dr["barcode"].ToString();
byte[] arr = (byte[])dr["P_Image"];
MemoryStream ms = new MemoryStream(arr);
picProImage.Image = Image.FromStream(ms);
}
}
else
{
this.Name = "اضافة منتج جديد";
btnAdd.Name = "اضافة ";
}
}
private void btndisplayExpire_Click(object sender, EventArgs e)
{
DataTable dt = CLASSPRODUCT.SP_PRODUCTGETEXPIREDDATE(int.Parse(dgvproduct.SelectedRows[0].Cells[0].Value.ToString()));
if (dt.Rows.Count > 0)
{
FRM_ProductExPierQTY frm = new FRM_ProductExPierQTY();
frm.dgvProEXDate.DataSource = dt;
frm.ShowDialog();
}
else
{
MessageBox.Show("لا توجد صلاحيات لهذا المنتج");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
MemoryStream ms = new MemoryStream();
picProImage.Image.Save(ms, picProImage.Image.RawFormat);
byte[] arr = ms.ToArray();
if (_isupdate == false)
{
if (txtproductname.Text != "" && txtBuyPrice.Text != "" && txtSellPrice.Text != "")
{
CLASSPRODUCT.SP_ADDNEWPRODUCT(txtproductname.Text, txtPDescription.Text, arr, txtBuyPrice.Text,
txtSellPrice.Text, (int)cmbcatogary.SelectedValue, (int)cmbAMName.SelectedValue, (int)cmbSnName.SelectedValue, txtbarcode.Text);
MessageBox.Show("تمت عملية اضافة المنتج بنجاح");
}
else
{
MessageBox.Show("المعلومات المدخلة غير كافية");
return;
}
// txtbarcode.Text = txtproductname.Text = txtBuyPrice.Text = txtPDescription.Text = txtSellPrice.Text = string.Empty;
foreach (Control item in groupBox1.Controls)
{
if (item is TextBox)
{
item.Text = string.Empty;
}
}
}
else
{
CLASSPRODUCT.SP_UPDATEPRODUCT(FRM_ProductManagment.id, txtproductname.Text, txtPDescription.Text, arr, txtBuyPrice.Text,
txtSellPrice.Text, (int)cmbcatogary.SelectedValue, (int)cmbAMName.SelectedValue, (int)cmbSnName.SelectedValue, txtbarcode.Text);
MessageBox.Show("تمت عملية تعديل بيانات المنتج بنجاح");
}
}
catch (Exception ex)
{
MessageBox.Show("البيانات المدخلة غير كافية");
}
}
public FRM_Search(string _ch)
{
InitializeComponent();
if (_ch == "Supplier")
{
//DataTable dt = ClassSupllier.SP_SUPPLIERSELECT();
//dataGridView1.DataSource = dt;
this.Text = "بيانات الموردين";
dataGridView1.DataSource = ClassSupllier.SP_SUPPLIERSELECT();
}
else if (_ch == "Product")
{
//DataTable dt = ClassSupllier.SP_SUPPLIERSELECT();
//dataGridView1.DataSource = dt;
this.Text = "المنتجات";
dataGridView1.DataSource = CLASSPRODUCT.SP_PRODECUTSELECT();
}
else if (_ch == "customer")
{
this.Text = "بيانات العملاء";
dataGridView1.DataSource = CLASS_CUSTOMER.SP_CUSTOMER_DISPLAY();
}
}
