Exemplo n.º 1
0
        private void biometricsBtn_Click(object sender, EventArgs e)
        {
            string promptValue = new Prompt("Procesamiento biometrico", "Ingrese el número de sección de la prueba de la que desea hacer el procesamiento de datos biometricos").show();

            if (!int.TryParse(promptValue, out int section))
            {
                throw new Exception("Error al intentar parsear el número de seccción. Verifique que los datos sean correctos");
            }

            ParserService parserService = new ParserService();

            try
            {
                SkinMeasurement skinMeasurement = parserService.ParseCsvSkinMeasurement(SkinMeasurement.PATH, SkinMeasurement.FILE_NAME, SkinMeasurement.CSV_KEY);
                SkinDao         skinDao         = new SkinDao();
                skinDao.SaveSkinMeasurement(skinMeasurement, section);
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }

            try
            {
                PulseMeasurement pulseMeasurement = parserService.ParseCsvPulseMeasurement(PulseMeasurement.PATH, PulseMeasurement.FILE_NAME, PulseMeasurement.CSV_KEY);
                PulseDao         pulseDao         = new PulseDao();
                pulseDao.SavePulseMeasurement(pulseMeasurement, section);
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }
        }
Exemplo n.º 2
0
        public SkinMeasurement ParseCsvSkinMeasurement(string path, string fileName, string csvKey)
        {
            SkinMeasurement skinMeasurement = new SkinMeasurement();

            try
            {
                using (var reader = new StreamReader(path + fileName))
                    using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
                    {
                        csv.Configuration.RegisterClassMap <SkinStatisticMap>();
                        csv.Configuration.Delimiter         = ";";
                        csv.Configuration.MissingFieldFound = null;

                        skipCsvResumeUntilKey(csv, csvKey);

                        var skinStatisticRecords = csv.GetRecords <SkinStatistic>();
                        skinMeasurement.AddSkinStatistics(skinStatisticRecords.ToList());
                    }
            } catch (Exception e)
            {
                Console.WriteLine("Ocurrio un error en el procesamiento de las mediciones de conductancia");
                Console.WriteLine(e.Message);
                throw e;
            }
            return(skinMeasurement);
        }
Exemplo n.º 3
0
        public void SaveSkinMeasurement(SkinMeasurement skinMeasurement, int seccion)
        {
            SqlConnection dbConnection = DbConnection.GetConnection();

            try
            {
                dbConnection.Open(); //TODO: ver si es transacional
                foreach (SkinStatistic skinStatistic in skinMeasurement.skinStatistics)
                {
                    SqlCommand command         = createCommandForRecord(seccion, dbConnection, skinStatistic);
                    int        recordsAffected = command.ExecuteNonQuery();
                }
            }
            catch (SqlException e)
            {
                Console.WriteLine("Fallo la escritura de piel en la base");
                Console.WriteLine(e.Message);
            }
            finally
            {
                dbConnection.Close();
            }
        }