public FRM_AddNewCustomer(bool _isUpdate)
{
InitializeComponent();
this.isUpdate = _isUpdate;
cmbCountry.DataSource = Class_COUNTRY.SP_COUNTRY_DISPLAY();
cmbCountry.DisplayMember = "اسم الدولة";
cmbCountry.ValueMember = "رقم الدولة";
cmbCountry_SelectionChangeCommitted(null, null);
if (isUpdate)
{
this.Text = "تعديل بيانات العميل";
btnaddUpdate.Text = "تعديل";
txtCuName.Text = FRM_CustomerManagment.row.Cells[1].Value.ToString();
txtCuAddress.Text = FRM_CustomerManagment.row.Cells[2].Value.ToString();
txtCuMobile.Text = FRM_CustomerManagment.row.Cells[3].Value.ToString();
MemoryStream ms = new MemoryStream(FRM_CustomerManagment.row.Cells[4].Value as byte []);
picCUImage.Image = Image.FromStream(ms);
cmbCity.Text = FRM_CustomerManagment.row.Cells[5].Value.ToString();
cmbCountry.Text = FRM_CustomerManagment.row.Cells[6].Value.ToString();
}
else
{
this.Text = "اضافة عميل جديد";
btnaddUpdate.Text = "اضافة";
}
}
public FRM_City()
{
InitializeComponent();
btnDisplay_Click(null, null);
cmbCountry.DataSource = Class_COUNTRY.SP_COUNTRY_DISPLAY();
cmbCountry.DisplayMember = "اسم الدولة";
cmbCountry.ValueMember = "رقم الدولة";
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (txtcountName.Text == "")
{
MessageBox.Show("الرجاء ادخال اسم الدولة");
return;
}
Class_COUNTRY.SP_COUNTRY_INSERT(txtcountName.Text);
MessageBox.Show("تم الاضافة بنجاح");
txtcountName.Text = "";
btnDisplay_Click(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtCountID.Text != "")
{
Class_COUNTRY.SP_COUNTRY_UPDATE(int.Parse(txtCountID.Text), txtcountName.Text);
MessageBox.Show("تم التعديل بنجاح");
btnDisplay_Click(null, null);
}
else
{
MessageBox.Show("لم يتم تحديد البلد");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
dgvcountry.DataSource = Class_COUNTRY.SP_COUNTRY_SEARCH(txtsearch.Text);
}
private void btnDisplay_Click(object sender, EventArgs e)
{
dgvcountry.DataSource = Class_COUNTRY.SP_COUNTRY_DISPLAY();
}
