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