//Update Existing contact public void UpdateInfoMedica(InfoMedica infoMedica) { if (infoMedica == null) { return; } //Obtain writable database SQLiteDatabase db = this.WritableDatabase; //Prepare content values ContentValues vals = new ContentValues(); vals.Put("idPersona", infoMedica.idPersona); vals.Put("identificacion", infoMedica.identificacion); vals.Put("peso", infoMedica.peso); vals.Put("altura", infoMedica.altura); vals.Put("presionArterial", infoMedica.presionArterial); vals.Put("frecuenciaCardiaca", infoMedica.frecuenciaCardiaca); vals.Put("detalle", infoMedica.detalle); ICursor cursor = db.Query("InfoMedica", new String[] { "id", "idPersona", "identificacion", "peso", "altura", "presionArterial", "frecuenciaCardiaca", "detalle" }, "id=?", new string[] { infoMedica.id.ToString() }, null, null, null, null); if (cursor != null) { if (cursor.MoveToFirst()) { // update the row db.Update("InfoMedica", vals, "id=?", new String[] { cursor.GetString(0) }); } cursor.Close(); } }
void buttonInsertClick(object sender, EventArgs e) { InfoMedicaDbHelper db = new InfoMedicaDbHelper(this); if (etpeso.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese el Peso.", ToastLength.Short).Show(); return; } if (etaltura.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese el altura.", ToastLength.Short).Show(); return; } if (etpresionarterial.Text.Trim().Length < 1) { Toast.MakeText(this, "Ingrese La presion arterial.", ToastLength.Short).Show(); return; } InfoMedica im = new InfoMedica(); if (etid.Text.Trim().Length > 0) { im.id = int.Parse(etid.Text); } im.identificacion = etidentificacion.Text; im.idPersona = Int32.Parse(etidPersona.Text); im.peso = Double.Parse(etpeso.Text); im.altura = Double.Parse(etaltura.Text); im.presionArterial = etpresionarterial.Text; im.frecuenciaCardiaca = etfrecuenciacardiaca.Text; im.detalle = etdetalle.Text; try { if (etid.Text.Trim().Length > 0) { db.UpdateInfoMedica(im); Toast.MakeText(this, "Se actualizo correctamente.", ToastLength.Short).Show(); } else { db.AddNewInfoMedica(im); Toast.MakeText(this, "Se agrego correctamente.", ToastLength.Short).Show(); } Finish(); //Go to main activity after save/edit var mainActivity = new Intent(this, typeof(InfoMedicaActivity)); mainActivity.PutExtra("PersonaId", personaId); mainActivity.PutExtra("PersonaName", personaNombre); mainActivity.PutExtra("PersonaIdentificacion", personaIdentificacion); StartActivity(mainActivity); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void lv_ItemLongClick(object sender, AdapterView.ItemLongClickEventArgs e) { InfoMedica o = listItsms[e.Position]; var activityAddEdit = new Intent(this, typeof(AddEditInfoMedicaActivity)); activityAddEdit.PutExtra("InfoMedicaId", o.id.ToString()); activityAddEdit.PutExtra("PersonaId", personaId); activityAddEdit.PutExtra("PersonaName", personaNombre); activityAddEdit.PutExtra("PersonaIdentificacion", personaIdentificacion); StartActivity(activityAddEdit); }
//Add New Contact public void AddNewInfoMedica(InfoMedica infoMedica) { SQLiteDatabase db = this.WritableDatabase; ContentValues vals = new ContentValues(); vals.Put("idPersona", infoMedica.idPersona); vals.Put("identificacion", infoMedica.identificacion); vals.Put("peso", infoMedica.peso); vals.Put("altura", infoMedica.altura); vals.Put("presionArterial", infoMedica.presionArterial); vals.Put("frecuenciaCardiaca", infoMedica.frecuenciaCardiaca); vals.Put("detalle", infoMedica.detalle); db.Insert("InfoMedica", null, vals); }