blob: ced98dbff04f449a0f9f9b90943dea2467e23ef3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
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);
}
}
}
}
|
