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