private void fillTextBox(Informasi_Email iem)
{
txtNIK.Text = iem.NIK;
txtAlamatEmailSekarang.Text = iem.Alamat_Email;
txtAlamatEmailBaru.Text = "";
cmbKepemilikanEmail.SelectedItem = iem.Kepemilikan_Email.ToString();
}
public Informasi_Email GetByAlamatEmailAndNik(string emailAddr, string nik)
{
Informasi_Email iem = null;
strSql = "SELECT * FROM informasi_email WHERE alamat_email = @1 AND nik = @2";
//strSql = "SELECT * FROM informasi_email WHERE alamat_email = '*****@*****.**' AND nik = '1.1.12.0153'";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", emailAddr);
cmd.Parameters.AddWithValue("@2", nik);
//cmd.Parameters.AddWithValue("@1", "*****@*****.**");
//cmd.Parameters.AddWithValue("@2", "1.1.12.0153");
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
//iem = MappingRowToObject(dtr);
if (dtr.Read())
{
iem = MappingRowToObject(dtr);
}
}
}
return(iem);
}
private void FillToListView(Informasi_Email email)
{
ListViewItem item = new ListViewItem(email.Id.ToString());
item.SubItems.Add(email.Alamat_Email);
item.SubItems.Add(email.Kepemilikan_Email);
item.SubItems.Add(email.NIK);
lvwListAllEmail.Items.Add(item);
}
private Informasi_Email MappingRowToObject(NpgsqlDataReader dtr)
{
Informasi_Email iem = new Informasi_Email();
iem.Id = dtr["id_inform_email"] is DBNull ? 0 : (int)dtr["id_inform_email"];
iem.Alamat_Email = dtr["alamat_email"] is DBNull ? string.Empty : dtr["alamat_email"].ToString();
iem.Kepemilikan_Email = dtr["kepemilikan_email"] is DBNull ? string.Empty : dtr["kepemilikan_email"].ToString();
iem.NIK = dtr["nik"] is DBNull ? string.Empty : dtr["nik"].ToString();
return(iem);
}
public bool cekRecord(string emailAddr, string nik)
{
Informasi_Email iem = GetByAlamatEmailAndNik(emailAddr, nik);
if (iem != null)
{
return(true);
}
else
{
return(false);
}
}
public int Update(Informasi_Email iem, string emailAddrLama)
{
//strSql = "UPDATE informasi_email SET alamat_email = @1, kepemilikan_email = @2, WHERE nik = @3 AND alamat_email = @4";
strSql = "UPDATE informasi_email SET alamat_email = @1, kepemilikan_email = @2 WHERE nik = @3 AND alamat_email = @4";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", iem.Alamat_Email);
cmd.Parameters.AddWithValue("@2", iem.Kepemilikan_Email);
cmd.Parameters.AddWithValue("@3", iem.NIK);
cmd.Parameters.AddWithValue("@4", emailAddrLama);
return(cmd.ExecuteNonQuery());
}
}
//Method CRUD. Insert, Update, Delete, Select
public int Save(Informasi_Email iem)
{
//strSql = "INSERT INTO informasi_email (id_inform_email, alamat_email, kepemilikan_email, nik) VALUES (@1, @2, @3, @4)";
strSql = "INSERT INTO informasi_email (id_inform_email, alamat_email, kepemilikan_email, nik) VALUES (DEFAULT, @2, @3, @4)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
//cmd.Parameters.AddWithValue("@1", iem.Id);
cmd.Parameters.AddWithValue("@2", iem.Alamat_Email);
cmd.Parameters.AddWithValue("@3", iem.Kepemilikan_Email);
cmd.Parameters.AddWithValue("@4", iem.NIK);
return(cmd.ExecuteNonQuery());
}
}
private void FillToListView(Informasi_Email email)
{
try
{
//int noUrut = lvwInformasiEmail.Items.Count + 1;
ListViewItem item = new ListViewItem(email.Id.ToString());
//item.SubItems.Add(email.Id.ToString());
item.SubItems.Add(email.Alamat_Email);
item.SubItems.Add(email.Kepemilikan_Email);
lvwInformasiEmail.Items.Add(item);
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "FillToListView");
}
}
public Informasi_Email GetByAlamatEmail(string emailAddr)
{
Informasi_Email iem = null;
strSql = "SELECT * FROM informasi_email WHERE alamat_email = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", emailAddr);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
iem = MappingRowToObject(dtr);
}
}
}
return(iem);
}
private void fillTextBox()
{
daftarEmail = iemDAO.GetByNIK(txtNIK.Text);
if (daftarEmail.Count > 0)
{
Informasi_Email iem = daftarEmail[0];
txtAlamatEmailSekarang.Text = iem.Alamat_Email;
txtAlamatEmailBaru.Text = "";
cmbKepemilikanEmail.Text = iem.Kepemilikan_Email;
txtAlamatEmailBaru.Focus();
}
else
{
txtAlamatEmailSekarang.Clear();
txtAlamatEmailBaru.Clear();
cmbKepemilikanEmail.Text = null;
lblTambahEmail.Focus();
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
if (txtAlamatEmailSekarang.ReadOnly == true && txtAlamatEmailBaru.ReadOnly == true)
{
lblMsgString("Klik Ubah untuk mengubah data. Dan klik Tambah untuk menambah data.", Color.Yellow);
}
else
{
Informasi_Email iem = new Informasi_Email();
if (txtAlamatEmailSekarang.ReadOnly == false && txtAlamatEmailBaru.ReadOnly == true) //Tambah
{
if (txtAlamatEmailSekarang.Text == "" || cmbKepemilikanEmail.Text == "") //Field harus diisi
{
lblMsgString("Field Alamat Email dan Kepemilikan Email harus diisi !", Color.Yellow);
}
else
{
//MessageBox.Show("iemDAO.cekRecord(" + txtAlamatEmailSekarang.Text + ", " + txtNIK.Text + ")");
resultBool = iemDAO.cekRecord(txtAlamatEmailSekarang.Text, txtNIK.Text);
//MessageBox.Show("resultBool = " + resultBool.ToString());
//MessageBox.Show("Enter Method : resultIEM = iemDAO.cekRecordIEM(txtAlamatEmailSekarang.Text, txtNIK.Text);");
//Informasi_Email resultIEM = iemDAO.cekRecordIEM(txtAlamatEmailSekarang.Text, txtNIK.Text);
//MessageBox.Show("Alamat Email Hasil Cek yang didapat = " + resultIEM.Alamat_Email);
if (resultBool == false) //Record belum ada, maka tambahkan ke database
{
iem.NIK = txtNIK.Text;
iem.Alamat_Email = txtAlamatEmailSekarang.Text;
iem.Kepemilikan_Email = cmbKepemilikanEmail.Text;
object[] data = new object[] { iem.Alamat_Email, iem.Kepemilikan_Email };
//resultBool = iemDAO.cekRecord(txtAlamatEmailBaru.Text, txtNIK.Text);
result = iemDAO.Save(iem);
if (result > 0)
{
lblMsgString("Data berhasil disimpan.", Color.Green);
//fillTextBox(iem);
loadDaftarEmailByNik(txtNIK.Text);
int jmlEmail = countJmlEmailByNIK(txtNIK.Text);
fillTextBoxMainForm(data, jmlEmail, init);
//Update View neighbor form
if (fLAIE != null)
{
fLAIE.refreshEmailList();
}
}
else
{
lblMsgString("Data gagal disimpan.", Color.Red);
}
}
else
{
lblMsgString("Alamat Email sudah ada !", Color.Yellow);
}
}
}
else if (txtAlamatEmailSekarang.ReadOnly == true && txtAlamatEmailBaru.ReadOnly == false) //Ubah / Update
{
if (cmbKepemilikanEmail.Text == "") //Field harus diisi
{
lblMsgString("Informasi kepemilikan email harus diisi !", Color.Yellow);
}
else
{
if (msgBoxWarning("Anda yakin akan mengubah data Email Karyawan dengan NIK = " + txtNIK.Text + " ?") == true)
{
if (txtAlamatEmailSekarang.Text == "") //Field harus isi
{
lblMsgString("Field Alamat Email Lama tidak boleh kosong !", Color.Yellow);
}
else
{
if (txtAlamatEmailBaru.Text == "")
{
iem.NIK = txtNIK.Text;
iem.Alamat_Email = txtAlamatEmailSekarang.Text;
iem.Kepemilikan_Email = cmbKepemilikanEmail.Text;
}
else
{
iem.NIK = txtNIK.Text;
iem.Alamat_Email = txtAlamatEmailBaru.Text;
iem.Kepemilikan_Email = cmbKepemilikanEmail.Text;
}
object[] data = new object[] { iem.Alamat_Email, iem.Kepemilikan_Email };
result = iemDAO.Update(iem, txtAlamatEmailSekarang.Text);
if (result > 0)
{
lblMsgString("Data berhasil diubah.", Color.Green);
//fillTextBox(iem);
int jmlEmail = countJmlEmailByNIK(txtNIK.Text);
fillTextBoxMainForm(data, jmlEmail, init);
loadDaftarEmailByNik(txtNIK.Text);
//Refress Email List On Neighbor Form
if (fLAIE != null)
{
fLAIE.refreshEmailList();
}
}
else
{
lblMsgString("Data gagal diubah.", Color.Red);
}
}
}
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
public Informasi_Email cekRecordIEM(string emailAddr, string nik)
{
Informasi_Email iem = GetByAlamatEmailAndNik(emailAddr, nik);
return(iem);
}
