public String getNomorIdentitas(tbl_umat temp) { //if (temp.no_k5 == "Null" && temp.no_ktp == "Null") // return temp.no_kk + " / KK"; //else if (temp.no_ktp == "Null" && temp.no_kk == "Null") // return temp.no_k5 + " / K5"; //else if (temp.no_kk == "Null" && temp.no_k5 == "Null") // return temp.no_ktp + " / KTP"; //else // return "Kosong" Debug.Write("ISI NOMOR IDENTIAS : " + " KTP " + temp.no_ktp + " KK " + temp.no_kk + "K5 " + temp.no_k5); if (string.Equals(temp.no_k5, "Null") && string.Equals(temp.no_ktp, "Null")) { return(temp.no_kk + " / KK"); } else if (string.Equals(temp.no_ktp, "Null") && string.Equals(temp.no_kk, "Null")) { return(temp.no_k5 + " / K5"); } else if (string.Equals(temp.no_kk, "Null") && string.Equals(temp.no_k5, "Null")) { return(temp.no_ktp + " / KTP"); } else { return("Kosong"); } }
private void initializeHeader() { tbl_umat umat = umatControl.getDataUmatSatuan(Convert.ToInt32(formIdentitas.idUmat)); Debug.Write("ISI NOMOR IDENTIAS : " + " KTP " + umat.no_ktp + " KK " + umat.no_kk + "K5 " + umat.no_k5); lb_namaKK.Text = umat.nama; lb_nok5.Text = umatControl.getNomorIdentitas(umat); lb_umur.Text = umat.umur.ToString() + " Tahun"; lb_stasi.Text = stasiControl.getNamaStasi(umat.id_stasi); lb_paroki.Text = parokiControl.getNamaParokiByID(umat.id_paroki); lb_jenisKelamin.Text = umat.jenis_kelamin; }
public String insertSamplingUmatBaru(tbl_umat temp) { String balikan; try { balikan = umatAdapter.insertUmat(getLastIndexIDUmatPlusOne(), temp.no_kk, temp.no_k5, temp.no_ktp, temp.nama, temp.umur, temp.jenis_kelamin, temp.no_telp, temp.id_ref_pekerjaan, temp.id_paroki, temp.id_stasi).ToString(); } catch (Exception E) { balikan = E.Message.ToString() + " " + temp.tostr(); } return(balikan); }
public tbl_umat getDataUmatSatuan(int idUmat) { tbl_umat balikan = new tbl_umat(); DataTable temp1 = umatAdapter.getUmatSatuanByIDUmat(idUmat); DataRow row = temp1.Rows[0]; balikan.no_kk = row["no_kk"].ToString(); balikan.no_ktp = row["no_ktp"].ToString(); balikan.no_k5 = row["no_k5"].ToString(); balikan.nama = row["nama"].ToString(); balikan.jenis_kelamin = row["jenis_kelamin"].ToString(); balikan.no_telp = row["no_telp"].ToString(); balikan.id_ref_pekerjaan = Convert.ToInt32(row["id_ref_pekerjaan"]); balikan.id_paroki = Convert.ToInt32(row["id_paroki"].ToString()); balikan.id_stasi = Convert.ToInt32(row["id_stasi"].ToString()); balikan.umur = Convert.ToInt32(row["umur"].ToString()); return(balikan); }
public bool getSamePerson(tbl_umat temp) { String query = "SELECT nama FROM tbl_umat WHERE(nama = @pNama) AND(id_paroki = @pParoki) AND(id_stasi = @pStasi)"; MySqlConnection connection = dbConnector.openConnection("", "", DatabasesConnector.dbEkonomi); connection.Open(); MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.AddWithValue("@pNama", temp.nama); command.Parameters.AddWithValue("@pParoki", temp.id_paroki); command.Parameters.AddWithValue("@pStasi", temp.id_stasi); MySqlDataReader reader = command.ExecuteReader(); DataSet ds = new DataSet(); DataTable balikan = new DataTable(); ds.Tables.Add(balikan); ds.EnforceConstraints = false; balikan.Load(reader); reader.Close(); return(balikan.Rows.Count > 0); }
private void btnSimpan_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.edtNamaKepalaKeluarga.Text) || string.IsNullOrWhiteSpace(this.edtNoK5.Text) || string.IsNullOrWhiteSpace(this.edtUmur.Text)) { MessageBox.Show("Silahkan isi data detail kepala keluarga terlebih dahulu!"); } else if (!edtUmur.Text.All(char.IsDigit)) { MessageBox.Show("Kolom umur hanya dapat diisi dengan angka saja!"); } else { tbl_umat temp = new tbl_umat(); temp.nama = this.edtNamaKepalaKeluarga.Text.ToString(); temp.umur = Convert.ToInt32(this.edtUmur.Text); temp.jenis_kelamin = this.cmbKelamin.SelectedValue.ToString(); temp.id_ref_pekerjaan = Convert.ToInt32(this.cmbPekerjaan.SelectedValue); temp.id_paroki = Convert.ToInt32(this.cmbParoki.SelectedValue); temp.id_stasi = Convert.ToInt32(this.cmbStasi.SelectedValue); if (this.radioK5.Checked) { temp.no_k5 = this.edtNoK5.Text; temp.no_kk = "Null"; temp.no_ktp = "Null"; ; } else if (this.radioKK.Checked) { temp.no_kk = this.edtNoK5.Text; temp.no_k5 = "Null"; temp.no_ktp = "Null"; } else if (this.radioKTP.Checked) { temp.no_ktp = this.edtNoK5.Text; temp.no_k5 = "Null"; temp.no_kk = "Null"; } if (string.IsNullOrWhiteSpace(this.edtNoTelp.Text)) { temp.no_telp = "Null"; } else { temp.no_telp = this.edtNoTelp.Text; } try { if (umatControl.insertSamplingUmatBaru(temp) == "1") { MessageBox.Show("Data umat baru berhasil dimasukan, silahkan isi data hasil sampling pada form berikutnya!"); idUmat = umatControl.getLastID(); GlobalParam.id_umat = Convert.ToInt32(idUmat); this.Hide(); formKondisiTempatTinggal formKondisiTempatTinggal = new formKondisiTempatTinggal(); formKondisiTempatTinggal.ShowDialog(); this.Close(); } else { MessageBox.Show("Data gagal dimasukan, silahkan hubungi admin!"); } } catch (Exception E) { MessageBox.Show("Data gagal dimasukan dengan error code : " + E.Message.ToString()); } } }