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