public async Task <IActionResult> Index(string strMessage = "") { ViewBag.Message = strMessage; var oReturn = new ReportsViewLogic(); _idAldakinUser = await _iApplicationUserAldakin.GetIdUserAldakin(HttpContext.User); oReturn = await _iLoadIndexController.LoadReportsAsync(_idAldakinUser); return(View(oReturn)); }
public async Task <IActionResult> ExportExpensesTypeExpense(string strCalendario = "", string strEntidad = "") { var oReturn = new ReportsViewLogic(); try { int iRow = 1, iCodEnt = 0; DateTime dtSelected = DateTime.Now; try { dtSelected = Convert.ToDateTime(strCalendario); iCodEnt = Convert.ToInt32(strEntidad); } catch (Exception ex) { } oReturn = await _iLoadIndexController.LoadReportsAsync(_idAldakinUser); _idAldakinUser = await _iApplicationUserAldakin.GetIdUserAldakin(HttpContext.User); string user = await _iWorkPartInformation.GetUserNameAsync(_idAldakinUser); string sWebRootFolder = _hostingEnvironment.WebRootPath; string sFileName = @"InformeGastos_" + _idAldakinUser + ".xlsx"; string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); if (file.Exists) { file.Delete(); file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); } List <ExcelTipoGasto> lExcel = await _iWorkPartInformation.ReviewExpenseTypeExpenseAsync(iCodEnt, dtSelected); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage package = new ExcelPackage(file)) { // add a new worksheet to the empty workbook ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Horas"); //First add the headers worksheet.Cells[1, 1].Value = user; worksheet.Cells[1, 2].Value = "Creado:" + DateTime.Now.Date.ToString(); iRow = iRow + 1; // //worksheet.Cells[1, 1].Value = "ID"; // //worksheet.Cells[1, 2].Value = "Name"; worksheet.Cells[iRow, 1].Value = "Nombre:"; worksheet.Cells[iRow, 2].Value = "Codigo Empleado:"; worksheet.Cells[iRow, 3].Value = "OT"; worksheet.Cells[iRow, 4].Value = "Desc. OT"; worksheet.Cells[iRow, 5].Value = "Presupuesto"; worksheet.Cells[iRow, 6].Value = "Capitulo"; worksheet.Cells[iRow, 7].Value = "Desc. Capitulo"; worksheet.Cells[iRow, 8].Value = "Anexo"; worksheet.Cells[iRow, 9].Value = "Version"; worksheet.Cells[iRow, 10].Value = "Articulo"; worksheet.Cells[iRow, 11].Value = "Cantidad"; worksheet.Cells[iRow, 12].Value = "Coste"; //Add values foreach (ExcelTipoGasto e in lExcel) { iRow++; worksheet.Cells[iRow, 1].Value = e.strEmpleado; worksheet.Cells[iRow, 2].Value = e.iCodEmpleado;//e.str2; worksheet.Cells[iRow, 3].Value = e.iOT; worksheet.Cells[iRow, 4].Value = e.strOT; worksheet.Cells[iRow, 5].Value = e.strPresu; worksheet.Cells[iRow, 6].Value = e.strCapitulo; worksheet.Cells[iRow, 7].Value = e.strNomCapitulo; worksheet.Cells[iRow, 8].Value = e.iAnexo; worksheet.Cells[iRow, 9].Value = e.iVersion; worksheet.Cells[iRow, 10].Value = e.strArticulo; worksheet.Cells[iRow, 11].Value = e.fCantidad; worksheet.Cells[iRow, 12].Value = e.fCoste; } ////worksheet.Cells["A2"].Value = 1000; ////worksheet.Cells["B2"].Value = "Jon"; ////worksheet.Cells["C2"].Value = "M"; ////worksheet.Cells["D2"].Value = 5000; ////worksheet.Cells["A3"].Value = 1001; ////worksheet.Cells["B3"].Value = "Graham"; ////worksheet.Cells["C3"].Value = "M"; ////worksheet.Cells["D3"].Value = 10000; ////worksheet.Cells["A4"].Value = 1002; ////worksheet.Cells["B4"].Value = "Jenny"; ////worksheet.Cells["C4"].Value = "F"; ////worksheet.Cells["D4"].Value = 5000; package.Save(); //Save the workbook. } var result = PhysicalFile(Path.Combine(sWebRootFolder, sFileName), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); Response.Headers["Content-Disposition"] = new ContentDispositionHeaderValue("attachment") { FileName = file.Name }.ToString(); return(result); } catch (Exception ex) { } return(await Index("Reports")); }
public async Task <IActionResult> ExportHoursPerMonth(string strCalendario = "", string strEntidad = "") { var oReturn = new ReportsViewLogic(); try { int iRow = 1, iCodEnt = 0; DateTime dtSelected = DateTime.Now; try { dtSelected = Convert.ToDateTime(strCalendario); iCodEnt = Convert.ToInt32(strEntidad); } catch (Exception ex) { } oReturn = await _iLoadIndexController.LoadReportsAsync(_idAldakinUser); _idAldakinUser = await _iApplicationUserAldakin.GetIdUserAldakin(HttpContext.User); string user = await _iWorkPartInformation.GetUserNameAsync(_idAldakinUser); string sWebRootFolder = _hostingEnvironment.WebRootPath; string sFileName = @"Horas_" + _idAldakinUser + ".xlsx"; string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); if (file.Exists) { file.Delete(); file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); } var lExcel = await _iWorkPartInformation.ReviewHourMonthAsync(iCodEnt, dtSelected); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage package = new ExcelPackage(file)) { // add a new worksheet to the empty workbook ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Horas"); //First add the headers worksheet.Cells[1, 1].Value = user; worksheet.Cells[1, 2].Value = "Creado:" + DateTime.Now.Date.ToString(); iRow = iRow + 1; worksheet.Cells[iRow, 1].Value = "TRABAJADOR:"; int count = 0; int i = 0; //Add values foreach (ListExcel1 e in lExcel) { iRow++; worksheet.Cells[iRow, 1].Value = e.nombre; count = 0; foreach (ExcelFormat f in e.Datos) { if (i == 0) { worksheet.Cells[iRow - 1, 2 + count].Value = "Dia:" + f.dia.Day; } worksheet.Cells[iRow, 2 + count].Value = f.horas; Color color; switch (f.color) { case "#FFFFFF": color = Color.White; break; case "#0000FF": color = Color.Blue; break; case "#006400": color = Color.Green; break; case "#FFFF00": color = Color.Yellow; break; case "#D3D3D3": color = Color.Gray; break; case "#FF8C00": color = Color.Orange; break; case "#F0FFF0": color = Color.Pink; break; default: color = Color.White; break; } worksheet.Cells[iRow, 2 + count].Style.Fill.PatternType = ExcelFillStyle.Solid; worksheet.Cells[iRow, 2 + count].Style.Fill.BackgroundColor.SetColor(color); //worksheet.Cells[iRow, 2 + count].Style.Fill.BackgroundColor.SetColor(Color.LightYellow); count++; } i++; } package.Save(); //Save the workbook. } var result = PhysicalFile(Path.Combine(sWebRootFolder, sFileName), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); Response.Headers["Content-Disposition"] = new ContentDispositionHeaderValue("attachment") { FileName = file.Name }.ToString(); return(result); } catch (Exception ex) { } return(await Index("Reports")); }
//public IActionResult TestDownloadOtherFile() //{ // try // { // string sWebRootFolder = ""; // string sFileName = @"demo.xlsx"; // string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); // FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); // if (file.Exists) // { // file.Delete(); // file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); // } // ExcelPackage.LicenseContext = LicenseContext.NonCommercial; // using (ExcelPackage package = new ExcelPackage(file)) // { // // add a new worksheet to the empty workbook // ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Employee"); // //First add the headers // worksheet.Cells[1, 1].Value = "ID"; // worksheet.Cells[1, 2].Value = "Name"; // worksheet.Cells[1, 3].Value = "Gender"; // worksheet.Cells[1, 4].Value = "Salary (in $)"; // //Add values // worksheet.Cells["A2"].Value = 1000; // worksheet.Cells["B2"].Value = "Jon"; // worksheet.Cells["C2"].Value = "M"; // worksheet.Cells["D2"].Value = 5000; // worksheet.Cells["A3"].Value = 1001; // worksheet.Cells["B3"].Value = "Graham"; // worksheet.Cells["C3"].Value = "M"; // worksheet.Cells["D3"].Value = 10000; // worksheet.Cells["A4"].Value = 1002; // worksheet.Cells["B4"].Value = "Jenny"; // worksheet.Cells["C4"].Value = "F"; // worksheet.Cells["D4"].Value = 5000; // package.Save(); //Save the workbook. // } // var result = PhysicalFile(Path.Combine(sWebRootFolder, sFileName), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); // Response.Headers["Content-Disposition"] = new ContentDispositionHeaderValue("attachment") // { // FileName = file.Name // }.ToString(); // return result; // } // catch(Exception ex) // { // } // return Index(); //} //public async Task<string> Export(string strCalendario = "", string strEntidad = "") //{ // int iRow = 1, iCodEnt = 1; // DateTime dtSelected = DateTime.Now; // _idAldakinUser = await _iApplicationUserAldakin.GetIdUserAldakin(HttpContext.User); // string sWebRootFolder = _hostingEnvironment.WebRootPath; // string sFileName = @"demo.xlsx"; // string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); // FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); // if (file.Exists) // { // file.Delete(); // file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); // } // List<Excel> lExcel = await _iWorkPartInformation.ReviewHourTypeHourAsync(iCodEnt, dtSelected); // ExcelPackage.LicenseContext = LicenseContext.NonCommercial; // using (ExcelPackage package = new ExcelPackage(file)) // { // // add a new worksheet to the empty workbook // ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Employee"); // //First add the headers // //worksheet.Cells[1, 1].Value = "ID"; // //worksheet.Cells[1, 2].Value = "Name"; // worksheet.Cells[iRow, 1].Value = "Nombre:"; // worksheet.Cells[iRow, 2].Value = "Codigo Empleado:"; // worksheet.Cells[iRow, 3].Value = "OT"; // worksheet.Cells[iRow, 4].Value = "Desc. OT"; // worksheet.Cells[iRow, 5].Value = "Presupuesto"; // worksheet.Cells[iRow, 6].Value = "Capitulo"; // worksheet.Cells[iRow, 7].Value = "Desc. Capitulo"; // worksheet.Cells[iRow, 8].Value = "Anexo"; // worksheet.Cells[iRow, 9].Value = "Version"; // worksheet.Cells[iRow, 10].Value = "Horas"; // worksheet.Cells[iRow, 11].Value = "Tipo de Hora"; // //Add values // //foreach(Excel e in lExcel) // //{ // // iRow++; // // worksheet.Cells[iRow, 1].Value = e.str1; // // worksheet.Cells[iRow, 2].Value = e.str2; // // worksheet.Cells[iRow, 3].Value = e.str3; // // worksheet.Cells[iRow, 4].Value = e.str4; // // worksheet.Cells[iRow, 5].Value = e.str5; // // worksheet.Cells[iRow, 6].Value = e.str6; // // worksheet.Cells[iRow, 7].Value = e.str7; // // worksheet.Cells[iRow, 8].Value = e.str8; // // worksheet.Cells[iRow, 9].Value = e.str9; // // worksheet.Cells[iRow, 10].Value = e.str10; // // worksheet.Cells[iRow, 11].Value = e.str11; // //} // ////worksheet.Cells["A2"].Value = 1000; // ////worksheet.Cells["B2"].Value = "Jon"; // ////worksheet.Cells["C2"].Value = "M"; // ////worksheet.Cells["D2"].Value = 5000; // ////worksheet.Cells["A3"].Value = 1001; // ////worksheet.Cells["B3"].Value = "Graham"; // ////worksheet.Cells["C3"].Value = "M"; // ////worksheet.Cells["D3"].Value = 10000; // ////worksheet.Cells["A4"].Value = 1002; // ////worksheet.Cells["B4"].Value = "Jenny"; // ////worksheet.Cells["C4"].Value = "F"; // ////worksheet.Cells["D4"].Value = 5000; // package.Save(); //Save the workbook. // } // return URL; //} public async Task <IActionResult> WorkerReport(string strCalendario = "", string strWorker = "") { var oReturn = new ReportsViewLogic(); try { int iRow = 1, iIdUser = 0; DateTime dtSelected = DateTime.Now; try { dtSelected = Convert.ToDateTime(strCalendario); iIdUser = Convert.ToInt32(strWorker); } catch (Exception ex) { } oReturn = await _iLoadIndexController.LoadReportsAsync(_idAldakinUser); _idAldakinUser = await _iApplicationUserAldakin.GetIdUserAldakin(HttpContext.User); string user = await _iWorkPartInformation.GetUserNameAsync(_idAldakinUser); string sWebRootFolder = _hostingEnvironment.WebRootPath; string sFileName = @"InformeTrabajador_" + _idAldakinUser + ".xlsx"; string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); if (file.Exists) { file.Delete(); file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); } var lExcel = await _iWorkPartInformation.WorkerReportAsync(iIdUser, dtSelected); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage package = new ExcelPackage(file)) { // add a new worksheet to the empty workbook ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Horas"); //First add the headers worksheet.Cells[1, 1].Value = user; worksheet.Cells[1, 2].Value = "Creado:" + DateTime.Now.Date.ToString(); iRow = iRow + 1; // //worksheet.Cells[1, 1].Value = "ID"; // //worksheet.Cells[1, 2].Value = "Name"; worksheet.Cells[iRow, 1].Value = "Nombre:"; worksheet.Cells[iRow, 2].Value = "Día:"; worksheet.Cells[iRow, 3].Value = "Inicio"; worksheet.Cells[iRow, 4].Value = "Fin"; //Add values foreach (ExcelWorkerReport e in lExcel) { iRow++; worksheet.Cells[iRow, 1].Value = e.strEmpleado; worksheet.Cells[iRow, 2].Value = e.strFecha;//e.str2; worksheet.Cells[iRow, 3].Value = e.strIni; worksheet.Cells[iRow, 4].Value = e.strFin; } ////worksheet.Cells["A2"].Value = 1000; ////worksheet.Cells["B2"].Value = "Jon"; ////worksheet.Cells["C2"].Value = "M"; ////worksheet.Cells["D2"].Value = 5000; ////worksheet.Cells["A3"].Value = 1001; ////worksheet.Cells["B3"].Value = "Graham"; ////worksheet.Cells["C3"].Value = "M"; ////worksheet.Cells["D3"].Value = 10000; ////worksheet.Cells["A4"].Value = 1002; ////worksheet.Cells["B4"].Value = "Jenny"; ////worksheet.Cells["C4"].Value = "F"; ////worksheet.Cells["D4"].Value = 5000; package.Save(); //Save the workbook. } var result = PhysicalFile(Path.Combine(sWebRootFolder, sFileName), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); Response.Headers["Content-Disposition"] = new ContentDispositionHeaderValue("attachment") { FileName = file.Name }.ToString(); return(result); } catch (Exception ex) { } return(await Index("Reports")); }