pers home / manual del sistema - universidad de...

PERS HOME / Manual del Sistema Programa de Ingeniería de Sistemas

Universidad de Nariño

Jairo Guerrero, Ing. MSc. Jesús Insuasti, Ing. MsEd. Alexander Barón , Ing. MSc.

PERS HOME / Manual del Sistema

2

Contenido

Introducción .................................................................................................................................................. 3

Marco del Proyecto ....................................................................................................................................... 4

Fase Operativa ...................................................................................................................................... 4

El Departamento de Sistemas ................................................................................................................... 4

Metodología de Construcción de Software .................................................................................................. 5

Ciclo de vida del Software PERS HOME .................................................................................................... 6

Diseño Arquitectónico .............................................................................................................................. 6

Estructura Física del Software PERS HOME .................................................................................................. 8

Diagrama de Clases del Software PERS HOME ......................................................................................... 8

Código fuente del Software PERS HOME ................................................................................................. 9

MainActivity.cs ...................................................................................................................................... 9

SurveyActivity.cs ................................................................................................................................. 13

SurveyDB.cs ......................................................................................................................................... 28

ESTRUCTURA DE LA BASE DE DATOS PERS HOME ...................................................................................... 29

TABLA Survey .......................................................................................................................................... 29

Tecnología de Desarrollo ............................................................................................................................ 29

Marcas Registradas ..................................................................................................................................... 29


3

Introducción

Este documento muestra el diseño e implementación del Sistema PERS HOME. La propuesta

PERS, entendida como el Plan de Energizacion Rural Sostenible para el Departamento de Nariño ha sido

una iniciativa de la Universidad de Nariño, específicamente el Departamento de Ingenieria Electronica

en colaboración con IPSE (Instituto de planificación y promoción de soluciones energéticas para las

zonas no interconectadas), Tetra Tech, UPME (Unidad de planeación minero energética). De dicho plan,

fue requerida la construcción de aplicaciones móviles separadas por sector (comercial, institucional y

residencial) a fin de ser aplicadas a través de tablets para la captura de encuestas. En este sentido, el

plan se apoyo en el Grupo de Investigacion GALERAS.NET para la construcción de dichas aplicaciones. El

presente documento describe el manual del sistema del software PERS HOME.

Para la construcción del sistema PERS HOME se presenta el diseño de arquitectura, las

especificaciones de estructura del software, los mapas de datos y el código fuente con las indicaciones

de despliegue y configuración del software.

Los Autores de esta producción de software, a saber: Jairo Guerrero, Ing. MSc; Jesús Insuasti,

Ing. MsEd; y Alexander Barón, Ing. MSc; son profesores de tiempo completo adscritos al Departamento

de Sistemas de la Universidad de Nariño y se encuentran vinculados al Grupo de Investigación

GALERAS.NET con registro COLCIENCIAS No. COL0047637


4

Marco del Proyecto

En Colombia un alto porcentaje de población se encuentra con serias limitaciones del orden de

consumo energetico. En el caso particular del departamento de Nariño, la Universidad de Nariño a

través del Departamento de Electronica y en colaboración con el Grupo de Investigacion GALERAS.NET

del Departamento de Sistemas han propuesto la estrategia de captura de información de encuestas de

diferentes sectores. En este particular, del sector residencial; es aquí donde nace el software PERS

HOME para dar respuesta a la necesidad de capturar, almacenar y transmitir información referente al

perfil de consumo energético de las residencias del Departamento de Nariño.

Fase Operativa

Durante esta fase la dirección del proyecto instala la aplicación PERS HOME en 25 tablets que

son utilizadas por los encuestadores que realizan el trabajo de campo. Con la capacitación respectiva, los

encuestadores tienen acceso a las residencias objeto de estudio y desarrollan la encuesta en las tablets

a través del uso del software PERS HOME. Las encuestas se almacenan localmente en los dispositivos

móviles haciendo uso del motor de base de datos local; una vez dispongan de acceso a Internet, dichas

encuestas almacenadas pueden ser enviadas al servidor Web central del proyecto.

El Departamento de Sistemas

A nivel nacional, la Constitución Política, a través del artículo 67, establece que la Educación

Superior es un servicio público y tiene una función social y se garantiza la autonomía universitaria

mediante el artículo 69. Estos hechos trascienden por medio de la Ley 30 de 1992 por la cual se organiza

el servicio público de la Educación Superior y es éste el escenario donde se crea el Sistema Nacional de

Acreditación.

Como políticas gubernamentales velan por el mejoramiento continuo de la calidad de la

educación superior, en este orden de ideas se adoptan estrategias nacionales para la obtención del

registro calificado de los programas y su posterior acreditación en alta calidad como proceso voluntario.

La Universidad de Nariño, comprometida con el desarrollo de la región enmarcada en el

acontecimiento mundo, busca la Acreditación Institucional y es menester que sus programas logren

altos niveles de calidad. El Departamento de Sistemas inició su fase de autoevaluación en el 2007 como

estrategia de autodiagnóstico y uno de los aspectos relevantes que se destaca es la necesidad de una

reforma curricular.


5

El proyecto contempla los aspectos relacionados al diseño e implementación de la Reforma

Curricular como respuesta a las necesidades detectadas en la fase de autoevaluación del proceso de

Acreditación de Alta Calidad del Programa de Ingeniería de Sistemas.

El Programa de Ingeniería de Sistemas, comprometido con el proceso de alta calidad ha

finalizado su fase de Autoevaluación permitiendo evidenciar las fortalezas y las debilidades del

programa. Referente a aspectos académicos, se manifiesta algunas deficiencias en cuanto a movilidad,

flexibilidad y actualización curricular frente a las necesidades de estos tiempos. Hoy por hoy el Programa

de Ingenieria de Sistemas cuenta con Acreditacion de Alta calidad cumpliéndole a la sociedad en los

aspectos de enseñanza, investigación y proyección social.

Metodología de Construcción de Software

El área de conocimiento del proceso de ingeniería de software se ocupa de la definición,

implementación, aseguramiento, medida, administración, cambios y mejoras del proceso de ingeniería

de software per-sé. De las diferentes metodologías para la construcción del software, se ha optado por

apropiar y adaptar el RUP (Rational Unified Process) que se caracteriza por ser:

Un proceso dirigido por casos de uso

Un proceso centrado en la arquitectura

Un proceso iterativo e incremental

La metodología, al estar dirigida por casos de uso significa que dichos elementos del diseño se

utilizan como artefactos básicos para establecer el comportamiento deseado del sistema para verificar y

validar la arquitectura del sistema, para las pruebas y para la comunicación entre las personas

involucradas en el proyecto.

Al ser la metodología centrada en la arquitectura, significa que dicha arquitectura del sistema se

utiliza como un artefacto básico para conceptualizar, construir, gestionar y hacer evolucionar el sistema

en desarrollo.

Finalmente, una metodología iterativa es aquella que involucra la gestión de un flujo de ejecutables

del sistema. Involucra además la continua integración de la arquitectura para la producción de

ejecutables, donde cada uno de ellos incorpora mejoras sobre sus predecesores.

En este caso particular, el diseño, desarrollo y despliegue del sistema PERS HOME fue asumido a

través de la adaptación del ciclo de vida de desarrollo de software bajo enfoque iterativo. A

continuación se muestra el diagrama que lideró la construcción del software:


6

Ciclo de vida del Software PERS HOME

Iniciación Elaboración Construcción Transición

Requisitos

Diseño

Implementación

Pruebas

Despliegue

iteración preliminar

iteración #1

iteración #2

iteración #3

iteración #4

iteración #5

iteración #6

- Iniciación: La fase donde se establecen los insumos necesarios para desarrollar el proyecto,

entre ellos están: la normatividad nacional y los formatos de recolección de datos suministrados

por el Plan de energización rural sostenible en colaboración con IPSE, UPME y el Departamento

de Electrónica de la Universidad de Nariño, así como la consecusion de los dispositivos móviles

(tablets) a ser usadas.

- Elaboración: Momento en el que se define la visión general del proyecto junto con el diseño de

su arquitectura. Se especifica los requerimientos del nuevo sistema basados en las necesidades

de los usuarios finales desde la óptica funcional y no funcional; haciendo incapie en la necesidad

de separar las aplicaciones por sectores (Comercial, Institucional y Residencial).

- Construcción: La fase que implementa el sistema usando tecnología computacional, su

desarrollo está conducido por el modelo donde se examinan en varias ocasiones si el producto

software está encaminado a satisfacer las necesidades de los usuarios.

- Transición: Al momento de interactuar los usuarios finales con el sistema, surgen algunos

ajustes que se deben efectuar con el fin de otorgar un tiempo de vida al sistema.

Diseño Arquitectónico

El Software PERS HOME representa una solución computacional para dispositivos móviles (tablets

con Android OS™). Esta aplicación es la encargada de soportar tecnológicamente el trabajo de campo

del Plan de energización Rural Sostenible. El trabajo de campo consiste en realizar una encuesta a las

residencias objeto de estudio según los lineamientos del plan mencionado.

Teniendo en cuenta que las encuestas de los sectores son dferentes; para el caso de PERS HOME se

require centrar la atención en información sobre consumo energético residencial. En ello se destacan

tres principales acciones: la captura de la encuesta residencial, el envio de encuestas a través del


7

servicio Web XML y borrar las encuestas residenciales. Tal configuración puede ser observada en la

figura 1.

Figura 1. Diagrama principal de casos de uso.

Los sistemas complementarios PERS COMM y PERS INST tendrán los casos de uso respectivos tal

como lo ilustra la figura 1. La escencia de la encuesta es diferente para cada software. Nuevamente se

hace incapie que dicha separación ha sido elaborada en respuesta al requerimiento funcional de la

dirección del plan de energización rural sostenible.

Teniendo en cuenta que el software PERS HOME se integra al conjunto de soluciones

computacionales del plan de energización rural sostenible, el diagrama de arquitectura genérico de la

solución integrada se muestra en la figura 2:

Figura 2. Arquitectura general de la solución computacional integrada PERS.


8

Estructura Física del Software PERS HOME Directorio \PERS_HOME ITEM DESCRIPCION

\PERS_HOME Directorio raíz de la solucion \bin Directorio de compilación a código ejecutable \obj Directorio de compilación a código objeto \Properties Directorio de información de configuración y ensamblado \References Coleccion de ensamblados de referencia \Web References Colección de servicios de referencia PERS_WS Referencia al Servicio Web XML \Assets Colección de activos de la aplicación \Resources Colección de recursos de la aplicación \Drawable Recursos Graficos - Icon.png Icono de la aplicación - title.png Titulo de la aplicación \Layout Archivo de recursos del formulario principal - list.axml Interfaz Android para el manejo de listas de datos - Main.axml Interfaz Android de la pantalla principal - Survey.axml Interfaz Android para la encuesta del sector residencial \Values Colección de recursos en cadenas de caracteres - Strings.xml Biblioteca de cadenas de caracteres - AboutResources.txt Informacion sobre manejo de recursos en aplicación Android - Resource.Designer.cs Codigo fuente sobre direccionamiento de objetos de interfaz Android - MainActivity.cs Codigo fuente de la pantalla principal - SurveyActivity.cs Codigo fuente de la pantalla de captura de la encuesta - SurveyDB.cs Codigo fuente de definición de la base de datos en SQLite for Android

Diagrama de Clases del Software PERS HOME

Teniendo en cuenta que el software maneja principalmente tres códigos fuentes de clases,

dichas clases hacen llamadas asíncronas al servicio Web XML lo cual genera delegados en clases publicas

adicionales. La escencia del software esta centrada en los códigos MainActivity.cs, SurveyActivity.cs, y

SurveyDB.cs.

El código fuente que se adjunta en el presente documento hace referencia a dichas clases

principales. Las clases complementarias son autogeneradas al consumir los recursos XML mediante

SOAP. La disposición de las clases principales, junto con las complementarias y sus delegasos asíncronos

puede observarse en la figura 3.


9

Figura 3. Dagrama de clases del Software PERS HOME

Código fuente del Software PERS HOME

MainActivity.cs

using Android.App; using Android.Database; using Android.OS; using Android.Widget; namespace PERS_Home { [Activity(Label = "PERS Residencial", MainLauncher = true, Icon = "@drawable/icon")] public class MainActivity : Activity { private ListView lstSurvey; private SurveyDB surveyDB;


10

private ICursor cursor; private string[] fromColumns; private int[] toControlIds; private string Respondent, PollsterName, info; private bool result; //---------------------------------------------------------------------------- protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.Main); Button _btnAdd = FindViewById<Button>(Resource.Id.btnAdd); _btnAdd.Click += _btnAdd_Click; Button _btnDelete = FindViewById<Button>(Resource.Id.btnDelete); _btnDelete.Click += _btnDelete_Click; Button _btnSend = FindViewById<Button>(Resource.Id.btnSend); _btnSend.Click += _btnSend_Click; Button _btnAbout = FindViewById<Button>(Resource.Id.btnAbout); _btnAbout.Click += _btnAbout_Click; Button _btnExit = FindViewById<Button>(Resource.Id.btnExit); _btnExit.Click += _btnExit_Click; lstSurvey = FindViewById<ListView>(Resource.Id.lstSurvey); lstSurvey.ItemClick += lstSurvey_ItemClick; surveyDB = new SurveyDB(this); fromColumns = new string[] { "Respondent", "PollsterName", "info" }; toControlIds = new int[] { Android.Resource.Id.Text1 }; this.LoadData(); } //---------------------------------------------------------------------------- public void LoadData() { Respondent = ""; PollsterName = ""; if (cursor != null) { StopManagingCursor(cursor); lstSurvey.Adapter = null; } cursor = surveyDB.ReadableDatabase.RawQuery("SELECT * FROM survey", null); StartManagingCursor(cursor); lstSurvey.Adapter = new SimpleCursorAdapter(this, Android.Resource.Layout.SimpleListItem1, cursor, fromColumns, toControlIds); } //---------------------------------------------------------------------------- void lstSurvey_ItemClick(object sender, AdapterView.ItemClickEventArgs e) { var obj = lstSurvey.Adapter.GetItem(e.Position); var curs = (ICursor)obj; Respondent = curs.GetString(1); PollsterName = curs.GetString(2); Toast.MakeText(this, Respondent, Android.Widget.ToastLength.Short).Show(); } //---------------------------------------------------------------------------- void _btnAdd_Click(object sender, System.EventArgs e) { Respondent = ""; PollsterName = ""; StartActivity(typeof(SurveyActivity)); } //---------------------------------------------------------------------------- void _btnDelete_Click(object sender, System.EventArgs e)


11

{ if (Respondent != "" && PollsterName != "") this.Delete(); else Toast.MakeText(this, "Seleccione la Encuesta de la lista", Android.Widget.ToastLength.Short).Show(); } //---------------------------------------------------------------------------- private void Delete() { result = false; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage("Desea borrar la encuesta de " + Respondent + "?"); builder.SetPositiveButton("Si", (sender, e) => { result = true; try { surveyDB.WritableDatabase.ExecSQL("DELETE FROM survey WHERE Respondent='" + Respondent + "' AND PollsterName='" + PollsterName + "'"); this.LoadData(); } catch (SQLException ex) { Toast.MakeText(this, ex.Message, Android.Widget.ToastLength.Short).Show(); } }); builder.SetNegativeButton("No", (sender, e) => { result = false; }); builder.Show(); result = true; } //---------------------------------------------------------------------------- void _btnSend_Click(object sender, System.EventArgs e) { this.Send(); } //---------------------------------------------------------------------------- private void Send() { result = false; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage("Para realizar esta accion, el dispositivo DEBE tener acceso a Internet. Desea enviar las encuestas al servidor?"); builder.SetPositiveButton("Si", (sender, e) => { result = true; bool success = true; ICursor curs; object obj; PERS_WS.PERS_WS ws = new PERS_WS.PERS_WS(); for (int i = 0; i < lstSurvey.Adapter.Count; i++) { obj = lstSurvey.Adapter.GetItem(i); curs = (ICursor)obj; Respondent = curs.GetString(1);


12

PollsterName = curs.GetString(2); info = curs.GetString(3); if (ws.AddHomeSurvey(Respondent + "|" + PollsterName + "|" + info) != "OK") success = false; } ws.Dispose(); if (success) { try { surveyDB.WritableDatabase.ExecSQL("DELETE FROM survey"); this.LoadData(); } catch (SQLException ex) { Toast.MakeText(this, ex.Message, Android.Widget.ToastLength.Short).Show(); } Toast.MakeText(this, "Envio de encuestas satisfactorio", Android.Widget.ToastLength.Short).Show(); } else Toast.MakeText(this, "Hubo errores al enviar las encuestas", Android.Widget.ToastLength.Short).Show(); }); builder.SetNegativeButton("No", (sender, e) => { result = false; }); builder.Show(); result = true; } //---------------------------------------------------------------------------- void _btnAbout_Click(object sender, System.EventArgs e) { this.about(); } //---------------------------------------------------------------------------- private void about() { result = true; string authors = "Autores: \n\n Jesus Insuasti, Jairo Guerrero, Alexander Baron"; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage(authors + " \n\n Grupo de Investigacion GALERAS.NET - Depto de Sistemas \n\n Universidad de Narino (Pasto, Colombia) \n\n 2013"); builder.SetPositiveButton("OK", (sender, e) => { result = false; }); builder.Show(); result = true; } //---------------------------------------------------------------------------- private void Exit() { result = false; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage("Desea salir del programa?"); builder.SetPositiveButton("Si", (sender, e) => {


13

result = true; StopManagingCursor(cursor); cursor.Dispose(); surveyDB.Close(); surveyDB.Dispose(); this.Finish(); System.Environment.Exit(0); }); builder.SetNegativeButton("No", (sender, e) => { result = false; }); builder.Show(); result = true; } //---------------------------------------------------------------------------- void _btnExit_Click(object sender, System.EventArgs e) { this.Exit(); } //---------------------------------------------------------------------------- } }

SurveyActivity.cs

using System; using System.Text; using System.Collections.Generic; using Android.App; using Android.Database; using Android.OS; using Android.Widget; namespace PERS_Home { [Activity(Label = "PERS Residencial - Nueva Encuesta")] public class SurveyActivity : Activity { private EditText txtRespondant, txtPollsterName; private bool result; private class SurveyItem { public string ObjectName; public int ObjectId; public string Value; // public SurveyItem(string on, int oi) { ObjectName = on; ObjectId = oi; Value = ""; } } private List<SurveyItem> SurveyUI = new List<SurveyItem>(); private string[] municipality = new string[] { "El Charco", "La Tola", "Mosquera", "Olaya Herrera", "Santa Barbara", "Tumaco",


14

"Francisco Pizarro", "Barbacoas", "Roberto Payan", "Magui Payan", "Ricaurte", "Mallama", "Ipiales", "Aldana", "Guachucal", "Cumbal", "Cuaspud", "Pupiales", "Puerres", "Cordoba", "Potosi", "El Contadero", "Iles", "Gualmatan", "Funes", "Tuquerres", "Imues", "Guaitarilla", "Ospina", "Sapuyes", "Samaniego", "Santacruz", "Providencia", "Sandona", "Linares", "Consaca", "Ancuya", "Taminango", "Policarpa", "Cumbitara", "El Rosario", "Leiva", "Pasto", "Narino", "La Florida", "Yacuanquer", "Tangua", "Chachagui", "La Union", "San Pedro de Cartago", "San Lorenzo", "Arboleda", "Buesaco", "El Tablon de Gomez", "Alban", "San Bernardo", "Belen", "Colon-Genova", "La Cruz", "San Pablo", "Los Andes-Sotomayor", "La Llanada", "El Tambo", "El Penol" }; private ArrayAdapter<string> mymunicipality; private string[] kinship = new string[] { "Jefe(a)", "Conyuge", "Hijo(a)", "Hermano(a)", "Padre", "Madre", "Otro" }; private ArrayAdapter<string> mykinship; private string[] academicdegree = new string[] { "Ninguno", "Pre-escolar", "Primaria Incompleta", "Primaria Completa", "Secundaria Incompleta", "Secundaria Completa", "Tecnico Incompleto", "Tecnico Completo", "Universitario Incompleto", "Universitario Completo" }; private ArrayAdapter<string> myacademicdegree; private string[] activities = new string[] { "Agricultura, pecuaria o silvicultiura", "Mineria, Industria Manufacturera", "Comercio", "Servicios", "Pensionado(a)", "Estudiante", "Inactivo", "Hogar" }; private ArrayAdapter<string> myactivities; private string[] health = new string[] { "No", "Regimen Contributivo", "Regimen Subsidiado" }; private ArrayAdapter<string> myhealth; //------------------------------------------------------------------------ public override void OnBackPressed() { this.Cancel(); } //------------------------------------------------------------------------ private void CaptureUI() { SurveyUI.Add(new SurveyItem("chkAccounts1", 2131035080)); SurveyUI.Add(new SurveyItem("chkAccounts10", 2131035206)); SurveyUI.Add(new SurveyItem("chkAccounts2", 2131035094)); SurveyUI.Add(new SurveyItem("chkAccounts3", 2131035108)); SurveyUI.Add(new SurveyItem("chkAccounts4", 2131035122)); SurveyUI.Add(new SurveyItem("chkAccounts5", 2131035136)); SurveyUI.Add(new SurveyItem("chkAccounts6", 2131035150)); SurveyUI.Add(new SurveyItem("chkAccounts7", 2131035164)); SurveyUI.Add(new SurveyItem("chkAccounts8", 2131035178)); SurveyUI.Add(new SurveyItem("chkAccounts9", 2131035192)); SurveyUI.Add(new SurveyItem("chkAmmonia", 2131034492)); SurveyUI.Add(new SurveyItem("chkBlender", 2131034850)); SurveyUI.Add(new SurveyItem("chkBottledWater", 2131034235)); SurveyUI.Add(new SurveyItem("chkCRTTV", 2131034960)); SurveyUI.Add(new SurveyItem("chkCellphone", 2131034269));


15

SurveyUI.Add(new SurveyItem("chkCentral", 2131034482)); SurveyUI.Add(new SurveyItem("chkChiller", 2131034477)); SurveyUI.Add(new SurveyItem("chkCoffeePot", 2131034872)); SurveyUI.Add(new SurveyItem("chkColdRoom", 2131034438)); SurveyUI.Add(new SurveyItem("chkComputer", 2131035037)); SurveyUI.Add(new SurveyItem("chkCookingBoughtWood", 2131034556)); SurveyUI.Add(new SurveyItem("chkCookingCapturedWood", 2131034557)); SurveyUI.Add(new SurveyItem("chkCookingCharcoal", 2131034555)); SurveyUI.Add(new SurveyItem("chkCookingElectricity", 2131034552)); SurveyUI.Add(new SurveyItem("chkCookingGasoline", 2131034554)); SurveyUI.Add(new SurveyItem("chkCookingKerosene", 2131034553)); SurveyUI.Add(new SurveyItem("chkCookingPropane", 2131034551)); SurveyUI.Add(new SurveyItem("chkDVDBluRay", 2131035015)); SurveyUI.Add(new SurveyItem("chkDiggings", 2131034433)); SurveyUI.Add(new SurveyItem("chkDryer", 2131034905)); SurveyUI.Add(new SurveyItem("chkElectricHeater", 2131034525)); SurveyUI.Add(new SurveyItem("chkElectricHeating", 2131034537)); SurveyUI.Add(new SurveyItem("chkElectricShower", 2131034529)); SurveyUI.Add(new SurveyItem("chkFan1", 2131034497)); SurveyUI.Add(new SurveyItem("chkFan2", 2131034502)); SurveyUI.Add(new SurveyItem("chkFan3", 2131034507)); SurveyUI.Add(new SurveyItem("chkFreezer", 2131034448)); SurveyUI.Add(new SurveyItem("chkFreon", 2131034487)); SurveyUI.Add(new SurveyItem("chkFridge", 2131034428)); SurveyUI.Add(new SurveyItem("chkGasHeater", 2131034517)); SurveyUI.Add(new SurveyItem("chkGasHeating", 2131034533)); SurveyUI.Add(new SurveyItem("chkHairDryer", 2131035026)); SurveyUI.Add(new SurveyItem("chkHomeTheater", 2131035004)); SurveyUI.Add(new SurveyItem("chkIncome1", 2131035081)); SurveyUI.Add(new SurveyItem("chkIncome10", 2131035207)); SurveyUI.Add(new SurveyItem("chkIncome2", 2131035095)); SurveyUI.Add(new SurveyItem("chkIncome3", 2131035109)); SurveyUI.Add(new SurveyItem("chkIncome4", 2131035123)); SurveyUI.Add(new SurveyItem("chkIncome5", 2131035137)); SurveyUI.Add(new SurveyItem("chkIncome6", 2131035151)); SurveyUI.Add(new SurveyItem("chkIncome7", 2131035165)); SurveyUI.Add(new SurveyItem("chkIncome8", 2131035179)); SurveyUI.Add(new SurveyItem("chkIncome9", 2131035193)); SurveyUI.Add(new SurveyItem("chkInternet", 2131034273)); SurveyUI.Add(new SurveyItem("chkIron", 2131034883)); SurveyUI.Add(new SurveyItem("chkLCDTV", 2131034971)); SurveyUI.Add(new SurveyItem("chkLEDTV", 2131034993)); SurveyUI.Add(new SurveyItem("chkMinisplit", 2131034467)); SurveyUI.Add(new SurveyItem("chkMunicipalityAqueduct", 2131034228)); SurveyUI.Add(new SurveyItem("chkNevecon", 2131034443)); SurveyUI.Add(new SurveyItem("chkOtherCooking", 2131034560)); SurveyUI.Add(new SurveyItem("chkOtherElectronics", 2131035048)); SurveyUI.Add(new SurveyItem("chkPhoneline", 2131034267)); SurveyUI.Add(new SurveyItem("chkPlasmaTV", 2131034982)); SurveyUI.Add(new SurveyItem("chkPublicStoup", 2131034236)); SurveyUI.Add(new SurveyItem("chkRadio", 2131034938)); SurveyUI.Add(new SurveyItem("chkRadioComm", 2131034271)); SurveyUI.Add(new SurveyItem("chkRain", 2131034234)); SurveyUI.Add(new SurveyItem("chkRead1", 2131035079)); SurveyUI.Add(new SurveyItem("chkRead10", 2131035205)); SurveyUI.Add(new SurveyItem("chkRead2", 2131035093)); SurveyUI.Add(new SurveyItem("chkRead3", 2131035107)); SurveyUI.Add(new SurveyItem("chkRead4", 2131035121));


16

SurveyUI.Add(new SurveyItem("chkRead5", 2131035135)); SurveyUI.Add(new SurveyItem("chkRead6", 2131035149)); SurveyUI.Add(new SurveyItem("chkRead7", 2131035163)); SurveyUI.Add(new SurveyItem("chkRead8", 2131035177)); SurveyUI.Add(new SurveyItem("chkRead9", 2131035191)); SurveyUI.Add(new SurveyItem("chkRiceCooker", 2131034839)); SurveyUI.Add(new SurveyItem("chkRiver", 2131034233)); SurveyUI.Add(new SurveyItem("chkSandwichMaker", 2131034861)); SurveyUI.Add(new SurveyItem("chkShiningMachine", 2131034916)); SurveyUI.Add(new SurveyItem("chkSoundEquip", 2131034949)); SurveyUI.Add(new SurveyItem("chkSplit", 2131034462)); SurveyUI.Add(new SurveyItem("chkStepGasHeater", 2131034521)); SurveyUI.Add(new SurveyItem("chkStudying1", 2131035082)); SurveyUI.Add(new SurveyItem("chkStudying10", 2131035208)); SurveyUI.Add(new SurveyItem("chkStudying2", 2131035096)); SurveyUI.Add(new SurveyItem("chkStudying3", 2131035110)); SurveyUI.Add(new SurveyItem("chkStudying4", 2131035124)); SurveyUI.Add(new SurveyItem("chkStudying5", 2131035138)); SurveyUI.Add(new SurveyItem("chkStudying6", 2131035152)); SurveyUI.Add(new SurveyItem("chkStudying7", 2131035166)); SurveyUI.Add(new SurveyItem("chkStudying8", 2131035180)); SurveyUI.Add(new SurveyItem("chkStudying9", 2131035194)); SurveyUI.Add(new SurveyItem("chkTowers", 2131034472)); SurveyUI.Add(new SurveyItem("chkVacuum", 2131034927)); SurveyUI.Add(new SurveyItem("chkVillageAqueduct", 2131034229)); SurveyUI.Add(new SurveyItem("chkWashingMachine", 2131034894)); SurveyUI.Add(new SurveyItem("chkWaterTruck", 2131034238)); SurveyUI.Add(new SurveyItem("chkWellWithPump", 2131034230)); SurveyUI.Add(new SurveyItem("chkWellWithoutPump", 2131034231)); SurveyUI.Add(new SurveyItem("chkWindow", 2131034459)); SurveyUI.Add(new SurveyItem("lblTotalPrepHours", 2131034624)); SurveyUI.Add(new SurveyItem("lblTotalPrepMinutes", 2131034625)); SurveyUI.Add(new SurveyItem("lblTotalPrepPeopleInside", 2131034626)); SurveyUI.Add(new SurveyItem("lblTotalPrepPeopleOutside", 2131034627)); SurveyUI.Add(new SurveyItem("lstAcademicDegree1", 2131035083)); SurveyUI.Add(new SurveyItem("lstAcademicDegree10", 2131035209)); SurveyUI.Add(new SurveyItem("lstAcademicDegree2", 2131035097)); SurveyUI.Add(new SurveyItem("lstAcademicDegree3", 2131035111)); SurveyUI.Add(new SurveyItem("lstAcademicDegree4", 2131035125)); SurveyUI.Add(new SurveyItem("lstAcademicDegree5", 2131035139)); SurveyUI.Add(new SurveyItem("lstAcademicDegree6", 2131035153)); SurveyUI.Add(new SurveyItem("lstAcademicDegree7", 2131035167)); SurveyUI.Add(new SurveyItem("lstAcademicDegree8", 2131035181)); SurveyUI.Add(new SurveyItem("lstAcademicDegree9", 2131035195)); SurveyUI.Add(new SurveyItem("lstActivity1", 2131035084)); SurveyUI.Add(new SurveyItem("lstActivity10", 2131035210)); SurveyUI.Add(new SurveyItem("lstActivity2", 2131035098)); SurveyUI.Add(new SurveyItem("lstActivity3", 2131035112)); SurveyUI.Add(new SurveyItem("lstActivity4", 2131035126)); SurveyUI.Add(new SurveyItem("lstActivity5", 2131035140)); SurveyUI.Add(new SurveyItem("lstActivity6", 2131035154)); SurveyUI.Add(new SurveyItem("lstActivity7", 2131035168)); SurveyUI.Add(new SurveyItem("lstActivity8", 2131035182)); SurveyUI.Add(new SurveyItem("lstActivity9", 2131035196)); SurveyUI.Add(new SurveyItem("lstHealth1", 2131035085)); SurveyUI.Add(new SurveyItem("lstHealth10", 2131035211)); SurveyUI.Add(new SurveyItem("lstHealth2", 2131035099)); SurveyUI.Add(new SurveyItem("lstHealth3", 2131035113));


17

SurveyUI.Add(new SurveyItem("lstHealth4", 2131035127)); SurveyUI.Add(new SurveyItem("lstHealth5", 2131035141)); SurveyUI.Add(new SurveyItem("lstHealth6", 2131035155)); SurveyUI.Add(new SurveyItem("lstHealth7", 2131035169)); SurveyUI.Add(new SurveyItem("lstHealth8", 2131035183)); SurveyUI.Add(new SurveyItem("lstHealth9", 2131035197)); SurveyUI.Add(new SurveyItem("lstKinship1", 2131035074)); SurveyUI.Add(new SurveyItem("lstKinship10", 2131035200)); SurveyUI.Add(new SurveyItem("lstKinship2", 2131035088)); SurveyUI.Add(new SurveyItem("lstKinship3", 2131035102)); SurveyUI.Add(new SurveyItem("lstKinship4", 2131035116)); SurveyUI.Add(new SurveyItem("lstKinship5", 2131035130)); SurveyUI.Add(new SurveyItem("lstKinship6", 2131035144)); SurveyUI.Add(new SurveyItem("lstKinship7", 2131035158)); SurveyUI.Add(new SurveyItem("lstKinship8", 2131035172)); SurveyUI.Add(new SurveyItem("lstKinship9", 2131035186)); SurveyUI.Add(new SurveyItem("lstMunicipality", 2131034137)); SurveyUI.Add(new SurveyItem("rad2ndStove", 2131034630)); SurveyUI.Add(new SurveyItem("rad2ndStoveCombustible", 2131034640)); SurveyUI.Add(new SurveyItem("radAboutPayment", 2131034328)); SurveyUI.Add(new SurveyItem("radAboutSetupPayment", 2131034338)); SurveyUI.Add(new SurveyItem("radBasicOvenDSM", 2131034802)); SurveyUI.Add(new SurveyItem("radBlenderDSM", 2131034856)); SurveyUI.Add(new SurveyItem("radBoughtWoodDSM", 2131034689)); SurveyUI.Add(new SurveyItem("radBoughtWoodSource", 2131034742)); SurveyUI.Add(new SurveyItem("radBrownerOvenDSM", 2131034820)); SurveyUI.Add(new SurveyItem("radCRTTVDSM", 2131034966)); SurveyUI.Add(new SurveyItem("radCanBeProvided", 2131034300)); SurveyUI.Add(new SurveyItem("radCapturedWoodCriteria", 2131034764)); SurveyUI.Add(new SurveyItem("radCapturedWoodDSM", 2131034699)); SurveyUI.Add(new SurveyItem("radCapturedWoodSource", 2131034734)); SurveyUI.Add(new SurveyItem("radCharcoalDSM", 2131034679)); SurveyUI.Add(new SurveyItem("radCoffeePotDSM", 2131034878)); SurveyUI.Add(new SurveyItem("radComputerDSM", 2131035043)); SurveyUI.Add(new SurveyItem("radCookingLocation", 2131034543)); SurveyUI.Add(new SurveyItem("radDVDBluRayDSM", 2131035021)); SurveyUI.Add(new SurveyItem("radDryerDSM", 2131034911)); SurveyUI.Add(new SurveyItem("radElectricity", 2131034278)); SurveyUI.Add(new SurveyItem("radElectricityMeter", 2131034285)); SurveyUI.Add(new SurveyItem("radEnoughWood", 2131034718)); SurveyUI.Add(new SurveyItem("radFloorMaterial", 2131034217)); SurveyUI.Add(new SurveyItem("radFreq2ndStove", 2131034635)); SurveyUI.Add(new SurveyItem("radGarbage", 2131034256)); SurveyUI.Add(new SurveyItem("radGender1", 2131035075)); SurveyUI.Add(new SurveyItem("radGender10", 2131035201)); SurveyUI.Add(new SurveyItem("radGender2", 2131035089)); SurveyUI.Add(new SurveyItem("radGender3", 2131035103)); SurveyUI.Add(new SurveyItem("radGender4", 2131035117)); SurveyUI.Add(new SurveyItem("radGender5", 2131035131)); SurveyUI.Add(new SurveyItem("radGender6", 2131035145)); SurveyUI.Add(new SurveyItem("radGender7", 2131035159)); SurveyUI.Add(new SurveyItem("radGender8", 2131035173)); SurveyUI.Add(new SurveyItem("radGender9", 2131035187)); SurveyUI.Add(new SurveyItem("radHairDryerDSM", 2131035032)); SurveyUI.Add(new SurveyItem("radHomeTheaterDSM", 2131035010)); SurveyUI.Add(new SurveyItem("radHomeType", 2131034153)); SurveyUI.Add(new SurveyItem("radHomeUsage", 2131034175)); SurveyUI.Add(new SurveyItem("radInvoice", 2131034296));


18

SurveyUI.Add(new SurveyItem("radIronDSM", 2131034889)); SurveyUI.Add(new SurveyItem("radKerGasDSM", 2131034669)); SurveyUI.Add(new SurveyItem("radLCDTVDSM", 2131034977)); SurveyUI.Add(new SurveyItem("radLEDTVDSM", 2131034999)); SurveyUI.Add(new SurveyItem("radLocation", 2131034140)); SurveyUI.Add(new SurveyItem("radMainLightning", 2131034351)); SurveyUI.Add(new SurveyItem("radMicrowaveOvenDSM", 2131034811)); SurveyUI.Add(new SurveyItem("radOtherElectronicsDSM", 2131035054)); SurveyUI.Add(new SurveyItem("radOthercombustibleDSM", 2131034709)); SurveyUI.Add(new SurveyItem("radOvenCombustible", 2131034784)); SurveyUI.Add(new SurveyItem("radOvenUsage", 2131034780)); SurveyUI.Add(new SurveyItem("radOwnership", 2131034166)); SurveyUI.Add(new SurveyItem("radPlasmaTVDSM", 2131034988)); SurveyUI.Add(new SurveyItem("radPropaneDSM", 2131034659)); SurveyUI.Add(new SurveyItem("radRadioDSM", 2131034944)); SurveyUI.Add(new SurveyItem("radRiceCookerDSM", 2131034845)); SurveyUI.Add(new SurveyItem("radSandwichMakerDSM", 2131034867)); SurveyUI.Add(new SurveyItem("radSanitaryService", 2131034249)); SurveyUI.Add(new SurveyItem("radServiceInterrupt", 2131034317)); SurveyUI.Add(new SurveyItem("radSewerage", 2131034245)); SurveyUI.Add(new SurveyItem("radShiningMachineDSM", 2131034922)); SurveyUI.Add(new SurveyItem("radSoundEquipDSM", 2131034955)); SurveyUI.Add(new SurveyItem("radTotalIncome", 2131035216)); SurveyUI.Add(new SurveyItem("radVacuumDSM", 2131034933)); SurveyUI.Add(new SurveyItem("radWallMaterial", 2131034184)); SurveyUI.Add(new SurveyItem("radWashingMachineDSM", 2131034900)); SurveyUI.Add(new SurveyItem("radWoodSource", 2131034726)); SurveyUI.Add(new SurveyItem("radWoodStoveAllday", 2131034775)); SurveyUI.Add(new SurveyItem("radWoodStoveType", 2131034749)); SurveyUI.Add(new SurveyItem("txt6MonthAvg", 2131034312)); SurveyUI.Add(new SurveyItem("txtAMHours1", 2131034380)); SurveyUI.Add(new SurveyItem("txtAMHours2", 2131034389)); SurveyUI.Add(new SurveyItem("txtAMHours3", 2131034398)); SurveyUI.Add(new SurveyItem("txtAMHours4", 2131034407)); SurveyUI.Add(new SurveyItem("txtAMHours5", 2131034416)); SurveyUI.Add(new SurveyItem("txtAMMinutes1", 2131034381)); SurveyUI.Add(new SurveyItem("txtAMMinutes2", 2131034390)); SurveyUI.Add(new SurveyItem("txtAMMinutes3", 2131034399)); SurveyUI.Add(new SurveyItem("txtAMMinutes4", 2131034408)); SurveyUI.Add(new SurveyItem("txtAMMinutes5", 2131034417)); SurveyUI.Add(new SurveyItem("txtAge1", 2131035078)); SurveyUI.Add(new SurveyItem("txtAge10", 2131035204)); SurveyUI.Add(new SurveyItem("txtAge2", 2131035092)); SurveyUI.Add(new SurveyItem("txtAge3", 2131035106)); SurveyUI.Add(new SurveyItem("txtAge4", 2131035120)); SurveyUI.Add(new SurveyItem("txtAge5", 2131035134)); SurveyUI.Add(new SurveyItem("txtAge6", 2131035148)); SurveyUI.Add(new SurveyItem("txtAge7", 2131035162)); SurveyUI.Add(new SurveyItem("txtAge8", 2131035176)); SurveyUI.Add(new SurveyItem("txtAge9", 2131035190)); SurveyUI.Add(new SurveyItem("txtAmmoniaHours", 2131034495)); SurveyUI.Add(new SurveyItem("txtAmmoniaPower", 2131034494)); SurveyUI.Add(new SurveyItem("txtBasicOvenPower", 2131034799)); SurveyUI.Add(new SurveyItem("txtBasicOvenUsage", 2131034801)); SurveyUI.Add(new SurveyItem("txtBilledPeriod", 2131034305)); SurveyUI.Add(new SurveyItem("txtBlenderFreq", 2131034855)); SurveyUI.Add(new SurveyItem("txtBlenderHours", 2131034853)); SurveyUI.Add(new SurveyItem("txtBlenderMinutes", 2131034854));


19

SurveyUI.Add(new SurveyItem("txtBlenderSpec", 2131034852)); SurveyUI.Add(new SurveyItem("txtBoughtWoodFreq", 2131034688)); SurveyUI.Add(new SurveyItem("txtBoughtWoodPaid", 2131034693)); SurveyUI.Add(new SurveyItem("txtBoughtWoodUnit", 2131034687)); SurveyUI.Add(new SurveyItem("txtBreakfastHours", 2131034589)); SurveyUI.Add(new SurveyItem("txtBreakfastMunites", 2131034590)); SurveyUI.Add(new SurveyItem("txtBreakfastPeopleInside", 2131034591)); SurveyUI.Add(new SurveyItem("txtBreakfastPeopleOutside", 2131034592)); SurveyUI.Add(new SurveyItem("txtBrownerOvenPower", 2131034817)); SurveyUI.Add(new SurveyItem("txtBrownerOvenUsage", 2131034819)); SurveyUI.Add(new SurveyItem("txtBulbPower1", 2131034379)); SurveyUI.Add(new SurveyItem("txtBulbPower2", 2131034388)); SurveyUI.Add(new SurveyItem("txtBulbPower3", 2131034397)); SurveyUI.Add(new SurveyItem("txtCRTTVFreq", 2131034965)); SurveyUI.Add(new SurveyItem("txtCRTTVHours", 2131034963)); SurveyUI.Add(new SurveyItem("txtCRTTVMinutes", 2131034964)); SurveyUI.Add(new SurveyItem("txtCRTTVSpec", 2131034962)); SurveyUI.Add(new SurveyItem("txtCaptureWoodUnitFreq", 2131034756)); SurveyUI.Add(new SurveyItem("txtCapturedWoodFreq", 2131034698)); SurveyUI.Add(new SurveyItem("txtCapturedWoodPaid", 2131034703)); SurveyUI.Add(new SurveyItem("txtCapturedWoodUnit", 2131034697)); SurveyUI.Add(new SurveyItem("txtCentralHours", 2131034485)); SurveyUI.Add(new SurveyItem("txtCentralPower", 2131034484)); SurveyUI.Add(new SurveyItem("txtCharcoalFreq", 2131034678)); SurveyUI.Add(new SurveyItem("txtCharcoalPaid", 2131034683)); SurveyUI.Add(new SurveyItem("txtCharcoalUnit", 2131034677)); SurveyUI.Add(new SurveyItem("txtChillerHours", 2131034480)); SurveyUI.Add(new SurveyItem("txtChillerPower", 2131034479)); SurveyUI.Add(new SurveyItem("txtCofeePotSpec", 2131034874)); SurveyUI.Add(new SurveyItem("txtCoffeeHours", 2131034613)); SurveyUI.Add(new SurveyItem("txtCoffeeMinutes", 2131034614)); SurveyUI.Add(new SurveyItem("txtCoffeePeopleInside", 2131034615)); SurveyUI.Add(new SurveyItem("txtCoffeePeopleOutside", 2131034616)); SurveyUI.Add(new SurveyItem("txtCoffeePotFreq", 2131034877)); SurveyUI.Add(new SurveyItem("txtCoffeePotHours", 2131034875)); SurveyUI.Add(new SurveyItem("txtCoffeePotMinutes", 2131034876)); SurveyUI.Add(new SurveyItem("txtColdRoomMark", 2131034440)); SurveyUI.Add(new SurveyItem("txtColdRoomVolume", 2131034441)); SurveyUI.Add(new SurveyItem("txtComputerFreq", 2131035042)); SurveyUI.Add(new SurveyItem("txtComputerHours", 2131035040)); SurveyUI.Add(new SurveyItem("txtComputerMinutes", 2131035041)); SurveyUI.Add(new SurveyItem("txtComputerSpec", 2131035039)); SurveyUI.Add(new SurveyItem("txtConsumption", 2131034310)); SurveyUI.Add(new SurveyItem("txtDVDBluRayFreq", 2131035020)); SurveyUI.Add(new SurveyItem("txtDVDBluRayHours", 2131035018)); SurveyUI.Add(new SurveyItem("txtDVDBluRayMinutes", 2131035019)); SurveyUI.Add(new SurveyItem("txtDVDBluRaySpec", 2131035017)); SurveyUI.Add(new SurveyItem("txtDate", 2131034126)); SurveyUI.Add(new SurveyItem("txtDiggingMark", 2131034435)); SurveyUI.Add(new SurveyItem("txtDiggingVolume", 2131034436)); SurveyUI.Add(new SurveyItem("txtDinnerHours", 2131034601)); SurveyUI.Add(new SurveyItem("txtDinnerMinutes", 2131034602)); SurveyUI.Add(new SurveyItem("txtDinnerPeopleInside", 2131034603)); SurveyUI.Add(new SurveyItem("txtDinnerPeopleOutside", 2131034604)); SurveyUI.Add(new SurveyItem("txtDperW", 2131034290)); SurveyUI.Add(new SurveyItem("txtDryerFreq", 2131034910)); SurveyUI.Add(new SurveyItem("txtDryerHours", 2131034908)); SurveyUI.Add(new SurveyItem("txtDryerMinutes", 2131034909));


20

SurveyUI.Add(new SurveyItem("txtDryerSpec", 2131034907)); SurveyUI.Add(new SurveyItem("txtEach2ndStove", 2131034634)); SurveyUI.Add(new SurveyItem("txtEconoPower", 2131034406)); SurveyUI.Add(new SurveyItem("txtElectricHeaterHours", 2131034527)); SurveyUI.Add(new SurveyItem("txtElectricHeaterSpec", 2131034526)); SurveyUI.Add(new SurveyItem("txtElectricHeatingHours", 2131034539)); SurveyUI.Add(new SurveyItem("txtElectricHeatingSpec", 2131034538)); SurveyUI.Add(new SurveyItem("txtElectricShowerHours", 2131034531)); SurveyUI.Add(new SurveyItem("txtElectricShowerSpec", 2131034530)); SurveyUI.Add(new SurveyItem("txtFanHours1", 2131034500)); SurveyUI.Add(new SurveyItem("txtFanHours2", 2131034505)); SurveyUI.Add(new SurveyItem("txtFanHours3", 2131034510)); SurveyUI.Add(new SurveyItem("txtFanPower1", 2131034499)); SurveyUI.Add(new SurveyItem("txtFanPower2", 2131034504)); SurveyUI.Add(new SurveyItem("txtFanPower3", 2131034509)); SurveyUI.Add(new SurveyItem("txtFlourescentPower", 2131034415)); SurveyUI.Add(new SurveyItem("txtFreezerMark", 2131034450)); SurveyUI.Add(new SurveyItem("txtFreezerVolume", 2131034451)); SurveyUI.Add(new SurveyItem("txtFreonHours", 2131034490)); SurveyUI.Add(new SurveyItem("txtFreonPower", 2131034489)); SurveyUI.Add(new SurveyItem("txtFridgeMark", 2131034430)); SurveyUI.Add(new SurveyItem("txtFridgeVolume", 2131034431)); SurveyUI.Add(new SurveyItem("txtGarages", 2131034208)); SurveyUI.Add(new SurveyItem("txtGasHeaterHours", 2131034519)); SurveyUI.Add(new SurveyItem("txtGasHeaterSpec", 2131034518)); SurveyUI.Add(new SurveyItem("txtGasHeatingHours", 2131034535)); SurveyUI.Add(new SurveyItem("txtGasHeatingSpec", 2131034534)); SurveyUI.Add(new SurveyItem("txtHairDryerFreq", 2131035031)); SurveyUI.Add(new SurveyItem("txtHairDryerHours", 2131035029)); SurveyUI.Add(new SurveyItem("txtHairDryerMinutes", 2131035030)); SurveyUI.Add(new SurveyItem("txtHairDryerSpec", 2131035028)); SurveyUI.Add(new SurveyItem("txtHeatingWaterHours", 2131034607)); SurveyUI.Add(new SurveyItem("txtHeatingWaterMinutes", 2131034608)); SurveyUI.Add(new SurveyItem("txtHeatingWaterPeopleInside", 2131034609)); SurveyUI.Add(new SurveyItem("txtHeatingWaterPeopleOutside", 2131034610)); SurveyUI.Add(new SurveyItem("txtHomeTheaterFreq", 2131035009)); SurveyUI.Add(new SurveyItem("txtHomeTheaterHours", 2131035007)); SurveyUI.Add(new SurveyItem("txtHomeTheaterMinutes", 2131035008)); SurveyUI.Add(new SurveyItem("txtHomeTheaterSpec", 2131035006)); SurveyUI.Add(new SurveyItem("txtHoursLightning", 2131034359)); SurveyUI.Add(new SurveyItem("txtHperD", 2131034293)); SurveyUI.Add(new SurveyItem("txtInterruptTime", 2131034325)); SurveyUI.Add(new SurveyItem("txtIronFreq", 2131034888)); SurveyUI.Add(new SurveyItem("txtIronHours", 2131034886)); SurveyUI.Add(new SurveyItem("txtIronMinutes", 2131034887)); SurveyUI.Add(new SurveyItem("txtIronSpec", 2131034885)); SurveyUI.Add(new SurveyItem("txtKerGasFreq", 2131034668)); SurveyUI.Add(new SurveyItem("txtKerGasPaid", 2131034673)); SurveyUI.Add(new SurveyItem("txtKerGasUnit", 2131034667)); SurveyUI.Add(new SurveyItem("txtLCDTVFreq", 2131034976)); SurveyUI.Add(new SurveyItem("txtLCDTVHours", 2131034974)); SurveyUI.Add(new SurveyItem("txtLCDTVMinutes", 2131034975)); SurveyUI.Add(new SurveyItem("txtLCDTVSpec", 2131034973)); SurveyUI.Add(new SurveyItem("txtLEDTVFreq", 2131034998)); SurveyUI.Add(new SurveyItem("txtLEDTVHours", 2131034996)); SurveyUI.Add(new SurveyItem("txtLEDTVMinutes", 2131034997)); SurveyUI.Add(new SurveyItem("txtLEDTVSpec", 2131034995)); SurveyUI.Add(new SurveyItem("txtLocation", 2131034148));


21

SurveyUI.Add(new SurveyItem("txtLunchHours", 2131034595)); SurveyUI.Add(new SurveyItem("txtLunchMinutes", 2131034596)); SurveyUI.Add(new SurveyItem("txtLunchPeopleInside", 2131034597)); SurveyUI.Add(new SurveyItem("txtLunchPeopleOutside", 2131034598)); SurveyUI.Add(new SurveyItem("txtMicrowaveOvenPower", 2131034808)); SurveyUI.Add(new SurveyItem("txtMicrowaveOvenUsage", 2131034810)); SurveyUI.Add(new SurveyItem("txtMinisplitHours", 2131034470)); SurveyUI.Add(new SurveyItem("txtMinisplitPower", 2131034469)); SurveyUI.Add(new SurveyItem("txtMinperDay", 2131034826)); SurveyUI.Add(new SurveyItem("txtMonthlyPayment", 2131034346)); SurveyUI.Add(new SurveyItem("txtNameAtHome1", 2131035073)); SurveyUI.Add(new SurveyItem("txtNameAtHome10", 2131035199)); SurveyUI.Add(new SurveyItem("txtNameAtHome2", 2131035087)); SurveyUI.Add(new SurveyItem("txtNameAtHome3", 2131035101)); SurveyUI.Add(new SurveyItem("txtNameAtHome4", 2131035115)); SurveyUI.Add(new SurveyItem("txtNameAtHome5", 2131035129)); SurveyUI.Add(new SurveyItem("txtNameAtHome6", 2131035143)); SurveyUI.Add(new SurveyItem("txtNameAtHome7", 2131035157)); SurveyUI.Add(new SurveyItem("txtNameAtHome9", 2131035185)); SurveyUI.Add(new SurveyItem("txtNameAthome8", 2131035171)); SurveyUI.Add(new SurveyItem("txtNeveconMark", 2131034445)); SurveyUI.Add(new SurveyItem("txtNeveconVolume", 2131034446)); SurveyUI.Add(new SurveyItem("txtNumAmmonia", 2131034493)); SurveyUI.Add(new SurveyItem("txtNumBasicOvens", 2131034800)); SurveyUI.Add(new SurveyItem("txtNumBathrooms", 2131034203)); SurveyUI.Add(new SurveyItem("txtNumBlenders", 2131034851)); SurveyUI.Add(new SurveyItem("txtNumBoughtWood", 2131034686)); SurveyUI.Add(new SurveyItem("txtNumBrownerOvens", 2131034818)); SurveyUI.Add(new SurveyItem("txtNumBulb1", 2131034378)); SurveyUI.Add(new SurveyItem("txtNumBulb2", 2131034387)); SurveyUI.Add(new SurveyItem("txtNumBulb3", 2131034396)); SurveyUI.Add(new SurveyItem("txtNumCRTTVs", 2131034961)); SurveyUI.Add(new SurveyItem("txtNumCapturedWood", 2131034696)); SurveyUI.Add(new SurveyItem("txtNumCentrals", 2131034483)); SurveyUI.Add(new SurveyItem("txtNumCharcoal", 2131034676)); SurveyUI.Add(new SurveyItem("txtNumChillers", 2131034478)); SurveyUI.Add(new SurveyItem("txtNumCoffeePots", 2131034873)); SurveyUI.Add(new SurveyItem("txtNumColdRooms", 2131034439)); SurveyUI.Add(new SurveyItem("txtNumComputers", 2131035038)); SurveyUI.Add(new SurveyItem("txtNumDVDBluRays", 2131035016)); SurveyUI.Add(new SurveyItem("txtNumDiggings", 2131034434)); SurveyUI.Add(new SurveyItem("txtNumDiningCommons", 2131034200)); SurveyUI.Add(new SurveyItem("txtNumDryers", 2131034906)); SurveyUI.Add(new SurveyItem("txtNumEcono", 2131034405)); SurveyUI.Add(new SurveyItem("txtNumFamilies", 2131034161)); SurveyUI.Add(new SurveyItem("txtNumFans1", 2131034498)); SurveyUI.Add(new SurveyItem("txtNumFans2", 2131034503)); SurveyUI.Add(new SurveyItem("txtNumFans3", 2131034508)); SurveyUI.Add(new SurveyItem("txtNumFlourescent", 2131034414)); SurveyUI.Add(new SurveyItem("txtNumFreezers", 2131034449)); SurveyUI.Add(new SurveyItem("txtNumFreon", 2131034488)); SurveyUI.Add(new SurveyItem("txtNumFridges", 2131034429)); SurveyUI.Add(new SurveyItem("txtNumHairDryers", 2131035027)); SurveyUI.Add(new SurveyItem("txtNumHomeTheaters", 2131035005)); SurveyUI.Add(new SurveyItem("txtNumIrons", 2131034884)); SurveyUI.Add(new SurveyItem("txtNumKerGas", 2131034666)); SurveyUI.Add(new SurveyItem("txtNumKitchens", 2131034197)); SurveyUI.Add(new SurveyItem("txtNumLCDTVs", 2131034972));


22

SurveyUI.Add(new SurveyItem("txtNumLEDTVs", 2131034994)); SurveyUI.Add(new SurveyItem("txtNumMicrowaveOvens", 2131034809)); SurveyUI.Add(new SurveyItem("txtNumMinisplits", 2131034468)); SurveyUI.Add(new SurveyItem("txtNumNevecons", 2131034444)); SurveyUI.Add(new SurveyItem("txtNumOtherCombustible", 2131034706)); SurveyUI.Add(new SurveyItem("txtNumOtherElectronics", 2131035049)); SurveyUI.Add(new SurveyItem("txtNumPeople", 2131034163)); SurveyUI.Add(new SurveyItem("txtNumPlasmaTVs", 2131034983)); SurveyUI.Add(new SurveyItem("txtNumPropane", 2131034656)); SurveyUI.Add(new SurveyItem("txtNumRadios", 2131034939)); SurveyUI.Add(new SurveyItem("txtNumRiceMakers", 2131034840)); SurveyUI.Add(new SurveyItem("txtNumRooms", 2131034194)); SurveyUI.Add(new SurveyItem("txtNumSandwichMakers", 2131034862)); SurveyUI.Add(new SurveyItem("txtNumShiningMachines", 2131034917)); SurveyUI.Add(new SurveyItem("txtNumSoundEquip", 2131034950)); SurveyUI.Add(new SurveyItem("txtNumSplits", 2131034463)); SurveyUI.Add(new SurveyItem("txtNumStoveBurners", 2131034564)); SurveyUI.Add(new SurveyItem("txtNumStoves1", 2131034572)); SurveyUI.Add(new SurveyItem("txtNumStoves2", 2131034575)); SurveyUI.Add(new SurveyItem("txtNumStoves3", 2131034578)); SurveyUI.Add(new SurveyItem("txtNumTowers", 2131034473)); SurveyUI.Add(new SurveyItem("txtNumVacuums", 2131034928)); SurveyUI.Add(new SurveyItem("txtNumWashingMachines", 2131034895)); SurveyUI.Add(new SurveyItem("txtNumWindows", 2131034460)); SurveyUI.Add(new SurveyItem("txtObservations", 2131034214)); SurveyUI.Add(new SurveyItem("txtOtherCombustibleFreq", 2131034708)); SurveyUI.Add(new SurveyItem("txtOtherCombustiblePaid", 2131034713)); SurveyUI.Add(new SurveyItem("txtOtherCombustibleUnit", 2131034707)); SurveyUI.Add(new SurveyItem("txtOtherCooking", 2131034562)); SurveyUI.Add(new SurveyItem("txtOtherElectronicsFreq", 2131035053)); SurveyUI.Add(new SurveyItem("txtOtherElectronicsHours", 2131035051)); SurveyUI.Add(new SurveyItem("txtOtherElectronicsMinutes", 2131035052)); SurveyUI.Add(new SurveyItem("txtOtherElectronicsSpec", 2131035050)); SurveyUI.Add(new SurveyItem("txtOtherFloorMaterial", 2131034223)); SurveyUI.Add(new SurveyItem("txtOtherGarbage", 2131034264)); SurveyUI.Add(new SurveyItem("txtOtherHomeType", 2131034158)); SurveyUI.Add(new SurveyItem("txtOtherHomeUsage", 2131034181)); SurveyUI.Add(new SurveyItem("txtOtherPayment", 2131034335)); SurveyUI.Add(new SurveyItem("txtOtherPrepHours", 2131034619)); SurveyUI.Add(new SurveyItem("txtOtherPrepMinutes", 2131034620)); SurveyUI.Add(new SurveyItem("txtOtherPrepPeopleInside", 2131034621)); SurveyUI.Add(new SurveyItem("txtOtherPrepPeopleOutside", 2131034622)); SurveyUI.Add(new SurveyItem("txtPMHours1", 2131034382)); SurveyUI.Add(new SurveyItem("txtPMHours2", 2131034391)); SurveyUI.Add(new SurveyItem("txtPMHours3", 2131034400)); SurveyUI.Add(new SurveyItem("txtPMHours4", 2131034409)); SurveyUI.Add(new SurveyItem("txtPMHours5", 2131034418)); SurveyUI.Add(new SurveyItem("txtPMMinutes1", 2131034383)); SurveyUI.Add(new SurveyItem("txtPMMinutes2", 2131034392)); SurveyUI.Add(new SurveyItem("txtPMMinutes3", 2131034401)); SurveyUI.Add(new SurveyItem("txtPMMinutes4", 2131034410)); SurveyUI.Add(new SurveyItem("txtPMMinutes5", 2131034419)); SurveyUI.Add(new SurveyItem("txtPaidAmount", 2131034307)); SurveyUI.Add(new SurveyItem("txtPlasmaTVFreq", 2131034987)); SurveyUI.Add(new SurveyItem("txtPlasmaTVHours", 2131034985)); SurveyUI.Add(new SurveyItem("txtPlasmaTVMinutes", 2131034986)); SurveyUI.Add(new SurveyItem("txtPlasmaTVSpec", 2131034984)); SurveyUI.Add(new SurveyItem("txtPollsterName", 2131034130));


23

SurveyUI.Add(new SurveyItem("txtPropaneFreq", 2131034658)); SurveyUI.Add(new SurveyItem("txtPropanePaid", 2131034663)); SurveyUI.Add(new SurveyItem("txtPropaneUnit", 2131034657)); SurveyUI.Add(new SurveyItem("txtRadioFreq", 2131034943)); SurveyUI.Add(new SurveyItem("txtRadioHours", 2131034941)); SurveyUI.Add(new SurveyItem("txtRadioMinutes", 2131034942)); SurveyUI.Add(new SurveyItem("txtRadioSpec", 2131034940)); SurveyUI.Add(new SurveyItem("txtRespondent", 2131034135)); SurveyUI.Add(new SurveyItem("txtRiceCookerFreq", 2131034844)); SurveyUI.Add(new SurveyItem("txtRiceMakerHours", 2131034842)); SurveyUI.Add(new SurveyItem("txtRiceMakerMinutes", 2131034843)); SurveyUI.Add(new SurveyItem("txtRiceMakerSpec", 2131034841)); SurveyUI.Add(new SurveyItem("txtSandwichMakerFreq", 2131034866)); SurveyUI.Add(new SurveyItem("txtSandwichMakerHours", 2131034864)); SurveyUI.Add(new SurveyItem("txtSandwichMakerMinutes", 2131034865)); SurveyUI.Add(new SurveyItem("txtSandwichMakerSpec", 2131034863)); SurveyUI.Add(new SurveyItem("txtShiningMachineFreq", 2131034921)); SurveyUI.Add(new SurveyItem("txtShiningMachineHours", 2131034919)); SurveyUI.Add(new SurveyItem("txtShiningMachineMinutes", 2131034920)); SurveyUI.Add(new SurveyItem("txtShiningMachineSpec", 2131034918)); SurveyUI.Add(new SurveyItem("txtSoundEquipFreq", 2131034954)); SurveyUI.Add(new SurveyItem("txtSoundEquipHours", 2131034952)); SurveyUI.Add(new SurveyItem("txtSoundEquipMinutes", 2131034953)); SurveyUI.Add(new SurveyItem("txtSoundEquipSpec", 2131034951)); SurveyUI.Add(new SurveyItem("txtSplitHours", 2131034465)); SurveyUI.Add(new SurveyItem("txtSplitPower", 2131034464)); SurveyUI.Add(new SurveyItem("txtStepGasHeaterHours", 2131034523)); SurveyUI.Add(new SurveyItem("txtStepGasHeaterSpec", 2131034522)); SurveyUI.Add(new SurveyItem("txtStovePower1", 2131034573)); SurveyUI.Add(new SurveyItem("txtStovePower2", 2131034576)); SurveyUI.Add(new SurveyItem("txtStovePower3", 2131034579)); SurveyUI.Add(new SurveyItem("txtStrata", 2131034315)); SurveyUI.Add(new SurveyItem("txtSurveyID", 2131034128)); SurveyUI.Add(new SurveyItem("txtTSCapturedWood", 2131034763)); SurveyUI.Add(new SurveyItem("txtTSgettingWater", 2131034242)); SurveyUI.Add(new SurveyItem("txtTotalHours1", 2131034384)); SurveyUI.Add(new SurveyItem("txtTotalHours2", 2131034393)); SurveyUI.Add(new SurveyItem("txtTotalHours3", 2131034402)); SurveyUI.Add(new SurveyItem("txtTotalHours4", 2131034411)); SurveyUI.Add(new SurveyItem("txtTotalHours5", 2131034420)); SurveyUI.Add(new SurveyItem("txtTowerHours", 2131034475)); SurveyUI.Add(new SurveyItem("txtTowerPower", 2131034474)); SurveyUI.Add(new SurveyItem("txtVacuumFreq", 2131034932)); SurveyUI.Add(new SurveyItem("txtVacuumHours", 2131034930)); SurveyUI.Add(new SurveyItem("txtVacuumMinutes", 2131034931)); SurveyUI.Add(new SurveyItem("txtVacuumSpec", 2131034929)); SurveyUI.Add(new SurveyItem("txtWarehouses", 2131034211)); SurveyUI.Add(new SurveyItem("txtWashingMachineFreq", 2131034899)); SurveyUI.Add(new SurveyItem("txtWashingMachineMinutes", 2131034898)); SurveyUI.Add(new SurveyItem("txtWashingMachineSpec", 2131034896)); SurveyUI.Add(new SurveyItem("txtWasingMachineHours", 2131034897)); SurveyUI.Add(new SurveyItem("txtWoodStoveBurnTime", 2131034770)); SurveyUI.Add(new SurveyItem("txtWoodType", 2131034723)); SurveyUI.Add(new SurveyItem("txtWoodWeight", 2131034716)); } //------------------------------------------------------------------------ private string Record() {


24

StringBuilder result = new StringBuilder(); this.CaptureUI(); // foreach (SurveyItem obj in SurveyUI) { switch (obj.ObjectName.Substring(0, 3).Trim()) { case "txt": obj.Value = FindViewById<EditText>(obj.ObjectId).Text; break; case "lst": obj.Value = FindViewById<AutoCompleteTextView>(obj.ObjectId).Text; break; case "lbl": obj.Value = FindViewById<TextView>(obj.ObjectId).Text; break; case "chk": obj.Value = FindViewById<CheckBox>(obj.ObjectId).Checked.ToString(); break; case "rad": try { obj.Value = FindViewById<RadioButton>(FindViewById<RadioGroup>(obj.ObjectId).CheckedRadioButtonId).Text; } catch (Exception ex) { obj.Value = "N/A"; } break; } result.Append("[" + obj.ObjectName + "]" + obj.Value + "~"); } return (result.ToString()); } //------------------------------------------------------------------------ protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.Survey); txtRespondant = FindViewById<EditText>(Resource.Id.txtRespondent); txtPollsterName = FindViewById<EditText>(Resource.Id.txtPollsterName); Button _btnOk = FindViewById<Button>(Resource.Id.btnOk); _btnOk.Click += _btnOk_Click; Button _btnCancel = FindViewById<Button>(Resource.Id.btnCancel); _btnCancel.Click += _btnCancel_Click; AutoCompleteTextView lstMunicipality = FindViewById<AutoCompleteTextView>(Resource.Id.lstMunicipality); mymunicipality = new ArrayAdapter<string>(this, Resource.Layout.list, municipality); lstMunicipality.Adapter = mymunicipality; mykinship = new ArrayAdapter<string>(this, Resource.Layout.list, kinship); AutoCompleteTextView lstKinship1 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship1); lstKinship1.Adapter = mykinship; AutoCompleteTextView lstKinship2 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship2); lstKinship2.Adapter = mykinship; AutoCompleteTextView lstKinship3 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship3); lstKinship3.Adapter = mykinship;


25

AutoCompleteTextView lstKinship4 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship4); lstKinship4.Adapter = mykinship; AutoCompleteTextView lstKinship5 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship5); lstKinship5.Adapter = mykinship; AutoCompleteTextView lstKinship6 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship6); lstKinship6.Adapter = mykinship; AutoCompleteTextView lstKinship7 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship7); lstKinship7.Adapter = mykinship; AutoCompleteTextView lstKinship8 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship8); lstKinship8.Adapter = mykinship; AutoCompleteTextView lstKinship9 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship9); lstKinship9.Adapter = mykinship; AutoCompleteTextView lstKinship10 = FindViewById<AutoCompleteTextView>(Resource.Id.lstKinship10); lstKinship10.Adapter = mykinship; myacademicdegree = new ArrayAdapter<string>(this, Resource.Layout.list, academicdegree); AutoCompleteTextView lstAcademicDegree1 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree1); lstAcademicDegree1.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree2 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree2); lstAcademicDegree2.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree3 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree3); lstAcademicDegree3.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree4 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree4); lstAcademicDegree4.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree5 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree5); lstAcademicDegree5.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree6 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree6); lstAcademicDegree6.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree7 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree7); lstAcademicDegree7.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree8 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree8); lstAcademicDegree8.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree9 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree9); lstAcademicDegree9.Adapter = myacademicdegree; AutoCompleteTextView lstAcademicDegree10 = FindViewById<AutoCompleteTextView>(Resource.Id.lstAcademicDegree10); lstAcademicDegree10.Adapter = myacademicdegree; myactivities = new ArrayAdapter<string>(this, Resource.Layout.list, activities); AutoCompleteTextView lstActivity1 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity1); lstActivity1.Adapter = myactivities;


26

AutoCompleteTextView lstActivity2 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity2); lstActivity2.Adapter = myactivities; AutoCompleteTextView lstActivity3 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity3); lstActivity3.Adapter = myactivities; AutoCompleteTextView lstActivity4 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity4); lstActivity4.Adapter = myactivities; AutoCompleteTextView lstActivity5 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity5); lstActivity5.Adapter = myactivities; AutoCompleteTextView lstActivity6 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity6); lstActivity6.Adapter = myactivities; AutoCompleteTextView lstActivity7 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity7); lstActivity7.Adapter = myactivities; AutoCompleteTextView lstActivity8 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity8); lstActivity8.Adapter = myactivities; AutoCompleteTextView lstActivity9 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity9); lstActivity9.Adapter = myactivities; AutoCompleteTextView lstActivity10 = FindViewById<AutoCompleteTextView>(Resource.Id.lstActivity10); lstActivity10.Adapter = myactivities; myhealth = new ArrayAdapter<string>(this, Resource.Layout.list, health); AutoCompleteTextView lstHealth1 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth1); lstHealth1.Adapter = myhealth; AutoCompleteTextView lstHealth2 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth2); lstHealth2.Adapter = myhealth; AutoCompleteTextView lstHealth3 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth3); lstHealth3.Adapter = myhealth; AutoCompleteTextView lstHealth4 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth4); lstHealth4.Adapter = myhealth; AutoCompleteTextView lstHealth5 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth5); lstHealth5.Adapter = myhealth; AutoCompleteTextView lstHealth6 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth6); lstHealth6.Adapter = myhealth; AutoCompleteTextView lstHealth7 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth7); lstHealth7.Adapter = myhealth; AutoCompleteTextView lstHealth8 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth8); lstHealth8.Adapter = myhealth; AutoCompleteTextView lstHealth9 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth9); lstHealth9.Adapter = myhealth; AutoCompleteTextView lstHealth10 = FindViewById<AutoCompleteTextView>(Resource.Id.lstHealth10); lstHealth10.Adapter = myhealth;


27

} //------------------------------------------------------------------------ private void Save() { string info = this.Record(); result = false; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage("Desea grabar la Encuesta?"); builder.SetPositiveButton("Si", (sender, e) => { result = true; string Respondant = txtRespondant.Text; string PollsterName = txtPollsterName.Text; if (Respondant.Trim().Length == 0 || PollsterName.Trim().Length == 0) Toast.MakeText(this, "Ingrese el nombre del encuestado y del encuestador", Android.Widget.ToastLength.Short).Show(); else { SurveyDB surveyDB = new SurveyDB(this); try { surveyDB.WritableDatabase.ExecSQL("INSERT INTO survey(Respondent, PollsterName, info) VALUES ('" + Respondant + "','" + PollsterName + "','" + info + "')"); MainActivity main = (MainActivity)this.Parent; main.LoadData(); } catch (SQLException ex) { Toast.MakeText(this, ex.Message, Android.Widget.ToastLength.Short).Show(); } surveyDB.Close(); surveyDB.Dispose(); this.Finish(); } }); builder.SetNegativeButton("No", (sender, e) => { result = false; }); builder.Show(); result = true; } //------------------------------------------------------------------------ private void Cancel() { result = false; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetTitle("PERS Residencial"); builder.SetIcon(Android.Resource.Drawable.IcDialogAlert); builder.SetMessage("La informacion consignada en este formulario se perdera. Desea salir de la Encuesta?"); builder.SetPositiveButton("Si", (sender, e) => { result = true; this.Finish(); }); builder.SetNegativeButton("No", (sender, e) => { result = false; });


28

builder.Show(); result = true; } //------------------------------------------------------------------------ void _btnOk_Click(object sender, System.EventArgs e) { this.Save(); } //------------------------------------------------------------------------ void _btnCancel_Click(object sender, System.EventArgs e) { this.Cancel(); } //------------------------------------------------------------------------ } }

SurveyDB.cs

using System; using Android.Database.Sqlite; using Android.Content; namespace PERS_Home { class SurveyDB : SQLiteOpenHelper { public static readonly string DBName = "survey.db"; public static readonly int DBVersion = 1; //----------------------------------------------------------------------------------- public SurveyDB(Context context) : base(context, DBName, null, DBVersion) { } //----------------------------------------------------------------------------------- public override void OnCreate(SQLiteDatabase db) { db.ExecSQL("CREATE TABLE [survey] ([_id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, [Respondent] TEXT NOT NULL, [PollsterName] TEXT NOT NULL, [info] TEXT NOT NULL)"); } //----------------------------------------------------------------------------------- public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { throw new NotImplementedException(); } //----------------------------------------------------------------------------------- } }


29

ESTRUCTURA DE LA BASE DE DATOS PERS HOME

TABLA Survey CAMPO TIPO DE DATO PERMITE NULOS? ATRIBUTOS

_Id TEXT No UNIQUE

Respondent TEXT No

PollsterName TEXT No

info TEXT No

Tecnología de Desarrollo

El Software PERS HOME fue diseñado e implementado por Jairo Guerrero, Ing. MSc; Jesús Insuasti,

Ing. MsEd; y Alexander Barón, Ing. MSc; los cuales son profesores de tiempo completo adscritos al

Departamento de Sistemas de la Universidad de Nariño.

Se utilizó Microsoft Visual Studio 2012 Express™ con bibliotecas Mono for Android™ programado en

lenguaje Microsoft Visual C#.NET™.

Marcas Registradas

Windows™, .NET Framework™, Visual Studio™, Visual C#.NET™ son marcas registradas de Microsoft

Corporation. Mono for Android™ es marca registrada de Xamarin, Android OS™ es marca registrada de

Google. SQLite es un proyecto abierto de uso libre desarrollado por programadores particulares.

pers home / manual del sistema - universidad de...

Documents