using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.Core.Helpers;
using Tango.Documents;
using Tango.PMR.ColorLab;

namespace Tango.BL.Calibration
{
    /// <summary>
    /// Represents a machine calibration helper.
    /// </summary>
    public static class CalibrationHelper
    {
        /// <summary>
        /// Imports the calibration data from excel.
        /// </summary>
        /// <param name="fileName">Name of the file.</param>
        /// <returns></returns>
        public static List<CalibrationPoint> ImportCalibrationDataFromExcel(String fileName)
        {
            using (ExcelReader reader = new ExcelReader(fileName))
            {
                return reader.GetDataByIndex<CalibrationPoint>("CalibrationData", 2);
            }
        }

        /// <summary>
        /// Exports the calibration data to excel.
        /// </summary>
        /// <param name="calibrationPoints">The calibration points.</param>
        /// <param name="fileName">Name of the file.</param>
        public static void ExportCalibrationDataToExcel(List<CalibrationPoint> calibrationPoints, String fileName)
        {
            CreateCalibrationDataExcelTemplate(fileName);

            using (ExcelWriter writer = new ExcelWriter(fileName))
            {
                writer.WriteData(calibrationPoints, "CalibrationData");
            }
        }

        /// <summary>
        /// Creates the calibration data excel template.
        /// </summary>
        /// <param name="fileName">Name of the file.</param>
        public static void CreateCalibrationDataExcelTemplate(String fileName)
        {
            var stream = EmbeddedResourceHelper.GetEmbeddedResourceStream("Tango.BL.Calibration.CalibrationDataTemplate.xlsx");

            using (FileStream fs = new FileStream(fileName, FileMode.Create))
            {
                stream.Seek(0, SeekOrigin.Begin);
                stream.CopyTo(fs);
            }
        }

        /// <summary>
        /// Creates the calibration data excel template.
        /// </summary>
        /// <param name="fileName">Name of the file.</param>
        public static void CreateColorDataInputExcelTemplate(String fileName)
        {
            var stream = EmbeddedResourceHelper.GetEmbeddedResourceStream("Tango.BL.Calibration.ColorDataInputTemplate.xlsx");

            using (FileStream fs = new FileStream(fileName, FileMode.Create))
            {
                stream.Seek(0, SeekOrigin.Begin);
                stream.CopyTo(fs);
            }
        }

        public static void CreateColorShadesInputExcelTemplate(String fileName)
        {
            var stream = EmbeddedResourceHelper.GetEmbeddedResourceStream("Tango.BL.Calibration.ColorShadesTemplate.xlsx");

            using (FileStream fs = new FileStream(fileName, FileMode.Create))
            {
                stream.Seek(0, SeekOrigin.Begin);
                stream.CopyTo(fs);
            }
        }
    }
}