private void btn_simpan_Click(object sender, EventArgs e)
{
try {
DtlTransaksi dtl = new DtlTransaksi();
dtl.id_transaksi = randomstring;
dtl.tgl_transaksi = dtp_transaksi.Value.ToString("yyyy-MM-dd");
dtl.id_pegawai = id_pegawai;
dtl.id_games = txt_id_game.Text;
dtl.jumlah = Convert.ToInt16(txt_jumlah.Text);
if ((dtl.tgl_transaksi == "") || (dtl.id_pegawai == "") || (dtl.id_games == "") || (dtl.jumlah == 0))
{
MessageBox.Show("All Data Should be Filled !", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (new DtlTransasksiDao().InsertData(dtl))
{
this.DialogResult = DialogResult.OK;
}
}
catch (DataException) {
MessageBox.Show("Input Failed", "Message");
}
}
public bool DeleteData(DtlTransaksi dtl)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "DELETE FROM dtl_transaksi WHERE `id_transaksi`='" + dtl.id_transaksi + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool InsertData(DtlTransaksi dtl)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "INSERT INTO dtl_transaksi (id_transaksi,tgl_transaksi, id_pegawai, id_games, jumlah) VALUES ('" + dtl.id_transaksi + "','" + dtl.tgl_transaksi + "','" + dtl.id_pegawai + "','" + dtl.id_games + "','" + dtl.jumlah + "')";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public DataSet FindByCategory(DtlTransaksi dtl_transaksi)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT * FROM dtl_transaksi WHERE `id_games`= '" + dtl_transaksi.id_games + "'";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "dtl_transaksi");
conn.Close();
return(ds);
}
private void btn_ubah_Click(object sender, EventArgs e)
{
DtlTransaksi dtl = new DtlTransaksi();
dtl.id_dtl_transaksi = Convert.ToInt16(txt_dtl_transaksi.Text);
dtl.id_transaksi = txt_id_transaksi.Text;
dtl.tgl_transaksi = dtp_tgl_transaksi.Value.ToString("yyyy-MM-dd");
dtl.id_pegawai = txt_id_pegawai.Text;
dtl.id_games = txt_id_game.Text;
dtl.jumlah = Convert.ToInt16(txt_jumlah.Text);
if (new DtlTransasksiDao().UpdateData(dtl))
{
MessageBox.Show("Data Has Been Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
binding();
}
}
public DataSet GrandTotal(DtlTransaksi dtl)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT SUM(dtl.`jumlah` * g.`harga`) FROM dtl_transaksi dtl INNER JOIN games g ON dtl.`id_games` = g.`id_games`";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "db_ticket");
conn.Close();
return(ds);
}
public DataSet CountTicket(DtlTransaksi dtl)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT dtl.`id_transaksi` ,dtl.`tgl_transaksi`, g.`id_games`, g.nama_games ,g.harga, dtl.`jumlah` ,dtl.`jumlah`*g.`harga` FROM dtl_transaksi dtl INNER JOIN games g ON dtl.`id_games`= g.`id_games` INNER JOIN master_transaksi mstr_trns ON mstr_trns.`id_transaksi` = dtl.`id_transaksi`WHERE mstr_trns.`status_transaksi` = 0";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "db_ticket");
conn.Close();
return(ds);
}
public DataSet FindByDate(DtlTransaksi dtl_transaksi)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT * FROM dtl_transaksi WHERE tgl_transaksi BETWEEN '" + dtl_transaksi.tgl_transaksi_awal + "' AND '" + dtl_transaksi.tgl_transaksi_akhir + "' ";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "dtl_transaksi");
conn.Close();
return(ds);
}
public bool UpdateData(DtlTransaksi dtl)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "UPDATE dtl_transaksi " +
"SET tgl_transaksi='" + dtl.tgl_transaksi + "'," +
"id_pegawai='" + dtl.id_pegawai + "'," +
"id_games='" + dtl.id_games + "'," +
"jumlah='" + dtl.jumlah + "'" +
"WHERE id_detail_transaksi='" + dtl.id_dtl_transaksi + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
private void btn_bayar_Click(object sender, EventArgs e)
{
DtlTransaksi dtl = new DtlTransaksi();
if (txt_bayar.Text == "")
{
MessageBox.Show("Please input cash money !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DataSet ds = new DtlTransasksiDao().GrandTotal(dtl);
lbl_total.Text = ds.Tables[0].Rows[0][0].ToString();
double bayar = Convert.ToDouble(txt_bayar.Text);
double grand_total = Convert.ToDouble(lbl_total.Text);
double kembalian = bayar - grand_total;
lbl_kembalian.Text = Convert.ToString(kembalian);
}
}
private void btn_cari_tgl_Click(object sender, EventArgs e)
{
if ((dtp_awal.Text == "") || (dtp_akhir.Text == ""))
{
MessageBox.Show("Please Input Keywords ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try {
DtlTransaksi dtl_transaksi = new DtlTransaksi();
dtl_transaksi.tgl_transaksi_awal = dtp_awal.Value.ToString("yyyy-MM-dd");
dtl_transaksi.tgl_transaksi_akhir = dtp_akhir.Value.ToString("yyyy-MM-dd");
DataSet ds = new DtlTransasksiDao().FindByDate(dtl_transaksi);
dgv_transaksi.DataSource = ds;
dgv_transaksi.DataMember = "dtl_transaksi";
}
catch (DataException) {
MessageBox.Show("Games Category Not Found !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void btn_hapus_Click(object sender, EventArgs e)
{
if (txt_id_transaksi.Text == "")
{
MessageBox.Show("ID Transaction not selected", "Message", MessageBoxButtons.OK);
return;
}
DialogResult dialogresult = MessageBox.Show("Are You Sure Want to Delete this Data ?", "Alert",
MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dialogresult == DialogResult.Yes)
{
DtlTransaksi dtl = new DtlTransaksi();
dtl.id_transaksi = txt_id_transaksi.Text;
if (new DtlTransasksiDao().DeleteData(dtl))
{
MessageBox.Show("Data Has Been Deleted.", "Message", MessageBoxButtons.OK);
binding();
}
}
}
private void btn_cari_Click(object sender, EventArgs e)
{
if (txt_cari.Text == "")
{
MessageBox.Show("Please Input Keywords ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
DtlTransaksi dtl_transaksi = new DtlTransaksi();
if (cmb_cari.Text == "ID Transaction")
{
try{
dtl_transaksi.id_transaksi = txt_cari.Text;
DataSet ds = new DtlTransasksiDao().FindById(dtl_transaksi);
dgv_transaksi.DataSource = ds;
dgv_transaksi.DataMember = "dtl_transaksi";
eventclickgrid();
}
catch (DataException) {
MessageBox.Show("ID Transaction Not Found !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (cmb_cari.Text == "ID Games")
{
try {
dtl_transaksi.id_games = txt_cari.Text;
DataSet ds = new DtlTransasksiDao().FindByCategory(dtl_transaksi);
dgv_transaksi.DataSource = ds;
dgv_transaksi.DataMember = "dtl_transaksi";
eventclickgrid();
}
catch (DataException) {
MessageBox.Show("ID Games Not Found !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
