public async Task <IActionResult> ExportCompras()
{
var list = new List <String[]>();
foreach (var item in listProductos)
{
String[] listData =
{
item.ID.ToString(),
item.Descripcion,
item.Cantidad.ToString(),
item.Precio,
item.Importe,
item.IdProveedor.ToString(),
item.Proveedor,
item.Email,
item.IdUsuario,
item.Usuario,
item.Role,
item.Dia.ToString(),
item.Mes,
item.Year,
item.Fecha,
item.Codigo,
item.Credito.ToString()
};
list.Add(listData);
}
String[] titles = { "ID", "Descripcion", "Cantidad", "Precio", "Importe", "IdProveedor", "Proveedor", "Email", "IdUsuario", "Usuario", "Role", "Dia", "Mes", "Year", "Fecha"
, "Codigo", "Credito" };
var export = new ExportData(_objeto._environment, Request, list, titles, "Compras.xlsx", "Compras");
return(await export.ExportExcelAsync());
}
public async Task <IActionResult> ExportProducto()
{
var list = new List <String[]>();
foreach (var item in listProductos)
{
String[] listData =
{
item.ID.ToString(),
item.Codigo,
item.Descripcion,
item.Precio,
item.Departamento,
item.Categoria,
item.Descuento,
Convert.ToString(item.Dia),
item.Mes,
item.Year,
item.Fecha,
item.Compra
};
list.Add(listData);
}
String[] titles = { "ID", "Codigo", "Descripcion", "Precio", "Departamento", "Categoria",
"Descuento", "Dia", "Mes", "Year", "Fecha", "Compra" };
var export = new ExportData(_objeto._environment, Request, list, titles, "Productos.xlsx", "Productos");
return(await export.ExportExcelAsync());
}
public async Task <IActionResult> Export()
{
var list = new List <String[]>();
if (!models.List.Equals(0))
{
foreach (var item in models.List)
{
String[] listData =
{
item.CursoID.ToString(),
item.Curso,
item.Informacion,
item.Horas.ToString(),
String.Format("${0:#,###,###,##0.00####}",item.Costo),
item.Estado.ToString(),
item.Categoria,
};
list.Add(listData);
}
}
String[] titles = { "CursoID", "Curso", "Informacion", "Horas", "Costo", "Estado", "Categoria" };
var export = new ExportData(_hostingEnvironment, list, titles, "Inscripciones.xlsx", "Inscripciones");
return(await export.ExportExcelAsync());
}
//[HttpPost]
public async Task <IActionResult> ExportProveedores()
{
var list = new List <String[]>();
foreach (var item in listProveedor)
{
String[] listData =
{
Convert.ToString(item.ID),
item.Proveedor,
item.Telefono,
item.Email,
item.Direccion
};
list.Add(listData);
}
String[] titles = { "ID", "Proveedor", "Telefono", "Email", "Direccion" };
var export = new ExportData(_objeto._environment, Request, list, titles, "Proveedores.xlsx", "Proveedores");
return(await export.ExportExcelAsync());
}
public async Task <IActionResult> ExportHistory()
{
var list = new List <String[]>();
foreach (var item in listTicket)
{
String[] listData =
{
Convert.ToString(item.ID),
item.Deuda,
Convert.ToString(item.FechaDeuda),
item.Pago,
Convert.ToString(item.FechaPago),
item.Ticket,
item.Email
};
list.Add(listData);
}
String[] titles = { "ID", "Deuda", "Fecha Deuda", "Pago", "Fecha Pago", "Ticket", "Email" };
var export = new ExportData(_objeto._environment, Request, list, titles, "TicketProveedores.xlsx", "Tickets");
return(await export.ExportExcelAsync());
}
//[HttpPost]
public async Task <IActionResult> Export()
{
var list = new List <String[]>();
foreach (var item in listClientes)
{
String[] listData =
{
Convert.ToString(item.ID),
item.NID,
item.Nombre,
item.Apellido,
item.Email,
item.Telefono,
item.Direccion,
item.Creditos
};
list.Add(listData);
}
String[] titles = { "ID", "NID", "Nombre", "Apellido", "Email", "Telefono", "Direccion", "Creditos" };
var export = new ExportData(_objeto._environment, Request, list, titles, "Clientes.xlsx", "Clientes");
return(await export.ExportExcelAsync());
}
