private void ChooseFirstFolderButton_Click(object sender, System.EventArgs e)
{
chosenPath = ManagerSearcherCommon.SelectFile();
if (!string.IsNullOrEmpty(chosenPath.Trim()))
{
StatusLabelText.Text = "Start process";
ChoosenPathLabel.Text = chosenPath;
}
}
public void ProcessFileByEpp()
{
FileInfo fi = new FileInfo(excelFilePath);
if (fi.Exists)
{
p = new ExcelPackage(fi);
ExcelWorksheet workSheet = p.Workbook.Worksheets[1];
DataTable dt = new DataTable();
var start = workSheet.Dimension.Start.Row + 1;
var end = workSheet.Dimension.End.Row;
for (int row = start; row <= end; row++)
{
string names = workSheet.Cells[row, 3].Text;
string URL = workSheet.Cells[row, 4].Text;
if (string.IsNullOrEmpty(names))
{
break;
}
var data = ManagerSearcherCommon.GetMiddleAndSurname(names).Split(',');
string middlename = data[0];
string surname = data[1];
object arg = row;
tasks.Add(Task.Factory.StartNew(new Action <object>((argValue) =>
{
try
{
int num = Convert.ToInt32(argValue);
Debug.WriteLine(num);
if (isNFF(middlename, surname, URL))
{
workSheet.Cells[num, 6].Value = "NFF";
}
else
{
workSheet.Cells[num, 6].Value = "FF";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}), arg));
}
}
}
