Save information list in txt MVC

Question

Good afternoon guys, as I am new in mvc would like a help if possible from you, I am trying to get some data from my list add the same in a txt file and save on my machine, what this agreeing is that the file is generated in my c:However, I am not able to write the information that comes from my list inside the archive, could if possible give me a help. Here’s an example from my controller.

        public IActionResult Exportar(DateTime dateTime, DateTime dateTimeFinal)
        {


            var Layout = _context.RegistroDePontos.Where(e => e.data >= dateTime && e.data <= dateTimeFinal).ToList();
                                                  
            string nomeArquivo = @"C:\" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt";
            StreamWriter writer = new StreamWriter(nomeArquivo, true);
            
            for(int i = 0; i < Layout.Count; i++)

                 writer.WriteLine(Layout[i].ToString());
            
            writer.Close();
           
            return View("Exportar",Layout);
        }

Answer 1

The problem is that you are trying to write an object as a string without telling you what exactly you want to present in the file. See below for an example with a fictitious construction.

public class RegistroDePonto
{
    public string Nome { get; set; }
    public DateTime Data { get; set; }
    public string Tipo { get; set; }
}

Example of reading the collection and writing to the file

//simulando a sua consulta
var layout = new List<RegistroDePontos>
{
    new RegistroDePontos { Nome = "Fulano", Data = DateTime.Parse("2020-03-27 08:30:00"), Tipo = "ENTRADA"},
    new RegistroDePontos { Nome = "Fulano", Data = DateTime.Parse("2020-03-27 12:00:00"), Tipo = "INTERVALO"},
    new RegistroDePontos { Nome = "Fulano", Data = DateTime.Parse("2020-03-27 13:00:00"), Tipo = "RETORNO"},
    new RegistroDePontos { Nome = "Fulano", Data = DateTime.Parse("2020-03-27 17:30:00"), Tipo = "SAÍDA"}
};

string nomeArquivo = @"C:\Temp\teste_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt";

using (StreamWriter writer = new StreamWriter(nomeArquivo, true))
{
    foreach (var registro in layout)
        writer.WriteLine($"{registro.Data} - {registro.Nome} - {registro.Tipo}");
}

Output:

27/03/2020 08:30:00 - Fulano - ENTRADA 
27/03/2020 12:00:00 - Fulano - INTERVALO 
27/03/2020 13:00:00 - Fulano - RETORNO 
27/03/2020 17:30:00 - Fulano - SAÍDA