public bool UpdateData(MasterTransaksi mstr_trns)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "UPDATE master_transaksi SET status_transaksi=1, total='" + mstr_trns.total + "' WHERE id_transaksi='" + mstr_trns.id_transaksi + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool GetStatusKosong(MasterTransaksi mstr_trns)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT status_transaksi FROM master_transaksi WHERE status_transaksi = 0";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool InsertData(MasterTransaksi mstr_trns)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "INSERT INTO master_transaksi VALUES ('" + mstr_trns.id_transaksi + "','" + mstr_trns.status + "', '" + mstr_trns.total + "')";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
private void btn_simpan_Click(object sender, EventArgs e)
{
MasterTransaksi mstr_trns = new MasterTransaksi();
mstr_trns.id_transaksi = txt_id_transaksi.Text;
mstr_trns.total = Convert.ToDouble(lbl_total.Text);
if (new MasterTransaksiDao().UpdateData(mstr_trns))
{
MessageBox.Show("Data Transaaction Has Been Saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
binding();
GenerateRandom(randomstring);
lbl_kembalian.Text = "";
txt_bayar.Text = "";
lbl_total.Text = "";
}
public DataSet GetStatusTransaksiKosong(MasterTransaksi mstr_trns)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT status_transaksi FROM master_transaksi WHERE status_transaksi = 0";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "master_transaksi");
conn.Close();
return(ds);
}
public void GenerateRandom(string randomstring)
{
MasterTransaksi mstr_trns = new MasterTransaksi();
// Create Random ID Transaction
char[] acak = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890".ToCharArray();
Random rand = new Random();
randomstring = "";
for (int i = 0; i < 10; i++)
{
randomstring += acak[rand.Next(0, 10)].ToString();
}
//Insert ID Transaction
txt_id_transaksi.Text = randomstring;
mstr_trns.id_transaksi = txt_id_transaksi.Text;
if (new MasterTransaksiDao().InsertData(mstr_trns))
{
this.DialogResult = DialogResult.OK;
}
return;
}
