public DialogProduk(String id_produk) { InitializeComponent(); k.sql = "select *from tb_produk where id_produk ='" + id_produk + "'"; k.setdt(); Byte[] tmpfoto = new Byte[0]; foreach (DataRow baris in k.dt.Rows) { txt_id.Text = baris[0].ToString(); txt_nama.Text = baris[1].ToString(); if (baris[2].ToString() == "Makanan") { rb_makanan.IsChecked = true; } else { rb_minuman.IsChecked = true; } txt_detail.Text = baris[3].ToString(); txt_harga.Text = Convert.ToDecimal(baris[4].ToString()).ToString("c"); tmpfoto = (Byte[])baris[5]; img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto); } }
public void showdata() { k.sql = "select sewa.id_sewa,customer.nama,sewa.tgl_checkin,sewa.lama_sewa,customer.no_hp,customer.kota,kamar.nomor_kamar from sewa " + "inner join customer on sewa.id_customer = customer.id_customer inner join kamar on sewa.id_kamar=kamar.id_kamar"; k.setdt(); dg_sewa.ItemsSource = k.dt.DefaultView; }
private void ClosingEventHandler2(object sender, DialogClosingEventArgs eventArgs) { if (_idmsg != null) { k.sql = "select *from tb_message where id_message = '" + _idmsg + "'"; k.setdt(); txt_idmsg.Text = k.dt.Rows[0][0].ToString(); txt_pesan.Text = k.dt.Rows[0][1].ToString(); } }
private void lv_kamar_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (lv_kamar.SelectedIndex >= 0) { DataRowView dataRow = (DataRowView)lv_kamar.SelectedItem; string index = dataRow.Row[0].ToString(); k.sql = "select *from kamar where id_kamar = '" + index + "'"; k.setdt(); idKmr = k.dt.Rows[0][0].ToString(); namaKmr = k.dt.Rows[0][1].ToString(); } }
public DialogMessage(String id_message) { InitializeComponent(); k.sql = "select *from tb_message where id_message ='" + id_message + "'"; k.setdt(); Byte[] tmpfoto = new Byte[0]; foreach (DataRow baris in k.dt.Rows) { txt_id.Text = baris[0].ToString(); txt_msg.Text = baris[1].ToString(); txt_alert.Text = baris[2].ToString(); } }
public void showdata() { k.sql = "select count(*) from customer where status = 1"; k.setdt(); lb_jmlpenghuni.Text = k.dt.Rows[0][0].ToString(); k.sql = "select count(*) from customer"; k.setdt(); lb_totalCust.Text = k.dt.Rows[0][0].ToString(); k.sql = "select count(*) from kamar"; k.setdt(); lb_jmlkamar.Text = k.dt.Rows[0][0].ToString(); }
void timer_refreshData(object sender, EventArgs e) { k.sql = "select COUNT(id_produk) from tb_produk"; k.setdt(); tile_jmlprod.Count = k.dt.Rows[0][0].ToString(); k.sql = "select COUNT(id_katalog) from tb_katalog"; k.setdt(); tile_jmlktlog.Count = k.dt.Rows[0][0].ToString(); int l_WindowCount = System.Windows.Forms.Screen.AllScreens.Count(); tile_jmlmonitor.Count = l_WindowCount.ToString(); }
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 async void loadData() { await Task.Delay(300); try { k.sql = "select *from customer where id_customer ='" + idCustomer + "'"; k.setdt(); Byte[] tmpfoto = new Byte[0]; foreach (DataRow baris in k.dt.Rows) { txt_nik.Text = baris[1].ToString(); txt_nama.Text = baris[2].ToString(); txt_telp.Text = baris[3].ToString(); if (baris[4].ToString() == "P") { rb_laki.IsChecked = true; } else { rb_perempuan.IsChecked = true; } String tgllahir = baris[5].ToString(); DateTime dt = Convert.ToDateTime(tgllahir); tgl_lahir.SelectedDate = dt; txt_asalkota.Text = baris[6].ToString(); txt_alamat.Text = baris[7].ToString(); cmb_pekerjaan.Text = baris[8].ToString(); txt_instansi.Text = baris[9].ToString(); if (!baris[10].Equals(null)) { tmpfoto = (Byte[])baris[10]; img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto); } } } catch (Exception ex) { //MessageBox.Show("error di open " + ex); } }
private async void loadData() { await Task.Delay(200); try { k.sql = "select *from kamar where id_kamar ='" + idKamar + "'"; k.setdt(); foreach (DataRow baris in k.dt.Rows) { txt_nama.Text = baris[1].ToString(); txt_biaya.Text = baris[2].ToString(); cmb_status.SelectedIndex = int.Parse(baris[4].ToString()); txt_luas.Text = baris[5].ToString(); } } catch (Exception ex) { //MessageBox.Show("error di open " + ex); } }
private void loadDataKost() { try { k.sql = "select *from kosan"; k.setdt(); foreach (DataRow baris in k.dt.Rows) { txt_nama.Text = baris[1].ToString(); txt_telp.Text = baris[6].ToString(); txt_kota.Text = baris[3].ToString(); txt_alamat.Text = baris[2].ToString(); txt_kdpos.Text = baris[4].ToString(); txt_deskripsi.Text = baris[5].ToString(); } } catch (Exception ex) { //MessageBox.Show("error di open " + ex); } }
private void ClosingEventHandler(object sender, DialogClosingEventArgs eventArgs) { k.sql = "select *from tb_produk where id_produk = '" + _idprod + "'"; k.setdt(); foreach (DataRow baris in k.dt.Rows) { txt_idprod.Text = baris[0].ToString(); txt_nama.Text = baris[1].ToString(); txt_harga.Text = Convert.ToDecimal(baris[4].ToString()).ToString("c"); lb_diskon.Content = txt_harga.Text; } }
public DialogDetailKatalog(String iddetkatalog) { InitializeComponent(); DataContext = this; idktlog = iddetkatalog; System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("id-ID"); System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("id-ID"); txt_diskon.Text = Convert.ToDecimal(0).ToString("c"); k.sql = "select * from tb_detail_katalog inner join tb_produk " + "on tb_detail_katalog.id_produk = tb_produk.id_produk where tb_produk.nama = '" + iddetkatalog + "'"; k.setdt(); foreach (DataRow baris in k.dt.Rows) { txt_idprod.Text = baris[1].ToString(); txt_nama.Text = baris[6].ToString(); txt_harga.Text = Convert.ToDecimal(baris[8].ToString()).ToString("c"); txt_diskon.Text = baris[2].ToString(); lb_diskon.Content = Convert.ToDecimal(baris[3].ToString()).ToString("c"); } }
public void showdata() { k.sql = "select * from kamar"; k.setdt(); lv_kamar.ItemsSource = k.dt.DefaultView; }
public void showdata() { k.sql = "select * from tb_produk"; k.setdt(); dg_produk.ItemsSource = k.dt.DefaultView; }
private void showdataprod() { k.sql = "select * from tb_detail_katalog inner join tb_produk on tb_detail_katalog.id_produk = tb_produk.id_produk where tb_detail_katalog.id_katalog = '" + txt_id.Text + "'"; k.setdt(); dg_produk.ItemsSource = k.dt.DefaultView; }
public void showdata() { k.sql = "select * from customer where status=0"; k.setdt(); lv_customer.ItemsSource = k.dt.DefaultView; }
public void showdata() { k.sql = "select * from tb_message"; k.setdt(); dg_message.ItemsSource = k.dt.DefaultView; }
public void showdata() { k.sql = "select * from tb_katalog"; k.setdt(); dg_katalog.ItemsSource = k.dt.DefaultView; }
public void showdata(string _idktlog) { k.sql = "select *from tb_katalog inner join tb_detail_katalog on tb_katalog.id_katalog = tb_detail_katalog.id_katalog inner join tb_produk on tb_detail_katalog.id_produk = tb_produk.id_produk where tb_katalog.id_katalog = '" + _idktlog + "'"; k.setdt(); lv_ktlog.ItemsSource = k.dt.DefaultView; }