private void loadInfoResign()
{
try
{
Informasi_Resign infoResign = irsDAO.GetByNIK(nik);
if (infoResign != null)
{
rbStatusResignNo.Checked = false;
rbStatusResignYes.Checked = true;
//txtTanggalResign.Text = infoResign.Tanggal_Resign.ToString();
txtTanggalResign.Text = string.Format("{0:dd/MM/yyyy}", infoResign.Tanggal_Resign);
txtAlasanResign.Text = infoResign.Alasan_Resign.ToString();
}
else
{
rbStatusResignNo.Checked = true;
rbStatusResignYes.Checked = false;
txtTanggalResign.Text = "";
txtTanggalResign.Enabled = false;
txtAlasanResign.Text = "";
txtAlasanResign.Enabled = false;
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "loadInformasiResign");
}
}
private Informasi_Resign MappingRowToObject(NpgsqlDataReader dtr)
{
Informasi_Resign irs = new Informasi_Resign();
irs.NIK = dtr["nik"] is DBNull ? string.Empty : dtr["nik"].ToString();
irs.Status_Resign = dtr["status_resign"] is DBNull ? string.Empty : dtr["status_resign"].ToString();
irs.Tanggal_Resign = dtr["tanggal_resign"] is DBNull ? DateTime.MinValue : DateTime.Parse(dtr["tanggal_resign"].ToString());
//irs.Tanggal_Resign = dtr["tanggal_resign"] is DBNull ? DateTime.MinValue : DateTime.Parse(string.Format("{0:dd/MM/yyyy}", dtr["tanggal_resign"].ToString()));
irs.Alasan_Resign = dtr["alasan_resign"] is DBNull ? string.Empty : dtr["alasan_resign"].ToString();
return(irs);
}
public bool cekRecord(string nik)
{
Informasi_Resign irs = GetByNIK(nik);
if (irs != null)
{
return(true);
}
else
{
return(false);
}
}
/*
* public List<Informasi_Resign> GetAll()
* {
* List<Informasi_Resign> daftarIrs = new List<Informasi_Resign>();
*
* strSql = "SELECT nik, tanggal_resign, status_resign, alasan_resign ORDER BY nik";
*
* using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
* {
* using (NpgsqlDataReader dtr = cmd.ExecuteReader())
* {
* while (dtr.Read())
* {
* daftarIrs.Add(MappingRowToObject(dtr));
* }
* }
* }
*
* return daftarIrs;
* }
*/
//Method CRUD. Insert, Update, Delete, Select
public int Save(Informasi_Resign irs)
{
strSql = "INSERT INTO informasi_resign (nik, status_resign, tanggal_resign, alasan_resign) VALUES (@1, @2, @3, @4)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", irs.NIK);
cmd.Parameters.AddWithValue("@2", irs.Status_Resign);
cmd.Parameters.AddWithValue("@3", irs.Tanggal_Resign);
cmd.Parameters.AddWithValue("@4", irs.Alasan_Resign);
return(cmd.ExecuteNonQuery());
}
}
public int Update(Informasi_Resign irs)
{
strSql = "UPDATE informasi_resign SET status_resign = @1, tanggal_resign = @2, alasan_resign = @3 WHERE nik = @4";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", irs.Status_Resign);
cmd.Parameters.AddWithValue("@2", irs.Tanggal_Resign);
cmd.Parameters.AddWithValue("@3", irs.Alasan_Resign);
cmd.Parameters.AddWithValue("@4", irs.NIK);
return(cmd.ExecuteNonQuery());
}
}
private void fillTextBox(Informasi_Resign irs)
{
if (irs.Status_Resign.Equals("Yes"))
{
rbStatusResignNo.Checked = false;
rbStatusResignYes.Checked = true;
}
else if (irs.Status_Resign.Equals("No"))
{
rbStatusResignNo.Checked = true;
rbStatusResignYes.Checked = false;
}
txtTanggalResign.Text = string.Format("{0:dd/MM/yyyy}", irs.Tanggal_Resign);
txtAlasanResign.Text = irs.Alasan_Resign;
}
public Informasi_Resign GetByNIK(string nik)
{
Informasi_Resign infoResign = null; //= new Informasi_Resign();
strSql = "SELECT * FROM informasi_resign WHERE nik = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", nik);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
infoResign = (MappingRowToObject(dtr));
}
}
}
return(infoResign);
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
//MessageBox.Show("Tahap awal memasuki method irsDAO.Save()");
if (rbStatusResignNo.Checked == false && rbStatusResignYes.Checked == false)
{
lblMsgString("Cek salah satu status resign.", Color.Yellow);
}
else if (txtAlasanResign.Text == "" || txtTanggalResign.Text == "")
{
lblMsgString("Isi tanggal resign dan alasan resign !!!", Color.Yellow);
}
else
{
//MessageBox.Show("Tahap 2 memasuki method irsDAO.Save()");
resultBool = irsDAO.cekRecord(nik);
//MessageBox.Show("Tahap 3 memasuki irsDAO.Save(). irsDAO.CekRecord(nik) = " + resultBool.ToString());
if (resultBool == false) //Record belum ada, maka tambahkan ke database
{
Informasi_Resign irs = new Informasi_Resign();
irs.NIK = nik;
if (rbStatusResignNo.Checked == true && rbStatusResignYes.Checked == false)
{
irs.Status_Resign = rbStatusResignNo.Text;
}
else if (rbStatusResignNo.Checked == false && rbStatusResignYes.Checked == true)
{
irs.Status_Resign = rbStatusResignYes.Text;
}
//MessageBox.Show("Format tanggal yang anda masukkan adalah : '{1}'", txtTanggalResign.Text);
irs.Tanggal_Resign = DateTime.ParseExact(txtTanggalResign.Text.Trim(), "dd/MM/yyyy", null); //Use Trim() to remove extra white space
irs.Alasan_Resign = txtAlasanResign.Text.Trim(); //Use Trim() to remove extra white space
//MessageBox.Show("Hasil Trim() extra white space pada textbox tsb menghasilkan : {1}", irs.Tanggal_Resign.ToString());
object[] data = new object[] { irs.Status_Resign };
result = irsDAO.Save(irs);
//MessageBox.Show("irsDAO.Save telah di eksekusi...");
if (result > 0)
{
lblMsgString("Data berhasil disimpan.", Color.Green);
fillTextBox(irs);
fillTextBoxMainForm(data, 0, init);
}
else
{
lblMsgString("Data gagal disimpan.", Color.Red);
}
}
else
{
//msgBoxWarning("Data Exist ! Hapus terlebih dahulu data yang ada.");
//lblMsgString("Data Exist ! Hapus terlebih dahulu data yang ada.", Color.Yellow);
if (msgBoxWarning("Anda yakin akan memperbaharui data Informasi Resign karyawan ini ?") == true)
{
Informasi_Resign irs = new Informasi_Resign();
irs.NIK = nik;
irs.Tanggal_Resign = DateTime.ParseExact(txtTanggalResign.Text.Trim(), "dd/MM/yyyy", null);
irs.Alasan_Resign = txtAlasanResign.Text.Trim();
irs.Status_Resign = rbStatusResignYes.Text;
result = irsDAO.Update(irs);
if (result > 0)
{
lblMsgString("Data Informasi Resign berhasil diperbaharui.", Color.Green);
}
else
{
}
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
