private void picExcel_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
string folderName = Properties.Settings.Default.DocumentsPath + "\\Contabilidad_" + Convert.ToInt32((cbxYear.SelectedItem as Year).Desde) + "_Goll";
string fileName = (cbxYear.SelectedItem as Year).Desde + "_" + cbxMonth.SelectedItem.ToString() + ".xlsx";
Validation.FormManager frmManager = new Validation.FormManager();
if (frmManager.generateExcel(FacturaDAL.getFacturasSemanas(Convert.ToInt64((cbxYear.SelectedItem as Year).Desde), Convert.ToDateTime("20-" + cbxMonth.SelectedItem.ToString() + "-2010").ToString("MM"), Validation.Validation.Val_Injection(txtBuscar.Text), Inicio.CurrentSucursal.Id)
, EgresoDAL.getEgresosSemanas(Convert.ToInt64((cbxYear.SelectedItem as Year).Desde), Convert.ToDateTime("20-" + cbxMonth.SelectedItem.ToString() + "-2010").ToString("MM"), Validation.Validation.Val_Injection(txtBuscar.Text), Inicio.CurrentSucursal.Id),
folderName, fileName,
Convert.ToInt32((cbxYear.SelectedItem as Year).Desde),
Convert.ToDateTime("20-" + cbxMonth.SelectedItem.ToString() + "-2019").Month))
{
MessageBox.Show("La hoja de calculo ha sido generada en la carpeta \"" + Properties.Settings.Default.DocumentsPath + "\\Contabilidad_" + Convert.ToInt32((cbxYear.SelectedItem as Year).Desde) + "_Goll\"" + ".", "Operación realizada", MessageBoxButtons.OK, MessageBoxIcon.Information);
Cursor = Cursors.Arrow;
}
}
catch (Exception ex)
{
string folderName = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Errores_" + Assembly.GetExecutingAssembly().GetName().Name + "_V_" + Assembly.GetExecutingAssembly().GetName().Version.ToString();
string fileName = "Exeptions_" + Name + ".txt";
Validation.FormManager frmManager = new Validation.FormManager();
frmManager.writeException(folderName, fileName, ex, "El archivo de excel del mes de " + Convert.ToDateTime("20-" + cbxMonth.SelectedItem.ToString() + "-2019").ToString("MMMM", new CultureInfo("es-ES")) + " esta siendo usado por otro programa.");
MessageBox.Show("El archivo de excel del mes de " + Convert.ToDateTime("20-" + cbxMonth.SelectedItem.ToString() + "-2019").ToString("MMMM", new CultureInfo("es-ES")) + " esta siendo usado por otro programa.", "Error al generar", MessageBoxButtons.OK, MessageBoxIcon.Error);
Cursor = Cursors.Arrow;
}
}
