private void buttonBatal_Click(object sender, EventArgs e) { SetTextBoxDisable(); buttonUbah.Enabled = false; buttonBatal.Enabled = false; try { var ctrlTP = new TransaksiProdukControl(); var ctrlDTP = new DetilTransaksiProdukControl(); if (statusTransaksi == 1) { MessageBox.Show("Transaksi Sudah Lunas! Transaksi tidak bisa dibatalkan!"); txtCari.Text = string.Empty; throw null; } else { ctrlTP.DeleteTransaksiProduk(txtCari.Text); ctrlDTP.DeleteDetilTransaksiProdukUsingIDTransaksi(txtCari.Text); MessageBox.Show("Transaksi Berhasil Dibatalkan!"); txtCari.Text = string.Empty; txtDiskon.Text = string.Empty; comboBoxCS.Text = string.Empty; comboBoxHewan.Text = string.Empty; comboBoxKasir.Text = string.Empty; comboBoxStatus.Text = string.Empty; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new TransaksiProdukControl(); try { if (txtCari.Text != null && list.SearchTransaksiProduk(txtCari.Text) != null) { transaksiProduk = list.SearchTransaksiProduk(txtCari.Text); notaProduk = list.ShowNotaProduk(txtCari.Text); NamaPelanggan = notaProduk.Nama_Pelanggan; NamaHewan = notaProduk.Nama_Hewan; NamaCS = notaProduk.Nama_CS; NamaKasir = notaProduk.Nama_Kasir; NoTelp = notaProduk.Nomor_Telpon; Jenis_Hewan = notaProduk.Jenis_Hewan; if (transaksiProduk.Status_Transaksi_Produk == 1) { txtNomorTransaksi.Text = transaksiProduk.ID_Transaksi_Produk; txtNamaHewan.Text = transaksiProduk.Nama_Hewan; txtNamaPelanggan.Text = transaksiProduk.Nama_Pelanggan; txtStatusBayar.Text = "Lunas"; txtSubtotal.Text = Convert.ToString(transaksiProduk.Subtotal_Transaksi_Produk); txtDiskon.Text = Convert.ToString(transaksiProduk.Diskon_Produk); txtTotalHarga.Text = Convert.ToString(transaksiProduk.Total_Transaksi_Produk); buttonCetak.Enabled = true; MessageBox.Show("Transaksi Sudah Lunas!"); } else { buttonHitungTotal.Enabled = true; txtDiskon.Enabled = true; subtotal = transaksiProduk.Subtotal_Transaksi_Produk; txtNomorTransaksi.Text = transaksiProduk.ID_Transaksi_Produk; txtNamaHewan.Text = transaksiProduk.Nama_Hewan; txtNamaPelanggan.Text = transaksiProduk.Nama_Pelanggan; txtSubtotal.Text = Convert.ToString(transaksiProduk.Subtotal_Transaksi_Produk); txtStatusBayar.Text = "Belum Lunas"; } } else { MessageBox.Show("Pencarian Tidak Ditemukan!"); txtCari.Text = string.Empty; throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnHapusProduk_Click(object sender, EventArgs e) { try { var ctrlDTP = new DetilTransaksiProdukControl(); var ctrlTP = new TransaksiProdukControl(); if (txtCariDetil.Text != null && ctrlDTP.SearchDetilTransaksiProduk(txtCariDetil.Text) != null) { 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 detil_transaksi_produk WHERE ID_DETIL_TRANSAKSI = '" + txtCariDetil.Text + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlhewan, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { hargaSubtotal = result1.GetInt32("SUB_TOTAL_PRODUK"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); ctrlDTP.DeleteDetilTransaksiProduk(txtCariDetil.Text, txtCari.Text); subtotalTransaksi = subtotalTransaksi - hargaSubtotal; totalHargaAkhir = subtotalTransaksi - tempDiskon; transaksiProduk = new TransaksiProduk(subtotalTransaksi); ctrlTP.UpdateSubtotalProduk(transaksiProduk, txtCari.Text); ctrlTP.UpdateTotalHargaProduk(totalHargaAkhir, txtCari.Text); MessageBox.Show("Produk Berhasil Dihapus!"); } else { MessageBox.Show("Transaksi Produk Tidak ditemukan!"); throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
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 TransaksiProdukControl(); if (ctrl.SearchTransaksiProduk(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); txtCari.Text = string.Empty; throw null; } else { List <TransaksiProduk> TransaksiProdukList = new List <TransaksiProduk>(); TransaksiProdukList.Add(ctrl.SearchTransaksiProduk(txtCari.Text)); dataGridViewTampil.DataSource = TransaksiProdukList; } } else if (stat == "detiltransaksi") { var ctrl = new DetilTransaksiProdukControl(); if (ctrl.SearchDetilTransaksiProduk(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); txtCari.Text = string.Empty; throw null; } else { List <DetilTransaksiProduk> DetilTransaksiProdukList = new List <DetilTransaksiProduk>(); DetilTransaksiProdukList.Add(ctrl.SearchDetilTransaksiProduk(txtCari.Text)); dataGridViewTampil.DataSource = DetilTransaksiProdukList; } } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void buttonTransaksi_Click(object sender, EventArgs e) { stat = "transaksi"; var ctrl = new TransaksiProdukControl(); dataGridViewTampil.DataSource = ctrl.ShowTransaksiProduk(); for (int i = 0; i < dataGridViewTampil.Columns.Count; i++) { string str = dataGridViewTampil.Columns[i].HeaderText; if (str == "Nomor_Telpon" || str == "Jenis_Hewan") { dataGridViewTampil.Columns[i].Visible = false; } } txtCari.Text = string.Empty; txtCari.Enabled = true; btnCari.Enabled = true; }
private void buttonBayar_Click(object sender, EventArgs e) { int status; var ctrl = new TransaksiProdukControl(); try { if (string.IsNullOrEmpty(txtJumlahBayar.Text.Trim())) { MessageBox.Show("Diskon Tidak Boleh Kosong!"); throw null; } ValidateNumberOnly(txtJumlahBayar.Text); if (totalHarga > Int32.Parse(txtJumlahBayar.Text)) { MessageBox.Show("Uang untuk Pembayaran Kurang!"); txtJumlahBayar.Text = string.Empty; throw null; } status = 1; kembalian = Int32.Parse(txtJumlahBayar.Text) - totalHarga; txtKembalian.Text = Convert.ToString(kembalian); transaksiProduk = new TransaksiProduk(status, totalHarga, diskon, FormLogin.id_pegawai); ctrl.UpdatePembayaranProduk(transaksiProduk, txtCari.Text); MessageBox.Show("Pembayaran Berhasil!"); txtJumlahBayar.Enabled = false; buttonBayar.Enabled = false; buttonCetak.Enabled = true; } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void buttonHitungTotal_Click(object sender, EventArgs e) { var ctrl = new TransaksiProdukControl(); try { if (string.IsNullOrEmpty(txtDiskon.Text.Trim())) { MessageBox.Show("Diskon Tidak Boleh Kosong!"); throw null; } ValidateNumberOnly(txtDiskon.Text); if (subtotal < Int32.Parse(txtDiskon.Text)) { MessageBox.Show("Diskon Melebihi Subtotal Harga!"); txtDiskon.Text = string.Empty; throw null; } diskon = Int32.Parse(txtDiskon.Text); totalHarga = subtotal - Int32.Parse(txtDiskon.Text); txtTotalHarga.Text = Convert.ToString(totalHarga); MessageBox.Show("Diskon telah ditambahkan!"); txtDiskon.Enabled = false; txtJumlahBayar.Enabled = true; buttonHitungTotal.Enabled = false; buttonBayar.Enabled = true; } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnUbahProduk_Click(object sender, EventArgs e) { int SubtotalProduk; try { if (string.IsNullOrEmpty(txtCariDetil.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } if (string.IsNullOrEmpty(txtJumlah.Text.Trim())) { MessageBox.Show("Jumlah Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxProduk.Text.Trim())) { MessageBox.Show("Nama Produk Kosong"); throw null; } 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 produk WHERE NAMA_PRODUK = '" + comboBoxProduk.Text + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlhewan, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { hargaProdukInputan = result1.GetInt32("HARGA_JUAL"); idProduk = result1.GetInt32("ID_PRODUk"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); var ctrl = new DetilTransaksiProdukControl(); var ctrlTP = new TransaksiProdukControl(); ValidateNumberOnly(txtJumlah.Text); SubtotalProduk = (Convert.ToInt32(txtJumlah.Text) * hargaProdukInputan); subtotalTransaksi = subtotalTransaksi - oldSubtotal + SubtotalProduk; totalHargaAkhir = subtotalTransaksi - tempDiskon; detilTransaksiProduk = new DetilTransaksiProduk(comboBoxProduk.Text, SubtotalProduk, Convert.ToInt32(txtJumlah.Text)); transaksiProduk = new TransaksiProduk(subtotalTransaksi); ctrl.UpdateDetilTransaksiProduk(detilTransaksiProduk, txtCariDetil.Text); ctrlTP.UpdateSubtotalProduk(transaksiProduk, txtCari.Text); ctrlTP.UpdateTotalHargaProduk(totalHargaAkhir, txtCari.Text); MessageBox.Show("Transaksi Berhasil Diubah!"); } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void buttonUbah_Click(object sender, EventArgs e) { SetTextBoxDisable(); buttonUbah.Enabled = false; buttonBatal.Enabled = false; int status; int totalHarga; try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } if (string.IsNullOrEmpty(txtDiskon.Text.Trim())) { MessageBox.Show("Diskon Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxStatus.Text.Trim())) { MessageBox.Show("Status Pembayaran Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxCS.Text.Trim())) { MessageBox.Show("Nama CS Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxHewan.Text.Trim())) { MessageBox.Show("Nama Hewan Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxKasir.Text.Trim())) { MessageBox.Show("Nama Kasir Kosong"); throw null; } var ctrl = new TransaksiProdukControl(); ValidateNumberOnly(txtDiskon.Text); if (comboBoxStatus.Text == "Lunas") { status = 1; } else { status = 0; } totalHarga = subtotal - Int32.Parse(txtDiskon.Text); transaksiProduk = new TransaksiProduk(comboBoxCS.Text, comboBoxHewan.Text, comboBoxKasir.Text, status, totalHarga, Int32.Parse(txtDiskon.Text)); ctrl.UpdateTransaksiProduk(transaksiProduk, txtCari.Text); MessageBox.Show("Transaksi Berhasil Diubah!"); txtCari.Text = string.Empty; txtDiskon.Text = string.Empty; comboBoxCS.Text = string.Empty; comboBoxHewan.Text = string.Empty; comboBoxKasir.Text = string.Empty; comboBoxStatus.Text = string.Empty; } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new TransaksiProdukControl(); var list2 = new DetilTransaksiProdukControl(); try { if (txtCari.Text != null && list.SearchTransaksiProduk(txtCari.Text) != null) { SetTextBoxEnable(); buttonUbah.Enabled = true; buttonBatal.Enabled = true; btnTambahProduk.Enabled = true; transaksiProduk = list.SearchTransaksiProduk(txtCari.Text); txtDiskon.Text = System.Convert.ToString(transaksiProduk.Diskon_Produk); subtotal = transaksiProduk.Subtotal_Transaksi_Produk; statusTransaksi = transaksiProduk.Status_Transaksi_Produk; subtotalTransaksi = transaksiProduk.Subtotal_Transaksi_Produk; tempDiskon = transaksiProduk.Diskon_Produk; if (transaksiProduk.Status_Transaksi_Produk == 1) { comboBoxStatus.Text = "Lunas"; } else { comboBoxStatus.Text = "Belum Lunas"; } 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 = '" + transaksiProduk.ID_Hewan + "';"; string sqlCS = "SELECT * FROM pegawai WHERE ID_PEGAWAI = '" + transaksiProduk.ID_Pegawai + "';"; string sqlKasir = "SELECT * FROM pegawai WHERE ID_PEGAWAI = '" + transaksiProduk.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 <TransaksiProduk> TransaksiProdukList = new List <TransaksiProduk>(); TransaksiProdukList.Add(list.SearchTransaksiProduk(txtCari.Text)); dataGridViewTransaksi.DataSource = TransaksiProdukList; dataGridViewDetiil.DataSource = list2.SearchDetilTransaksiProdukUsingIDTransaksi(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()); } }