//Destination Upazila Button Code here..... protected void btnSaveDestinationUpazilla_Click(object sender, EventArgs e) { if (txtDestinationUpazillaName.Text == string.Empty) { lblDestinationUpazila.Text = "Textbox can not be null"; } else { string destinationUpazilaName = txtDestinationUpazillaName.Text.ToUpper(); int districtId = Convert.ToInt32(ddlDistrictId.SelectedValue); DestinationUpazila destinationUpazila = new DestinationUpazila(destinationUpazilaName, districtId); lblDestinationUpazila.Text = destinationUpazilaManager.SaveDestinationUpazila(destinationUpazila); } }
//Create a method for Save DestinationUpazila public int SaveDestinationUpazila(DestinationUpazila destinationUpazila) { SqlConnection con = new SqlConnection(connectionString); string query = "INSERT INTO DestinationUpazila VALUES('" + destinationUpazila.DestinationUpazilaName + "'," + destinationUpazila.DistrictId + ")"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int rowAffected = cmd.ExecuteNonQuery(); con.Close(); return(rowAffected); }
//Create a Method for SaveFromUpazila public string SaveDestinationUpazila(DestinationUpazila destinationUpazila) { DestinationUpazila aDestinationUpazila = destinationUpazilaGateway.IsExist(destinationUpazila); if (aDestinationUpazila == null) { int rowAffected = destinationUpazilaGateway.SaveDestinationUpazila(destinationUpazila); if (rowAffected > 0) { return("Save Successfully"); } else { return("Saving failed"); } } else { return("Destination Upazila Name Exist"); } }
//Create a method for checking DestinationUpazila Name exist or not public DestinationUpazila IsExist(DestinationUpazila destinationUpazila) { SqlConnection con = new SqlConnection(connectionString); string query = "SELECT * FROM DestinationUpazila WHERE DestinationUpazilaName='" + destinationUpazila.DestinationUpazilaName + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); DestinationUpazila aDestinationUpazila = null; if (reader.HasRows) { reader.Read(); aDestinationUpazila = new DestinationUpazila(); aDestinationUpazila.DestinationUpazilaId = (int)reader["DestinationUpazilaId"]; aDestinationUpazila.DestinationUpazilaName = reader["DestinationUpazilaName"].ToString(); } reader.Close(); con.Close(); return(aDestinationUpazila); }