private Status_Pajak MappingRowToObject(NpgsqlDataReader dtr)
{
Status_Pajak stPj = new Status_Pajak();
stPj.Kode_Status_Pajak = dtr["kode_status_pajak"] is DBNull ? string.Empty : dtr["kode_status_pajak"].ToString();
stPj.Keterangan = dtr["keterangan"] is DBNull ? string.Empty : dtr["keterangan"].ToString();
return(stPj);
}
//Method CRUD. Insert, Update, Delete, Select
public int Save(Status_Pajak stPj)
{
strSql = "INSERT INTO status_pajak (kode_status_pajak, keterangan) VALUES (@1, @2)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", stPj.Kode_Status_Pajak);
cmd.Parameters.AddWithValue("@2", stPj.Keterangan);
return(cmd.ExecuteNonQuery());
}
}
public int Update(Status_Pajak stPj)
{
strSql = "UPDATE status_pajak SET kode_status_pajak = @1, keterangan = @2 WHERE kode_status_pajak = @3";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", stPj.Kode_Status_Pajak);
cmd.Parameters.AddWithValue("@2", stPj.Keterangan);
cmd.Parameters.AddWithValue("@3", stPj.Kode_Status_Pajak);
return(cmd.ExecuteNonQuery());
}
}
public bool cekRecord(string kodStp)
{
Status_Pajak stPj = GetByKodeStatus(kodStp);
if (stPj != null)
{
return(true);
}
else
{
return(false);
}
}
public Status_Pajak GetByKodeStatus(string kodStp)
{
Status_Pajak stPj = null;
strSql = "SELECT * FROM status_pajak WHERE kode_status_pajak = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", kodStp);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
stPj = MappingRowToObject(dtr);
}
}
}
return(stPj);
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
if (txtKodeStatusPajak.Text == "")
{
statusStripStatusPajakPanel1("Field Kode Status Pajak tidak boleh kosong !!!", Color.Yellow);
}
else
{
Status_Pajak stPj = new Status_Pajak();
stPj.Kode_Status_Pajak = txtKodeStatusPajak.Text;
stPj.Keterangan = txtKeterangan.Text;
//Cek Record Level apakah sudah ada atau belum, guna menentukan operasi
//Update atau Save
resultBool = stPjDAO.cekRecord(txtKodeStatusPajak.Text);
if (resultBool == false) //Data Level masih kosong jadi bisa disimpan
{
result = stPjDAO.Save(stPj);
if (result > 0)
{
statusStripStatusPajakPanel1("Data berhasil disimpan.", Color.Green);
clearTextBox();
txtKodeStatusPajak.Focus();
loadDataStatusPajak();
}
else
{
statusStripStatusPajakPanel1("Data gagal disimpan.", Color.Red);
}
}
else //Meng-update data level
{
if (msgBoxWarning("Anda yakin akan mengubah data Status Pajak dengan Kode = " + txtKodeStatusPajak.Text + " ?") == true)
{
result = stPjDAO.Update(stPj);
if (result > 0)
{
statusStripStatusPajakPanel1("Data berhasil diubah.", Color.Green);
clearTextBox();
txtKodeStatusPajak.Focus();
loadDataStatusPajak();
}
else
{
statusStripStatusPajakPanel1("Data gagal diubah.", Color.Red);
}
}
else
{
clearTextBox();
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
