private void btnSave_Click(object sender, RoutedEventArgs e) { if (!validateAll()) { MessageBox.Show("Data gagal disimpan", "Gagal", MessageBoxButton.OK, MessageBoxImage.Error); } else { SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]); SqlCommand cmd = new SqlCommand("sp_Pasien_Create", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("nama_pasien", txtNamaPasien.Text); cmd.Parameters.AddWithValue("jenis_kelamin", Kenko.getJenkel(rdLaki)); cmd.Parameters.AddWithValue("tgl_lahir", Kenko.FormatLocalDate(txtTglLahir.Text)); cmd.Parameters.AddWithValue("alamat", txtAlamat.Text); cmd.Parameters.AddWithValue("no_telp", txtNoTelp.Text); cmd.Parameters.AddWithValue("golongan_darah", getGol()); cmd.Parameters.AddWithValue("pekerjaan", String.IsNullOrEmpty(txtPekerjaan.Text) ? DBNull.Value : (object)txtPekerjaan.Text); try { connection.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Data berhasil disimpan!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); connection.Close(); ClearForm(); dataMaster.ItemsSource = Kenko.getData("sp_Pasien_Read", "").DefaultView; } catch (Exception ex) { MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error); } } }