protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.LayDeathAdd);
txtfname = FindViewById <EditText> (Resource.Id.txtfname);
txtlname = FindViewById <EditText> (Resource.Id.txtlname);
txtexname = FindViewById <EditText> (Resource.Id.txtexname);
txtbday = FindViewById <EditText> (Resource.Id.txtageatdeath);
spngender = FindViewById <Spinner> (Resource.Id.spngender);
spndeathcert = FindViewById <Spinner> (Resource.Id.spndeathcert);
spnregisterdeath = FindViewById <Spinner> (Resource.Id.spnregisterdeath);
var adaptergender = ArrayAdapter.CreateFromResource(
this, Resource.Array.Gender_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adaptergender.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spngender.Adapter = adaptergender;
var adpdeathcert = ArrayAdapter.CreateFromResource(
this, Resource.Array.Death_certificate, Android.Resource.Layout.SimpleSpinnerItem);
adpdeathcert.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spndeathcert.Adapter = adpdeathcert;
var adpregisterdeath = ArrayAdapter.CreateFromResource(
this, Resource.Array.Death_register, Android.Resource.Layout.SimpleSpinnerItem);
adpregisterdeath.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnregisterdeath.Adapter = adpregisterdeath;
var items = ConDeath.GetListSingle("select * from tblDeath where id='" + Intent.GetStringExtra("death_id") + "'");
txtfname.Text = items.fname;
txtlname.Text = items.lname;
txtexname.Text = items.ename;
txtbday.Text = items.age_death;
string[] array;
array = Resources.GetStringArray(Resource.Array.Gender_Spinner);
fcnspinner(spngender, array, items.gender);
array = Resources.GetStringArray(Resource.Array.Death_certificate);
fcnspinner(spndeathcert, array, items.birthcertificate);
array = Resources.GetStringArray(Resource.Array.Death_register);
fcnspinner(spnregisterdeath, array, items.register);
btnAddaddress = FindViewById <Button> (Resource.Id.btnAddAddress);
btnAddaddress.Click += new EventHandler(btnAddaddress_Clicked);
}
private void Save_Address(object sender, DialogClickEventArgs args)
{
ConDeath.AddDeath(Intent.GetStringExtra("address_id").ToString(), txtfname.Text, txtlname.Text, txtexname.Text, spngender.SelectedItem.ToString(), txtbday.Text, spnregisterdeath.SelectedItem.ToString(), spndeathcert.SelectedItem.ToString());
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
builder.SetMessage("Saving Death Information Successful");
builder.SetCancelable(false);
builder.SetPositiveButton("Ok", Save_success);
builder.Show();
}
public async void ApiRSTlist()
{
var progressDialog = ProgressDialog.Show(this, "Please wait...", "Updating Data From Server...", true);
try
{
var address = ConAddress.GetListArray1("select * from tblAddressList where sync='1'");
foreach (var x in address)
{
await(ApiConnection1.AddressId(GlobalVariables.GlobalUrl + "/addressid"));
await(ApiConnection1.Updatedata(GlobalVariables.GlobalUrl + "/address/" + GlobalVariables.GlobalUserid + "/" + x.province + "/" + x.city + "/" + x.barangay + "/" + x.building_no + "/" + x.fname + "/" + x.lname + "/" + x.contact));
var member = ConMember.GetListArray1("select * from tblmember where address_id='" + x.id + "'");
foreach (var m in member)
{
var ename = m.ename;
if (m.ename == "")
{
ename = "000";
}
await(ApiConnection1.Updatedata(GlobalVariables.GlobalUrl + "/member/" + GlobalVariables.GlobalAddressId + "/" + m.fname + "/" + m.mname + "/" + m.lname + "/" + ename + "/" + m.rhousehold + "/" + m.gender + "/" + m.birthday + "/" + m.birth_certificate + "/" + m.marital_status + "/" + m.religion + "/" + m.school_attendance + "/" + m.literacy + "/" + m.highest_grade + "/" + m.work_status + "/" + m.occupation + "/" + m.pwd));
}
var housing = ConHousing.GetListSingle("select * from tblHousing where address_id='" + x.id + "'");
await(ApiConnection1.Updatedata(GlobalVariables.GlobalUrl + "/housing/" + GlobalVariables.GlobalAddressId + "/" + housing.building + "/" + housing.roof + "/" + housing.wall + "/" + housing.light + "/" + housing.drink + "/" + housing.cooking + "/" + housing.tenure));
var death = ConDeath.GetListArray1("select * from tblDeath where address_id='" + x.id + "'");
foreach (var d in death)
{
await(ApiConnection1.Updatedata(GlobalVariables.GlobalUrl + "/death/" + GlobalVariables.GlobalAddressId + "/" + d.fname + "/" + d.lname + "/" + d.gender + "/" + d.age_death + "/" + d.register + "/" + d.birthcertificate));
}
//ConAddress.DeleteAddressQuery("delete from tblAddressList where id='"+ housing.address_id +"'");
//ConMember.DeleteMemberQuery("delete from tblmember where address_id='"+ housing.address_id +"'");
//ConHousing.DeleteHousingQuery("delete from tblHousing where address_id='"+ housing.address_id +"'");
//ConDeath.DeleteDeathQuery("delete from tblDeath where address_id='"+ housing.address_id +"'");
Toast.MakeText(this, "Saving Successful..", ToastLength.Long).Show();
refreshItems();
}
}
catch (Exception ex)
{
Toast.MakeText(this, "Unable To Update Data.\n" + ex.Message, ToastLength.Long).Show();
}
progressDialog.Cancel();
}
private void lvlist_ItemClicked(object sender, AdapterView.ItemClickEventArgs e)
{
var item = ((AdpDeathList)lvlist.Adapter).GetItemDetail(e.Position);
var intent = new Intent();
intent.PutExtra("death_id", item.id.ToString());
intent.PutExtra("fullname", item.fname + ", " + item.lname + ", " + item.ename);
intent.PutExtra("address_id", Intent.GetStringExtra("address_id"));
intent.PutExtra("fulladdress", txtfulladdress.Text);
var builder1 = new AlertDialog.Builder(this);
builder1.SetTitle("Census");
builder1.SetMessage(item.fname + ", " + item.lname + ", " + item.ename);
builder1.SetPositiveButton("View", delegate
{
intent.SetClass(this, typeof(ActDeathView));
StartActivity(intent);
});
builder1.SetNeutralButton("Edit", delegate
{
intent.SetClass(this, typeof(ActDeathEdit));
StartActivity(intent);
});
builder1.SetNegativeButton("Delete", delegate
{
var builderdel = new AlertDialog.Builder(this);
builderdel.SetTitle("Census");
builderdel.SetMessage("Are You Sure You Want To Delete Selected Death Information?\n" + item.fname + ", " + item.lname + ", " + item.ename);
builderdel.SetPositiveButton("Delete", delegate
{
ConDeath.DeleteList(item.id);
var builder2 = new AlertDialog.Builder(this);
builder2.SetTitle("Census");
builder2.SetTitle("Death Information Successfully Delete");
builder2.SetPositiveButton("Ok", delegate {
refreshItems();
});
builder2.Show();
});
builderdel.SetNegativeButton("Cancel", delegate { builderdel.Dispose(); });
builderdel.Show();
});
builder1.Show();
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.LayDeathView);
txtfname = FindViewById <EditText> (Resource.Id.txtfname);
txtlname = FindViewById <EditText> (Resource.Id.txtlname);
txtexname = FindViewById <EditText> (Resource.Id.txtexname);
txtgender = FindViewById <EditText> (Resource.Id.txtgender);
txtageatdeath = FindViewById <EditText> (Resource.Id.txtageatdeath);
txtcopydeathcert = FindViewById <EditText> (Resource.Id.txtcopydeathcert);
txtdeathreg = FindViewById <EditText> (Resource.Id.txtdeathreg);
var items = ConDeath.GetListSingle("select * from tblDeath where id='" + Intent.GetStringExtra("death_id") + "'");
txtfname.Text = items.fname;
txtlname.Text = items.lname;
txtexname.Text = items.ename;
txtageatdeath.Text = items.age_death;
txtgender.Text = items.gender;
txtcopydeathcert.Text = items.birthcertificate;
txtdeathreg.Text = items.register;
}
private void Save_Address(object sender, DialogClickEventArgs args)
{
tblDeath updatdeath = new tblDeath();
updatdeath.id = Convert.ToInt32(Intent.GetStringExtra("death_id"));
updatdeath.address_id = Intent.GetStringExtra("address_id");
updatdeath.fname = txtfname.Text;
updatdeath.lname = txtlname.Text;
updatdeath.ename = txtexname.Text;
updatdeath.gender = spngender.SelectedItem.ToString();
updatdeath.age_death = txtbday.Text;
updatdeath.birthcertificate = spndeathcert.SelectedItem.ToString();
updatdeath.register = spnregisterdeath.SelectedItem.ToString();
ConDeath.UpdateList(updatdeath);
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
builder.SetMessage("Updating Death Information Successful");
builder.SetCancelable(false);
builder.SetPositiveButton("Ok", Save_success);
builder.Show();
}
public void refreshItems()
{
var items = ConDeath.GetList(Intent.GetStringExtra("address_id"), txtsearch.Text);
lvlist.Adapter = new AdpDeathList(this, items);
}
