private void LoadExcelData(Spreedsheet sprd, bool planilhaUpdateVisibility = true)
{
sprd.GetTabelaExcel();
lblPlanilhaNomeArquivo.Text = sprd.Title;
slblTpMainEnderecoArquivo.Text = "Arquivo: " + sprd.FileName;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DataSource = sprd.DataTable;
sprd.DataTable.Dispose();
btnPlanilhaUpdate.Visible = planilhaUpdateVisibility;
tabMain.SelectedTab = tpPanilha;
}
private void OpenDialog(Spreedsheet sprd, Control ctl, string worksheetName = "")
{
try
{
if (sprd.OpenFile())
{
Spreedsheet = sprd;
LoadExcelData(Spreedsheet);
ctl.Visible = true;
}
}
catch (Exception e)
{
ctl.Visible = false;
MessageBox.Show(e.Message);
}
}
private void SetClickSimulate(Spreedsheet sprd, Control ctl1, Control ctl2,
SetClickSimulateEventHandler handler)
{
ctl1.Click += (s, e) =>
{
try
{
handler?.Invoke(this, new SetClickSimulateEventArgs(sprd, ctl1, ctl2));
ctl2.Visible = true;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, $@"Erro ao gerar {sprd.Title}", MessageBoxButtons.OK);
tabMain.SelectedTab = tpLogo;
pnlMainInfos.Visible = false;
ctl2.Visible = false;
}
isSimulating = true;
};
}
// Todo, passar função de validação
private void LoadExcelData(Spreedsheet sprd)
{
try
{
if (sprd.OpenFile())
{
sprd.GetTabelaExcel();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DataSource = sprd.DataTable;
//lblRegistros.Text = (dgvDados.Rows.Count - 1).ToString();
sprd.DataTable.Dispose();
txtLogo.Visible = false;
}
else
{
throw new Exception("Erro a carregar o arquivo");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public SetClickSimulateEventArgs(Spreedsheet spreedsheet, Control ctl1, Control ctl2)
{
Spreedsheet = spreedsheet;
Ctl1 = ctl1;
Ctl2 = ctl2;
}
private void SetClickOpenSpreedsheet(Spreedsheet sprd, Control ctl1, Control ctl2)
{
ctl2.Click += (s, e) => { LoadExcelData(sprd); };
ctl1.Click += (s, e) => { OpenDialog(sprd, ctl2); };
}
