Ejemplo n.º 1
0
        protected override IState NextState(KeyValuePair <int, MenuItem> selectedMenu)
        {
            if (selectedMenu.Key == 1)
            {
                Console.WriteLine(10);
            }
            else if (selectedMenu.Key == 2)
            {
                FileFinderSettings settings = new FileFinderSettings();
                settings.ReadFromXml(@".\settings.xml");

                FileFinder fileFinder = new FileFinder(settings);
                fileFinder.Find();

                foreach (var file in fileFinder.Files)
                {
                    Console.WriteLine(file.FullName);
                }
            }
            else if (selectedMenu.Key == 3)
            {
                return(null);
            }

            return(this);
        }
Ejemplo n.º 2
0
        static void Main(string[] args)
        {
            //Налаштування також можна передати в конструктор.
            //Якщо maxLength == 0, то довжина не обмежується
            //fileExtension зчитуються незалежно від регістру.
            FileFinderSettings settings = new FileFinderSettings();

            settings.ReadFromXml(@".\settingsExample.xml");

            FileFinder fileFinder = new FileFinder(settings);

            fileFinder.Find();

            foreach (var file in fileFinder.Files)
            {
                Console.WriteLine(file.FullName);
            }
        }
Ejemplo n.º 3
0
        void Init()
        {
            FileFinderSettings settingsManager = null;

            menuState = new AutoConfigurableMenuState();
            {
                //menuState.AddMenuItem(new MenuItem() { Text = "Create DB" }, () => {
                //	//Вроде і без цього робить
                //	//if(!System.IO.File.Exists(dbName))
                //	//SQLiteConnection.CreateFile(dbName);

                //	//DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SQLite");

                //	//DbConnection connection = factory.CreateConnection();
                //	//connection.ConnectionString = connectionString;
                //	//connection.Open();

                //	//DbDataAdapter dataAdapter = factory.CreateDataAdapter();
                //	//dataAdapter.SelectCommand = factory.CreateCommand();
                //	//dataAdapter.SelectCommand.Connection = connection;
                //	//dataAdapter.SelectCommand.CommandText = "select * from file";

                //	//DataSet dataSet = new DataSet("files");
                //	//dataAdapter.Fill(dataSet, "files");


                //	//DataTable table = new DataTable("file");
                //	//DataColumn column = new DataColumn("IdFile", typeof(int)) {
                //	//	AllowDBNull = false,
                //	//	ReadOnly = false,
                //	//	Unique = true,
                //	//	AutoIncrement = true,
                //	//	AutoIncrementSeed = 1,
                //	//	AutoIncrementStep = 1,
                //	//	Caption = "Id file",
                //	//};
                //	//table.Columns.Add(column);

                //	//column = new DataColumn("PathToFile", typeof(string)) {
                //	//	AllowDBNull = false,
                //	//	ReadOnly = false,
                //	//	Caption = "Path to file",
                //	//};
                //	//table.Columns.Add(column);

                //	//column = new DataColumn("FileSize", typeof(ulong)) {
                //	//	AllowDBNull = false,
                //	//	ReadOnly = false,
                //	//	Caption = "File size",
                //	//};
                //	//table.Columns.Add(column);

                //	//dataSet.Tables.Add(table);

                //	//DataRow row = table.NewRow();
                //	//row[1] = "test\\test.jpg";
                //	//row[2] = 666;
                //	//dataSet.Tables[0].Rows.Add(row);
                //	//dataSet.AcceptChanges();

                //	//foreach(DataTable t in dataSet.Tables) {
                //	//	Console.WriteLine($" => {t.TableName}");
                //	//	foreach(DataRow r in t.Rows) {
                //	//		Console.WriteLine($"{r[0]}\t{r[1]}\t{r[2]}");
                //	//	}
                //	//}


                //	////Треба для БД які представлені 1 файлом. Наприклад SQLite
                //	//if(factory is IDisposable disposable)
                //	//	disposable.Dispose();



                //	DataSet dataSet = new DataSet();
                //	dataSet.ReadXml(@".\files.xml");

                //	foreach(DataTable t in dataSet.Tables) {
                //		Console.WriteLine($" => {t.TableName}");
                //		foreach(DataRow r in t.Rows) {
                //			Console.WriteLine($"{r[0]}\t{r[1]}");
                //		}
                //	}

                //	return menuState;
                //});
            }

            menuState.AddMenuItem(new MenuItem()
            {
                Text = "Parse, create and fill DB"
            }, () => {
                FileFinderSettings settings = new FileFinderSettings();
                settings.ReadFromXml(@".\settings.xml");
                FileFinder fileFinder = new FileFinder(settings);

                new MenuItem()
                {
                    Text = "Start file parsing.\n", TextColor = attentionColor
                }.Print();
                fileFinder.Find();
                new MenuItem()
                {
                    Text = "End file parsing.\n", TextColor = attentionColor
                }.Print();

                new MenuItem()
                {
                    Text = "Start saving as DB.\n", TextColor = attentionColor
                }.Print();
                {
                    EzDBAccess.EzDBList <DBFileInfo> tmpList = new EzDBAccess.EzDBList <DBFileInfo>("System.Data.SqlClient", @"Server=(localdb)\mssqllocaldb; Database=master; Integrated Security=True", true);
                }
                //fileFinder.SaveAsXml(@".\files.xml");

                DataSet dataSet = new DataSet();
                //dataSet.ReadXml(@".\files.xml");

                using (SqlConnection connection = new SqlConnection(connectionString)) {
                    connection.Open();
                    SqlDataAdapter adapter = new SqlDataAdapter("select * from DBFileInfo", connection);
                    adapter.Fill(dataSet);
                    foreach (var i in fileFinder.Files)
                    {
                        DataRow row = dataSet.Tables[0].NewRow();
                        row[1]      = i.FullName;
                        row[2]      = i.Length;
                        dataSet.Tables[0].Rows.Add(row);
                    }
                    SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);
                    adapter.Update(dataSet);
                    //dataSet.AcceptChanges();
                    //dataSet.Clear();
                    //adapter.Fill(dataSet);

                    adapter.Dispose();
                }

                new MenuItem()
                {
                    Text = "End saving as DB.\n", TextColor = attentionColor
                }.Print();


                dataSet.Dispose();

                return(menuState);
            });

            menuState.AddMenuItem(new MenuItem()
            {
                Text = "Print files"
            }, () => {
                //dataSet.ReadXml(@".\files.xml");
                try {
                    using (SqlConnection connection = new SqlConnection(connectionString)) {
                        connection.Open();
                        SqlDataAdapter adapter = new SqlDataAdapter("select * from DBFileInfo", connection);
                        DataSet dataSet        = new DataSet();
                        adapter.Fill(dataSet);
                        SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);

                        int[] columnWidths = new int[] { 7, 50, 10 };
                        foreach (DataTable t in dataSet.Tables)
                        {
                            Console.WriteLine($" => {t.TableName}");
                            for (byte i = 0; i < t.Columns.Count; ++i)
                            {
                                string str = t.Columns[i].ToString();
                                if (str.Length > columnWidths[i])
                                {
                                    str = str.Substring(0, columnWidths[i] - 3) + "...";
                                }
                                str  = str.PadRight(columnWidths[i]);
                                str += ' ';
                                Console.Write(str);
                            }
                            Console.WriteLine();

                            foreach (DataRow r in t.Rows)
                            {
                                for (byte i = 0; i < t.Columns.Count; ++i)
                                {
                                    string str = r[i].ToString();
                                    if (str.Length > columnWidths[i])
                                    {
                                        str = str.Substring(0, columnWidths[i] - 3) + "...";
                                    }
                                    str  = str.PadRight(columnWidths[i]);
                                    str += ' ';
                                    Console.Write(str);
                                }
                                Console.WriteLine();
                            }
                        }

                        commandBuilder.Dispose();
                        dataSet.Dispose();
                        adapter.Dispose();
                    }
                }
                catch (Exception ex) {
                    new MenuItem()
                    {
                        Text = "Cant read from DB. Choose ", PreText = "Error: ", PreTextColor = ConsoleColor.Red
                    }.Print();
                    new MenuItem()
                    {
                        Text = "Parse, create and fill DB ", TextColor = ConsoleColor.Blue
                    }.Print();
                    new MenuItem()
                    {
                        Text = "before print files\n"
                    }.Print();
                }

                return(menuState);
            });

            menuState.AddMenuItem(new MenuItem()
            {
                Text = "Settings file finder"
            }, () => {
                settingsManager = new FileFinderSettings();
                settingsManager.ReadFromXml(@".\settings.xml");
                return(settingsState);
            });


            menuState.AddMenuItem(new MenuItem()
            {
                Text = "Exit"
            }, () => null);

            settingsState = new AutoConfigurableMenuState();

            settingsState.AddMenuItem(new MenuItem()
            {
                Text = "Set max path length", InBrakesText = "Щоб шукати не у всiй системi.", InBrakesTextColor = attentionColor
            }, () => {
                ushort rez = ushort.MaxValue;
                do
                {
                    if (rez == 0)
                    {
                        new MenuItem()
                        {
                            Text = "Cant parse number\n", PreText = "Error: ", PreTextColor = ConsoleColor.Red
                        }
                    }
                    .Print();
                    Console.Write("New length: ");
                } while(!ushort.TryParse(Console.ReadLine(), out rez));