private void btnSave_Click(object sender, EventArgs e)
{
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Insert data Please");
}
else
{
DataTable dt = ClassSetting.searchCityByName(txtname.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (txtname.Text.Equals(dt.Rows[i][0].ToString()))
{
found = 1;
}
}
if (found == 1)
{
MessageBox.Show("This name already exists . .");
}
else
{
int add = ClassLocation.sp_AddCity(txtname.Text, int.Parse(cmbCountry.SelectedValue.ToString()));
txtname.Text = "";
MessageBox.Show("Done");
}
}
}