private Departemen MappingRowToObject(NpgsqlDataReader dtr) { Departemen dept = new Departemen(); dept.Kode_Departemen = dtr["kode_departemen"] is DBNull ? string.Empty : dtr["kode_departemen"].ToString(); dept.Nama_Departemen = dtr["nama_departemen"] is DBNull ? string.Empty : dtr["nama_departemen"].ToString(); return(dept); }
public int Update(Departemen dept) { strSql = "UPDATE departemen SET nama_departemen = @1 WHERE kode_departemen = @2"; using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@1", dept.Nama_Departemen); cmd.Parameters.AddWithValue("@2", dept.Kode_Departemen); return(cmd.ExecuteNonQuery()); } }
//Method CRUD (Insert, Update, Delete, Select) public int Save(Departemen dept) { strSql = "INSERT INTO departemen (kode_departemen, nama_departemen) VALUES (@1, @2)"; using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@1", dept.Kode_Departemen); cmd.Parameters.AddWithValue("@2", dept.Nama_Departemen); return(cmd.ExecuteNonQuery()); } }
public bool cekRecord(string kodDept) { Departemen dept = GetByKodeDepartemen(kodDept); if (dept != null) { return(true); } else { return(false); } }
public Departemen GetByKodeDepartemen(string kodDept) { Departemen dept = null; strSql = "SELECT * FROM departemen WHERE kode_departemen = @1"; using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@1", kodDept); using (NpgsqlDataReader dtr = cmd.ExecuteReader()) { if (dtr.Read()) { dept = MappingRowToObject(dtr); } } } return(dept); }
private void btnSimpan_Click(object sender, EventArgs e) { try { if (txtKodeDepartemen.Text == "" || txtNamaDepartemen.Text == "") { statusStripDeptPanel1("Field Kode_Departemen atau Nama_Departemen tidak boleh kosong !", Color.Yellow); } else { Departemen dept = new Departemen(); dept.Kode_Departemen = txtKodeDepartemen.Text; dept.Nama_Departemen = txtNamaDepartemen.Text; //Cek Record tabel Departemen apakah sudah ada kode_departemen terkait ? resultBool = deptDAO.cekRecord(txtKodeDepartemen.Text); if (resultBool == false) { result = deptDAO.Save(dept); if (result > 0) { statusStripDeptPanel1("Data berhasil disimpan.", Color.Green); clearTextBox(); loadDataDepartemen(); } else { statusStripDeptPanel1("Data gagal disimpan.", Color.Red); } } else //Meng-update data departemen { if (msgBoxWarning("Anda yakin akan mengubah data Departemen dengan Kode = " + txtKodeDepartemen.Text + " ?") == true) { result = deptDAO.Update(dept); if (result > 0) { statusStripDeptPanel1("Data berhasil diubah.", Color.Green); clearTextBox(); loadDataDepartemen(); } else { statusStripDeptPanel1("Data gagal diubah.", Color.Red); } } else { clearTextBox(); } } } } catch (Exception ex) { errorDBox(ex.Message.ToString(), "btnSimpan_Click"); } }