private void btnHapusLayanan_Click(object sender, EventArgs e) { var ctrlDTL = new DetilTransaksiLayananControl(); var ctrlTL = new TransaksiLayananControl(); try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Kode Transaksi Kosong"); throw null; } if (string.IsNullOrEmpty(txtCariDetil.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } if (txtCariDetil.Text != null && ctrlDTL.SearchDetilTransaksiLayanan(txtCariDetil.Text) != null) { hargaSubtotal = 0; detilTransaksiLayanan = ctrlDTL.SearchDetilTransaksiLayanan(txtCariDetil.Text); hargaSubtotal = detilTransaksiLayanan.Sub_Total_Layanan; ctrlDTL.DeleteDetilTransaksiLayanan(txtCariDetil.Text, txtCari.Text); subtotalLayanan = subtotalLayanan - hargaSubtotal; totalHargaAkhir = subtotalLayanan - tempDiskon; ctrlTL.UpdateSubtotalLayanan(subtotalLayanan, txtCari.Text); ctrlTL.UpdateTotalHargaLayanan(totalHargaAkhir, txtCari.Text); MessageBox.Show("Layanan Berhasil Dihapus!"); } else { MessageBox.Show("Transaksi Layanan Tidak ditemukan!"); throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnUbahLayanan_Click(object sender, EventArgs e) { int SubtotalLayanan; try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Kode Transaksi Kosong"); throw null; } 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(comboBoxLayanan.Text.Trim())) { MessageBox.Show("Nama Layanan 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 sqlLayanan = "SELECT * FROM layanan WHERE NAMA_LAYANAN = '" + comboBoxLayanan.Text + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlLayanan, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { hargaLayananInput = result1.GetInt32("HARGA_LAYANAN"); idLayanan = result1.GetInt32("ID_LAYANAN"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); var ctrl = new DetilTransaksiLayananControl(); var ctrlTP = new TransaksiLayananControl(); ValidateNumberOnly(txtJumlah.Text); SubtotalLayanan = (Convert.ToInt32(txtJumlah.Text) * hargaLayananInput); subtotalLayanan = tempSubtotalLayanan - oldSubtotal + SubtotalLayanan; totalHargaAkhir = subtotalLayanan - tempDiskon; detilTransaksiLayanan = new DetilTransaksiLayanan(comboBoxLayanan.Text, SubtotalLayanan, Convert.ToInt32(txtJumlah.Text)); transaksiLayanan = new TransaksiLayanan(subtotalLayanan); ctrl.UpdateDetilTransaksiLayanan(detilTransaksiLayanan, txtCariDetil.Text); ctrlTP.UpdateSubtotalLayanan(transaksiLayanan, txtCari.Text); ctrlTP.UpdateTotalHargaLayanan(totalHargaAkhir, txtCari.Text); MessageBox.Show("Transaksi Berhasil Diubah!"); } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }