private Upah MappingRowToObject(NpgsqlDataReader dtr)
{
Upah up = new Upah();
up.Kode_Upah = dtr["kode_upah"] is DBNull ? string.Empty : dtr["kode_upah"].ToString();
up.Tipe_Upah = dtr["tipe_upah"] is DBNull ? string.Empty : dtr["tipe_upah"].ToString();
return(up);
}
public int Update(Upah up)
{
strSql = "UPDATE upah SET tipe_upah = @1 WHERE kode_upah = @2";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", up.Tipe_Upah);
cmd.Parameters.AddWithValue("@2", up.Kode_Upah);
return(cmd.ExecuteNonQuery());
}
}
//Method CRUD. Insert, Update, Delete, Select
public int Save(Upah up)
{
strSql = "INSERT INTO upah (kode_upah, tipe_upah) VALUES (@1, @2)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", up.Kode_Upah);
//cmd.Parameters.AddWithValue("@1", "1");
cmd.Parameters.AddWithValue("@2", up.Tipe_Upah);
return(cmd.ExecuteNonQuery());
}
}
public bool cekRecord(string kodUP)
{
Upah up = GetByKodeUpah(kodUP);
if (up != null)
{
return(true);
}
else
{
return(false);
}
}
public Upah GetByKodeUpah(string kodUP)
{
Upah up = null;
strSql = "SELECT * FROM upah WHERE kode_upah = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", kodUP);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
up = MappingRowToObject(dtr);
}
}
}
return(up);
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
if (txtKode.Text == "" || txtTipeUpah.Text == "")
{
statusStripUPPanel1("Field Kode dan Tipe Upah tidak boleh kosong !!!", Color.Yellow);
}
else
{
Upah up = new Upah();
up.Kode_Upah = txtKode.Text;
up.Tipe_Upah = txtTipeUpah.Text;
resultBool = upDAO.cekRecord(txtKode.Text);
if (resultBool == false) //Data Lokasi Kerja masih kosong jadi bisa disimpan
{
result = upDAO.Save(up);
if (result > 0)
{
statusStripUPPanel1("Data berhasil disimpan.", Color.Green);
clearTextBox();
txtKode.Focus();
loadDataUpah();
}
else
{
statusStripUPPanel1("Data gagal disimpan.", Color.Red);
}
}
else //Meng-update data lokasi kerja
{
if (msgBoxWarning("Anda yakin akan mengubah data Upah dengan Kode = " + txtKode.Text + " ?") == true)
{
result = upDAO.Update(up);
if (result > 0)
{
statusStripUPPanel1("Data berhasil diubah.", Color.Green);
clearTextBox();
txtKode.Focus();
loadDataUpah();
}
else
{
statusStripUPPanel1("Data gagal diubah.", Color.Red);
}
}
else
{
clearTextBox();
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
