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 btnCariDetil_Click(object sender, EventArgs e) { var list = new DetilTransaksiProdukControl(); int id_produk; try { if (txtCari.Text != null && list.SearchDetilTransaksiProdukUsingID(txtCariDetil.Text, txtCari.Text) != null) { SetTextBoxEnable(); btnTambahProduk.Enabled = true; btnHapusProduk.Enabled = true; btnUbahProduk.Enabled = true; detilTransaksiProduk = list.SearchDetilTransaksiProdukUsingID(txtCariDetil.Text, txtCari.Text); txtJumlah.Text = System.Convert.ToString(detilTransaksiProduk.Jumlah_Produk); id_produk = detilTransaksiProduk.ID_Produk; oldSubtotal = detilTransaksiProduk.Sub_Total_Produk; string connStr = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;"; MySqlConnection conn = new MySqlConnection(connStr); string sqlproduk = "SELECT Harga_Jual, Nama_Produk FROM produk WHERE ID_PRODUK = '" + id_produk + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlproduk, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { comboBoxProduk.Text = result1.GetString("Nama_Produk"); hargaProduk = result1.GetInt32("Harga_Jual"); Console.WriteLine(hargaProduk); Console.WriteLine(comboBoxProduk.Text); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); } 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 buttonDetilTransaksi_Click(object sender, EventArgs e) { stat = "detiltransaksi"; var ctrl = new DetilTransaksiProdukControl(); dataGridViewTampil.DataSource = ctrl.ShowDetilTransaksiProduk(); txtCari.Text = string.Empty; txtCari.Enabled = true; btnCari.Enabled = true; }
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 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 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()); } }