public void Procesar(Cesantia c, string periodo)
{
var excelAppOut = new ExcelX.Application();
//var fecha = DateTime.Now.ToString().Replace("/", "").Replace(":","").Replace(" ","");
//var periodo = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0');
var rutaSalida = @"C:\Fondos Nacionales\out\" + periodo + @"\Cesantia\Preliminar\";
//excelAppOut.Workbooks.Open(@"C:\Fondos Nacionales\Templates\IF_CESANTIA.xls");
Utilidades.AbrirLibro(excelAppOut, @"C:\Fondos Nacionales\Templates\IF_CESANTIA");
//"Feb-17"
ExcelX._Worksheet Salida = (ExcelX.Worksheet)excelAppOut.Sheets["Template"];
Salida.Cells["14", "V"] = c.NroSubsidios.Replace(".", "").Replace(",", "");
Salida.Cells["15", "V"] = c.NroAfiliados.Replace(".", "").Replace(",", "");
//Salida.Cells["16", "V"] = "133";
Salida.Cells["21", "T"] = c.NroEmpresas.Replace(".", "").Replace(",", "");
Salida.Cells["52", "R"] = c.ValorNotaInterna.Replace(".", "").Replace(",", "");
System.IO.FileAttributes attr;
try
{
attr = System.IO.File.GetAttributes(rutaSalida);
}
catch (Exception ex)
{
System.IO.Directory.CreateDirectory(rutaSalida);
}
//_" + fecha + "
Salida.SaveAs(rutaSalida + "IFCesantia" + Utilidades.ExtensionLibro(Salida.Application.ActiveWorkbook));
excelAppOut.Quit();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excelAppOut);
}
public void ProcesarFondo(Cesantia c, string periodo)
{
var excelAppOut = new ExcelX.Application();
var fecha = DateTime.Now.ToString().Replace("/", "").Replace(":", "").Replace(" ", "");
//var periodo = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0');
var rutaEntrada = @"C:\Fondos Nacionales\out\" + periodo + @"\Cesantia\Preliminar\IFCesantia";
var rutaSalida = @"C:\Fondos Nacionales\out\" + periodo + @"\Cesantia\";
//excelAppOut.Workbooks.Open(rutaEntrada);
Utilidades.AbrirLibro(excelAppOut, rutaEntrada);
//"Feb-17"
ExcelX._Worksheet Salida = (ExcelX.Worksheet)excelAppOut.Sheets["Template"];
Salida.Cells["14", "I"] = c.AporteFiscalMes.Replace(".", "").Replace(",", "");
Salida.Cells["16", "I"] = c.Reintego.Replace(".", "").Replace(",", "");
Salida.Cells["27", "I"] = c.SubsidiosCesantia.Replace(".", "").Replace(",", "");
System.IO.FileAttributes attr;
try
{
attr = System.IO.File.GetAttributes(rutaSalida);
}
catch (Exception ex)
{
System.IO.Directory.CreateDirectory(rutaSalida);
}
Salida.Name = periodo;
Salida.SaveAs(rutaSalida + "IFCesantia_" + fecha + Utilidades.ExtensionLibro(Salida.Application.ActiveWorkbook));
excelAppOut.Quit();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excelAppOut);
}
public void ProcesarFondoCesantia(System.ComponentModel.BackgroundWorker worker, string periodo)
{
worker.ReportProgress(0);
Cesantia c = new Cesantia()
{
AporteFiscalMes = Convert.ToString(DatosCuentasFBL3N("7003000002", periodo) * -1),
Reintego = Convert.ToString(DatosCuentasFBL3N("7003000003", periodo) * -1),
SubsidiosCesantia = Convert.ToString(DatosCuentasFBL3N("8007000001", periodo)),
SubsidiosCesantiaRetroactivos = "0",
ChequesCaducados = "0",
ChequesRevalidados = "0",
GastosDeAdministracion = "0"
};
worker.ReportProgress(70);
cc.ProcesarFondo(c, periodo);
worker.ReportProgress(100);
}