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);
}
}
}