private void btnCari_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } else { if (stat == "transaksi") { var ctrl = new TransaksiLayananControl(); if (ctrl.SearchTransaksiLayanan(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); txtCari.Text = string.Empty; throw null; } else { List <TransaksiLayanan> TransaksiLayananList = new List <TransaksiLayanan>(); TransaksiLayananList.Add(ctrl.SearchTransaksiLayanan(txtCari.Text)); dataGridViewTampil.DataSource = TransaksiLayananList; } } else if (stat == "detiltransaksi") { var ctrl = new DetilTransaksiLayananControl(); if (ctrl.SearchDetilTransaksiLayanan(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); txtCari.Text = string.Empty; throw null; } else { List <DetilTransaksiLayanan> DetilTransaksiLayananList = new List <DetilTransaksiLayanan>(); DetilTransaksiLayananList.Add(ctrl.SearchDetilTransaksiLayanan(txtCari.Text)); dataGridViewTampil.DataSource = DetilTransaksiLayananList; } } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new TransaksiLayananControl(); var list2 = new DetilTransaksiLayananControl(); try { if (txtCari.Text != null && list.SearchTransaksiLayanan(txtCari.Text) != null) { SetTextBoxEnable(); buttonUbah.Enabled = true; buttonBatal.Enabled = true; btnTambahLayanan.Enabled = true; transaksiLayanan = list.SearchTransaksiLayanan(txtCari.Text); txtDiskon.Text = System.Convert.ToString(transaksiLayanan.Diskon_Layanan); subtotal = transaksiLayanan.Subtotal_Transaksi_Layanan; statusTransaksi = transaksiLayanan.Status_Layanan; progressLayanan = transaksiLayanan.Progres_Layanan; tempDiskon = transaksiLayanan.Diskon_Layanan; subtotalLayanan = transaksiLayanan.Subtotal_Transaksi_Layanan; tempSubtotalLayanan = subtotalLayanan; if (transaksiLayanan.Status_Layanan == 1) { comboBoxStatus.Text = "Lunas"; } else { comboBoxStatus.Text = "Belum Lunas"; } if (transaksiLayanan.Progres_Layanan == 1) { comboBoxProgress.Text = "Selesai"; } else { comboBoxProgress.Text = "Belum Selesai"; } string connStr = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;"; MySqlConnection conn = new MySqlConnection(connStr); string sqlhewan = "SELECT * FROM hewan WHERE ID_HEWAN = '" + transaksiLayanan.ID_Hewan + "';"; string sqlCS = "SELECT * FROM pegawai WHERE ID_PEGAWAI = '" + transaksiLayanan.ID_Pegawai + "';"; string sqlKasir = "SELECT * FROM pegawai WHERE ID_PEGAWAI = '" + transaksiLayanan.Peg_ID_Pegawai + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlhewan, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { comboBoxHewan.Text = result1.GetString("Nama_Hewan"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); conn.Open(); try { MySqlCommand cmd2 = new MySqlCommand(sqlCS, conn); MySqlDataReader result2 = cmd2.ExecuteReader(); if (result2 != null) { while (result2.Read()) { comboBoxCS.Text = result2.GetString("Nama_Pegawai"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlKasir, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { comboBoxKasir.Text = result1.GetString("Nama_Pegawai"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); List <TransaksiLayanan> TransaksiLayananList = new List <TransaksiLayanan>(); TransaksiLayananList.Add(list.SearchTransaksiLayanan(txtCari.Text)); dataGridViewTransaksi.DataSource = TransaksiLayananList; dataGridViewDetiil.DataSource = list2.SearchDetilTransaksiLayananUsingIDLayanan(txtCari.Text); } else { MessageBox.Show("Pencarian Tidak Ditemukan"); txtCari.Text = string.Empty; txtCariDetil.Text = string.Empty; throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new TransaksiLayananControl(); try { if (txtCari.Text != null && list.SearchTransaksiLayanan(txtCari.Text) != null) { transaksiLayanan = list.SearchTransaksiLayanan(txtCari.Text); notaLayanan = list.ShowNotaLayanan(txtCari.Text); NamaPelanggan = notaLayanan.Nama_Pelanggan; NamaHewan = notaLayanan.Nama_Hewan; NamaCS = notaLayanan.Nama_CS; NamaKasir = notaLayanan.Nama_Kasir; NoTelp = notaLayanan.Nomor_Telpon; Jenis_Hewan = notaLayanan.Jenis_Hewan; if (transaksiLayanan.Status_Layanan == 1) { txtNomorTransaksi.Text = transaksiLayanan.ID_Transaksi_Layanan; txtNamaHewan.Text = transaksiLayanan.Nama_Hewan; txtNamaPelanggan.Text = transaksiLayanan.Nama_Pelanggan; txtStatusBayar.Text = "Lunas"; txtSubtotal.Text = Convert.ToString(transaksiLayanan.Subtotal_Transaksi_Layanan); txtDiskon.Text = Convert.ToString(transaksiLayanan.Diskon_Layanan); txtTotalHarga.Text = Convert.ToString(transaksiLayanan.Total_Transaksi_Layanan); if (transaksiLayanan.Progres_Layanan == 1) { txtProgress.Text = "Selesai"; } else { txtProgress.Text = "Belum Selesai"; } buttonCetak.Enabled = true; MessageBox.Show("Transaksi Sudah Lunas!"); } else { buttonHitungTotal.Enabled = true; txtDiskon.Enabled = true; subtotal = transaksiLayanan.Subtotal_Transaksi_Layanan; txtNomorTransaksi.Text = transaksiLayanan.ID_Transaksi_Layanan; txtNamaHewan.Text = transaksiLayanan.Nama_Hewan; txtNamaPelanggan.Text = transaksiLayanan.Nama_Pelanggan; txtSubtotal.Text = Convert.ToString(transaksiLayanan.Subtotal_Transaksi_Layanan); if (transaksiLayanan.Progres_Layanan == 1) { txtProgress.Text = "Selesai"; } else { txtProgress.Text = "Belum Selesai"; } txtStatusBayar.Text = "Belum Lunas"; } } else { MessageBox.Show("Pencarian Tidak Ditemukan!"); txtCari.Text = string.Empty; throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }