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