private void Save_Address(object sender, DialogClickEventArgs args)
{
tblAddressList updateaddress = new tblAddressList();
updateaddress.id = Convert.ToInt32(Intent.GetStringExtra("id"));
updateaddress.province = txtProvince.Text;
updateaddress.city = txtCity.Text;
updateaddress.barangay = txtBarangay.Text;
updateaddress.building_no = txtNumber.Text;
updateaddress.fname = txtFname.Text;
updateaddress.lname = txtLname.Text;
updateaddress.contact = txtContact.Text;
ConAddress.UpdateAddressList(updateaddress);
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Census");
builder.SetMessage("Updating Address Successful");
builder.SetPositiveButton("Ok", delegate {
var intent = new Intent();
intent.SetClass(this, typeof(ActAddress));
StartActivity(intent);
});
builder.Show();
}
public static long UpdateAddressList(tblAddressList item)
{
using (var database = Database.Connection())
{
database.Update(item);
return(item.id);
}
}
public static List <tblAddressList> GetList(string address)
{
tblAddressList itemlist = new tblAddressList();
using (var database = Database.Connection())
{
return(database.Query <tblAddressList> ("select * from tblAddressList " +
"where year='" + GlobalVariables.GlobalYear + "' and building_no || ',' || barangay || ',' || city ||',' || province like '%" + address + "%'").ToList());
}
}
