private void btn_ubah_Click_1(object sender, EventArgs e)
{
gaji obj_gj = new gaji();
obj_gj.nik = txt_nik.Text;
obj_gj.gajipokok = Convert.ToString(txt_gajipokok.Text);
obj_gj.tunjangan = Convert.ToString(txt_tunjangan.Text);
if (new gaji_dao().updatedata(obj_gj))
{
MessageBox.Show("Ubah Data Berhasil ");
binding();
}
}
private void btn_ubah_Click(object sender, EventArgs e)
{
gaji g = new gaji();
g.nik = txt_nik.Text;
g.gajipokok = txt_gajipokok.Text;
g.tunjangan = txt_tunjangan.Text;
if (new gaji_dao().updatedata(g))
{
MessageBox.Show("Data Berhasil di ubah");
binding();
}
}
public bool hapusdata(gaji g)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "DELETE FROM t_penggajian WHERE `nik` = '" + g.nik + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool updatedata(gaji obj_gj)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "UPDATE t_penggajian " + "SET gaji_pokok ='" + obj_gj.gajipokok + "'," + "tunjangan='" + obj_gj.tunjangan + "'" + "WHERE nik='" + obj_gj.nik + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool insertdata(gaji g)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "INSERT INTO t_penggajian VALUES ('" + g.nik + "'," +
"'" + g.gajipokok + "','" + g.tunjangan + "')";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public DataSet caridata_tunjangan(gaji g)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT * FROM t_penggajian WHERE tunjangan = '" + g.tunjangan + "'";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "db_indomart");
conn.Close();
return(ds);
}
public DataSet caridata_nik(gaji g)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT t_karyawan.`Nik`, t_karyawan.`Nama_Karyawan`, t_karyawan.`Jabatan` , t_penggajian.`gaji_pokok`, t_penggajian.`tunjangan` FROM t_karyawan INNER JOIN t_penggajian ON t_karyawan.`Nik` = t_penggajian.`Nik`";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "db_indomart");
conn.Close();
return(ds);
}
private void btn_simpan_Click(object sender, EventArgs e)
{
try
{
gaji g = new gaji();
g.nik = cb_nik.Text;
g.gajipokok = Convert.ToString(txt_gajipokok.Text);
g.tunjangan = Convert.ToString(txt_tunjangan.Text);
if (new gaji_dao().insertdata(g))
{
this.DialogResult = DialogResult.OK;
}
}
catch
{
MessageBox.Show("Nik Sudah Ada");
}
}
private void btn_hapus_Click_1(object sender, EventArgs e)
{
gaji g = new gaji();
g.nik = txt_nik.Text;
if (txt_nik.Text == "")
{
MessageBox.Show("Nik Tidak Boleh Kosong");
}
DialogResult dialogresult = MessageBox.Show("Apakah Anda Akan Menghapus Data", "Pesan", MessageBoxButtons.YesNo);
if (dialogresult == DialogResult.Yes)
{
if (new gaji_dao().hapusdata(g))
{
MessageBox.Show("Hapus Data Berhasil");
binding();
}
}
}
private void btn_hapus_Click(object sender, EventArgs e)
{
if (txt_nik.Text == "")
{
MessageBox.Show("NIK Kosong", "pesan", MessageBoxButtons.OK);
return;
}
DialogResult dialodResult = MessageBox.Show("Apakah data akan di hapus?",
"pesan",
MessageBoxButtons.YesNo,
MessageBoxIcon.Error);
if (dialodResult == DialogResult.Yes)
{
gaji g = new gaji();
g.nik = txt_nik.Text;
if (new gaji_dao().hapusdata(g))
{
MessageBox.Show("Data berhasil di Hapus");
binding();
}
}
}
private void btn_cari_Click(object sender, EventArgs e)
{
if (txt_cari.Text == "")
{
MessageBox.Show("Kata Kunci Tidak Boleh Kosong");
}
gaji g = new gaji();
if (cb_cari.Text == "NIK")
{
try
{
g.nik = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_nik(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
catch
{
MessageBox.Show("Tidak Ketemu");
}
}
else if (cb_cari.Text == "Gaji Pokok")
{
g.gajipokok = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_gajipokok(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
else if (cb_cari.Text == "Tunjangan")
{
g.tunjangan = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_tunjangan(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
}
