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