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