public int Update(Status_Pekerja stP)
{
strSql = "UPDATE status_pekerja SET nama_status = @1 WHERE kode_status = @2";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", stP.Status);
cmd.Parameters.AddWithValue("@2", stP.Kode_Status);
return(cmd.ExecuteNonQuery());
}
}
//Method CRUD. Insert, Update, Delete, Select
public int Save(Status_Pekerja stP)
{
strSql = "INSERT INTO status_pekerja (kode_status, nama_status) VALUES (@1, @2)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", stP.Kode_Status);
cmd.Parameters.AddWithValue("@2", stP.Status);
return(cmd.ExecuteNonQuery());
}
}
public bool cekRecord(string kodStat)
{
Status_Pekerja stP = GetByKodeStatus(kodStat);
if (stP != null)
{
return(true);
}
else
{
return(false);
}
}
private Status_Pekerja MappingRowToObject(NpgsqlDataReader dtr)
{
Status_Pekerja stP = new Status_Pekerja();
//stP.Kode_Status = dtr[0] is DBNull ? string.Empty : dtr[0].ToString();
//stP.Status = dtr[1] is DBNull ? string.Empty : dtr[1].ToString();
//stP.Kode_Status = dtr["kode_status_pekerja"] is DBNull ? string.Empty : dtr["kode_status_pekerja"].ToString();
//stP.Status = dtr["status_pekerja"] is DBNull ? string.Empty : dtr["status_pekerja"].ToString();
stP.Kode_Status = dtr["kode_status"] is DBNull ? string.Empty : dtr["kode_status"].ToString();
stP.Status = dtr["nama_status"] is DBNull ? string.Empty : dtr["nama_status"].ToString();
return(stP);
}
public Status_Pekerja GetByKodeStatus(string kodStat)
{
Status_Pekerja stP = null;
strSql = "SELECT * FROM status_pekerja WHERE kode_status = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", kodStat);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
stP = MappingRowToObject(dtr);
}
}
}
return(stP);
}
private void btnHapus_Click(object sender, EventArgs e)
{
try
{
Status_Pekerja stP = new Status_Pekerja();
stP.Kode_Status = txtKodeStatus.Text;
if (txtKodeStatus.Text == "")
{
statusStripStPPanel1("Tentukan Kode_Status yang akan dihapus !", Color.Yellow);
}
else
{
if (msgBoxWarning("Apakah anda yakin akan menghapus data Status Pekerja dengan Kode \"" + stP.Kode_Status + "\" ?") == true)
{
result = stPDAO.Delete(stP.Kode_Status);
if (result > 0)
{
statusStripStPPanel1("Data berhasil dihapus.", Color.Green);
}
else
{
statusStripStPPanel1("Data gagal dihapus.", Color.Red);
}
}
else
{
clearTextBox();
}
loadDataStatusPekerja();
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnHapus_Click");
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
if (txtKodeStatus.Text == "" || txtStatus.Text == "")
{
statusStripStPPanel1("Field Kode_Status maupun Status tidak boleh kosong !", Color.Yellow);
}
else
{
Status_Pekerja sTP = new Status_Pekerja();
sTP.Kode_Status = txtKodeStatus.Text;
sTP.Status = txtStatus.Text;
//Tentukan operasi Update atau Save
resultBool = stPDAO.cekRecord(sTP.Kode_Status);
if (resultBool == false) //Operasi Save
{
result = stPDAO.Save(sTP);
if (result > 0)
{
statusStripStPPanel1("Data berhasil disimpan.", Color.Green);
clearTextBox();
loadDataStatusPekerja();
}
else
{
statusStripStPPanel1("Data gagal disimpan.", Color.Red);
}
}
else //Operasi Update
{
if (msgBoxWarning("Anda yakin akan mengubah data Status Pekerja dengan Kode = " + sTP.Kode_Status.ToString() + " ?") == true)
//if (msgBoxWarning("Anda yakin akan mengubah data Status Pekerja dengan Kode = " + txtKodeStatus.Text + " ?") == true)
{
result = stPDAO.Update(sTP);
if (result > 0)
{
statusStripStPPanel1("Data berhasil diubah.", Color.Green);
clearTextBox();
loadDataStatusPekerja();
}
else
{
statusStripStPPanel1("Data gagal diubah.", Color.Red);
}
}
else
{
clearTextBox();
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
