Ejemplo n.º 1
0
        private void ProcessRecords(List <OuiLookup> Items)
        {
            var added    = 0;
            var existing = 0;

            foreach (var item in Items)
            {
                try
                {
                    Console.SetCursorPosition(0, 2);
                    var result = NetworkContext.Merge(item);
                    Console.Write($"Records Added: {added:N0}");
                    added++;
                }
                catch (LiteDB.LiteException ex)
                {
                    if (ex.Message.StartsWith("Cannot insert duplicate key in unique index '_id'."))
                    {
                        Console.SetCursorPosition(0, 3);
                        Console.WriteLine($"Existing Record: {existing:N0}");
                        existing++;
                    }
                    else
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                finally
                {
                    var totalProcessed = Convert.ToDecimal(added + existing);
                    var pct            = Math.Round((totalProcessed / Items.Count) * 100, 2);
                    Console.SetCursorPosition(0, 4);
                    Console.Write($"Percent Processed: {totalProcessed:N0}/{Items.Count:N0} \t\t {pct:N} %");
                }
            }
        }