private void btn_ubah_Click(object sender, RoutedEventArgs e) { try { int biaya = int.Parse(txt_biaya.Text, System.Globalization.NumberStyles.Currency); k.sql = "update kamar set nomor_kamar=@1,biaya=@2,status=@3, luas_kamar=@4 where id_kamar = '" + idKamar + "'"; k.setparam(); k.perintah.Parameters.AddWithValue("@1", txt_nama.Text); k.perintah.Parameters.AddWithValue("@2", biaya); k.perintah.Parameters.AddWithValue("@3", cmb_status.SelectedIndex); k.perintah.Parameters.AddWithValue("@4", txt_luas.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_simpan1_Click(object sender, RoutedEventArgs e) { try { k.sql = "update kosan set nama_kosan=@1,no_telp=@2,kota=@3,alamat=@4,kode_pos=@5, deskripsi_kost=@6 where id_pemilik = 1"; k.setparam(); k.perintah.Parameters.AddWithValue("@1", txt_nama.Text); k.perintah.Parameters.AddWithValue("@2", txt_telp.Text); k.perintah.Parameters.AddWithValue("@3", txt_kota); k.perintah.Parameters.AddWithValue("@4", txt_alamat.Text); k.perintah.Parameters.AddWithValue("@5", txt_kdpos.Text); k.perintah.Parameters.AddWithValue("@6", txt_deskripsi.Text); k.perintah.ExecuteNonQuery(); k.close(); var sampleMessageDialog = new SampleMessageDialog { Message = { Text = "Data Berhasil Diubah" } }; DialogHost.Show(sampleMessageDialog, "MainDialog"); } catch (Exception ex) { MessageBox.Show("error " + ex.ToString()); } }
private void btn_bayar_Click(object sender, RoutedEventArgs e) { int tunai = int.Parse(txt_tunai.Text, System.Globalization.NumberStyles.Currency); kembali = int.Parse(txt_kembali.Text, System.Globalization.NumberStyles.Currency); try { k.sql = "insert into pembayaran values(@1,@2,@3,@4,@5,@6,@7)"; k.setparam(); k.perintah.Parameters.AddWithValue("@1", txt_invoice.Text); k.perintah.Parameters.AddWithValue("@2", tglBayar.ToString("yyyy-MM-dd")); k.perintah.Parameters.AddWithValue("@3", total); k.perintah.Parameters.AddWithValue("@4", noSewa); k.perintah.Parameters.AddWithValue("@5", 1); k.perintah.Parameters.AddWithValue("@6", tunai); k.perintah.Parameters.AddWithValue("@7", kembali); 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_ubah_Click(object sender, RoutedEventArgs e) { int harga = int.Parse(lb_diskon.Content.ToString(), System.Globalization.NumberStyles.Currency); try { k.sql = "update tb_detail_katalog set diskon=@diskon,harga_diskon=@hardis where id_produk = '" + txt_idprod.Text + "'"; k.setparam(); k.perintah.Parameters.AddWithValue("@diskon", txt_diskon.Text); k.perintah.Parameters.AddWithValue("@hardis", harga); 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) { try { k.sql = "update tb_message set message=@message,alert=@alert where id_message = '" + txt_id.Text + "'"; k.setparam(); k.perintah.Parameters.AddWithValue("@message", txt_msg.Text); k.perintah.Parameters.AddWithValue("@alert", txt_alert.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_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_simpan_Click(object sender, RoutedEventArgs e) { if (txt_nama.Text == "" || txt_kamar.Text == "") { var sampleMessageDialog = new SampleMessageDialog { Message = { Text = "Lengkapi Dulu Data" } }; DialogHost.Show(sampleMessageDialog, "SubDialogSewa"); } else { try { DateTime tglCheckin = tgl_checkin.SelectedDate.Value; String idSewa = "KMR-" + idKamar + "M" + tglCheckin.ToString("MMdd") + "C" + idCust; k.sql = "insert into sewa values(@1,@2,@3,@4,@5,@6,@7)"; k.setparam(); k.perintah.Parameters.AddWithValue("@1", idSewa); k.perintah.Parameters.AddWithValue("@2", tglCheckin.ToString("yyyy-MM-dd")); k.perintah.Parameters.AddWithValue("@3", slider_lama.Value); k.perintah.Parameters.AddWithValue("@4", idCust); k.perintah.Parameters.AddWithValue("@5", "1"); k.perintah.Parameters.AddWithValue("@6", idKamar); k.perintah.Parameters.AddWithValue("@7", "1"); k.perintah.ExecuteNonQuery(); k.close(); k.sql = "update customer set status= 1 where id_customer='" + idCust + "'"; k.setdt(); k.sql = "update kamar set status= 1 where id_kamar='" + idKamar + "'"; k.setdt(); 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_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) { if (txt_id.Text == "" || txt_deskripsi.Text == "") { var sampleMessageDialog = new SampleMessageDialog { Message = { Text = "Lengkapi dulu data" } }; DialogHost.Show(sampleMessageDialog, "MainDialog"); } else { try { k.sql = "update tb_katalog set deskripsi=@desk where id_katalog = '" + txt_id.Text + "'"; k.setparam(); k.perintah.Parameters.AddWithValue("@desk", txt_deskripsi.Text); k.perintah.ExecuteNonQuery(); k.close(); DialogHost.CloseDialogCommand.Execute(null, this); var sampleMessageDialog = new SampleMessageDialog { Message = { Text = "Data Berhasil Diubah" } }; DialogHost.Show(sampleMessageDialog, "MainDialog"); bersih(); kodeotomatis(); showdataktlog(); btn_ubah.IsEnabled = false; btn_hapus.IsEnabled = false; btn_simpan.IsEnabled = true; } 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()); } }
private void btn_simpan_Click(object sender, RoutedEventArgs e) { if (txt_nama.Text == "" || txt_biaya.Text == "") { var sampleMessageDialog = new SampleMessageDialog { Message = { Text = "Lengkapi Dulu Data" } }; DialogHost.Show(sampleMessageDialog, "SubDialogCKamar"); } else { try { int biaya = int.Parse(txt_biaya.Text, System.Globalization.NumberStyles.Currency); k.sql = "insert into kamar values(@1,@2,@3,@4,@5,@6)"; k.setparam(); k.perintah.Parameters.AddWithValue("@1", null); k.perintah.Parameters.AddWithValue("@2", txt_nama.Text); k.perintah.Parameters.AddWithValue("@3", biaya); k.perintah.Parameters.AddWithValue("@4", "1"); k.perintah.Parameters.AddWithValue("@5", "0"); k.perintah.Parameters.AddWithValue("@6", txt_luas.Text); 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_idprod.Text == "" || txt_nama.Text == "" || txt_harga.Text == "" || txt_diskon.Text == "") //{ //var sampleMessageDialog = new SampleMessageDialog //{ // Message = { Text = "Lengkapi Dulu Data" } //}; //DialogHost.Show(sampleMessageDialog, "MainDialog"); //} //else //{ String kont = lb_diskon.Content.ToString(); int harga = int.Parse(lb_diskon.Content.ToString(), System.Globalization.NumberStyles.Currency); try { k.sql = "insert into tb_detail_katalog values(@id_katalog,@id_produk,@diskon,@harga_diskon)"; k.setparam(); k.perintah.Parameters.AddWithValue("@id_katalog", idktlog); k.perintah.Parameters.AddWithValue("@id_produk", txt_idprod.Text); k.perintah.Parameters.AddWithValue("@diskon", txt_diskon.Text); k.perintah.Parameters.AddWithValue("@harga_diskon", harga); k.perintah.ExecuteNonQuery(); k.close(); DialogHost.CloseDialogCommand.Execute(null, this); } catch (Exception ex) { MessageBox.Show("Data Gagal Didaftarkan " + ex); } //} }