private void btnaddUpdate_Click(object sender, EventArgs e) { MemoryStream ms = new MemoryStream(); picCUImage.Image.Save(ms, picCUImage.Image.RawFormat); byte[] cu_image = ms.ToArray(); if (txtCuName.Text == "") { MessageBox.Show("يجب ادخال اسم العميل"); return; } if (isUpdate) { CLASS_CUSTOMER.SP_CUSTOMER_UPDATE(int.Parse(FRM_CustomerManagment.row.Cells[0].Value.ToString()), txtCuName.Text, txtCuAddress.Text, txtCuMobile.Text, cu_image, int.Parse(cmbCity.SelectedValue.ToString())); MessageBox.Show("تمت عملية التعديل بنجاح"); } else { try { CLASS_CUSTOMER.SP_ADD_NEW_CUSTOMER(txtCuName.Text, txtCuAddress.Text, txtCuMobile.Text, cu_image, int.Parse(cmbCity.SelectedValue.ToString())); MessageBox.Show("تمت الاضافة بنجاح"); txtCuName.Text = txtCuAddress.Text = txtCuMobile.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void btn_ok_Click(object sender, EventArgs e) { MemoryStream ms = new MemoryStream(); pic_Image.Image.Save(ms, pic_Image.Image.RawFormat); byte[] cu_image = ms.ToArray(); if (txt_Name.Text == "") { MessageBox.Show("يجب ادخال اسم العميل"); return; } if (ISUpdate) { CLASS_CUSTOMER.sp_customer_update(int.Parse(FRM_CUSTOMER_MANEGEMENT.row.Cells[0].Value.ToString()), txt_Name.Text, txt_Addres.Text, txt_Mobile.Text, cu_image, int.Parse(cmb_city.SelectedValue.ToString())); MessageBox.Show("تم التعديل "); } else { CLASS_CUSTOMER.sp_customer_insert(txt_Name.Text, txt_Addres.Text, txt_Mobile.Text, cu_image, int.Parse(cmb_city.SelectedValue.ToString())); MessageBox.Show("تم الاضافة"); txt_Name.Text = txt_Addres.Text = txt_Mobile.Text = ""; } }
private void BTNDELETE_Click(object sender, EventArgs e) { if (grid_Customer.SelectedRows.Count > 0) { row = grid_Customer.SelectedRows[0]; CLASS_CUSTOMER.sp_customer_delete(int.Parse(row.Cells[0].Value.ToString())); MessageBox.Show(" تم الحذف بنجاح "); } else { MessageBox.Show("يجب اختيار عميل"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (dgvCustomer.SelectedRows.Count > 0) { row = dgvCustomer.SelectedRows[0]; CLASS_CUSTOMER.SP_CUSTOMER_DELETE(int.Parse(row.Cells[0].Value.ToString())); MessageBox.Show("تمت عملية الحذف بنجاح"); } else { MessageBox.Show("يجب اختيار العميل"); } }
private void FRM_CUSTOMER_MANEGEMENT_Activated(object sender, EventArgs e) { grid_Customer.DataSource = CLASS_CUSTOMER.sp_customer_display(); grid_Customer.Columns[4].Width = 100; foreach (DataGridViewColumn col in grid_Customer.Columns) { //if( col is DataGridViewIamgeColumn) //{ // (DataGridViewIamgeColumn)col).IamgeLayout = DataGridViewImageCellLayout.Stretch; //} //55-16:27 } }
public FRM_SEARCH(string _ch) { InitializeComponent(); if (_ch == "supplier") { DataTable dt = CLASS_SUPPLIER.SP_SUPPLIERSELECT(); dataGridView1.DataSource = dt; this.Text = "بيانات الموردين "; } else if (_ch == "product") { this.Text = "بيانات المنتجات"; dataGridView1.DataSource = CLASS_PRODUCTS.SP_PRODUCTSELECT(); } else if (_ch == "customer") { this.Text = "بيانات العملاء"; dataGridView1.DataSource = CLASS_CUSTOMER.sp_customer_display(); } }
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(); } }
private void txtSEARCH_TextChanged(object sender, EventArgs e) { grid_Customer.DataSource = CLASS_CUSTOMER.sp_customer_sreach(txtSEARCH.Text); grid_Customer.Columns[4].Width = 100; }
private void cmb_country_SelectionChangeCommitted(object sender, EventArgs e) { cmb_city.DataSource = CLASS_CUSTOMER.sp_city_country_ID(int.Parse(cmb_country.SelectedValue.ToString())); cmb_city.DisplayMember = "City_Name"; cmb_city.ValueMember = "City_ID"; }
private void txtSearch_TextChanged(object sender, EventArgs e) { display(CLASS_CUSTOMER.SP_CUSTOMER_SEARCH(txtSearch.Text)); }
private void btnDisplay_Click(object sender, EventArgs e) { display(CLASS_CUSTOMER.SP_CUSTOMER_DISPLAY()); }