public static long UpdateHousing(tblHousing item)
{
using (var database = Database.Connection())
{
database.Update(item);
return(item.id);
}
}
private void btnAddaddress_Clicked(object sender, EventArgs e)
{
if (spnbuilding.SelectedItem.ToString() != "Select Building Type" && spnroof.SelectedItem.ToString() != "Select Roof Type" && spnwall.SelectedItem.ToString() != "Select Wall Type" && spnlight.SelectedItem.ToString() != "Select Source Of Light" && spndrink.SelectedItem.ToString() != "Select Source Of Drink" && spncook.SelectedItem.ToString() != "Select Use For Cooking" && spntenure.SelectedItem.ToString() != "Select Tenure Status")
{
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
var items = ConHousing.GetListSingle("select * from tblHousing where address_id='" + Intent.GetStringExtra("address_id") + "'");
if (items == null)
{
builder.SetMessage("Are You Sure You Want To Save Housing Question?");
builder.SetPositiveButton("Yes", Save_Address);
}
else
{
builder.SetMessage("Are You Sure You Want To Update Housing Question?");
builder.SetPositiveButton("Yes", delegate
{
tblHousing updatehousing = new tblHousing();
updatehousing.id = items.id;
updatehousing.address_id = Intent.GetStringExtra("address_id");
updatehousing.building = spnbuilding.SelectedItem.ToString();
updatehousing.roof = spnroof.SelectedItem.ToString();
updatehousing.wall = spnwall.SelectedItem.ToString();
updatehousing.light = spnlight.SelectedItem.ToString();
updatehousing.drink = spndrink.SelectedItem.ToString();
updatehousing.cooking = spncook.SelectedItem.ToString();
updatehousing.tenure = spntenure.SelectedItem.ToString();
ConHousing.UpdateHousing(updatehousing);
Save_Address1();
});
}
builder.SetNegativeButton("Cancel", delegate { builder.Dispose(); });
builder.Show();
}
else
{
Toast.MakeText(this, "Unable to continue.\n Please Complete The Field.", ToastLength.Long).Show();
}
}
