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