public FileStreamResult Stream(MontarRelatorios montarRelatorios) { var fileContent = MagazineLuizaData.MontaArquivoRetorno(montarRelatorios); if (fileContent.Length > 1) { var stream = new MemoryStream(fileContent); var fileStreamResult = new FileStreamResult(stream, contentType: "text/csv"); fileStreamResult.FileDownloadName = "ManuseioMagazineLuzia.csv"; return(fileStreamResult); } return(null); }
public static byte[] MontaArquivoRetorno(MontarRelatorios oMontarRelatorio) { byte[] buffer = null; using (SqlConnection connection = new SqlConnection(conexao)) { connection.Open(); SqlDataReader rdr = null; string XmlFiltroPessoa = @"<Filtro><Item><Ctr>309</Ctr><Eps>56077</Eps></Item></Filtro>"; int StFormatoRetorno = 10034; try { SqlCommand cmd = new SqlCommand("MontarArquivoRetorno"); cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@XmlFiltroPessoa", Convert.ToString(XmlFiltroPessoa)); cmd.Parameters.AddWithValue("@StFormatoRetorno", Convert.ToInt32(StFormatoRetorno)); cmd.Parameters.AddWithValue("@DtInicial", Convert.ToDateTime(oMontarRelatorio.DtInicial)); cmd.Parameters.AddWithValue("@DtFinal", Convert.ToDateTime(oMontarRelatorio.DtFinal)); cmd.Parameters.AddWithValue("@IdUnidadePostadora", Convert.ToInt32(oMontarRelatorio.IdUnidadePostadora)); cmd.Parameters.AddWithValue("@TicketFTP", Convert.ToInt32(0)); rdr = cmd.ExecuteReader(); StringBuilder builder = new StringBuilder(); while (rdr.Read()) { builder.Append(rdr[0].ToString()); builder.Append("\n"); } buffer = Encoding.ASCII.GetBytes(builder.ToString()); } catch (Exception ex) { throw ex; } } return(buffer); }