private void btn_Delete_Click(object sender, EventArgs e)
{
try
{
if (txt_ID.Text != "")
{
CLASS_CITY.sp_city_delete(int.Parse(txt_ID.Text));
MessageBox.Show("تم الحذف");
btn_Display_Click(null, null);
txt_ID.Text = txt_Name.Text = "";
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btn_Update_Click(object sender, EventArgs e)
{
try
{
if (txt_ID.Text != "")
{
CLASS_CITY.sp_city_update(int.Parse(txt_ID.Text), txt_Name.Text, int.Parse(cmb_country_ID.SelectedValue.ToString()));
MessageBox.Show("تم التعديل");
btn_Display_Click(null, null);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
private void btn_Add_Click(object sender, EventArgs e)
{
try
{
if (txt_Name.Text == "")
{
MessageBox.Show("يجب ادخال اسم المدينة");
return;
}
CLASS_CITY.sp_city_insert(txt_Name.Text, int.Parse(cmb_country_ID.SelectedValue.ToString()));
MessageBox.Show("تم الاضافة");
btn_Display_Click(null, null);
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
private void txt_Search_TextChanged(object sender, EventArgs e)
{
dgvCity.DataSource = CLASS_CITY.sp_city_search(txt_Search.Text);
}
private void btn_Display_Click(object sender, EventArgs e)
{
dgvCity.DataSource = CLASS_CITY.sp_city_diplay();
}
