public bool ShowSelectEntitiesDialog(SelectEntitiesDialogOptions options, out List <string> selected)
{
using (CheckedListForm form = new CheckedListForm())
{
form.Text = options.Caption;
form.InitializeDialog(options.Description, options.Options, options.Checked, this, this);
System.Windows.Forms.DialogResult formsResult = form.ShowDialog();
selected = new List <string>();
bool isOk = formsResult == DialogResult.OK;
if (isOk)
{
selected = form.GetSelectedItems();
}
return(isOk);
}
}
public void ParseExcelTransactions()
{
ExcelOutput excel = new ExcelOutput();
excel.Connect();
List <string> names = excel.GetSheetNames();
List <string> checkedNames = names.First().AsList();
if (false)
{
WinFormDialog dialog = new WinFormDialog();
SelectEntitiesDialogOptions options = new SelectEntitiesDialogOptions()
{
Caption = "Arkusze",
Description = "Wybierz arkusze",
Options = names,
Checked = checkedNames
};
List <string> selectedNames;
bool isOk = dialog.ShowSelectEntitiesDialog(options, out selectedNames);
if (!isOk)
{
return;
}
}
List <ITransactionParser> parsers = new List <ITransactionParser>();
parsers.Add(new ExcelSheetParser());
GetExcelTransactionsAction.Data getExcelData = new GetExcelTransactionsAction.Data()
{
SheetFileNames = checkedNames,
Excel = excel,
Parsers = parsers
};
GetExcelTransactionsAction getExcelAction = new GetExcelTransactionsAction();
GetTransactionsAction.Result result = getExcelAction.Execute(getExcelData);
}
void ProceedImportExcel()
{
List <string> names = _IExcel.GetSheetNames();
List <string> checkedNames = names.ToList();
SelectEntitiesDialogOptions options = new SelectEntitiesDialogOptions()
{
Caption = "Arkusze",
Description = "Wybierz arkusze",
Options = names,
Checked = checkedNames
};
List <string> selectedNames;
bool isOk = _iOutput.FileDialog.ShowSelectEntitiesDialog(options, out selectedNames);
if (!isOk)
{
return;
}
List <ITransactionParser> parsers = _import.GetParsers();
new List <ITransactionParser>();
GetExcelTransactionsAction.Data getExcelData = new GetExcelTransactionsAction.Data()
{
SheetFileNames = selectedNames,
Excel = _IExcel,
Parsers = parsers
};
GetExcelTransactionsAction getExcelAction = new GetExcelTransactionsAction();
GetTransactionsAction.Result result = getExcelAction.Execute(getExcelData);
_repository.Reports.Item.Reports = result.Reports;
_iOutput.ShowReports(result.Reports);
}
