using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Web.Http;
using System.Web.Http.Description;
using Arkub.Artiq.CoreBL.User;
using Arkub.Artiq.ExternalAPI.RESTv1.Interfaces.ActionFilterAttributes;
using Certiq.Rest.Controllers.Core;
using Certiq.Rest.Controllers.Core.Dtos;
using Certiq.Rest.Controllers.Helpers;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Reflection;
using System.Web;
using System.Web.Http;
using System.Web.UI;

namespace Certiq.Rest.Controllers.Controllers
{
   /// <summary>
   /// TrainingDataController manages REST endpoints fetching data for machine learning
   /// </summary>
   [RoutePrefix("v1/TrainingData")]
   public class TrainingDataController : ApiController
   {
      private readonly ICertiqApiContainer _certiqApiContainer;
      private int LimitOfRows = 10000;

      /// <inheritdoc />
      /// <summary>
      /// Initializes container
      /// </summary>
      /// <param name="certiqApiContainer"></param>
      public TrainingDataController(ICertiqApiContainer certiqApiContainer)
      {
         _certiqApiContainer = certiqApiContainer;
      }

      /// <summary>
      /// Returns an object with fields from dapper query columns
      /// </summary>
      /// <remarks>
      /// Returns Registers 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 Registers from MachineRegisterHistoryId  {fromId} + 1  to fetch <see cref="LimitOfRows"/>  number of registers</param>
      [HeaderAuthorizeActionFilter]
      [GuidAuthorizationActionFilter]
      [Route("registers")]
      [HttpGet]
      [ResponseType(typeof(List<dynamic>))]
      public IHttpActionResult GetTrainingDataRegistersSmartRoc(IUser apiUser, int fromId)
      {
         return Ok(_certiqApiContainer.TrainingDataRepository.TrainingDataSmartRocRegisters(apiUser, fromId, LimitOfRows));
      }


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


}


// https://goosedotnet.wordpress.com/2014/09/29/generate-and-export-a-string-only-csv-file-from-webapi/