private void Save_Address(object sender, DialogClickEventArgs args)
{
tblmember updatemember = new tblmember();
updatemember.id = Convert.ToInt32(Intent.GetStringExtra("member_id"));
updatemember.address_id = Intent.GetStringExtra("address_id");
updatemember.fname = txtfname.Text;
updatemember.mname = txtmname.Text;
updatemember.lname = txtlname.Text;
updatemember.ename = txtexname.Text;
updatemember.gender = spngender.SelectedItem.ToString();
updatemember.birthday = txtbday.Text;
updatemember.birth_certificate = spnbirthcert.SelectedItem.ToString();
updatemember.marital_status = spnmarital.SelectedItem.ToString();
updatemember.religion = txtreligion.Text;
updatemember.school_attendance = spnschoolattendance.SelectedItem.ToString();
updatemember.literacy = spnliteracy.SelectedItem.ToString();
updatemember.highest_grade = spnschoolhigh.SelectedItem.ToString();
updatemember.occupation = txtoccupation.Text;
updatemember.rhousehold = spnrhouse.SelectedItem.ToString();
updatemember.work_status = spnworkstatus.SelectedItem.ToString();
ConMember.UpdateMemberList(updatemember);
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
builder.SetMessage("Updating Member Successful");
builder.SetPositiveButton("Ok", Save_success);
builder.Show();
}
private void Save_Address(object sender, DialogClickEventArgs args)
{
ConMember.AddMember(Intent.GetStringExtra("address_id").ToString(), txtfname.Text, txtmname.Text, txtlname.Text, txtexname.Text, spngender.SelectedItem.ToString(), txtbday.Text, spnbirthcert.SelectedItem.ToString(), spnmarital.SelectedItem.ToString(), txtreligion.Text, spnschoolattendance.SelectedItem.ToString(), spnliteracy.SelectedItem.ToString(), spnschoolhigh.SelectedItem.ToString(), txtoccupation.Text, spnrhouse.SelectedItem.ToString(), spnworkstatus.SelectedItem.ToString());
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
builder.SetMessage("Saving Address Successful");
builder.SetPositiveButton("Ok", Save_success);
//delegate {
//var intent = new Intent ();
//intent.SetClass (this, typeof(ActMember));
//StartActivity (intent);
//});
builder.Show();
}
private void lvlist_ItemClicked(object sender, AdapterView.ItemClickEventArgs e)
{
var item = ((AdpMemberList)lvlist.Adapter).GetItemDetail(e.Position);
var intent = new Intent();
intent.PutExtra("member_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(ActMemberView));
StartActivity(intent);
});
builder1.SetNeutralButton("Edit", delegate
{
//intent.PutExtra("id",item.id.ToString());
//intent.PutExtra ("fullname", item.fname + ", " + item.lname + ", " + item.ename);
intent.SetClass(this, typeof(ActMemberEdit));
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 Member?\n" + item.fname + ", " + item.lname + ", " + item.ename);
builderdel.SetPositiveButton("Delete", delegate
{
ConMember.DeleteMemberList(item.id);
var builder2 = new AlertDialog.Builder(this);
builder2.SetTitle("Census");
builder2.SetTitle("Member Successfully Delete");
builder2.SetPositiveButton("Ok", delegate {
refreshItems();
});
builder2.Show();
});
builderdel.SetNegativeButton("Cancel", delegate { builderdel.Dispose(); });
builderdel.Show();
});
builder1.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();
}
public override void OnBackPressed()
{
var member = ConMember.GetListSingle("select * from tblmember where address_id='" + Intent.GetStringExtra("address_id") + "'");
var house = ConHousing.GetListSingle("select * from tblHousing where address_id='" + Intent.GetStringExtra("address_id") + "'");
if (member != null && house != null)
{
ConAddress.GetListupdate("update tblAddressList set status='Done' where id='" + Intent.GetStringExtra("address_id") + "'");
}
else
{
ConAddress.GetListupdate("update tblAddressList set status='Open' where id='" + Intent.GetStringExtra("address_id") + "'");
}
var intent = new Intent();
intent.SetClass(this, typeof(ActAddress));
StartActivity(intent);
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.LayNameView);
txtfname = FindViewById <EditText> (Resource.Id.txtfname);
txtmname = FindViewById <EditText> (Resource.Id.txtmname);
txtlname = FindViewById <EditText> (Resource.Id.txtlname);
txtexname = FindViewById <EditText> (Resource.Id.txtexname);
txtbday = FindViewById <EditText> (Resource.Id.txtbday);
txtreligion = FindViewById <EditText> (Resource.Id.txtreligion);
txtoccupation = FindViewById <EditText> (Resource.Id.txtoccupation);
txtgender = FindViewById <EditText> (Resource.Id.txtgender);
txtrhouse = FindViewById <EditText> (Resource.Id.txtrhouse);
txtbirthcert = FindViewById <EditText> (Resource.Id.txtbirthcert);
txtmarital = FindViewById <EditText> (Resource.Id.txtmarital);
txtschoolhigh = FindViewById <EditText> (Resource.Id.txtschoolhigh);
txtschoolattendance = FindViewById <EditText> (Resource.Id.txtschoolattendance);
txtliteracy = FindViewById <EditText> (Resource.Id.txtliteracy);
txtworkstatus = FindViewById <EditText> (Resource.Id.txtworkstatus);
txtpwd = FindViewById <EditText> (Resource.Id.txtpwd);
var items = ConMember.GetListSingle("select * from tblmember where id='" + Intent.GetStringExtra("member_id") + "'");
txtfname.Text = items.fname;
txtmname.Text = items.mname;
txtlname.Text = items.lname;
txtexname.Text = items.ename;
txtbday.Text = items.birthday;
txtreligion.Text = items.religion;
txtoccupation.Text = items.occupation;
txtgender.Text = items.gender;
txtrhouse.Text = items.rhousehold;
txtbirthcert.Text = items.birth_certificate;
txtmarital.Text = items.marital_status;
txtschoolhigh.Text = items.highest_grade;
txtschoolattendance.Text = items.school_attendance;
txtliteracy.Text = items.literacy;
txtworkstatus.Text = items.work_status;
txtpwd.Text = items.pwd;
}
private void Save_success(object sender, DialogClickEventArgs args)
{
var member = ConMember.GetListSingle("select * from tblmember where address_id='" + Intent.GetStringExtra("address_id") + "'");
var house = ConHousing.GetListSingle("select * from tblHousing where address_id='" + Intent.GetStringExtra("address_id") + "'");
if (member != null && house != null)
{
ConAddress.GetListupdate("update tblAddressList set status='Done' where id='" + Intent.GetStringExtra("address_id") + "'");
}
else
{
ConAddress.GetListupdate("update tblAddressList set status='Open',sync='0' where id='" + Intent.GetStringExtra("address_id") + "'");
}
var intent = new Intent();
intent.PutExtra("address_id", Intent.GetStringExtra("address_id"));
intent.PutExtra("fulladdress", Intent.GetStringExtra("fulladdress"));
intent.SetClass(this, typeof(ActAddress));
StartActivity(intent);
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.LayNameAdd);
txtfname = FindViewById <EditText> (Resource.Id.txtfname);
txtmname = FindViewById <EditText> (Resource.Id.txtmname);
txtlname = FindViewById <EditText> (Resource.Id.txtlname);
txtexname = FindViewById <EditText> (Resource.Id.txtexname);
txtbday = FindViewById <EditText> (Resource.Id.txtbday);
txtreligion = FindViewById <EditText> (Resource.Id.txtreligion);
txtoccupation = FindViewById <EditText> (Resource.Id.txtoccupation);
spngender = FindViewById <Spinner> (Resource.Id.spngender);
spnrhouse = FindViewById <Spinner> (Resource.Id.spnrhouse);
spnbirthcert = FindViewById <Spinner> (Resource.Id.spnbirthcert);
spnmarital = FindViewById <Spinner> (Resource.Id.spnmarital);
spnschoolattendance = FindViewById <Spinner> (Resource.Id.spnschoolattendance);
spnschoolhigh = FindViewById <Spinner> (Resource.Id.spnschoolhigh);
spnliteracy = FindViewById <Spinner> (Resource.Id.spnliteracy);
spnworkstatus = FindViewById <Spinner> (Resource.Id.spnworkstatus);
var adaptergender = ArrayAdapter.CreateFromResource(
this, Resource.Array.Gender_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adaptergender.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spngender.Adapter = adaptergender;
var adapterhouse = ArrayAdapter.CreateFromResource(
this, Resource.Array.RHOUSE_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adapterhouse.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnrhouse.Adapter = adapterhouse;
var adpbirthcert = ArrayAdapter.CreateFromResource(
this, Resource.Array.BirthCertCopy_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpbirthcert.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnbirthcert.Adapter = adpbirthcert;
var adpmarital = ArrayAdapter.CreateFromResource(
this, Resource.Array.Marital_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpmarital.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnmarital.Adapter = adpmarital;
var adpschoolattendance = ArrayAdapter.CreateFromResource(
this, Resource.Array.SchoolAttend_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpschoolattendance.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnschoolattendance.Adapter = adpschoolattendance;
var adpschoolhigh = ArrayAdapter.CreateFromResource(
this, Resource.Array.SchoolHigh_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpschoolhigh.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnschoolhigh.Adapter = adpschoolhigh;
var adpliteracy = ArrayAdapter.CreateFromResource(
this, Resource.Array.Literacy_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpliteracy.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnliteracy.Adapter = adpliteracy;
var adpworkstatus = ArrayAdapter.CreateFromResource(
this, Resource.Array.WorkStatus_Spinner, Android.Resource.Layout.SimpleSpinnerItem);
adpworkstatus.SetDropDownViewResource(Android.Resource.Layout.SimpleListItemActivated1);
spnworkstatus.Adapter = adpworkstatus;
var items = ConMember.GetListSingle("select * from tblmember where id='" + Intent.GetStringExtra("member_id") + "'");
txtfname.Text = items.fname;
txtmname.Text = items.mname;
txtlname.Text = items.lname;
txtexname.Text = items.ename;
txtbday.Text = items.birthday;
txtreligion.Text = items.religion;
txtoccupation.Text = items.occupation;
string[] array;
array = Resources.GetStringArray(Resource.Array.Gender_Spinner);
fcnspinner(spngender, array, items.gender);
array = Resources.GetStringArray(Resource.Array.RHOUSE_Spinner);
fcnspinner(spnrhouse, array, items.rhousehold);
array = Resources.GetStringArray(Resource.Array.BirthCertCopy_Spinner);
fcnspinner(spnbirthcert, array, items.birth_certificate);
array = Resources.GetStringArray(Resource.Array.Marital_Spinner);
fcnspinner(spnmarital, array, items.marital_status);
array = Resources.GetStringArray(Resource.Array.SchoolAttend_Spinner);
fcnspinner(spnschoolattendance, array, items.school_attendance);
array = Resources.GetStringArray(Resource.Array.SchoolHigh_Spinner);
fcnspinner(spnschoolhigh, array, items.highest_grade);
array = Resources.GetStringArray(Resource.Array.Literacy_Spinner);
fcnspinner(spnliteracy, array, items.literacy);
array = Resources.GetStringArray(Resource.Array.WorkStatus_Spinner);
fcnspinner(spnworkstatus, array, items.work_status);
//spngender.sel.ToString () = "123";
//spngender.SelectedItem="asd";
/*spnrhouse
* spnbirthcert
* spnmarital
* spnschoolattendance
* spnschoolhigh
* spnliteracy
*/
txtbday.Touch += (sender, e) => {
if (dialogdate == true)
{
dialogdate = false;
var inputView = LayoutInflater.Inflate(Resource.Layout.LayInputDATE, null);
var builder = new AlertDialog.Builder(this);
var datep = (DatePicker)inputView.FindViewById(Resource.Id.datepicker);
builder.SetTitle("Cencus");
builder.SetMessage("Select Birthday : ");
builder.SetView(inputView);
builder.SetPositiveButton("Change", OkDialog_Clicked);
builder.SetNegativeButton("Cancel", delegate {
builder.Dispose();
});
builder.Show();
}
else
{
dialogdate = true;
}
};
btnAddaddress = FindViewById <Button> (Resource.Id.btnAddAddress);
btnAddaddress.Click += new EventHandler(btnAddaddress_Clicked);
}
public void refreshItems()
{
var items = ConMember.GetList(Intent.GetStringExtra("address_id"), txtsearch.Text);
lvlist.Adapter = new AdpMemberList(this, items);
}
