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"));
}