public void binding()
{
DataSet data = new DtlTransasksiDao().ShowTransaction();
dgv_transaksi.DataSource = data;
dgv_transaksi.DataMember = "db_ticket";
DataGridViewColumn column0 = dgv_transaksi.Columns[0];
column0.Width = 125;
column0.HeaderText = "ID Order";
DataGridViewColumn column1 = dgv_transaksi.Columns[1];
column1.Width = 125;
column1.HeaderText = "ID Transaction";
DataGridViewColumn column2 = dgv_transaksi.Columns[2];
column2.Width = 150;
column2.HeaderText = "Transaction Date";
DataGridViewColumn column3 = dgv_transaksi.Columns[3];
column3.Width = 100;
column3.HeaderText = "Employee ID";
DataGridViewColumn column4 = dgv_transaksi.Columns[4];
column4.Width = 100;
column4.HeaderText = "Games ID";
DataGridViewColumn column5 = dgv_transaksi.Columns[5];
column5.Width = 150;
column5.HeaderText = "Game Category";
DataGridViewColumn column6 = dgv_transaksi.Columns[6];
column6.Width = 100;
column6.HeaderText = "Price";
DataGridViewColumn column7 = dgv_transaksi.Columns[7];
column7.Width = 50;
column7.HeaderText = "Amount";
DataGridViewColumn column8 = dgv_transaksi.Columns[8];
column8.Width = 100;
column8.HeaderText = "Total";
}
private void Frm_rpt_ticket_Load(object sender, EventArgs e)
{
DataSet data = new DtlTransasksiDao().ShowTransaction();
DataTable dt = new DataTable();
dt = data.Tables[0];
Cr_ticket obj_rpt = new Cr_ticket();
obj_rpt.SetDataSource(dt);
Crv_ticket.ReportSource = obj_rpt;
Crv_ticket.Refresh();
}
private void btn_tambah_Click(object sender, EventArgs e)
{
// Insert Data in Form
Frm_tmbh_transaksi frm_tmbh = new Frm_tmbh_transaksi(id_pegawai, txt_id_transaksi.Text);
if (frm_tmbh.ShowDialog() == DialogResult.OK)
{
MessageBox.Show("Data Has Been Added To Cart", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
binding();
DataSet ds = new DtlTransasksiDao().GrandTotal(dtl);
lbl_total.Text = ds.Tables[0].Rows[0][0].ToString();
}
}
//Get Data From databases, post to Data Grid View
public void binding()
{
DataSet data = new DtlTransasksiDao().CountTicket(dtl);
dgv_transaksi.DataSource = data;
dgv_transaksi.DataMember = "db_ticket";
DataGridViewColumn column0 = dgv_transaksi.Columns[0];
column0.Width = 125;
column0.HeaderText = "Transaction ID";
DataGridViewColumn column1 = dgv_transaksi.Columns[1];
column1.Width = 125;
column1.HeaderText = "Transaction Date";
DataGridViewColumn column2 = dgv_transaksi.Columns[2];
column2.Width = 80;
column2.HeaderText = "Games ID";
DataGridViewColumn column3 = dgv_transaksi.Columns[3];
column3.Width = 150;
column3.HeaderText = "Games Category";
DataGridViewColumn column4 = dgv_transaksi.Columns[4];
column4.Width = 50;
column4.HeaderText = "Price";
DataGridViewColumn column5 = dgv_transaksi.Columns[5];
column5.Width = 50;
column5.HeaderText = "Amount";
DataGridViewColumn column6 = dgv_transaksi.Columns[6];
column6.Width = 100;
column6.HeaderText = "Total";
}
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_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);
}
}
}