static void Main()
{
string projectDirectory = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.FullName;
string errorsfilePathToWrite = $@"{projectDirectory}\ExcelManagerErrors_{DateTime.Now.ToString("ddMMyy_HHmm")}.txt";
string infofilePathToWrite = $@"{projectDirectory}\ExcelManagerInfo_{DateTime.Now.ToString("ddMMyy_HHmm")}.txt";
ConsoleWriter consoleWriter = new ConsoleWriter();
FileLogger fileLogger = new FileLogger();
ConsoleReader consoleReader = new ConsoleReader();
consoleWriter.LogInfo("enter fileName:");
string filePathName = consoleReader.Read();
//string filePathName = @"D:\my documents\professional\GGG_OnlineShop\ggg\glasses.xlsx";
ExcelManager excelManager = new ExcelManager(fileLogger, infofilePathToWrite, filePathName);
Engine engine = new Engine(consoleWriter, fileLogger, consoleReader, filePathName, excelManager, errorsfilePathToWrite, infofilePathToWrite);
engine.Startup();
}
public void ReplaceGivenColumnWithSourceOneByGivenColumnMatch()
{
string baseSheetName = "";
string matchColumn = "";
string columnToReplace = "";
string[] targetSheets = { };
try
{
ConsoleWriter.LogInfo("Enter baseSheet(source) name. Should be 1 word, no spaces");
baseSheetName = ConsoleReader.Read();
ConsoleWriter.LogInfo("Enter matchColumn(column on which will look for match) name. Should be 1 word, no spaces");
matchColumn = ConsoleReader.Read();
ConsoleWriter.LogInfo("Enter columnToReplace name. Should be 1 word, no spaces");
columnToReplace = ConsoleReader.Read();
ConsoleWriter.LogInfo($"Enter sheets you want to replace {columnToReplace} column with baseSheet's one; names separated by spaces. No empty spaces in sheet names!");
targetSheets = ConsoleReader.Read().Split(' ');
}
catch (Exception)
{
ConsoleWriter.LogError("input not entered correctly");
}
foreach (var targetSheetName in targetSheets)
{
try
{
ExcelManager.ReplaceGivenColumnWithSourceOne(baseSheetName, targetSheetName, columnToReplace, matchColumn, true);
}
catch (Exception e)
{
FileLogger.LogError($"-------------------------- {columnToReplace} replace: {targetSheetName} --------------------------", errorsfilePathToWrite);
FileLogger.LogError(e.Message, errorsfilePathToWrite);
}
}
}
public void Startup()
{
ConsoleWriter.LogInfo($"used file: {this.filePathName}");
Help();
ConsoleWriter.LogInfo("Enter command number:");
int command = -1;
while (command != 0)
{
if (int.TryParse(ConsoleReader.Read(), out command))
{
switch (command)
{
case 0: return;
case 1: AdaptDescription(); break;
case 2: ReplaceDescription(); break;
case 3: AddQuantities(); break;
case 4: AddInterchangeables(); break;
case 5: AddOESCode(); break;
case 6: AddAndAdaptPlaces(); break;
case 7:
ReplaceGivenColumnWithSourceOneByGivenColumnMatch(); break;
default: Help(); break;
}
ConsoleWriter.LogInfo("Enter command number:");
}
}
}