Esempio n. 1
0
        private async void pinbutton_Clicked(object sender, EventArgs e)
        {
            try
            {
                Ping Pings   = new Ping();
                int  timeout = 50;

                if (Pings.Send(eServerIP.Text, timeout).Status == IPStatus.Success)
                {
                    try
                    {
                        string connectionString = fireBird.connectionString(true);

                        FbConnection fb = new FbConnection(connectionString);
                        fb.Open();


                        fb.Close();
                        Preferences.Set("SERVER_IP", eServerIP.Text);


                        await DisplayAlert("Conectado", "Se ha conectado", "ok");

                        //await PopupNavigation.PushAsync(new PopUpPing()); //popup conexion con exito//
                        Debug.WriteLine("Ping exitoso a la ip: " + eServerIP.Text);
                    }
                    catch (Exception ea)
                    {
                        Debug.WriteLine("Error en el metodo pingbtn" + ea.Message);
                        Analytics.TrackEvent("Exception al hacer ping:  " + ea.Message + "\n Escaner: " + Preferences.Get("LECTOR", "N/A"));
                        //await PopupNavigation.PushAsync(new PopUpPingIncorrecto()); //popup conexion erronea//
                    }
                }
                else
                {
                    Preferences.Set("SYNC_VSU", false);

                    await DisplayAlert("Error", "No se pudo establecer conexion", "ok");

                    //await PopupNavigation.PushAsync(new PopUpPingIncorrecto());//popup conexion erronea//
                }
            }
            catch (Exception ea)
            {
                Debug.WriteLine("Error en el metodo pingbtn " + ea.Message);
                Analytics.TrackEvent("Exception al hacer ping:  " + ea.Message + "\n Escaner: " + Preferences.Get("LECTOR", "N/A"));
            }
        }
Esempio n. 2
0
        private async void BtSync_Clicked(object sender, EventArgs e)
        {
            string Password    = "******";
            string TryPassword = await DisplayPromptAsync("verificacion", "Ingrese la contraseña maestra para continuar", "Aceptar", "Cancelar", "Contraseña", 11, null);

            if (Password == TryPassword)
            {
                Preferences.Set("BUSY", false);
                Debug.WriteLine("Timer Stopped");
                App.syncTimer.Stop();
                App.syncTimer.Enabled = false;
                var db = new SQLiteConnection(Preferences.Get("DB_PATH", ""));
                Preferences.Set("IS_SYNC", "true");
                if (Connectivity.NetworkAccess == NetworkAccess.Internet)
                {
                    try
                    {
                        fireBird = new FireBirdData();
                        //Mostramos el popup
                        popupLoadingView.IsVisible = true;

                        pbLoading.IsVisible = true;
                        aiLoading.IsVisible = false;
                        aiLoading.IsRunning = false;
                        lblLoadingText.Text = "Loading...";

                        var querry1 = "";

                        //Vamos a buscar el directorio de la base de datos

                        //Buscamos el Chunk Size
                        var iChunkSize = int.Parse(Preferences.Get("CHUNK_SIZE", "10000"));

                        //Vamos a poner el timeout del http en 20 min seg
                        _client.Timeout = new TimeSpan(0, 40, 0);

                        Debug.WriteLine("Setting timeout to 20 min");

                        string querry           = "";
                        string connectionString = fireBird.connectionString(false);


                        FbCommand cmd;
                        //var Url = "http://" + Preferences.Get("SERVER_IP", "localhost") + ":" + Preferences.Get("SERVER_PORT", "4444")
                        //+ "/?sql=";

                        //TODO: Buscar cuantas cedulas se van a descargar.

                        querry = "select count(p.cedula) as anyCount from padron p";
                        int tries = 0;
                        //string contenido;
                        int maxRegistro = 0;
                        while (true)
                        {
                            try
                            {
                                FbConnection fb = new FbConnection(connectionString);

                                fb.Open();
                                FbCommand command = new FbCommand(
                                    querry,
                                    fb);


                                FbDataReader reader = command.ExecuteReader();

                                if (reader.HasRows)
                                {
                                    while (reader.Read())
                                    {
                                        maxRegistro = Convert.ToInt32(reader[0]);
                                    }
                                }
                                else
                                {
                                    Debug.WriteLine("No rows found.");
                                }
                                reader.Close();

                                fb.Close();
                                fb.Dispose();

                                break;
                            }
                            catch (Exception ex)
                            {
                                Analytics.TrackEvent("Error al conectarse a base de datos " + ex.Message + "\n Escaner: " + Preferences.Get("LECTOR", "N/A"));
                                Debug.WriteLine("Error en Sync");
                                if (tries >= 5)
                                {
                                    throw new Exception("No se pudo conectar con la base de datos.");
                                }
                                var x = ex.Message;
                                tries += 1;
                            }
                        }

                        //var maxRegistroList = JsonConvert.DeserializeObject<List<counterObj>>(contenido);
                        //var maxRegistro = maxRegistroList.First();

                        //Descargar CEDULAS

                        querry = "select p.cedula, p.nombres, p.apellido1, p.apellido2 from padron p";

                        if (maxRegistro > 0)
                        {
                            int    loadedRegistros   = 1;
                            int    commitedRegistros = 0;
                            double progress          = 0.0;
                            var    listPadron        = new List <PADRON>();
                            while (loadedRegistros < maxRegistro)
                            {
                                progress = (double)loadedRegistros / maxRegistro;
                                if (maxRegistro - loadedRegistros < iChunkSize - 1)
                                {
                                    querry1 = querry1 = querry + " ROWS "
                                                        + loadedRegistros.ToString() + " TO " + maxRegistro.ToString();
                                    progress = 1.0;
                                }
                                else
                                {
                                    querry1 = querry + " ROWS "
                                              + loadedRegistros.ToString() + " TO " + (loadedRegistros + iChunkSize - 1).ToString();
                                }

                                await Task.Factory.StartNew(() =>
                                {
                                    listPadron.AddRange(fireBird.DownloadPadron(querry1, false));

                                    //var listPadronTemp = JsonConvert.DeserializeObject<List<PADRON>>(contenidoTBL);
                                    //listPadron = listPadron.Concat(listPadronTemp).ToList();
                                    if (listPadron.Count >= int.Parse(Preferences.Get("COMMIT_SIZE", "1000000")) || maxRegistro - loadedRegistros < iChunkSize - 1)
                                    {
                                        try
                                        {
                                            Device.BeginInvokeOnMainThread(() =>
                                            {
                                                lblLoadingText.Text = "Commited " + commitedRegistros.ToString() + "/" + maxRegistro.ToString() + " CEDULAS";
                                            });
                                            Debug.WriteLine("Se van a insertar: " + listPadron.Count.ToString() + " En la BBDD Local");
                                            //await Task.Factory.StartNew(() =>
                                            //{
                                            db.InsertAll(listPadron);
                                            //});
                                            commitedRegistros = commitedRegistros + listPadron.Count;
                                            //Preferences.Set("TOTAL_CEDULAS_DESCARGADAS", commitedRegistros.ToString());
                                            Device.BeginInvokeOnMainThread(() =>
                                            {
                                                //lblCantidadPadron.Text = $"Cantidad de cedulas descargadas: {Preferences.Get("TOTAL_CEDULAS_DESCARGADAS", commitedRegistros.ToString())}";
                                                Debug.WriteLine($"Cantidad de cedulas descargadas: {Preferences.Get("TOTAL_CEDULAS_DESCARGADAS", commitedRegistros.ToString())}");
                                            });
                                            listPadron.Clear();
                                        }
                                        catch (Exception ea)
                                        {
                                            Debug.WriteLine("Se ha encontrado una excepcion, Error: " + ea.Message);
                                        }
                                    }

                                    Device.BeginInvokeOnMainThread(() =>
                                    {
                                        lblLoadingText.Text = "Downloading CEDULAS: " + loadedRegistros.ToString() + "/" + maxRegistro.ToString();
                                    });
                                    Debug.WriteLine("Downloading CEDULAS: " + loadedRegistros.ToString() + "/" + maxRegistro.ToString());
                                    loadedRegistros = loadedRegistros + iChunkSize;
                                });

                                await pbLoading.ProgressTo(progress, 200, Easing.Linear);
                            }

                            pbLoading.Progress  = 0.0;
                            lblLoadingText.Text = "Guardando Padron";
                            pbLoading.IsVisible = false;
                            aiLoading.IsVisible = true;
                            aiLoading.IsRunning = true;
                            Debug.WriteLine("Se van a insertar: " + listPadron.Count.ToString() + " En la BBDD Local");
                            await Task.Factory.StartNew(() =>
                            {
                                db.InsertAll(listPadron);
                            });

                            pbLoading.IsVisible = true;
                            aiLoading.IsVisible = false;
                            aiLoading.IsRunning = false;
                            lblLoadingText.Text = "Loading...";

                            //Si hay Cedulas para cargar entramos
                        }
                    }
                    catch (Exception ey)
                    {
                        Debug.WriteLine("Error syncronisando: " + ey.Message);
                        popupLoadingView.IsVisible = false;
                        try
                        {
                            var options = new NotificationOptions()
                            {
                                Title       = "Error syncronisando",
                                Description = "Hubo un error en la syncronización, intente nuevamente",
                                IsClickable = false // Set to true if you want the result Clicked to come back (if the user clicks it)
                            };
                            var notification = DependencyService.Get <IToastNotificator>();
                            var result       = notification.Notify(options);
                        }
                        catch (Exception eo)
                        {
                            Debug.WriteLine("Error en notificacion: " + eo.Message);
                        }
                    }
                    finally
                    {
                        db.Dispose();

                        popupLoadingView.IsVisible = false;
                        try
                        {
                            _client.Timeout = new TimeSpan(0, 0, 100);
                        }
                        catch (Exception eu)
                        {
                            Debug.WriteLine("Error devolviendo el time out: " + eu.Message);
                        }
                        Debug.WriteLine("Setting timeout to 100 seconds");
                        Debug.WriteLine("Timer Start");
                        //Preferences.Set("IS_SYNC", "false");
                        App.syncTimer.Enabled = true;
                        App.syncTimer.Start();
                        Preferences.Set("BUSY", true);
                    }
                    //"select b.boleta_id, b.boleta, b.fecha_lectura, null as SUBIDA from boletas b where b.fecha_lectura is NULL"
                }
                else
                {
                    //Si no hay connecion a internet avisar al usuario
                    Debug.WriteLine("NO NETWORK");
                    popupLoadingView.IsVisible = false;
                    var options = new NotificationOptions()
                    {
                        Title       = "No hay conexión",
                        Description = "No se puede sincronizar sin una conexión a la red",
                        IsClickable = false // Set to true if you want the result Clicked to come back (if the user clicks it)
                    };
                    var notification = DependencyService.Get <IToastNotificator>();
                    var result       = notification.Notify(options);
                    Debug.WriteLine("Timer Start");
                    Preferences.Set("IS_SYNC", "false");
                    App.syncTimer.Enabled = true;
                    App.syncTimer.Start();
                }
            }
            else
            {
                await DisplayAlert("Credencial incorrecta", "La credencial ingresada no es valida", "OK");
            }
        }