private void LoadPersonaInList() { PersonaDbHelper dbVals = new PersonaDbHelper(this); if (txtSearch.Text.Trim().Length < 1) { listItsms = dbVals.GetAllPersonas(); } else { listItsms = dbVals.GetContactsBySearchName(txtSearch.Text.Trim()); } lv.Adapter = new PersonaListBaseAdapter(this, listItsms); lv.ItemLongClick += lv_ItemLongClick; }
private void LoadDataForEdit(string contactId) { PersonaDbHelper db = new PersonaDbHelper(this); ICursor cData = db.getPersonaById(int.Parse(contactId)); if (cData.MoveToFirst()) { etidentificacion.Text = cData.GetString(cData.GetColumnIndex("identificacion")); etnombre.Text = cData.GetString(cData.GetColumnIndex("nombre")); etapellidos.Text = cData.GetString(cData.GetColumnIndex("apellidos")); etdireccion.Text = cData.GetString(cData.GetColumnIndex("direccion")); etcorreo.Text = cData.GetString(cData.GetColumnIndex("correo")); ettelefono.Text = cData.GetString(cData.GetColumnIndex("telefono")); etsexo.Text = cData.GetString(cData.GetColumnIndex("sexo")); etestadocivil.Text = cData.GetString(cData.GetColumnIndex("estadoCivil")); etdetalle.Text = cData.GetString(cData.GetColumnIndex("detalle")); ettiposangre.Text = cData.GetString(cData.GetColumnIndex("tipoSangre")); dpfechanac.Text = cData.GetString(cData.GetColumnIndex("fechaNac")); } }
private void DeleteSelectedPersona(string contactId) { PersonaDbHelper _db = new PersonaDbHelper(activity); _db.DeletePersona(contactId); }
void buttonInsertClick(object sender, EventArgs e) { PersonaDbHelper db = new PersonaDbHelper(this); if (etidentificacion.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese la identificacion.", ToastLength.Short).Show(); return; } if (etnombre.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese el nombre.", ToastLength.Short).Show(); return; } if (etapellidos.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese los apellidos.", ToastLength.Short).Show(); return; } if (etdireccion.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese la direccion.", ToastLength.Short).Show(); return; } if (dpfechanac.Text.Trim().Length < 1) { string fechaPattern = "^(0[1-9]|[12][0-9]|3[01])[.](0[1-9]|1[012])[.](19|20)[0-9]{2}$"; if (!Regex.IsMatch(dpfechanac.Text, fechaPattern, RegexOptions.IgnoreCase)) { Toast.MakeText(this, "Fecha de nacimiento incorrecta.", ToastLength.Short).Show(); return; } Toast.MakeText(this, "Ingrese la fecha de nacimiento.", ToastLength.Short).Show(); return; } if (etcorreo.Text.Trim().Length > 0) { string EmailPattern = @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"; if (!Regex.IsMatch(etcorreo.Text, EmailPattern, RegexOptions.IgnoreCase)) { Toast.MakeText(this, "Correo incorrecto.", ToastLength.Short).Show(); return; } } Persona per = new Persona(); if (etid.Text.Trim().Length > 0) { per.id = int.Parse(etid.Text); } per.identificacion = etidentificacion.Text; per.nombre = etnombre.Text; per.apellidos = etapellidos.Text; per.direccion = etdireccion.Text; per.correo = etcorreo.Text; per.telefono = ettelefono.Text; per.estadoCivil = etestadocivil.Text; per.tipoSangre = ettiposangre.Text; per.detalle = etdetalle.Text; per.sexo = etsexo.Text; try { per.fechaNac = Convert.ToDateTime(dpfechanac.Text); } catch { per.fechaNac = new DateTime(); } try { if (etid.Text.Trim().Length > 0) { db.UpdatePersona(per); Toast.MakeText(this, "Se actualizo correctamente.", ToastLength.Short).Show(); } else { db.AddNewPersona(per); Toast.MakeText(this, "Se agrego correctamente.", ToastLength.Short).Show(); } Finish(); //Go to main activity after save/edit var mainActivity = new Intent(this, typeof(PersonaActivity)); StartActivity(mainActivity); } catch (Exception ex) { throw new Exception(ex.Message); } }