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