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