public void insert(Add_cityBLL objectBLL) { try { int var = 0; SqlCommand cmd = new SqlCommand("insert_city", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@country", objectBLL.Country); cmd.Parameters.AddWithValue("@state", objectBLL.State); cmd.Parameters.AddWithValue("@city_name", objectBLL.City_name); con.Open(); var = cmd.ExecuteNonQuery(); if (var > 0) { objectBLL.Status = true; } } catch (Exception ex) { String msg = ex.Message; } finally { con.Close(); con.Dispose(); } }
// Add_cityDLL objectDLL = new Add_cityDLL(); public void insert(Add_cityBLL objectBLL) { objectDLL.insert(objectBLL); }