private void lvlist_ItemLongClick(object sender, AdapterView.ItemLongClickEventArgs e) { var item = ((AdpAddressList)lvlist.Adapter).GetItemDetail(e.Position); var builder = new AlertDialog.Builder(this); builder.SetTitle("Census"); builder.SetMessage(item.building_no + ", " + item.barangay + ", " + item.city + ", " + item.province); builder.SetPositiveButton("Edit", delegate { var intent = new Intent(); intent.PutExtra("id", item.id.ToString()); intent.SetClass(this, typeof(ActAddressEdit)); StartActivity(intent); }); builder.SetNegativeButton("Delete", delegate { var builderdel = new AlertDialog.Builder(this); builderdel.SetTitle("Census"); builderdel.SetMessage("Are You Sure You Want To Delete Selected Address?\n" + item.building_no + ", " + item.barangay + ", " + item.city + ", " + item.province); builderdel.SetPositiveButton("Delete", delegate { ConAddress.DeleteAddressList(item.id); var builder1 = new AlertDialog.Builder(this); builder1.SetTitle("Census"); builder1.SetTitle("Address Successfully Delete"); builder1.SetPositiveButton("Ok", delegate { refreshItems(); }); builder1.Show(); }); builderdel.SetNegativeButton("Cancel", delegate { builderdel.Dispose(); }); builderdel.Show(); }); builder.Show(); }
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(); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.LayAddressAdd); txtProvince = FindViewById <EditText> (Resource.Id.txtProvince); txtCity = FindViewById <EditText> (Resource.Id.txtCity); txtBarangay = FindViewById <EditText> (Resource.Id.txtBarangay); txtNumber = FindViewById <EditText> (Resource.Id.txtBuilding_no); txtFname = FindViewById <EditText> (Resource.Id.txtFname); txtLname = FindViewById <EditText> (Resource.Id.txtLname); txtContact = FindViewById <EditText> (Resource.Id.txtContact); lbladdresstitle = FindViewById <TextView> (Resource.Id.lbladdresstitle); lbladdresstitle.Text = "UPDATE ADDRESS INFORMATION"; btnAddaddress = FindViewById <Button> (Resource.Id.btnAddAddress); btnAddaddress.Text = "Update Address"; btnAddaddress.Click += new EventHandler(btnAddaddress_Clicked); var items = ConAddress.GetListArray("select * from tblAddressList where id='" + Intent.GetStringExtra("id") + "'"); txtProvince.Text = items.province; txtCity.Text = items.city; txtBarangay.Text = items.barangay; txtNumber.Text = items.building_no; txtFname.Text = items.fname; txtLname.Text = items.lname; txtContact.Text = items.contact; }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.LayLogin); CopyExistingDB(); var url = ConAddress.GetConnectionURL(); GlobalVariables.GlobalUrl = url.url; txtuser = FindViewById <EditText> (Resource.Id.txtusername); txtpass = FindViewById <EditText> (Resource.Id.txtpassword); btnlogin = FindViewById <Button>(Resource.Id.btnlogin); btnlogin.Click += new EventHandler(btnlogin_click); //var intent1 = new Intent (); //intent1.SetClass (this, typeof(ActMemberAdd)); //StartActivity (intent1); var users = ConAddress.GetUser(); if (users.username != "") { GlobalVariables.GlobalUserid = users.user_id; GlobalVariables.GlobalFname = users.fname; GlobalVariables.GlobalLname = users.lname; var intent = new Intent(); intent.SetClass(this, typeof(ActAddress)); Toast.MakeText(this, "Login Successfully\n" + users.fname + " " + users.lname + ".", ToastLength.Long).Show(); StartActivity(intent); } }
public static async Task <bool> UserLogin(string url) { bool result = false; var request = System.Net.WebRequest.Create(url) as HttpWebRequest; if (request != null) { request.Method = "GET"; request.ServicePoint.Expect100Continue = false; request.Timeout = 20000; request.ContentType = "application/json"; using (WebResponse response = await request.GetResponseAsync()) { using (Stream stream = response.GetResponseStream()) { string x = JsonObject.Load(stream).ToString(); JsonObject jObj = (JsonObject)JsonObject.Parse(x); JsonArray jArr = (JsonArray)jObj["result"]; foreach (var item in jArr) { tblUser user = new tblUser(); user.id = 1; user.user_id = Convert.ToString((Int32)item ["number"]); user.fname = Convert.ToString((string)item ["fname"]); user.lname = Convert.ToString((string)item ["lname"]); user.username = Convert.ToString((string)item ["user"]); user.password = Convert.ToString((string)item ["password"]); ConAddress.UpdateUser(user); } } } } return(result); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.aspinnertest); var spinner = FindViewById <Spinner>(Resource.Id.spntest); _address = ConAddress.GetList(""); var adapter = new CustomSpinnerAdapter(this, _address); spinner.Adapter = adapter; spinner.ItemSelected += SpinnerItemSelected; }
private void OkDialog_Clicked(object sender, DialogClickEventArgs args) { tblConnection connection = new tblConnection(); var dialog = (AlertDialog)sender; var txtnewurl = (EditText)dialog.FindViewById(Resource.Id.txturl); connection.id = 1; connection.url = txtnewurl.Text; ConAddress.UpdateConnectionURL(connection); var url = ConAddress.GetConnectionURL(); GlobalVariables.GlobalUrl = url.url; }
private void Save_Address(object sender, DialogClickEventArgs args) { ConAddress.AddAddressList(txtProvince.Text, txtCity.Text, txtBarangay.Text, txtNumber.Text, txtFname.Text, txtLname.Text, txtContact.Text, GlobalVariables.GlobalYear); var builder = new AlertDialog.Builder(this); builder.SetTitle("Census"); builder.SetMessage("Saving Address Successful"); builder.SetPositiveButton("Ok", delegate { var intent = new Intent(); intent.SetClass(this, typeof(ActAddress)); StartActivity(intent); }); 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(); }
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); }
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); }
public override View GetView(int position, View convertView, ViewGroup parent) { LinearLayout view; tblAddressList item; CheckBox chkbox; item = _items.ElementAt(position); view = (convertView ?? _context.LayoutInflater.Inflate(Resource.Layout.LayAddressLists, parent, false) ) as LinearLayout; view.FindViewById <TextView>(Resource.Id.lvladdress).Text = item.building_no + ", " + item.barangay + ", " + item.city + ", " + item.province + "."; view.FindViewById <TextView>(Resource.Id.lvlfullname).Text = item.fname + " " + item.lname; view.FindViewById <TextView>(Resource.Id.lvlstatus).Text = item.status; chkbox = view.FindViewById <CheckBox> (Resource.Id.checkBox1); if (item.status != "Done") { chkbox.Visibility = ViewStates.Invisible; } if (item.sync == "1") { chkbox.Checked = true; } chkbox.CheckedChange += (object sender, CompoundButton.CheckedChangeEventArgs e) => { if (e.IsChecked.Equals(true)) { ConAddress.GetListupdate("update tblAddressList set sync='1' where id='" + item.id + "'"); } else { ConAddress.GetListupdate("update tblAddressList set sync='0' where id='" + item.id + "'"); } }; return(view); }
private async void btnlogin_click(object sender, EventArgs e) { var url = ConAddress.GetConnectionURL(); GlobalVariables.GlobalUrl = url.url; if (txtuser.Text != "" && txtpass.Text != "") { var progressDialog = ProgressDialog.Show(this, "Please wait...", "Verifying Credentials...", true); try { await(ApiConnection1.UserLogin(GlobalVariables.GlobalUrl + "/login/" + txtuser.Text + "/" + txtpass.Text)); var users = ConAddress.GetUser(); if (users.username != "") { GlobalVariables.GlobalUserid = users.user_id; GlobalVariables.GlobalFname = users.fname; GlobalVariables.GlobalLname = users.lname; var intent = new Intent(); intent.SetClass(this, typeof(ActAddress)); Toast.MakeText(this, "Login Successfully\n" + users.fname + " " + users.lname + ".", ToastLength.Long).Show(); StartActivity(intent); } else { Toast.MakeText(this, "Login Failed\nIncorect UserName Or Password..", ToastLength.Long).Show(); } } catch (Exception ex) { Toast.MakeText(this, "Unable To Connect To Server.\n" + ex.Message, ToastLength.Long).Show(); } progressDialog.Cancel(); } else { Toast.MakeText(this, "Unable To Login.\nPlease Complete Your Credential..", ToastLength.Long).Show(); } txtpass.Text = ""; }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.LayAddress); var menuButton = FindViewById(Resource.Id.menuHdrButton); menuButton.Click += (sender, e) => { leftdrawer(); }; var MenuUserName = FindViewById <TextView>(Resource.Id.MenuUserName); MenuUserName.Text = " " + GlobalVariables.GlobalFname + " " + GlobalVariables.GlobalLname; var MenuInterviewer = FindViewById(Resource.Id.MenuInterviewer); MenuInterviewer.Click += (sender, e) => { leftdrawer(); }; var MenuLogout = FindViewById(Resource.Id.MenuLogout); MenuLogout.Click += (sender, e) => { tblUser user = new tblUser(); GlobalVariables.GlobalUserid = ""; user.id = 1; user.user_id = ""; user.username = ""; user.password = ""; user.fname = ""; user.lname = ""; ConAddress.UpdateUser(user); var intent = new Intent(); intent.SetClass(this, typeof(ActLogin)); StartActivity(intent); }; lvlist = FindViewById <ListView>(Resource.Id.lvlist); lvlist.ItemClick += new System.EventHandler <AdapterView.ItemClickEventArgs>(lvlist_ItemClicked); lvlist.ItemLongClick += new System.EventHandler <AdapterView.ItemLongClickEventArgs>(lvlist_ItemLongClick); txtsearch = FindViewById <EditText>(Resource.Id.txtsearch); txtsearch.AfterTextChanged += delegate { refreshItems(); }; btnSync = FindViewById <Button> (Resource.Id.btnSync); btnSync.Click += delegate { ApiRSTlist(); }; btnAddaddress = FindViewById <Button> (Resource.Id.btnAddaddress); btnAddaddress.Click += delegate { var intent = new Intent(); intent.SetClass(this, typeof(ActAddressAdd)); StartActivity(intent); }; refreshItems(); }
public void refreshItems() { var items = ConAddress.GetList(txtsearch.Text); lvlist.Adapter = new AdpAddressList(this, items); }