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);
}
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);
}
}
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));
