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