public ActionResult Consultar() { List <eFile> Files = new List <eFile>(); #region Excel eFile f_excel = new eFile(); List <Folio> folios = new List <Folio>(); for (int i = 0; i < 274; i++) { Folio folio = new Folio(); folio.Lote = 114; folio.ContadorLote = 683; folio.Color_Producto = "GRISP"; folio.Contador = i + 1; folios.Add(folio); } f_excel.FileStream = Excel.CrearExcelFolios(folios); f_excel.FileName = "folios.xlsx"; Files.Add(f_excel); //return File(FileBytesArray, "application/xlsx", "Folios" + ".xlsx"); #endregion eFile f_pdf = new eFile(); f_pdf.FileStream = Pdf.CreatePdf(folios); f_pdf.FileName = "folios.pdf"; Files.Add(f_pdf); byte[] FileBytesArray; FileBytesArray = Zip.CreateZip(Files); //return File(FileBytesArray, "pdf/application", "Folios" + ".pdf"); return(File(FileBytesArray, "application/octet-stream", "Folios.zip")); }
/** * A function to retrieve the name of all files belonging to a deck in local database * Pre: local deck id * Post: List of corresponding eFile Objects */ public static List <eFile> loadFileName(int did) { List <eFile> eFileList = new List <eFile>(); string SQL; MySqlCommand cmd = new MySqlCommand(); MySqlDataReader myData; connect(); try { SQL = "SELECT data FROM Objects,CDRelations WHERE CDRelations.did = " + Convert.ToString(did) + " AND CDRelations.cid = Objects.cid"; cmd.Connection = conn; cmd.CommandText = SQL; myData = cmd.ExecuteReader(); while (myData.Read()) { eFile file = new eFile(myData.GetString(myData.GetOrdinal("data"))); eFileList.Add(file); } myData.Close(); conn.Close(); return(eFileList); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); conn.Close(); throw new Exception(); } }