public bool udpdateData(Tranksaksi t, string id_tranksaksi)
{
Boolean stat = false;
try
{
konek.Open();
cmd = new MySqlCommand();
cmd.Connection = konek;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE tranksaksi SET tgl_masuk='" + t.tgl_masuk + "'," +
"tgl_keluar='" + t.tgl_keluar + "'," +
"nama_layanan='" + t.nama_layanan + "'," +
"nama_barang='" + t.nama_barang + "'," +
"banyak_barang='" + t.banyak_barang + "'," +
"harga='" + t.harga + "'," +
"total_harga='" + t.total_harga + "'," +
"id_user='******' WHERE id_tranksaksi='" + id_tranksaksi + "'";
cmd.ExecuteNonQuery();
stat = true;
konek.Close();
}
catch (MySqlException)
{
Console.WriteLine("gagal di update");
}
return(stat);
}
private void button1_Click(object sender, EventArgs e)
{
int a, b;//ubah properties semuanya
int.TryParse(textBox1.Text, out a);
int.TryParse(textBox2.Text, out b);
textBox3.Text = Convert.ToString(a * b);
Tranksaksi t = new Tranksaksi();
t.tgl_masuk = dateTimePicker1.Value.ToString("yyyy/MM/dd");
t.tgl_keluar = dateTimePicker2.Value.ToString("yyyy/MM/dd");
t.nama_layanan = comboBox1.Text;
t.nama_barang = comboBox2.Text;
t.banyak_barang = textBox1.Text;
t.harga = textBox2.Text;
t.total_harga = textBox3.Text;
t.id_user = comboBox3.Text;
td.insertData(t);
lihatSemuaData();
}
public bool insertData(Tranksaksi tf)
{
Boolean stat = false;
try
{
konek.Open();
cmd = new MySqlCommand();
cmd.Connection = konek;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO tranksaksi (tgl_masuk, tgl_keluar, nama_layanan, nama_barang, " +
"banyak_barang, harga, total_harga, id_user) " +
"VALUES ('" + tf.tgl_masuk + "','" + tf.tgl_keluar + "','" + tf.nama_layanan + "','"
+ tf.nama_barang + "','" + tf.banyak_barang + "','" + tf.harga + "','" + tf.total_harga + "','" + tf.id_user + "')";
cmd.ExecuteNonQuery();
stat = true;
konek.Close();
}
catch (MySqlException)
{
Console.WriteLine("gagal di insert");
}
return(stat);
}