public DetilTransaksiLayanan SearchDetilTransaksiLayananUsingID(String idDetilTransaksi, String idTransaksi) { string sql = "SELECT P.ID_DETILTRANSAKSI_LAYANAN , P.ID_TRANSAKSI_LAYANAN, P.ID_LAYANAN, L.NAMA_LAYANAN, P.SUB_TOTAL_LAYANAN, P.JUMLAH_DETIL_LAYANAN, L.HARGA_LAYANAN " + "FROM detil_transaksi_layanan P " + "JOIN layanan L ON (P.ID_LAYANAN = L.ID_LAYANAN) " + "WHERE P.ID_DETILTRANSAKSI_LAYANAN = '" + idDetilTransaksi + "' AND P.ID_TRANSAKSI_LAYANAN = '" + idTransaksi + "';"; DetilTransaksiLayanan detiltransaksiLayanan = null; try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader result = cmd.ExecuteReader(); if (result != null) { while (result.Read()) { detiltransaksiLayanan = new DetilTransaksiLayanan( result.GetInt32("ID_DETILTRANSAKSI_LAYANAN"), result.GetString("ID_TRANSAKSI_LAYANAN"), result.GetInt32("ID_LAYANAN"), result.GetString("NAMA_LAYANAN"), result.GetInt32("SUB_TOTAL_LAYANAN"), result.GetInt32("JUMLAH_DETIL_LAYANAN"), result.GetInt32("HARGA_LAYANAN")); } } } catch (Exception ex) { Console.WriteLine("Failed to search..."); Console.WriteLine(ex.ToString()); } return(detiltransaksiLayanan); }
public List <DetilTransaksiLayanan> ShowDetilTransaksiLayanan() { string sql = "SELECT P.ID_DETILTRANSAKSI_LAYANAN, P.ID_TRANSAKSI_LAYANAN, P.ID_LAYANAN, L.NAMA_LAYANAN, P.SUB_TOTAL_LAYANAN, P.JUMLAH_DETIL_LAYANAN, L.HARGA_LAYANAN " + "FROM detil_transaksi_layanan P " + "JOIN layanan L ON (P.ID_LAYANAN = L.ID_LAYANAN);"; List <DetilTransaksiLayanan> DetilTransaksiLayananList = new List <DetilTransaksiLayanan>(); try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader result = cmd.ExecuteReader(); if (result != null) { while (result.Read()) { DetilTransaksiLayanan DTP = new DetilTransaksiLayanan( result.GetInt32("ID_DETILTRANSAKSI_LAYANAN"), result.GetString("ID_TRANSAKSI_LAYANAN"), result.GetInt32("ID_LAYANAN"), result.GetString("NAMA_LAYANAN"), result.GetInt32("SUB_TOTAL_LAYANAN"), result.GetInt32("JUMLAH_DETIL_LAYANAN"), result.GetInt32("HARGA_LAYANAN")); DetilTransaksiLayananList.Add(DTP); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } return(DetilTransaksiLayananList); }
public DetilTransaksiLayanan SearchDetilTransaksiLayananUsingID(String idDetilTransaksi, String idTransaksi) { DetilTransaksiLayanan detilTransaksiLayanan = null; dtlDAO.makeConnection(); detilTransaksiLayanan = dtlDAO.SearchDetilTransaksiLayananUsingID(idDetilTransaksi, idTransaksi); dtlDAO.closeConnection(); return(detilTransaksiLayanan); }
public void UpdateDetilTransaksiLayanan(DetilTransaksiLayanan DTL, String idTransaksi) { string sql = "UPDATE detil_transaksi_layanan SET ID_LAYANAN = (SELECT ID_LAYANAN FROM layanan WHERE NAMA_LAYANAN = '" + DTL.Nama_Layanan + "')" + ", JUMLAH_DETIL_LAYANAN = '" + DTL.Jumlah_Detil_Layanan + "' ,SUB_TOTAL_LAYANAN = '" + DTL.Sub_Total_Layanan + "'" + " WHERE ID_DETILTRANSAKSI_LAYANAN = '" + idTransaksi + "';"; try { MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteReader(); Console.WriteLine("Data Updated..."); } catch (Exception ex) { Console.WriteLine("Failed to update..."); Console.WriteLine(ex.ToString()); } }
public void CreateDetilTransaksiLayanan(DetilTransaksiLayanan DTL) { string sql = "SET FOREIGN_KEY_CHECKS = 0; " + "INSERT INTO detil_transaksi_layanan(ID_TRANSAKSI_LAYANAN, ID_LAYANAN, SUB_TOTAL_LAYANAN, JUMLAH_DETIL_LAYANAN)" + "VALUES ('" + DTL.ID_Transaksi_Layanan + "','" + DTL.ID_Layanan + "','" + DTL.Sub_Total_Layanan + "','" + DTL.Jumlah_Detil_Layanan + "'); " + "SET FOREIGN_KEY_CHECKS = 1;"; try { MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteReader(); Console.WriteLine("Data Created..."); } catch (Exception ex) { Console.WriteLine("Failed to create..."); Console.WriteLine(ex.ToString()); } }
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 btnCariDetil_Click(object sender, EventArgs e) { var list = new DetilTransaksiLayananControl(); int id_layanan; 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 (txtCari.Text != null && list.SearchDetilTransaksiLayananUsingID(txtCariDetil.Text, txtCari.Text) != null) { SetTextBoxEnable(); btnHapusLayanan.Enabled = true; btnUbahLayanan.Enabled = true; detilTransaksiLayanan = list.SearchDetilTransaksiLayananUsingID(txtCariDetil.Text, txtCari.Text); txtJumlah.Text = System.Convert.ToString(detilTransaksiLayanan.Jumlah_Detil_Layanan); id_layanan = detilTransaksiLayanan.ID_Layanan; ID_Transaksi = detilTransaksiLayanan.ID_Transaksi_Layanan; oldSubtotal = detilTransaksiLayanan.Sub_Total_Layanan; 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 Nama_Layanan, Harga_Layanan FROM layanan WHERE ID_LAYANAN = '" + id_layanan + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlproduk, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { comboBoxLayanan.Text = result1.GetString("Nama_Layanan"); hargaLayanan = result1.GetInt32("Harga_Layanan"); } } } 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 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()); } }
public void UpdateDetilTransaksiLayanan(DetilTransaksiLayanan detailTransaksiProduk, String idTransaksi) { dtlDAO.makeConnection(); dtlDAO.UpdateDetilTransaksiLayanan(detailTransaksiProduk, idTransaksi); dtlDAO.closeConnection(); }
public void CreateDetilTransaksiLayanan(DetilTransaksiLayanan DTL) { dtlDAO.makeConnection(); dtlDAO.CreateDetilTransaksiLayanan(DTL); dtlDAO.closeConnection(); }