private bool SaveData()
        {
            try
            {
                var db = SingletonDB.getInstance().DB;

                var dir = wrapper.GetDictionary();
                int des = 0, vas = 0;
                dir.ForEach(m => des += m.Value.tbl_variable_desactualizada.Count());
                dir.ForEach(m => vas += m.Value.tbl_variable_prioritaria.Count());
                int total = des + vas + dir.Count();
                wrapper = new WrapperObject <string, int, tbl_paciente_prioritario>();
                int saved = 0;
                foreach (var item in dir)
                {
                    try
                    {
                        db.tbl_paciente_prioritario.Add(item.Value);
                        saved += db.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                    }
                }
            }
            catch (Exception ex)
            {
                IOUtilities.WriteExceptionLog(ex, Configuration.GetClassName <PriorityPatient>());
                return(false);
            }
            return(true);
        }
 public void Build(byte[] binaryFile, string idArchivo, string nameFile)
 {
     try
     {
         this.idArchivo       = idArchivo;
         desactualizado       = new WrapperObject <tbl_variable_desactualizada, string, string>();
         variable_prioritaria = new WrapperObject <tbl_variable_prioritaria, string, string>();
         wrapper = new WrapperObject <string, int, tbl_paciente_prioritario>();
         IXLTableRows rows = initFileWorkSheet(binaryFile, nameFile);
         if (rows != null)
         {
             ValidatePriorityPatient(rows);
             SaveData();
             //Task.Factory.StartNew(() => ValidatePriorityPatient(rows));
             //Task.Factory.StartNew(() => SaveData());
             //Task.Factory.StartNew(() => Analsis());
         }
         else
         {
             throw new Exception("El archivo enviado no tiene un formato valido para se analizado. Debe ser CSV, XLS o XLSX");
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        /// <summary>
        private void Analsis()
        {
            foreach (var temp in desactualizado.GetList())
            {
                string content = $"{temp.tbl_paciente_prioritario.nombres}@{temp.nombreVariable}@{temp.valorVariable}@{temp.mesesDesactualizado}";
                //IOUtilities.WriteLog(content, @"PILOTO", $@"{DateTime.Now.ToString("yyyy-MM-dd HH")}_variable_desactualizadas.txt");
            }

            desactualizado = new WrapperObject <tbl_variable_desactualizada, string, string>();
            foreach (var temp in variable_prioritaria.GetList())
            {
                string content = $"{temp.tbl_paciente_prioritario.nombres}@{temp.nombreVariable}@{temp.valorVariable}@{temp.valorUmbral}";
                //IOUtilities.WriteLog(content, @"PILOTO", $@"{DateTime.Now.ToString("yyyy-MM-dd HH")}_variable_prioritaria.txt");
            }
            variable_prioritaria = new WrapperObject <tbl_variable_prioritaria, string, string>();
        }
Exemplo n.º 4
0
        //ConcurrentBag<string> log = new ConcurrentBag<string>();
        public static void SaveAnalysis(double elepsedtime, ValidatorResult <DTOValidacionArchivo> validator_result)
        {
            //JavaScriptSerializer json_serializer = new JavaScriptSerializer();
            //json_serializer.MaxJsonLength = 2147483647;
            //Task<string> output = Task<string>.Factory.StartNew(() => json_serializer.Serialize(validator_result.GetResult()));
            //Task.Factory.StartNew(() => IOUtilities.WriteLog(output.Result, "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_json_serializer.json", true));

            //Task.Factory.StartNew(() => SaveLog($"{DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")}\tTiempo actual {elepsedtime}."));
            //Task.Factory.StartNew(() => log.ForEach(m => IOUtilities.WriteLog(m, "PILOTO",$"{DateTime.Now.ToString("yyyy-MM-dd HH")}_linea.txt", false)));

            validator_result.GetResult().OrderBy(m => m.Columna).ForEach(m => IOUtilities.WriteLog(m.ToString(), "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_result_validation.txt", false));
            //Task.Factory.StartNew(() => validator_result.GetResult().OrderBy(m => m.Columna).ForEach(m => IOUtilities.WriteLog(m.ToString(), "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_result_validation.txt", false)));

            analisis1.GetList().ForEach(m => IOUtilities.WriteLog(m, "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_lista_de_errores.txt", false));
            //Task task1 = Task.Factory.StartNew(() => analisis1.GetList().ForEach(m => IOUtilities.WriteLog(m, "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_lista_de_errores.txt", false)));

            foreach (var keyvalue in analisis1.GetDictionary())
            {
                string concat = "";
                //keyvalue.Value.ForEach(m => concat = $"{concat},{m}");
                concat = keyvalue.Value.Count() > 0 ? $"@{keyvalue.Value[0]}" : "";
                IOUtilities.WriteLog($"{keyvalue.Key}{concat}", "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_lista_sin_errores.txt", false);
            }

            foreach (var keyvalue in analisis2.GetDictionary())
            {
                string concat = "";
                keyvalue.Value.ForEach(m => concat = $"{concat}@{m}");
                IOUtilities.WriteLog($"{keyvalue.Key}{concat}", "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_lineas_todos.txt", false);
            }

            foreach (var keyvalue in analisis2.GetList())
            {
                IOUtilities.WriteLog($"{keyvalue}", "PILOTO", $"{DateTime.Now.ToString("yyyy-MM-dd HH")}_lineas_todos.txt", false);
            }
            analisis1 = new WrapperObject <string, string, string[]>();
            analisis2 = new WrapperObject <string, string, string[]>();
            //Task.WaitAll(task1);
        }