private void btn_simpan_Click(object sender, RoutedEventArgs e)
{
if (txt_nama.Text == "" || txt_telp.Text == "" || txt_asalkota.Text == "" || txt_nik.Text == "")
{
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Lengkapi Dulu Data" }
};
DialogHost.Show(sampleMessageDialog, "SubDialogCustomer");
}
else
{
try
{
String jk = "";
if (rb_laki.IsChecked == true)
{
jk = "P";
}
else
{
jk = "W";
}
DateTime tgllahir = tgl_lahir.SelectedDate.Value;
var img = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);
k.sql = "insert into customer values(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12)";
k.setparam();
k.perintah.Parameters.AddWithValue("@1", null);
k.perintah.Parameters.AddWithValue("@2", txt_nik.Text);
k.perintah.Parameters.AddWithValue("@3", txt_nama.Text);
k.perintah.Parameters.AddWithValue("@4", txt_telp.Text);
k.perintah.Parameters.AddWithValue("@5", jk);
k.perintah.Parameters.AddWithValue("@6", tgllahir.ToString("yyyy-MM-dd"));
k.perintah.Parameters.AddWithValue("@7", txt_asalkota.Text);
k.perintah.Parameters.AddWithValue("@8", txt_alamat.Text);
k.perintah.Parameters.AddWithValue("@9", cmb_pekerjaan.Text);
k.perintah.Parameters.AddWithValue("@10", txt_instansi.Text);
k.perintah.Parameters.AddWithValue("@11", img);
k.perintah.Parameters.AddWithValue("@12", 0);
k.perintah.ExecuteNonQuery();
k.close();
DialogHost.CloseDialogCommand.Execute(null, this);
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Data Berhasil Tersimpan" }
};
DialogHost.Show(sampleMessageDialog, "MainDialog");
}
catch (Exception ex)
{
MessageBox.Show("Data Gagal Didaftarkan " + ex);
}
}
}
private void btn_simpan_Click(object sender, RoutedEventArgs e)
{
if (txt_id.Text == "" || txt_nama.Text == "" || txt_harga.Text == "")
{
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Lengkapi Dulu Data" }
};
DialogHost.Show(sampleMessageDialog, "MainDialog");
}
else
{
try
{
String jenis = "";
int harga = int.Parse(txt_harga.Text, System.Globalization.NumberStyles.Currency);
if (rb_makanan.IsChecked == true)
{
jenis = "Makanan";
}
else
{
jenis = "Minuman";
}
var img = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);
k.sql = "insert into tb_produk values(@id,@nama,@jenis,@detail,@harga,@foto)";
k.setparam();
k.perintah.Parameters.AddWithValue("@id", txt_id.Text);
k.perintah.Parameters.AddWithValue("@nama", txt_nama.Text);
k.perintah.Parameters.AddWithValue("@detail", txt_detail.Text);
k.perintah.Parameters.AddWithValue("@jenis", jenis);
k.perintah.Parameters.AddWithValue("@harga", harga);
k.perintah.Parameters.AddWithValue("@foto", img);
k.perintah.ExecuteNonQuery();
k.close();
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Data Berhasil Tersimpan" }
};
DialogHost.Show(sampleMessageDialog, "MainDialog");
showdata();
bersih();
kodeotomatis();
}
catch (Exception ex)
{
MessageBox.Show("Data Gagal Didaftarkan " + ex);
}
}
}
private void btn_ubah_Click(object sender, RoutedEventArgs e)
{
try
{
String jk = "";
if (rb_laki.IsChecked == true)
{
jk = "P";
}
else
{
jk = "W";
}
DateTime tgllahir = tgl_lahir.SelectedDate.Value;
var img = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);
k.sql = "update customer set nama=@1,no_hp=@2,jenis_kelamin=@3,tgl_lahir=@4,kota=@5,alamat=@6,pekerjaan=@7,nama_instansi=@8,foto=@9, nik=@10 where id_customer = '" + idCustomer + "'";
k.setparam();
k.perintah.Parameters.AddWithValue("@1", txt_nama.Text);
k.perintah.Parameters.AddWithValue("@2", txt_telp.Text);
k.perintah.Parameters.AddWithValue("@3", jk);
k.perintah.Parameters.AddWithValue("@4", tgllahir.ToString("yyyy-MM-dd"));
k.perintah.Parameters.AddWithValue("@5", txt_asalkota.Text);
k.perintah.Parameters.AddWithValue("@6", txt_alamat.Text);
k.perintah.Parameters.AddWithValue("@7", cmb_pekerjaan.Text);
k.perintah.Parameters.AddWithValue("@8", txt_instansi.Text);
k.perintah.Parameters.AddWithValue("@9", img);
k.perintah.Parameters.AddWithValue("@10", txt_nik.Text);
k.perintah.ExecuteNonQuery();
k.close();
DialogHost.CloseDialogCommand.Execute(null, this);
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Data Berhasil Diubah" }
};
DialogHost.Show(sampleMessageDialog, "MainDialog");
}
catch (Exception ex)
{
MessageBox.Show("error " + ex.ToString());
}
}
private void btn_ubah_Click(object sender, RoutedEventArgs e)
{
String jenis = "";
if (rb_makanan.IsChecked == true)
{
jenis = "Makanan";
}
else
{
jenis = "Minuman";
}
int harga = int.Parse(txt_harga.Text, System.Globalization.NumberStyles.Currency);
var img = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);
try
{
k.sql = "update tb_produk set nama=@nama,jenis=@jenis,detail=@detail,harga=@harga,foto=@foto where id_produk = '" + txt_id.Text + "'";
k.setparam();
k.perintah.Parameters.AddWithValue("@nama", txt_nama.Text);
k.perintah.Parameters.AddWithValue("@jenis", jenis);
k.perintah.Parameters.AddWithValue("@detail", txt_detail.Text);
k.perintah.Parameters.AddWithValue("@harga", harga);
k.perintah.Parameters.AddWithValue("@foto", img);
k.perintah.ExecuteNonQuery();
k.close();
DialogHost.CloseDialogCommand.Execute(null, this);
var sampleMessageDialog = new SampleMessageDialog
{
Message = { Text = "Data Berhasil Diubah" }
};
DialogHost.Show(sampleMessageDialog, "MainDialog");
}
catch (Exception ex)
{
MessageBox.Show("error " + ex.ToString());
}
}
