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();
}
