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