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"); } }