public List <Rutina> all(Context context) { List <Rutina> lista = new List <Rutina>(); Conexion con = new Conexion(); con.start(context); MySqlDataReader data = null; try { var cmd = new MySqlCommand(string.Format("SELECT * FROM rutinas"), con.getConnection()); data = cmd.ExecuteReader(); while (data.Read()) { Rutina aux = new Rutina(); aux.id = data.GetInt32("ID"); aux.kcal = data.GetInt32("kcal"); aux.name = data.GetString("Nombre"); aux.content = data.GetString("Contenido"); lista.Add(aux); } data.Close(); con.end(context); return(lista); } catch (Exception ex) { con.end(context); Toast.MakeText(context, ex.ToString(), ToastLength.Long).Show(); return(lista); } }
protected override void OnStart() { base.OnStart(); var rutine = new Rutina(); rutinas = rutine.all(this); list.Adapter = new RutinaAdapter(this, Resource.Layout.itemRutine, rutinas); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.pacientRutine); pacient.id = Intent.GetIntExtra("Pacient", 0); pacient.findAndLoad(this, pacient.id); authLevel = Intent.GetIntExtra("Auth", 4); rutine.findAndLoad(this, pacient.paciente.idRutina); nameET = FindViewById <EditText>(Resource.Id.rutineNameDetailsET); kcal = FindViewById <EditText>(Resource.Id.rutineKcalDetailsET); name = FindViewById <Spinner>(Resource.Id.rutineNameDetailsSP); description = FindViewById <EditText>(Resource.Id.rutineDescriptionDetailsET); var rutina = new Rutina(); rutinas = rutina.all(this); nameET.Text = rutine.name; kcal.Text = rutine.kcal.ToString(); ArrayAdapter <Rutina> adapter = new ArrayAdapter <Rutina>(this, Resource.Layout.support_simple_spinner_dropdown_item, rutinas); name.Adapter = adapter; if (pacient.paciente.idRutina == 0) { pacient.paciente.idRutina = rutinas[rutinas.FindIndex(a => a.name == "Sin Rutina")].id; } name.SetSelection(rutinas.FindIndex(a => a.id == pacient.paciente.idRutina)); name.ItemSelected += rutineSelectionChange; changePacientRutinePB = FindViewById <Button>(Resource.Id.changePacientRutinePB); changePacientRutinePB.Click += changePacientRutine; if (authLevel == 4 || authLevel == 2) { changePacientRutinePB.Visibility = ViewStates.Invisible; } cancelPacientRutineUpdatePB = FindViewById <Button>(Resource.Id.cancelPacientRutineUpdatePB); cancelPacientRutineUpdatePB.Click += cancelPacientRutineUpdate; savePacientRutineUpdatePB = FindViewById <Button>(Resource.Id.savePacientRutineUpdatePB); savePacientRutineUpdatePB.Click += savePacientRutineUpdate; // Create your application here }
private void AgregarRutina(object sender, EventArgs e) { Rutina rutine = new Rutina(); var name = FindViewById <EditText>(Resource.Id.rutineNameAdd); rutine.name = name.Text; var content = FindViewById <EditText>(Resource.Id.rutineDescriptionAdd); rutine.content = content.Text; var kcal = FindViewById <EditText>(Resource.Id.rutineKcalAdd); if (kcal.Text != "") { rutine.kcal = int.Parse(kcal.Text); } else { rutine.kcal = 0; } if (!(rutine.name.Trim() != "" && rutine.content.Trim() != "")) { Toast.MakeText(this, "Debe llenar todos los campos", ToastLength.Short).Show(); return; } if (rutine.findAndLoad(this, rutine.name)) { Toast.MakeText(this, "La rutina ya esta registrada", ToastLength.Short).Show(); } else { rutine.save(this); name.Text = ""; content.Text = ""; kcal.Text = ""; Finish(); } }