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());
}
