/// <summary>
      /// Returns an object with fields from dapper query columns
      /// </summary>
      /// <remarks>
      /// Returns Events for SmartRoc machines
      /// Returns a cursor value that keeps track of what data's been recieved
      /// </remarks>
      /// <param name="apiUser"></param>
      /// <param name="fromId">Input cursor to get Events from MachineEventHistoryId  {fromId} + 1  to fetch <see cref="LimitOfRows"/>  number of events</param>
      [HeaderAuthorizeActionFilter]
      [GuidAuthorizationActionFilter]
      [Route("events")]
      [HttpGet]
      [ResponseType(typeof(List<dynamic>))]
      public HttpResponseMessage GetTrainingDataEventsSmartRoc(IUser apiUser, int fromId)
      {
        // var list = _certiqApiContainer.TrainingDataRepository.TrainingDataSmartRocEvents(apiUser, fromId, LimitOfRows);

         var records = new List<Record>()
         {
            new Record{ BirthDate = DateTime.Now, Email = "apa@hotmail.com", Name = "apa", Phone = "0704153", Tickets = 3 },
            new Record{ BirthDate = DateTime.Now, Email = "apa2@hotmail.com", Name = "apa2", Phone = "0704153", Tickets = 3 },
            new Record{ BirthDate = DateTime.Now, Email = "apa3@hotmail.com", Name = "apa3", Phone = "0704153", Tickets = 3 }
         };

      var sb = new StringBuilder();

         sb.Append("Name,Phone,Email,Birth Date,Tickets\r\n");

         foreach (var record in records)
         {
            sb.AppendFormat("=\"{0}\",", record.Name);
            sb.AppendFormat("=\"{0}\",", record.Phone);
            sb.AppendFormat("=\"{0}\",", record.Email);
            sb.AppendFormat("=\"{0}\",", record.BirthDate.ToShortDateString());
            sb.AppendFormat("=\"{0}\"\r\n", record.Tickets.ToString());
         }

         HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);

         result.Content = new StringContent(sb.ToString());
         result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
         result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); //attachment will force download
         result.Content.Headers.ContentDisposition.FileName = "RecordExport.csv";

         return result;


         return null;
      }
   }





   public class Record
   {
      public string Name { get; set; }
      public string Phone { get; set; }
      public string Email { get; set; }
      public DateTime BirthDate { get; set; }
      public int Tickets { get; set; }
   }