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